1 17:44:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1197 2 17:44:54 SQL Execute: ORACLE - select GHHZCK from vw_sf_ysghhb where GHYSBH=? AND GHMZSJ >= to_char(sysdate-1, 'YYYYMMDD' ) and TZBZ00 = '0' and ((((GHXHS0-YYXHS0)>(GHYGHS-GHYYHS)) and (SFZJGH='0')) OR (SFZJGH='1')) and ( (GHJSSJ >= GHQSSJ and GHJSSJ >= to_char(sysdate,'HH24:MI:SS') and GHQSSJ <= to_char(sysdate,'HH24:MI:SS') and GHMZSJ = to_char(sysdate,'YYYYMMDD') ) or (GHJSSJ < GHQSSJ and ((GHMZSJ = to_char(sysdate-1, 'YYYYMMDD' ) and GHQSSJ <= to_char(sysdate,'HH24:MI:SS' ) ) or (GHMZSJ = to_char(sysdate-1, 'YYYYMMDD' ) and GHJSSJ >= to_char(sysdate,'HH24:MI:SS' ) ) ) ) ) 3 17:44:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000 4 17:44:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 767287 5 17:44:54 SQL Execute: ORACLE - select SF_YS_YKDWZXXMTS(?,?) TSXX00 from dual 6 17:44:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 7 17:44:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1197 8 17:44:54 SQL Execute: ORACLE - select GHLBBH,GHLBMC,GHXHS0,GHYGHS from SF_YSGHHB where GHKSBH=? and GHYSBH=? and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD') and GHQSSJ<=TO_CHAR(sysdate,'HH24:MI:SS') and GHJSSJ>=TO_CHAR(sysdate,'HH24:MI:SS') 9 17:44:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 10 17:44:54 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 from YS_BRZDXX a, XT_ICD900 b where a.ICD900=b.ICD900(+) and a.SFXYZD='1'and a.GHID00=? 11 17:44:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 12 17:44:54 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD from YS_BRZDXX where SFXYZD='0'and GHID00=? 13 17:44:54 SQL Data In: ORACLE - Param = 1, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000 14 17:44:54 SQL Data In: ORACLE - Param = 2, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000 15 17:44:54 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 767287 16 17:44:54 SQL Data In: ORACLE - Param = 4, Name = PRESULT, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 17 17:44:54 SQL Data In: ORACLE - Param = 5, Name = PMSG000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 18 17:44:54 SQL Execute: ORACLE - BEGIN "SP_YS_GHXZTS" (PGHKS00 => :PGHKS00,PGHYS00 => :PGHYS00,PBRID00 => :PBRID00,PRESULT => :PRESULT,PMSG000 => :PMSG000); END; 19 17:44:54 SQL Execute: ORACLE - select sf_ys_ghxz00(474,1197,767287) from dual 20 17:44:54 SQL Execute: ORACLE - select LBMC00,LBBH00 from VW_BM_GHLBB0 where lbbh00 in (-99999,23,35) 21 17:44:54 SQL Execute: ORACLE - select HZLBMC,HZLB00 from BM_HZLB00 22 17:44:54 SQL Execute: ORACLE - select SFYD00,GRSFEN,BRDYFW from BM_BRXXB0 where BRID00=767287 23 17:44:54 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select GHID00 from SF_BRXXB0 b where brid00=767287) and rownum=1 24 17:44:54 SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1 25 17:44:54 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 767287.000000 26 17:44:54 SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 23 27 17:44:54 SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000 28 17:44:54 SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 29 17:44:54 SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 30 17:44:54 SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 31 17:44:54 SQL Data In: ORACLE - Param = 7, Name = PSFGHF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 32 17:44:54 SQL Data In: ORACLE - Param = 8, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 33 17:44:54 SQL Data In: ORACLE - Param = 9, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 34 17:44:54 SQL Data In: ORACLE - Param = 10, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 35 17:44:54 SQL Data In: ORACLE - Param = 11, Name = PGHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 36 17:44:54 SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE,PGHYS00 => :PGHYS00,PGHHBID => :PGHHBID); END; 37 17:44:54 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 767287.000000 38 17:44:54 SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 23 39 17:44:54 SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000 40 17:44:54 SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 41 17:44:54 SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 42 17:44:54 SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 43 17:44:54 SQL Data In: ORACLE - Param = 7, Name = PSFGHF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 44 17:44:54 SQL Data In: ORACLE - Param = 8, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 45 17:44:54 SQL Data In: ORACLE - Param = 9, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 46 17:44:54 SQL Data In: ORACLE - Param = 10, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 47 17:44:54 SQL Data In: ORACLE - Param = 11, Name = PGHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 48 17:44:54 SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE,PGHYS00 => :PGHYS00,PGHHBID => :PGHHBID); END; 49 17:44:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 767287 50 17:44:54 SQL Execute: ORACLE - select nvl(max(GHID00),0) GHID00 from YS_BRBQB0 where GHID00 in (select GHID00 from SF_BRXXB0 b where BRID00=? ) 51 17:44:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 767287 52 17:44:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4085812 53 17:44:54 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='0'