1 14:50:35 Log started for: Yjsystem 2 14:50:38 SQL Prepare: ORACLE - Select SYSDATE from Dual 3 14:50:38 SQL Execute: ORACLE - Select SYSDATE from Dual 4 14:50:38 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 5 14:50:38 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 6 14:50:38 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 7 14:50:38 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 8 14:50:38 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 9 14:50:38 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 10 14:50:38 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 11 14:50:38 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 12 14:50:38 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FJYB' and KLDH00 not in ('CK','JMCK') 13 14:50:38 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FJYB' and KLDH00 not in ('CK','JMCK') 14 14:50:38 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 15 14:50:38 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 16 14:50:38 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'CK_BC' and KLDH00 not in ('CK','JMCK') 17 14:50:38 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'CK_BC' and KLDH00 not in ('CK','JMCK') 18 14:51:45 SQL Prepare: ORACLE - Select SYSDATE from Dual 19 14:51:45 SQL Execute: ORACLE - Select SYSDATE from Dual 20 14:51:45 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 21 14:51:45 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 22 14:51:45 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 23 14:51:45 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 24 14:51:45 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137601069896' and ICKNBH = '0222137601069896' 25 14:51:45 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137601069896' and ICKNBH = '0222137601069896' 26 14:51:45 SQL Prepare: ORACLE - select * from bm_brxxb0 where zyzt00='1' and brid00=159116 27 14:51:45 SQL Execute: ORACLE - select * from bm_brxxb0 where zyzt00='1' and brid00=159116 28 14:51:45 SQL Prepare: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 29 14:51:45 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 159116.000000 30 14:51:45 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 0 31 14:51:45 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 32 14:51:45 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 33 14:51:45 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 34 14:51:45 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 35 14:51:45 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 36 14:51:45 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 37 14:51:45 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 38 14:51:45 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 39 14:51:45 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 40 14:51:45 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 41 14:51:45 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 42 14:51:45 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 43 14:51:45 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 44 14:51:45 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 45 14:51:45 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 46 14:51:45 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 47 14:51:45 SQL Prepare: ORACLE - SELECT * FROM VW_YS_YXGH00 WHERE GHH000='8583997' 48 14:51:45 SQL Execute: ORACLE - SELECT * FROM VW_YS_YXGH00 WHERE GHH000='8583997' 49 14:51:45 SQL Prepare: ORACLE - select * from bm_brxxb0 where brid00=159116 50 14:51:45 SQL Execute: ORACLE - select * from bm_brxxb0 where brid00=159116 51 14:51:45 SQL Prepare: ORACLE - select GHKS00,JZYS00,JZYSXM from sf_brxxb0 where ghid00=18176358 52 14:51:45 SQL Execute: ORACLE - select GHKS00,JZYS00,JZYSXM from sf_brxxb0 where ghid00=18176358 53 14:51:45 SQL Prepare: ORACLE - select sysdate from dual 54 14:51:45 SQL Execute: ORACLE - select sysdate from dual 55 14:51:45 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,yzlx00 from vw_yj_yw0000_wzx b where xmzt00 in('0','1') and brid00=159116 and (YJKSBH=49 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=49) and kdksbh in (select Sqxmks from vw_xt_xmfwfx where jsxmks=49)) or KDKSBH=49) 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='20151208' order by YJdjh0 56 14:51:45 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,yzlx00 from vw_yj_yw0000_wzx b where xmzt00 in('0','1') and brid00=159116 and (YJKSBH=49 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=49) and kdksbh in (select Sqxmks from vw_xt_xmfwfx where jsxmks=49)) or KDKSBH=49) 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='20151208' order by YJdjh0 57 14:51:45 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 58 14:51:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 59 14:51:45 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 60 14:51:45 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 61 14:51:45 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 62 14:51:45 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 63 14:51:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 64 14:51:45 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 65 14:51:45 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 66 14:51:45 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 67 14:54:51 SQL Prepare: ORACLE - Select brid00,yjdjh0,brxm00,yjfzh0,zyhghh,yexm00,zlxmjc,zxksmc,xb0000,csrq00,kdsj00,lrxm00,zje000,DQBQ00,RYCWH0,BQMC00, kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,mzzybz,sl0000,decode(xmzt00,'5','تا','·ٌ') yt,YZLX00,b.TSBZMC from vw_yj_yw0000_wzx b where xmzt00 in ('0','5','1','2') and brid00=:1 and (YJKSBH=:2 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=:3) and kdksbh in (select SQXMKS from vw_xt_xmfwfx where jsxmks=:4)) or (KDKSBH=:5 and YJLRBZ='Y')) 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) or sl0000>0) and kdrq00 between :6 and :7 order by yjdjh0 68 14:54:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4139662.000000 69 14:54:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49.000000 70 14:54:51 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49.000000 71 14:54:51 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49.000000 72 14:54:51 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49.000000 73 14:54:51 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20151201 74 14:54:51 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20151208 75 14:54:51 SQL Execute: ORACLE - Select brid00,yjdjh0,brxm00,yjfzh0,zyhghh,yexm00,zlxmjc,zxksmc,xb0000,csrq00,kdsj00,lrxm00,zje000,DQBQ00,RYCWH0,BQMC00, kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,mzzybz,sl0000,decode(xmzt00,'5','تا','·ٌ') yt,YZLX00,b.TSBZMC from vw_yj_yw0000_wzx b where xmzt00 in ('0','5','1','2') and brid00=? and (YJKSBH=? or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=?) and kdksbh in (select SQXMKS from vw_xt_xmfwfx where jsxmks=?)) or (KDKSBH=? and YJLRBZ='Y')) 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) or sl0000>0) and kdrq00 between ? and ? order by yjdjh0 76 14:54:51 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 77 14:54:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 78 14:54:51 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 79 14:54:51 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 80 14:54:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 81 14:54:51 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 82 14:54:51 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00='YJJZ00' AND VALUE0='Y' 83 14:54:51 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00='YJJZ00' AND VALUE0='Y' 84 14:54:53 SQL Prepare: ORACLE - SELECT * FROM VW_YS_YXGH00 WHERE GHH000=:1 85 14:54:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 8583959 86 14:54:53 SQL Execute: ORACLE - SELECT * FROM VW_YS_YXGH00 WHERE GHH000=? 87 14:54:53 SQL Prepare: ORACLE - select * from bm_brxxb0 where brid00=:1 88 14:54:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4139662.000000 89 14:54:53 SQL Execute: ORACLE - select * from bm_brxxb0 where brid00=? 90 14:54:53 SQL Prepare: ORACLE - select GHQXBZ from bm_ghlbb0 where LBBH00=:1 91 14:54:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 25.000000 92 14:54:53 SQL Execute: ORACLE - select GHQXBZ from bm_ghlbb0 where LBBH00=?