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