1 09:00:36 Log started for: 库存物资管理子系统 2 09:00:37 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '192.168.9.252','K',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 09:00:37 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '192.168.9.252','K',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 09:00:37 SQL Data In: ORACLE - Rows affected = 1 5 09:00:37 SQL Prepare: ORACLE - Commit 6 09:00:37 SQL Execute: ORACLE - Commit 7 09:00:37 SQL Data In: ORACLE - Rows affected = 0 8 09:00:37 SQL Prepare: ORACLE - Select SYSDATE from Dual 9 09:00:37 SQL Execute: ORACLE - Select SYSDATE from Dual 10 09:00:37 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 11 09:00:37 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 12 09:00:37 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 13 09:00:37 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 14 09:00:37 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 15 09:00:37 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 16 09:00:37 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 17 09:00:37 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 18 09:00:37 SQL Prepare: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='K' 19 09:00:37 SQL Execute: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='K' 20 09:00:40 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('c','9','1','5','2','a','8') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='K' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9009')) order by BH0000 21 09:00:40 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('c','9','1','5','2','a','8') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='K' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9009')) order by BH0000 22 09:00:40 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9009'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'K' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9009')) 23 09:00:40 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9009'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'K' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9009')) 24 09:00:40 SQL Prepare: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9009' and CZBZ00='1' 25 09:00:40 SQL Execute: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9009' and CZBZ00='1' 26 09:00:40 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 27 09:00:40 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 28 09:00:40 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 29 09:00:40 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 30 09:00:40 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 31 09:00:40 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 32 09:00:40 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 33 09:00:40 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 34 09:00:40 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1742744,803,'wlzx-2','K',nvl('3050344',' '),'',208) 35 09:00:40 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1742744,803,'wlzx-2','K',nvl('3050344',' '),'',208) 36 09:00:40 SQL Data In: ORACLE - Rows affected = 1 37 09:00:40 SQL Prepare: ORACLE - Commit 38 09:00:40 SQL Execute: ORACLE - Commit 39 09:00:40 SQL Data In: ORACLE - Rows affected = 0 40 09:00:40 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 208 41 09:00:40 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 208 42 09:00:40 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 43 09:00:40 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 44 09:00:40 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 45 09:00:40 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 46 09:00:40 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 208 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 47 09:00:40 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 208 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 48 09:00:40 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20090515' 49 09:00:40 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20090515' 50 09:00:40 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=208 51 09:00:40 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=208 52 09:00:40 SQL Prepare: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 53 09:00:40 SQL Execute: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 54 09:00:40 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 55 09:00:40 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 56 09:00:40 SQL Prepare: ORACLE - delete SD_SB.WZ_TEMP00 57 09:00:40 SQL Execute: ORACLE - delete SD_SB.WZ_TEMP00 58 09:00:41 SQL Data In: ORACLE - Rows affected = 0 59 09:00:41 SQL Prepare: ORACLE - Commit 60 09:00:41 SQL Execute: ORACLE - Commit 61 09:00:41 SQL Data In: ORACLE - Rows affected = 0 62 09:00:41 SQL Prepare: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 63 09:00:41 SQL Execute: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 64 09:00:41 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=803 65 09:00:41 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=803 66 09:00:41 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='K' and (( 803= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='K' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=803)))) 67 09:00:41 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='K' and (( 803= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='K' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=803)))) 68 09:00:41 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'K$%' and A.XTDM00='K' and trim(A.MKDM00)='K$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((803= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='K' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=803)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 69 09:00:41 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'K$%' and A.XTDM00='K' and trim(A.MKDM00)='K$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((803= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='K' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=803)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 70 09:00:41 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((803= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=803)))) 71 09:00:41 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((803= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=803)))) 72 09:00:41 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 73 09:00:41 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 74 09:00:41 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 803= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=803)))) 75 09:00:41 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 803= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=803)))) 76 09:00:44 SQL Prepare: ORACLE - SELECT DISTINCT a.SHBMBH,a.SHBMMC,b.BMBH00 FROM WZ_RCK000 a,VW_WZ_CJBM00 b WHERE a.SHBMBH=b.BMID00 AND a.KFBMBH=208 AND RCKLB0='2' AND ZTBZ00='1' ORDER BY b.BMBH00 77 09:00:44 SQL Execute: ORACLE - SELECT DISTINCT a.SHBMBH,a.SHBMMC,b.BMBH00 FROM WZ_RCK000 a,VW_WZ_CJBM00 b WHERE a.SHBMBH=b.BMID00 AND a.KFBMBH=208 AND RCKLB0='2' AND ZTBZ00='1' ORDER BY b.BMBH00 78 09:00:44 SQL Prepare: ORACLE - SELECT RCKDH0,BMMC00,RCKBMC,KDRQ00,BZ0000,RCKID0,KFBMBH,KSQLDH,SHBMBH,SHBMMC FROM VW_WZ_RCK000 WHERE (SHBMBH = :1 or 999999999=:2) AND KFBMBH = :3 AND RCKLB0 ='2' AND ZTBZ00 ='1' AND KDRQ00 >=:4 AND KDRQ00 <=:5 ORDER BY RCKDH0 DESC 79 09:00:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 999999999.000000 80 09:00:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 999999999.000000 81 09:00:44 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 82 09:00:44 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090508 83 09:00:44 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090515 84 09:00:44 SQL Execute: ORACLE - SELECT RCKDH0,BMMC00,RCKBMC,KDRQ00,BZ0000,RCKID0,KFBMBH,KSQLDH,SHBMBH,SHBMMC FROM VW_WZ_RCK000 WHERE (SHBMBH = ? or 999999999=?) AND KFBMBH = ? AND RCKLB0 ='2' AND ZTBZ00 ='1' AND KDRQ00 >=? AND KDRQ00 <=? ORDER BY RCKDH0 DESC 85 09:00:44 SQL Prepare: ORACLE - select * from VW_WZ_RCKMX0 where RCKID0=:1 order by RCKMXH 86 09:00:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35902.000000 87 09:00:44 SQL Execute: ORACLE - select * from VW_WZ_RCKMX0 where RCKID0=? order by RCKMXH 88 09:00:45 SQL Prepare: ORACLE - select * from VW_WZ_RCKMX0 where RCKID0=:1 order by RCKMXH 89 09:00:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35902.000000 90 09:00:45 SQL Execute: ORACLE - select * from VW_WZ_RCKMX0 where RCKID0=? order by RCKMXH 91 09:00:45 SQL Prepare: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 WHERE RCKBZ0 = '2' AND SFYX00 = 'Y' order by RCKBBH 92 09:00:45 SQL Execute: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 WHERE RCKBZ0 = '2' AND SFYX00 = 'Y' order by RCKBBH 93 09:00:45 SQL Prepare: ORACLE - select * from WZ_RCK000 where RCKLB0='2' and KFBMBH=208 and ZTBZ00='1' order by RCKID0 94 09:00:45 SQL Execute: ORACLE - select * from WZ_RCK000 where RCKLB0='2' and KFBMBH=208 and ZTBZ00='1' order by RCKID0 95 09:00:45 SQL Prepare: ORACLE - select * from VW_WZ_RCK000 where RCKID0=:1 and ZTBZ00='1' and RCKLB0='2' 96 09:00:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35902.000000 97 09:00:45 SQL Execute: ORACLE - select * from VW_WZ_RCK000 where RCKID0=? and ZTBZ00='1' and RCKLB0='2' 98 09:00:45 SQL Prepare: ORACLE - SELECT YGBH00,ZWXM00 FROM BM_YGBM00 WHERE YGBH00 ='307' 99 09:00:45 SQL Execute: ORACLE - SELECT YGBH00,ZWXM00 FROM BM_YGBM00 WHERE YGBH00 ='307' 100 09:00:45 SQL Prepare: ORACLE - SELECT * FROM VW_WZ_RCKMX0 WHERE RCKID0=35902 101 09:00:45 SQL Execute: ORACLE - SELECT * FROM VW_WZ_RCKMX0 WHERE RCKID0=35902 102 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 103 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 104 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11705 105 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11705 106 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =7402 107 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =7402 108 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11706 109 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11706 110 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11716 111 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11716 112 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8510 113 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8510 114 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11718 115 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11718 116 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10402 117 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10402 118 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11602 119 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11602 120 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 121 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 122 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 123 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 124 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 125 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 126 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 127 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 128 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 129 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 130 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 131 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 132 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 133 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 134 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 135 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 136 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 137 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 138 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11705 139 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11705 140 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =7402 141 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =7402 142 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11706 143 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11706 144 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11716 145 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11716 146 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8510 147 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8510 148 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11718 149 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11718 150 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10402 151 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10402 152 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11602 153 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11602 154 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 155 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 156 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 157 09:00:45 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 158 09:00:45 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 159 09:00:46 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 160 09:00:46 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 161 09:00:46 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 162 09:00:46 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 163 09:00:46 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 164 09:00:46 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 165 09:00:46 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 166 09:00:46 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 167 09:00:46 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 168 09:00:46 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 169 09:00:46 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 170 09:00:46 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 171 09:00:46 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 172 09:00:46 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=803 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKSR' 173 09:00:46 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=803 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKSR' 174 09:00:46 SQL Prepare: ORACLE - select LS0000,SFXS00 from XT_ZDYLXS where YGBH00=803 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKSR' and DBGRIN='DBGridEh1' order by LS0000 175 09:00:46 SQL Execute: ORACLE - select LS0000,SFXS00 from XT_ZDYLXS where YGBH00=803 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKSR' and DBGRIN='DBGridEh1' order by LS0000 176 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 177 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 178 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11705 179 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11705 180 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =7402 181 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =7402 182 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11706 183 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11706 184 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11716 185 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11716 186 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8510 187 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8510 188 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11718 189 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11718 190 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10402 191 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10402 192 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11602 193 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11602 194 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 195 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 196 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 197 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 198 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 199 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 200 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 201 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 202 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 203 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 204 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 205 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 206 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 207 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 208 09:01:00 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 209 09:01:00 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 210 09:01:02 SQL Prepare: ORACLE - SELECT DISTINCT a.SHBMBH,a.SHBMMC,b.BMBH00 FROM WZ_RCK000 a,VW_WZ_CJBM00 b WHERE a.SHBMBH=b.BMID00 AND a.KFBMBH=208 AND RCKLB0='2' AND ZTBZ00='1' ORDER BY b.BMBH00 211 09:01:02 SQL Execute: ORACLE - SELECT DISTINCT a.SHBMBH,a.SHBMMC,b.BMBH00 FROM WZ_RCK000 a,VW_WZ_CJBM00 b WHERE a.SHBMBH=b.BMID00 AND a.KFBMBH=208 AND RCKLB0='2' AND ZTBZ00='1' ORDER BY b.BMBH00 212 09:01:02 SQL Prepare: ORACLE - SELECT RCKDH0,BMMC00,RCKBMC,KDRQ00,BZ0000,RCKID0,KFBMBH,KSQLDH,SHBMBH,SHBMMC FROM VW_WZ_RCK000 WHERE (SHBMBH = :1 or 999999999=:2) AND KFBMBH = :3 AND RCKLB0 ='2' AND ZTBZ00 ='1' AND KDRQ00 >=:4 AND KDRQ00 <=:5 ORDER BY RCKDH0 DESC 213 09:01:02 SQL Execute: ORACLE - SELECT RCKDH0,BMMC00,RCKBMC,KDRQ00,BZ0000,RCKID0,KFBMBH,KSQLDH,SHBMBH,SHBMMC FROM VW_WZ_RCK000 WHERE (SHBMBH = ? or 999999999=?) AND KFBMBH = ? AND RCKLB0 ='2' AND ZTBZ00 ='1' AND KDRQ00 >=? AND KDRQ00 <=? ORDER BY RCKDH0 DESC 214 09:01:02 SQL Prepare: ORACLE - select * from VW_WZ_RCKMX0 where RCKID0=:1 order by RCKMXH 215 09:01:02 SQL Execute: ORACLE - select * from VW_WZ_RCKMX0 where RCKID0=? order by RCKMXH 216 09:01:03 SQL Prepare: ORACLE - select * from VW_WZ_RCKMX0 where RCKID0=:1 order by RCKMXH 217 09:01:03 SQL Execute: ORACLE - select * from VW_WZ_RCKMX0 where RCKID0=? order by RCKMXH 218 09:01:05 SQL Prepare: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 WHERE RCKBZ0 = '2' AND SFYX00 = 'Y' order by RCKBBH 219 09:01:05 SQL Execute: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 WHERE RCKBZ0 = '2' AND SFYX00 = 'Y' order by RCKBBH 220 09:01:05 SQL Prepare: ORACLE - select * from VW_WZ_RCK000 where RCKID0=:1 and ZTBZ00='1' and RCKLB0='2' 221 09:01:05 SQL Execute: ORACLE - select * from VW_WZ_RCK000 where RCKID0=? and ZTBZ00='1' and RCKLB0='2' 222 09:01:05 SQL Prepare: ORACLE - SELECT YGBH00,ZWXM00 FROM BM_YGBM00 WHERE YGBH00 ='307' 223 09:01:05 SQL Execute: ORACLE - SELECT YGBH00,ZWXM00 FROM BM_YGBM00 WHERE YGBH00 ='307' 224 09:01:05 SQL Prepare: ORACLE - SELECT * FROM VW_WZ_RCKMX0 WHERE RCKID0=35902 225 09:01:05 SQL Execute: ORACLE - SELECT * FROM VW_WZ_RCKMX0 WHERE RCKID0=35902 226 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 227 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 228 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11705 229 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11705 230 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =7402 231 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =7402 232 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11706 233 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11706 234 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11716 235 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11716 236 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8510 237 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8510 238 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11718 239 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11718 240 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10402 241 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10402 242 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11602 243 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11602 244 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 245 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 246 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 247 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 248 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 249 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 250 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 251 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 252 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 253 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 254 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 255 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 256 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 257 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 258 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 259 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 260 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 261 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 262 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11705 263 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11705 264 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =7402 265 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =7402 266 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11706 267 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11706 268 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11716 269 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11716 270 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8510 271 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8510 272 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11718 273 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11718 274 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10402 275 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10402 276 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11602 277 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11602 278 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 279 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 280 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 281 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 282 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 283 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 284 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 285 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =6106 286 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 287 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =10409 288 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 289 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 290 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 291 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =11604 292 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 293 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 294 09:01:05 SQL Prepare: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 295 09:01:05 SQL Execute: ORACLE - SELECT NVL(KCZSL0,0) PCJCS0 FROM WZ_KC0000 WHERE KCID00 =8227 296 09:01:05 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=803 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKSR' 297 09:01:05 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=803 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKSR' 298 09:01:05 SQL Prepare: ORACLE - select LS0000,SFXS00 from XT_ZDYLXS where YGBH00=803 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKSR' and DBGRIN='DBGridEh1' order by LS0000 299 09:01:05 SQL Execute: ORACLE - select LS0000,SFXS00 from XT_ZDYLXS where YGBH00=803 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKSR' and DBGRIN='DBGridEh1' order by LS0000