1 15:13:21 Log started for: 库存物资管理子系统 2 15:13:21 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '192.168.1.4','K',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 15:13:21 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '192.168.1.4','K',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 15:13:21 SQL Data In: ORACLE - Rows affected = 1 5 15:13:21 SQL Prepare: ORACLE - Commit 6 15:13:21 SQL Execute: ORACLE - Commit 7 15:13:21 SQL Data In: ORACLE - Rows affected = 0 8 15:13:21 SQL Prepare: ORACLE - Select SYSDATE from Dual 9 15:13:21 SQL Execute: ORACLE - Select SYSDATE from Dual 10 15:13:21 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 11 15:13:21 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 12 15:13:21 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 13 15:13:21 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 14 15:13:21 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 15 15:13:21 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 16 15:13:21 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 17 15:13:21 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 18 15:13:21 SQL Prepare: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='K' 19 15:13:21 SQL Execute: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='K' 20 15:13:25 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('c') 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)='9999')) order by BH0000 21 15:13:25 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('c') 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)='9999')) order by BH0000 22 15:13:32 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9999'='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)='9999')) 23 15:13:32 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9999'='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)='9999')) 24 15:13:32 SQL Prepare: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00='1' 25 15:13:32 SQL Execute: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00='1' 26 15:13:32 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 27 15:13:32 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 28 15:13:32 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 29 15:13:32 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 30 15:13:32 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.4' 31 15:13:32 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.4' 32 15:13:32 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 33 15:13:32 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 34 15:13:32 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 494 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 35 15:13:32 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 494 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 36 15:13:32 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 37 15:13:32 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 38 15:13:32 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 39 15:13:32 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 40 15:13:32 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(459552,636,'3E03347A1BE045A','K',nvl('257922',' '),'',494) 41 15:13:32 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(459552,636,'3E03347A1BE045A','K',nvl('257922',' '),'',494) 42 15:13:32 SQL Data In: ORACLE - Rows affected = 1 43 15:13:32 SQL Prepare: ORACLE - Commit 44 15:13:32 SQL Execute: ORACLE - Commit 45 15:13:32 SQL Data In: ORACLE - Rows affected = 0 46 15:13:32 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 494 47 15:13:32 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 494 48 15:13:32 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20090522' 49 15:13:32 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20090522' 50 15:13:32 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=494 51 15:13:32 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=494 52 15:13:32 SQL Prepare: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 53 15:13:32 SQL Execute: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 54 15:13:32 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 55 15:13:32 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 56 15:13:32 SQL Prepare: ORACLE - delete SD_SB.WZ_TEMP00 57 15:13:32 SQL Execute: ORACLE - delete SD_SB.WZ_TEMP00 58 15:13:33 SQL Data In: ORACLE - Rows affected = 2392 59 15:13:33 SQL Prepare: ORACLE - Commit 60 15:13:33 SQL Execute: ORACLE - Commit 61 15:13:33 SQL Data In: ORACLE - Rows affected = 0 62 15:13:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 63 15:13:33 SQL Execute: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 64 15:13:33 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=636 65 15:13:33 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=636 66 15:13:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='K' and (( 636= 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=636)))) 67 15:13:33 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='K' and (( 636= 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=636)))) 68 15:13:33 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 ((636= 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=636)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 69 15:13:33 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 ((636= 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=636)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 70 15:13:33 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 ((636= 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=636)))) 71 15:13:33 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 ((636= 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=636)))) 72 15:13:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 73 15:13:33 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 74 15:13:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 636= 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=636)))) 75 15:13:33 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 636= 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=636)))) 76 15:13:36 SQL Prepare: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH 77 15:13:36 SQL Execute: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH 78 15:13:36 SQL Prepare: ORACLE - BEGIN "SP_WZ_KCCX00" (:p1,:p2,:p3,:p4,:p5); END; 79 15:13:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 494 80 15:13:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 81 15:13:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 82 15:13:36 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 83 15:13:36 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 84 15:13:36 SQL Execute: ORACLE - BEGIN "SP_WZ_KCCX00" (?,?,?,?,?); END; 85 15:13:36 SQL Prepare: ORACLE - SELECT WZSXMC,WZMC00,trim(wzgg00)||trim(wzxh00) as GGXH00 ,WZGG00,WZXH00,WZDW00,JSJE00,JSSL00,ZJJE00, PH0000,PZDE00,HGH000,JCS000,KSMC00,SHBMMC,TEMP00 FROM WZ_TEMP00 WHERE TJID00 = :1 ORDER BY TJPX00 86 15:13:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29807.000000 87 15:13:36 SQL Execute: ORACLE - SELECT WZSXMC,WZMC00,trim(wzgg00)||trim(wzxh00) as GGXH00 ,WZGG00,WZXH00,WZDW00,JSJE00,JSSL00,ZJJE00, PH0000,PZDE00,HGH000,JCS000,KSMC00,SHBMMC,TEMP00 FROM WZ_TEMP00 WHERE TJID00 = ? ORDER BY TJPX00 88 15:13:36 SQL Prepare: ORACLE - BEGIN "SP_WZ_KCCX00" (:p1,:p2,:p3,:p4,:p5); END; 89 15:13:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 494 90 15:13:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 91 15:13:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 92 15:13:36 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 93 15:13:36 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 94 15:13:36 SQL Execute: ORACLE - BEGIN "SP_WZ_KCCX00" (?,?,?,?,?); END; 95 15:13:36 SQL Prepare: ORACLE - SELECT WZSXMC,WZMC00,trim(wzgg00)||trim(wzxh00) as GGXH00 ,WZGG00,WZXH00,WZDW00,JSJE00,JSSL00,ZJJE00, PH0000,PZDE00,HGH000,JCS000,KSMC00,SHBMMC,TEMP00 FROM WZ_TEMP00 WHERE TJID00 = :1 ORDER BY TJPX00 96 15:13:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29808.000000 97 15:13:36 SQL Execute: ORACLE - SELECT WZSXMC,WZMC00,trim(wzgg00)||trim(wzxh00) as GGXH00 ,WZGG00,WZXH00,WZDW00,JSJE00,JSSL00,ZJJE00, PH0000,PZDE00,HGH000,JCS000,KSMC00,SHBMMC,TEMP00 FROM WZ_TEMP00 WHERE TJID00 = ? ORDER BY TJPX00