1       16:26:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1729169.000000
2       16:26:24  SQL Execute: ORACLE -  select  * from  zy_brjfb0  where  pjh000 = ?

3       16:26:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3438781.000000
4       16:26:24  SQL Execute: ORACLE - select * from zy_brxxb0 where brid00= ?

5       16:26:24  SQL Execute: ORACLE -  select  C.BRBLH0,B.BMMC00,A.RYCWH0,A.BRID00  from  zy_brxxb0 A,bm_bmbm00 B,bm_brxxb0 C  where A.BRID00=c.BRID00 and  A.DQBQ00 = B.BMBH00 and A.cyrq00 is null and A.MRN000 = '2202430'

6       16:26:24  SQL Execute: ORACLE -  select  COUNT(*) JKCS00  from  zy_brxxb0 A,ZY_PJSYQK  B,ZY_BRJFB0 C where B.PLBH00=8 AND A.ZYID00 = C.ZYID00 AND C.PJH000=B.PJH000 and A.cyrq00 is null and A.MRN000 = '2202430'

7       16:26:24  SQL Execute: ORACLE -  select  A.ICKH00  from  IC_YHXX00 A,BM_BRXXB0 B where  A.BRID00 = B.BRID00 and  A.ZT0000='1' and B.MRN000 = '2202430'

8       16:26:24  SQL Execute: ORACLE -  select * from ZY_BRXXB0 where CYRQ00 IS NULL and MRN000='2202430'

9       16:26:28  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',445,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',2360,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =2360 AND b.JSKSBH = '445')
  AND (INSTR (',' || a.jsksbh || ',',',445,') > 0 or a.jsksbh is null)