1 08:23:32 SQL Execute: ORACLE - SELECT * FROM (SELECT A.ZLXMID,(SELECT ZLXMJC FROM BM_ZLZD00 WHERE ZLXMID = A.ZLXMID) ZLXMJC FROM VW_TJ_ZLJCDY A WHERE ZLXMID IN (0,27861) AND (XB0000 <> '0') AND XB0000 = '2' ) A GROUP BY ZLXMID, ZLXMJC 2 08:23:32 SQL Execute: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='556647' and zlxmid='27861' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 3 08:23:32 SQL Execute: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='27861' 4 08:23:32 SQL Execute: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=27861 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '220034' AND SFYX00 = 'Y' 5 08:23:32 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6 08:23:32 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 7 08:23:32 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 27861.000000 8 08:23:32 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 556647 9 08:23:32 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 10 08:23:32 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 11 08:23:32 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 27861 12 08:23:32 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 13 08:23:32 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 14 08:23:32 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 15 08:23:32 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 16 08:23:32 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 663.000000 17 08:23:32 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 654 18 08:23:32 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 19 08:23:32 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 20 08:23:32 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 21 08:23:32 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 22 08:23:32 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 23 08:23:32 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 24 08:23:32 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 25 08:23:32 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 26 08:23:32 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 27 08:23:32 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 28 08:23:32 SQL Execute: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='3144153' 29 08:23:32 SQL Data In: ORACLE - Rows affected = 1 30 08:23:32 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='3144153' 31 08:23:32 SQL Data In: ORACLE - Rows affected = 1 32 08:23:32 SQL Execute: ORACLE - UPDATE YJ_YWJJ00 A SET SL0000=(SELECT SL0000*ZKL000/100 FROM TJ_YJDJH0 WHERE YJDJH0=A.YJDJH0) WHERE YJDJH0 IN (SELECT YJDJH0 FROM TJ_YJDJH0 WHERE GHID00=556647) AND GDBZ00='Y' 33 08:23:32 SQL Data In: ORACLE - Rows affected = 1 34 08:23:32 SQL Execute: ORACLE - Commit 35 08:23:32 SQL Data In: ORACLE - Rows affected = 0 36 08:23:32 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and (KDKSBH=663 or YJKSBH=663) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and b.yyid00 = '220034' order by YJdjh0,KSXH00 37 08:23:32 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 38 08:23:32 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('220034', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '556647' AND ROWNUM = 1 AND XMZT00 < 2 39 08:23:32 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 40 08:23:34 SQL Execute: ORACLE - SELECT * FROM (SELECT A.ZLXMID,(SELECT ZLXMJC FROM BM_ZLZD00 WHERE ZLXMID = A.ZLXMID) ZLXMJC FROM VW_TJ_ZLJCDY A WHERE ZLXMID IN (0,27862) AND (XB0000 <> '0') AND XB0000 = '2' ) A GROUP BY ZLXMID, ZLXMJC 41 08:23:34 SQL Execute: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='556647' and zlxmid='27862' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 42 08:23:34 SQL Execute: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='27862' 43 08:23:34 SQL Execute: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=27862 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '220034' AND SFYX00 = 'Y' 44 08:23:34 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 45 08:23:34 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 46 08:23:34 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 27862.000000 47 08:23:34 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 556647 48 08:23:34 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 49 08:23:34 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 50 08:23:34 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 27862 51 08:23:34 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 52 08:23:34 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 53 08:23:34 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 54 08:23:34 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 55 08:23:34 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 663.000000 56 08:23:34 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 654 57 08:23:34 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 58 08:23:34 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 59 08:23:34 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 60 08:23:34 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 61 08:23:34 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 62 08:23:34 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 63 08:23:34 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 64 08:23:34 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 65 08:23:34 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 66 08:23:34 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 67 08:23:34 SQL Execute: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='3144154' 68 08:23:34 SQL Data In: ORACLE - Rows affected = 1 69 08:23:34 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='3144154' 70 08:23:34 SQL Data In: ORACLE - Rows affected = 1 71 08:23:34 SQL Execute: ORACLE - UPDATE YJ_YWJJ00 A SET SL0000=(SELECT SL0000*ZKL000/100 FROM TJ_YJDJH0 WHERE YJDJH0=A.YJDJH0) WHERE YJDJH0 IN (SELECT YJDJH0 FROM TJ_YJDJH0 WHERE GHID00=556647) AND GDBZ00='Y' 72 08:23:34 SQL Data In: ORACLE - Rows affected = 3 73 08:23:34 SQL Execute: ORACLE - Commit 74 08:23:34 SQL Data In: ORACLE - Rows affected = 0 75 08:23:34 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and (KDKSBH=663 or YJKSBH=663) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and b.yyid00 = '220034' order by YJdjh0,KSXH00 76 08:23:34 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 77 08:23:34 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('220034', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '556647' AND ROWNUM = 1 AND XMZT00 < 2 78 08:23:34 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 79 08:23:36 SQL Execute: ORACLE - SELECT * FROM (SELECT A.ZLXMID,(SELECT ZLXMJC FROM BM_ZLZD00 WHERE ZLXMID = A.ZLXMID) ZLXMJC FROM VW_TJ_ZLJCDY A WHERE ZLXMID IN (0,27865) AND (XB0000 <> '0') AND XB0000 = '2' ) A GROUP BY ZLXMID, ZLXMJC 80 08:23:36 SQL Execute: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='556647' and zlxmid='27865' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 81 08:23:36 SQL Execute: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='27865' 82 08:23:36 SQL Execute: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=27865 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '220034' AND SFYX00 = 'Y' 83 08:23:36 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 84 08:23:36 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 85 08:23:36 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 27865.000000 86 08:23:36 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 556647 87 08:23:36 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 88 08:23:36 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 89 08:23:36 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 27865 90 08:23:36 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 91 08:23:36 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 92 08:23:36 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 93 08:23:36 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 94 08:23:36 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 663.000000 95 08:23:36 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 654 96 08:23:36 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 97 08:23:36 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 98 08:23:36 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 99 08:23:36 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 100 08:23:36 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 101 08:23:36 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 102 08:23:36 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 103 08:23:36 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 104 08:23:36 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 105 08:23:36 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 106 08:23:36 SQL Execute: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='3144155' 107 08:23:36 SQL Data In: ORACLE - Rows affected = 1 108 08:23:36 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='3144155' 109 08:23:36 SQL Data In: ORACLE - Rows affected = 1 110 08:23:36 SQL Execute: ORACLE - UPDATE YJ_YWJJ00 A SET SL0000=(SELECT SL0000*ZKL000/100 FROM TJ_YJDJH0 WHERE YJDJH0=A.YJDJH0) WHERE YJDJH0 IN (SELECT YJDJH0 FROM TJ_YJDJH0 WHERE GHID00=556647) AND GDBZ00='Y' 111 08:23:36 SQL Data In: ORACLE - Rows affected = 4 112 08:23:36 SQL Execute: ORACLE - Commit 113 08:23:36 SQL Data In: ORACLE - Rows affected = 0 114 08:23:36 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and (KDKSBH=663 or YJKSBH=663) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and b.yyid00 = '220034' order by YJdjh0,KSXH00 115 08:23:36 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 116 08:23:36 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('220034', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '556647' AND ROWNUM = 1 AND XMZT00 < 2 117 08:23:36 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 118 08:23:39 SQL Execute: ORACLE - SELECT * FROM (SELECT A.ZLXMID,(SELECT ZLXMJC FROM BM_ZLZD00 WHERE ZLXMID = A.ZLXMID) ZLXMJC FROM VW_TJ_ZLJCDY A WHERE ZLXMID IN (0,27867) AND (XB0000 <> '0') AND XB0000 = '2' ) A GROUP BY ZLXMID, ZLXMJC 119 08:23:39 SQL Execute: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='556647' and zlxmid='27867' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 120 08:23:39 SQL Execute: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='27867' 121 08:23:39 SQL Execute: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=27867 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '220034' AND SFYX00 = 'Y' 122 08:23:39 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 123 08:23:39 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 124 08:23:39 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 27867.000000 125 08:23:39 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 556647 126 08:23:39 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 127 08:23:39 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 128 08:23:39 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 23, Scale = 0, Data = 27862,27868,27869,27870 129 08:23:39 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 130 08:23:39 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 131 08:23:39 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 132 08:23:39 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 133 08:23:39 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 663.000000 134 08:23:39 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 654 135 08:23:39 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 136 08:23:39 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 137 08:23:39 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 138 08:23:39 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 139 08:23:39 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 140 08:23:39 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 141 08:23:39 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 142 08:23:39 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 143 08:23:39 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 144 08:23:39 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 145 08:23:39 SQL Execute: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='3144156' 146 08:23:39 SQL Data In: ORACLE - Rows affected = 1 147 08:23:39 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='3144156' 148 08:23:39 SQL Data In: ORACLE - Rows affected = 1 149 08:23:39 SQL Execute: ORACLE - UPDATE YJ_YWJJ00 A SET SL0000=(SELECT SL0000*ZKL000/100 FROM TJ_YJDJH0 WHERE YJDJH0=A.YJDJH0) WHERE YJDJH0 IN (SELECT YJDJH0 FROM TJ_YJDJH0 WHERE GHID00=556647) AND GDBZ00='Y' 150 08:23:39 SQL Data In: ORACLE - Rows affected = 24 151 08:23:39 SQL Execute: ORACLE - Commit 152 08:23:39 SQL Data In: ORACLE - Rows affected = 0 153 08:23:39 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and (KDKSBH=663 or YJKSBH=663) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and b.yyid00 = '220034' order by YJdjh0,KSXH00 154 08:23:39 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 155 08:23:39 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('220034', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '556647' AND ROWNUM = 1 AND XMZT00 < 2 156 08:23:39 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 157 08:23:41 SQL Execute: ORACLE - SELECT * FROM (SELECT A.ZLXMID,(SELECT ZLXMJC FROM BM_ZLZD00 WHERE ZLXMID = A.ZLXMID) ZLXMJC FROM VW_TJ_ZLJCDY A WHERE ZLXMID IN (0,27868) AND (XB0000 <> '0') AND XB0000 = '2' ) A GROUP BY ZLXMID, ZLXMJC 158 08:23:41 SQL Execute: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='556647' and zlxmid='27868' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 159 08:23:41 SQL Execute: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='27868' 160 08:23:41 SQL Execute: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=27868 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '220034' AND SFYX00 = 'Y' 161 08:23:41 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 162 08:23:41 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 163 08:23:41 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 27868.000000 164 08:23:41 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 556647 165 08:23:41 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 166 08:23:41 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 167 08:23:41 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 27868 168 08:23:41 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 169 08:23:41 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 170 08:23:41 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 171 08:23:41 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 172 08:23:41 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 663.000000 173 08:23:41 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 654 174 08:23:41 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 175 08:23:41 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 176 08:23:41 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 177 08:23:41 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 178 08:23:41 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 179 08:23:41 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 180 08:23:41 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 181 08:23:41 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 182 08:23:41 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 183 08:23:41 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 184 08:23:41 SQL Execute: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='3144157' 185 08:23:41 SQL Data In: ORACLE - Rows affected = 1 186 08:23:41 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='3144157' 187 08:23:41 SQL Data In: ORACLE - Rows affected = 1 188 08:23:41 SQL Execute: ORACLE - UPDATE YJ_YWJJ00 A SET SL0000=(SELECT SL0000*ZKL000/100 FROM TJ_YJDJH0 WHERE YJDJH0=A.YJDJH0) WHERE YJDJH0 IN (SELECT YJDJH0 FROM TJ_YJDJH0 WHERE GHID00=556647) AND GDBZ00='Y' 189 08:23:41 SQL Data In: ORACLE - Rows affected = 34 190 08:23:41 SQL Execute: ORACLE - Commit 191 08:23:41 SQL Data In: ORACLE - Rows affected = 0 192 08:23:41 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and (KDKSBH=663 or YJKSBH=663) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and b.yyid00 = '220034' order by YJdjh0,KSXH00 193 08:23:41 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 194 08:23:41 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('220034', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '556647' AND ROWNUM = 1 AND XMZT00 < 2 195 08:23:41 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 196 08:23:43 SQL Execute: ORACLE - SELECT * FROM (SELECT A.ZLXMID,(SELECT ZLXMJC FROM BM_ZLZD00 WHERE ZLXMID = A.ZLXMID) ZLXMJC FROM VW_TJ_ZLJCDY A WHERE ZLXMID IN (0,27463) AND (XB0000 <> '0') AND XB0000 = '2' ) A GROUP BY ZLXMID, ZLXMJC 197 08:23:43 SQL Execute: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='556647' and zlxmid='27463' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 198 08:23:43 SQL Execute: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='27463' 199 08:23:43 SQL Execute: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=27463 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '220034' AND SFYX00 = 'Y' 200 08:23:43 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 201 08:23:43 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 202 08:23:43 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 27463.000000 203 08:23:43 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 556647 204 08:23:43 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 205 08:23:43 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 206 08:23:43 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 27463 207 08:23:43 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 208 08:23:43 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 209 08:23:43 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 210 08:23:43 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 211 08:23:43 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 663.000000 212 08:23:43 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 682 213 08:23:43 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 214 08:23:43 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 215 08:23:43 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 216 08:23:43 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 217 08:23:43 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 218 08:23:43 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 219 08:23:43 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 220 08:23:43 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 221 08:23:43 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 222 08:23:43 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 223 08:23:43 SQL Execute: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='3144158' 224 08:23:43 SQL Data In: ORACLE - Rows affected = 1 225 08:23:43 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='3144158' 226 08:23:43 SQL Data In: ORACLE - Rows affected = 1 227 08:23:43 SQL Execute: ORACLE - UPDATE YJ_YWJJ00 A SET SL0000=(SELECT SL0000*ZKL000/100 FROM TJ_YJDJH0 WHERE YJDJH0=A.YJDJH0) WHERE YJDJH0 IN (SELECT YJDJH0 FROM TJ_YJDJH0 WHERE GHID00=556647) AND GDBZ00='Y' 228 08:23:43 SQL Data In: ORACLE - Rows affected = 36 229 08:23:43 SQL Execute: ORACLE - Commit 230 08:23:43 SQL Data In: ORACLE - Rows affected = 0 231 08:23:43 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and (KDKSBH=663 or YJKSBH=663) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and b.yyid00 = '220034' order by YJdjh0,KSXH00 232 08:23:43 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 233 08:23:43 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('220034', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '556647' AND ROWNUM = 1 AND XMZT00 < 2 234 08:23:43 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 235 08:23:45 SQL Execute: ORACLE - SELECT * FROM (SELECT A.ZLXMID,(SELECT ZLXMJC FROM BM_ZLZD00 WHERE ZLXMID = A.ZLXMID) ZLXMJC FROM VW_TJ_ZLJCDY A WHERE ZLXMID IN (0,27468) AND (XB0000 <> '0') AND XB0000 = '2' ) A GROUP BY ZLXMID, ZLXMJC 236 08:23:45 SQL Execute: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='556647' and zlxmid='27468' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 237 08:23:45 SQL Execute: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='27468' 238 08:23:45 SQL Execute: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=27468 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '220034' AND SFYX00 = 'Y' 239 08:23:45 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 240 08:23:45 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 241 08:23:45 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 27468.000000 242 08:23:45 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 556647 243 08:23:45 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 244 08:23:45 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 245 08:23:45 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 27468 246 08:23:45 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 247 08:23:45 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 248 08:23:45 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 249 08:23:45 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 250 08:23:45 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 663.000000 251 08:23:45 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 682 252 08:23:45 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 253 08:23:45 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 254 08:23:45 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 255 08:23:45 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1633.000000 256 08:23:45 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 257 08:23:45 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 258 08:23:45 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 259 08:23:45 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 260 08:23:45 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 261 08:23:45 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 262 08:23:45 SQL Execute: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='3144159' 263 08:23:45 SQL Data In: ORACLE - Rows affected = 1 264 08:23:45 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='3144159' 265 08:23:45 SQL Data In: ORACLE - Rows affected = 1 266 08:23:45 SQL Execute: ORACLE - UPDATE YJ_YWJJ00 A SET SL0000=(SELECT SL0000*ZKL000/100 FROM TJ_YJDJH0 WHERE YJDJH0=A.YJDJH0) WHERE YJDJH0 IN (SELECT YJDJH0 FROM TJ_YJDJH0 WHERE GHID00=556647) AND GDBZ00='Y' 267 08:23:45 SQL Data In: ORACLE - Rows affected = 38 268 08:23:45 SQL Execute: ORACLE - Commit 269 08:23:45 SQL Data In: ORACLE - Rows affected = 0 270 08:23:45 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and (KDKSBH=663 or YJKSBH=663) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and b.yyid00 = '220034' order by YJdjh0,KSXH00 271 08:23:46 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 272 08:23:46 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('220034', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '556647' AND ROWNUM = 1 AND XMZT00 < 2 273 08:23:46 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 274 08:24:00 SQL Execute: ORACLE - select * from BM_ZKLQXB where YGBH00 = '1633' 275 08:24:00 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000 = '80' where YJDJH0 = '3144153' 276 08:24:00 SQL Data In: ORACLE - Rows affected = 1 277 08:24:00 SQL Execute: ORACLE - select * from BM_ZKLQXB where YGBH00 = '1633' 278 08:24:00 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000 = '80' where YJDJH0 = '3144154' 279 08:24:00 SQL Data In: ORACLE - Rows affected = 1 280 08:24:00 SQL Execute: ORACLE - select * from BM_ZKLQXB where YGBH00 = '1633' 281 08:24:00 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000 = '80' where YJDJH0 = '3144155' 282 08:24:00 SQL Data In: ORACLE - Rows affected = 1 283 08:24:00 SQL Execute: ORACLE - select * from BM_ZKLQXB where YGBH00 = '1633' 284 08:24:00 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000 = '80' where YJDJH0 = '3144156' 285 08:24:00 SQL Data In: ORACLE - Rows affected = 1 286 08:24:00 SQL Execute: ORACLE - select * from BM_ZKLQXB where YGBH00 = '1633' 287 08:24:00 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000 = '80' where YJDJH0 = '3144157' 288 08:24:00 SQL Data In: ORACLE - Rows affected = 1 289 08:24:00 SQL Execute: ORACLE - Commit 290 08:24:00 SQL Data In: ORACLE - Rows affected = 0 291 08:24:00 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and (KDKSBH=663 or YJKSBH=663) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and b.yyid00 = '220034' order by YJdjh0,KSXH00 292 08:24:00 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 293 08:24:00 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('220034', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '556647' AND ROWNUM = 1 AND XMZT00 < 2 294 08:24:00 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='556647' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)))