1       14:56:33  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 130.000000
2       14:56:33  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 00412951    
3       14:56:33  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221103
4       14:56:33  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221115
5       14:56:33  SQL Execute: ORACLE -  select z.zyh000,z.xm0000,a.rycwh0,z.djh000,z.hjje00,z.zfje00,z.gfje00,z.jzje00,z.czrq00,z.czsj00,z.zyid00,a.MRN000,z.yexm00 from zy_brxxb0  a,zy_brfy00 z  where  z.hjje00>=0  and nvl(a.BRSZXT,'0')='0' and    z.brid00=a.brid00(+) and z.zyid00=a.zyid00(+)and a.brzt00 like '2%' and exists(select 'Y' from zy_fymx00 where DJH000=Z.DJH000 and  KDBQ00=? and XMBH00<9999999990) and (not exists (select 1 from yj_yw0000 where zyghid=z.zyid00 and mzzybz='1' and sfdjh0=z.djh000 and zlxmid>0) or exists (select 1 from zy_fymx00 k,xt_zlsfgx b where k.djh000=z.djh000 and k.xmbh00=b.sfxmid and k.zxks00=a.dqks00 and b.gdbz00='N' and b.fjfybz='Y' and b.bqsfbz='Y'))
 and  Z.ZYH000    = ? and  Z.CZRQ00 >= ? and  Z.CZRQ00 <  ?
 order by z.CZRQ00,z.CZSJ00