体检套餐消费数据（多条重复数据取最大时间）

select n.MRN, n.姓名,n.手机号, n.项目名称,n.金额 from 
 (select  row_number() over(partition by m.就诊 order by m.创建时间 desc)  seq,m.* from (select pgpmi.fxgetmrn(pt.patient_id, 'MRTOP') mrn,
       p.person_name 姓名,
       p.mobile_phone_no 手机号,
       ot.template_desc 项目名称,
       v.visit_id 就诊,
       op.created_datetime 创建时间,
       sum(pat.txn_amount - pat.discount_amount - pat.package_amount +
           pat.package_discount_amount) 金额
  from orderentrypanel   op,
       visit             v,
       patient           pt,
       person            p,
       ordertemplatemstr ot,
       patientaccount    pa,
       patientaccounttxn pat
 where 1 = 1
   and op.ordertemplatemstr_id = ot.ordertemplatemstr_id
   and ot.entitymstr_id = 4
   and ot.defunct_ind = 'N'
   and ot.template_desc like '%体检%'
   and op.defunct_ind = 'N'
   and v.admit_status <> 'AST5'
   and op.visit_id = v.visit_id
   and v.patient_id = pt.patient_id
   and pt.person_id = p.person_id
   and v.visit_id = pa.visit_id
   and pa.patientaccount_id = pat.patientaccount_id
   and pa.account_status = 'ACS1'
   and pat.charge_status = 'CTTNOR'
 group by pt.patient_id,
          p.person_name,
          p.mobile_phone_no,
          ot.template_desc,
          v.visit_id,
          op.created_datetime
) m) n where n.seq = 1 order by n.姓名