1       11:28:00  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 4538211     
2       11:28:00  SQL Execute: ORACLE - select a.*,' ' QTYFMC ,(select SFKSLY from YF_MZCF00 where CFLSH0=a.CFLSH0) SFKSLY  from ys_cfxxb0 a  where cflsh0=(select max(cflsh0) from YS_CFXXB0 where GHH000=? and YPDLBH in ('0','1') and  CFXZ00='0')

3       11:28:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ¼±Õï
4       11:28:02  SQL Execute: ORACLE - select ghqxbz from bm_ghlbb0 where lbmc00=?

5       11:28:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 4538211     
6       11:28:02  SQL Execute: ORACLE - select HBQX00 from SF_BRXXB0 where GHH000=?

7       11:28:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7482219.000000
8       11:28:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19000101
9       11:28:03  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7482219
10      11:28:03  SQL Execute: ORACLE - select 
  a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC,
  a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0,
  (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900 and SYBZ00='1' and rownum=1) ICDJMC ,a.FWMC00,a.BWMC00
from YS_BRZDXX a, XT_ICD900 b 
  where a.ICD900 = b.ICD900(+) and a.SFXYZD='1'
    and a.GHID00 = ?  
   and (exists(select 1 from SF_BRXXB0 where GHID00=a.GHID00 and GHRQ00>=?)  or a.GHID00=?)
order by zzdbz0,zdxxid


11      11:28:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7482219.000000
12      11:28:03  SQL Execute: ORACLE - select 
  ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC,
  JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD,
  DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, 
  (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1),
  (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC
 ,BWMC00,FWMC00
from YS_BRZDXX A
  where SFXYZD='0'and GHID00=? 
order by zzdbz0


13      11:28:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7482219.000000
14      11:28:03  SQL Execute: ORACLE - select 
  ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC,
  JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD,
 (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900 and rownum=1) ICDJMC ,
 BWMC00,FWMC00 
from YS_BRZDXX A
  where SFXYZD='2' and GHID00=? 
order by zzdbz0


15      11:28:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7482219.000000
16      11:28:03  SQL Execute: ORACLE - select * from YS_BRZYS0 A
  where  GHID00=? 
order by ID0000


17      11:28:03  SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00,YYLBID,to_date(decode(nvl(YYKBRQ,' '),' ',to_char(sysdate,'YYYYMMDD'),YYKBRQ),'YYYYMMDD') YYKBRQ from SF_BRXXB0 where GHID00=7482219 

18      11:28:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7482219.000000
19      11:28:03  SQL Execute: ORACLE - SELECT BRBQID,  GHID00,  GHH000,  BRZS00,  SFCZ00,  SFHC00,  BS0000,
  TGJC00,  SYSJC0,  SZ0000,  ST0000,  MX0000,  TW0000,  XTCS00,
  HXCS00,  SZY000,  SSY000,  JZYS00,  SJYS00,  CZRQ00,  CZSJ00,
  JZYSXM,  ZS0000,  JZRQSJ,  ZDCLNR,  FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01,
  GMS000,BRTZ00,BRSG00
 FROM YS_BRBQB0 WHERE GHID00=?
 

20      11:28:03  SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=1576416)and GHID00<7482219 and rownum=1
 Union all 
select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=1576416)and GHID00>7482219 and rownum=1