1 09:44:10 SQL Execute: ORACLE - select SF_YS_CHECKDTJR JRBZ00 from dual 2 09:44:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1150 3 09:44:10 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 09:44:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142.000000 5 09:44:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5999047 6 09:44:10 SQL Execute: ORACLE - select SF_YS_YKDWZXXMTS(?,?) TSXX00 from dual 7 09:44:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 142 8 09:44:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1150 9 09:44:10 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 09:44:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5999047 11 09:44:10 SQL Execute: ORACLE - select count(*) record_no from sf_brxxb0 where brid00=? and thbz00<>'0' and GHLB00<>-99999 12 09:44:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 13 09:44:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19000101 14 09:44:10 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>=?) 15 09:44:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 16 09:44:10 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=? 17 09:44:10 SQL Data In: ORACLE - Param = 1, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142.000000 18 09:44:10 SQL Data In: ORACLE - Param = 2, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1150.000000 19 09:44:10 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5999047 20 09:44:10 SQL Data In: ORACLE - Param = 4, Name = PRESULT, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 21 09:44:10 SQL Data In: ORACLE - Param = 5, Name = PMSG000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 22 09:44:10 SQL Execute: ORACLE - BEGIN "SP_YS_GHXZTS" (PGHKS00 => :PGHKS00,PGHYS00 => :PGHYS00,PBRID00 => :PBRID00,PRESULT => :PRESULT,PMSG000 => :PMSG000); END; 23 09:44:10 SQL Execute: ORACLE - select SF_YS_GETSFJZSJ_GH('1') JZBZ00 from dual 24 09:44:10 SQL Execute: ORACLE - select sf_ys_ghxz00(142,1150,5999047) from dual 25 09:44:10 SQL Execute: ORACLE - select LBMC00,LBBH00 from VW_BM_GHLBB0 where lbbh00 in (23,24,16,14,21 ) 26 09:44:10 SQL Execute: ORACLE - select HZLBMC,HZLB00 from BM_HZLB00 27 09:44:10 SQL Execute: ORACLE - select SFYD00,GRSFEN,BRDYFW from BM_BRXXB0 where BRID00=5999047 28 09:44:10 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select GHID00 from SF_BRXXB0 b where brid00=5999047) and rownum=1 29 09:44:10 SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1 30 09:44:10 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5999047.000000 31 09:44:10 SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 24 32 09:44:10 SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142.000000 33 09:44:10 SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 34 09:44:10 SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 35 09:44:10 SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 36 09:44:10 SQL Data In: ORACLE - Param = 7, Name = PSFGHF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 37 09:44:10 SQL Data In: ORACLE - Param = 8, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 38 09:44:10 SQL Data In: ORACLE - Param = 9, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 39 09:44:10 SQL Data In: ORACLE - Param = 10, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 40 09:44:10 SQL Data In: ORACLE - Param = 11, Name = PGHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 41 09:44:10 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; 42 09:44:10 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5999047.000000 43 09:44:10 SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 24 44 09:44:10 SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142.000000 45 09:44:10 SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 46 09:44:10 SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 47 09:44:10 SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 48 09:44:10 SQL Data In: ORACLE - Param = 7, Name = PSFGHF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 49 09:44:10 SQL Data In: ORACLE - Param = 8, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 50 09:44:10 SQL Data In: ORACLE - Param = 9, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 51 09:44:10 SQL Data In: ORACLE - Param = 10, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 52 09:44:10 SQL Data In: ORACLE - Param = 11, Name = PGHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 53 09:44:10 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; 54 09:44:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5999047 55 09:44:10 SQL Execute: ORACLE - select nvl(max(GHID00),0) GHID00 from YS_BRBQB0 where GHID00 in (select GHID00 from SF_BRXXB0 b where BRID00=? ) 56 09:44:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5999047 57 09:44:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13529871 58 09:44:10 SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='0' 59 10:21:21 Log started for: SQL Navigator for Oracle