1 15:16:15 SQL Prepare: ORACLE - Select 1 from SF_BRXXB0 where GHH000='435429' and LBBH00='0' 2 15:16:15 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='435429' and LBBH00='0' 3 15:16:15 SQL Prepare: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='64399' and ZT0000='1' 4 15:16:15 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='64399' and ZT0000='1' 5 15:16:15 SQL Prepare: ORACLE - select a.GHQXBZ from bm_ghlbb0 a,SF_BRXXB0 b where a.LBBH00=b.GHLB00 AND b.GHH000='435429' 6 15:16:15 SQL Execute: ORACLE - select a.GHQXBZ from bm_ghlbb0 a,SF_BRXXB0 b where a.LBBH00=b.GHLB00 AND b.GHH000='435429' 7 15:16:15 SQL Prepare: ORACLE - BEGIN "SP_YJ_XMWH" (PYJDJH0 => :PYJDJH0,PYJKSBH => :PYJKSBH,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PYEXM00 => :PYEXM00,PBRXM00 => :PBRXM00,PXB0000 => :PXB0000,PCSRQ00 => :PCSRQ00,PZLXMID => :PZLXMID,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PLRXM00 => :PLRXM00,PJZBZ00 => :PJZBZ00,PBWMC00 => :PBWMC00,PZDID00 => :PZDID00,PMZZYBZ => :PMZZYBZ,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,PYWMXID => :PYWMXID,POPNAME => :POPNAME,PNEWDJH => :PNEWDJH,PDQBQ00 => :PDQBQ00); END; 8 15:16:15 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 9 15:16:15 SQL Data In: ORACLE - Param = 2, Name = PYJKSBH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 41 10 15:16:15 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 64399.000000 11 15:16:15 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 524202.000000 12 15:16:15 SQL Data In: ORACLE - Param = 5, Name = PYEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 13 15:16:15 SQL Data In: ORACLE - Param = 6, Name = PBRXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 14 15:16:15 SQL Data In: ORACLE - Param = 7, Name = PXB0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 15 15:16:15 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 16 15:16:15 SQL Data In: ORACLE - Param = 9, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10314.000000 17 15:16:15 SQL Data In: ORACLE - Param = 10, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 392.000000 18 15:16:15 SQL Data In: ORACLE - Param = 11, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000 19 15:16:15 SQL Data In: ORACLE - Param = 12, Name = PLRXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 9999 20 15:16:15 SQL Data In: ORACLE - Param = 13, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 21 15:16:15 SQL Data In: ORACLE - Param = 14, Name = PBWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 22 15:16:15 SQL Data In: ORACLE - Param = 15, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 23 15:16:15 SQL Data In: ORACLE - Param = 16, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 24 15:16:15 SQL Data In: ORACLE - Param = 17, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 25 15:16:15 SQL Data In: ORACLE - Param = 18, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 26 15:16:15 SQL Data In: ORACLE - Param = 19, Name = PYWMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 27 15:16:15 SQL Data In: ORACLE - Param = 20, Name = POPNAME, Type = fldZSTRING, Precision = 1, Scale = 0, Data = A 28 15:16:15 SQL Data In: ORACLE - Param = 21, Name = PNEWDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 29 15:16:15 SQL Data In: ORACLE - Param = 22, Name = PDQBQ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 30 15:16:15 SQL Execute: ORACLE - BEGIN "SP_YJ_XMWH" (PYJDJH0 => :PYJDJH0,PYJKSBH => :PYJKSBH,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PYEXM00 => :PYEXM00,PBRXM00 => :PBRXM00,PXB0000 => :PXB0000,PCSRQ00 => :PCSRQ00,PZLXMID => :PZLXMID,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PLRXM00 => :PLRXM00,PJZBZ00 => :PJZBZ00,PBWMC00 => :PBWMC00,PZDID00 => :PZDID00,PMZZYBZ => :PMZZYBZ,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,PYWMXID => :PYWMXID,POPNAME => :POPNAME,PNEWDJH => :PNEWDJH,PDQBQ00 => :PDQBQ00); END; 31 15:16:15 SQL Prepare: ORACLE - INSERT INTO YJ_YWMX00 (ID0000,YJDJH0,ZLXMID) values (SQ_YJ_YWMX00_ID0000.NEXTVAL,:1,:2) 32 15:16:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3990825.000000 33 15:16:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10314.000000 34 15:16:15 SQL Execute: ORACLE - INSERT INTO YJ_YWMX00 (ID0000,YJDJH0,ZLXMID) values (SQ_YJ_YWMX00_ID0000.NEXTVAL,?,?) 35 15:16:15 SQL Data In: ORACLE - Rows affected = 1 36 15:16:15 SQL Prepare: ORACLE - Commit 37 15:16:15 SQL Execute: ORACLE - Commit 38 15:16:15 SQL Data In: ORACLE - Rows affected = 0 39 15:16:15 SQL Prepare: ORACLE - BEGIN "SP_YJ_YWJJ00" (PYJDJH0 => :PYJDJH0,PCXJJ00 => :PCXJJ00); END; 40 15:16:15 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3990825.000000 41 15:16:15 SQL Data In: ORACLE - Param = 2, Name = PCXJJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 42 15:16:15 SQL Execute: ORACLE - BEGIN "SP_YJ_YWJJ00" (PYJDJH0 => :PYJDJH0,PCXJJ00 => :PCXJJ00); END; 43 15:16:15 SQL Prepare: ORACLE - select sysdate from dual 44 15:16:15 SQL Execute: ORACLE - select sysdate from dual 45 15:16:15 SQL Prepare: ORACLE - Select yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,lrxm00,kdsj00,zje000, xb0000,sl0000,csrq00,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,brid00,mzzybz from vw_yj_yw0000_wzx b where xmzt00 in('0','1') and brid00=64399 and (YJKSBH=57 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=57) and kdksbh in (select Sqxmks from vw_xt_xmfwfx where jsxmks=57)) or KDKSBH=57) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null)) and kdrq00='20100430' and YJDJH0 not in ( 0 ) order by YJdjh0 46 15:16:15 SQL Execute: ORACLE - Select yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,lrxm00,kdsj00,zje000, xb0000,sl0000,csrq00,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,brid00,mzzybz from vw_yj_yw0000_wzx b where xmzt00 in('0','1') and brid00=64399 and (YJKSBH=57 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=57) and kdksbh in (select Sqxmks from vw_xt_xmfwfx where jsxmks=57)) or KDKSBH=57) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null)) and kdrq00='20100430' and YJDJH0 not in ( 0 ) order by YJdjh0 47 15:16:15 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 48 15:16:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3990825 49 15:16:15 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 50 15:16:15 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=3990825 51 15:16:15 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=3990825 52 15:16:15 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 53 15:16:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3990825 54 15:16:15 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 55 15:16:15 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=3990825 56 15:16:15 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=3990825 57 15:16:17 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 58 15:16:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3990825 59 15:16:17 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 60 15:16:17 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=3990825 61 15:16:17 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=3990825 62 15:16:17 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 63 15:16:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3990825 64 15:16:17 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 65 15:16:17 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=3990825 66 15:16:17 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=3990825 67 15:16:17 SQL Prepare: ORACLE - select YJDJH0 from YJ_YW0000 where yjfzh0 is null and yjdjh0 = 3990825 union all select YJDJH0 from YJ_YW0000 where yjfzh0 is not null and yjfzh0 in ( select yjfzh0 from yj_yw0000 where yjdjh0 = 3990825) 68 15:16:17 SQL Execute: ORACLE - select YJDJH0 from YJ_YW0000 where yjfzh0 is null and yjdjh0 = 3990825 union all select YJDJH0 from YJ_YW0000 where yjfzh0 is not null and yjfzh0 in ( select yjfzh0 from yj_yw0000 where yjdjh0 = 3990825) 69 15:16:17 SQL Prepare: ORACLE - select * from VW_SF_YJYWMX where yjfzh0 is null and yjdjh0 = 3990825 union all select * from VW_SF_YJYWMX where yjfzh0 is not null and yjfzh0 in ( select yjfzh0 from yj_yw0000 where yjdjh0 = 3990825) 70 15:16:17 SQL Execute: ORACLE - select * from VW_SF_YJYWMX where yjfzh0 is null and yjdjh0 = 3990825 union all select * from VW_SF_YJYWMX where yjfzh0 is not null and yjfzh0 in ( select yjfzh0 from yj_yw0000 where yjdjh0 = 3990825)