1 16:11:52 Log started for: 库存物资管理子系统 2 16:11:52 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 16:11:52 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 16:11:52 SQL Data In: ORACLE - Rows affected = 1 5 16:11:52 SQL Prepare: ORACLE - Commit 6 16:11:52 SQL Execute: ORACLE - Commit 7 16:11:52 SQL Data In: ORACLE - Rows affected = 0 8 16:11:52 SQL Prepare: ORACLE - Select SYSDATE from Dual 9 16:11:52 SQL Execute: ORACLE - Select SYSDATE from Dual 10 16:11:52 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 11 16:11:52 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 12 16:11:52 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 13 16:11:52 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 14 16:11:52 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 15 16:11:52 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 16 16:11:52 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 16:11:52 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 16:11:52 SQL Prepare: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='K' 19 16:11:52 SQL Execute: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='K' 20 16:11:53 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)='9998')) order by BH0000 21 16:11:53 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)='9998')) order by BH0000 22 16:11:58 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='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)='9998')) 23 16:11:58 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='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)='9998')) 24 16:11:58 SQL Prepare: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00='1' 25 16:11:58 SQL Execute: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00='1' 26 16:11:58 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 27 16:11:58 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 28 16:11:58 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 29 16:11:58 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 30 16:11:58 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 31 16:11:58 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 32 16:11:58 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 33 16:11:58 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 34 16:11:58 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 35 16:11:58 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 36 16:11:58 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 37 16:11:58 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 38 16:11:58 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 39 16:11:58 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 40 16:11:58 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1724913,476,'wlzx-2','K',nvl('3023638',' '),'',208) 41 16:11:58 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1724913,476,'wlzx-2','K',nvl('3023638',' '),'',208) 42 16:11:58 SQL Data In: ORACLE - Rows affected = 1 43 16:11:58 SQL Prepare: ORACLE - Commit 44 16:11:58 SQL Execute: ORACLE - Commit 45 16:11:58 SQL Data In: ORACLE - Rows affected = 0 46 16:11:58 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 208 47 16:11:58 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 208 48 16:11:58 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20090429' 49 16:11:58 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20090429' 50 16:11:58 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=208 51 16:11:58 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=208 52 16:11:58 SQL Prepare: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 53 16:11:58 SQL Execute: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 54 16:11:58 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 55 16:11:58 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 56 16:11:58 SQL Prepare: ORACLE - delete SD_SB.WZ_TEMP00 57 16:11:58 SQL Execute: ORACLE - delete SD_SB.WZ_TEMP00 58 16:11:58 SQL Data In: ORACLE - Rows affected = 721 59 16:11:58 SQL Prepare: ORACLE - Commit 60 16:11:58 SQL Execute: ORACLE - Commit 61 16:11:58 SQL Data In: ORACLE - Rows affected = 0 62 16:11:58 SQL Prepare: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 63 16:11:58 SQL Execute: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 64 16:11:58 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=476 65 16:11:58 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476 66 16:11:58 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='K' and (( 476= 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=476)))) 67 16:11:58 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='K' and (( 476= 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=476)))) 68 16:11:58 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 ((476= 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=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 69 16:11:58 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 ((476= 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=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 70 16:11:58 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 ((476= 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=476)))) 71 16:11:58 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 ((476= 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=476)))) 72 16:11:58 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 73 16:11:58 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 74 16:11:58 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 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=476)))) 75 16:11:58 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 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=476)))) 76 16:12:05 SQL Prepare: ORACLE - SELECT * FROM BM_WZSX00 77 16:12:05 SQL Execute: ORACLE - SELECT * FROM BM_WZSX00 78 16:12:05 SQL Prepare: ORACLE - SELECT YJFLID,YJFLMC FROM BM_WZYJFL WHERE YJFLBH LIKE '%' ORDER BY YJFLID 79 16:12:05 SQL Execute: ORACLE - SELECT YJFLID,YJFLMC FROM BM_WZYJFL WHERE YJFLBH LIKE '%' ORDER BY YJFLID 80 16:12:10 SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 81 16:12:10 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 82 16:12:10 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1 or WZDMBM Like :2) Order By WZDMBM,PYSM00) where Rownum<=40 83 16:12:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 84 16:12:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 85 16:12:10 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ? or WZDMBM Like ?) Order By WZDMBM,PYSM00) where Rownum<=40 86 16:12:13 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 87 16:12:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = g% 88 16:12:13 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 89 16:12:14 SQL Prepare: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 90 16:12:14 SQL Data In: ORACLE - Param = 1, Name = AS_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 91 16:12:14 SQL Data In: ORACLE - Param = 2, Name = AS_WZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8306.000000 92 16:12:14 SQL Data In: ORACLE - Param = 3, Name = STARTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 93 16:12:14 SQL Data In: ORACLE - Param = 4, Name = ENDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090429 94 16:12:14 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 95 16:12:14 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 96 16:12:14 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 97 16:12:14 SQL Execute: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 98 16:12:14 SQL Prepare: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00 99 16:12:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22893.000000 100 16:12:14 SQL Execute: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00 101 16:12:15 SQL Prepare: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=:1 102 16:12:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8306.000000 103 16:12:15 SQL Execute: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=? 104 16:12:15 SQL Prepare: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00) 105 16:12:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22893.000000 106 16:12:15 SQL Execute: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00) 107 16:27:40 SQL Prepare: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=:1 108 16:27:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8306.000000 109 16:27:40 SQL Execute: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=? 110 16:27:40 SQL Prepare: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00) 111 16:27:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22893.000000 112 16:27:40 SQL Execute: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00) 113 16:29:47 SQL Prepare: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=:1 114 16:29:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8306.000000 115 16:29:47 SQL Execute: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=? 116 16:29:47 SQL Prepare: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00) 117 16:29:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22893.000000 118 16:29:47 SQL Execute: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00) 119 16:30:13 SQL Prepare: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 120 16:30:13 SQL Data In: ORACLE - Param = 1, Name = AS_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 121 16:30:13 SQL Data In: ORACLE - Param = 2, Name = AS_WZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8306.000000 122 16:30:13 SQL Data In: ORACLE - Param = 3, Name = STARTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 123 16:30:13 SQL Data In: ORACLE - Param = 4, Name = ENDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090429 124 16:30:13 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 125 16:30:13 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 126 16:30:13 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 127 16:30:13 SQL Execute: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 128 16:30:13 SQL Prepare: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00 129 16:30:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22896.000000 130 16:30:13 SQL Execute: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00 131 16:30:14 SQL Prepare: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=:1 132 16:30:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8306.000000 133 16:30:14 SQL Execute: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=? 134 16:30:14 SQL Prepare: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00) 135 16:30:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22896.000000 136 16:30:14 SQL Execute: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00) 137 16:30:28 SQL Prepare: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=:1 138 16:30:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8306.000000 139 16:30:28 SQL Execute: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=? 140 16:30:28 SQL Prepare: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00) 141 16:30:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22896.000000 142 16:30:28 SQL Execute: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00) 143 16:30:56 SQL Prepare: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=:1 144 16:30:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8306.000000 145 16:30:56 SQL Execute: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=? 146 16:30:56 SQL Prepare: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00) 147 16:30:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22896.000000 148 16:30:56 SQL Execute: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00) 149 16:31:01 SQL Prepare: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 150 16:31:01 SQL Data In: ORACLE - Param = 1, Name = AS_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 151 16:31:01 SQL Data In: ORACLE - Param = 2, Name = AS_WZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8306.000000 152 16:31:01 SQL Data In: ORACLE - Param = 3, Name = STARTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 153 16:31:01 SQL Data In: ORACLE - Param = 4, Name = ENDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090429 154 16:31:01 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 155 16:31:01 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 156 16:31:01 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 157 16:31:01 SQL Execute: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 158 16:31:01 SQL Prepare: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00 159 16:31:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22897.000000 160 16:31:01 SQL Execute: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00 161 16:31:02 SQL Prepare: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=:1 162 16:31:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8306.000000 163 16:31:02 SQL Execute: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=? 164 16:31:02 SQL Prepare: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00) 165 16:31:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22897.000000 166 16:31:02 SQL Execute: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00) 167 16:32:36 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 168 16:32:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 谷氨酰转酞酶（ggt）% 169 16:32:36 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 170 16:32:37 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 171 16:32:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 谷氨酰转酞酶（ggt% 172 16:32:37 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 173 16:32:38 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 174 16:32:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = 谷氨酰转酞酶（gg% 175 16:32:38 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 176 16:32:38 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 177 16:32:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 谷氨酰转酞酶（g% 178 16:32:38 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 179 16:32:38 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 180 16:32:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 15, Scale = 0, Data = 谷氨酰转酞酶（% 181 16:32:38 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 182 16:32:38 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 183 16:32:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = 谷氨酰转酞酶% 184 16:32:38 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 185 16:32:38 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 186 16:32:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 谷氨酰转酞% 187 16:32:38 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 188 16:32:38 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 189 16:32:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 谷氨酰转% 190 16:32:38 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 191 16:32:38 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 192 16:32:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 谷氨酰% 193 16:32:38 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 194 16:32:38 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 195 16:32:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 谷氨% 196 16:32:38 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 197 16:32:38 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 198 16:32:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 谷% 199 16:32:38 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 200 16:32:38 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1 or WZDMBM Like :2) Order By WZDMBM,PYSM00) where Rownum<=40 201 16:32:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 202 16:32:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 203 16:32:38 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ? or WZDMBM Like ?) Order By WZDMBM,PYSM00) where Rownum<=40 204 16:32:40 SQL Prepare: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 205 16:32:40 SQL Data In: ORACLE - Param = 1, Name = AS_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 206 16:32:40 SQL Data In: ORACLE - Param = 2, Name = AS_WZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6711.000000 207 16:32:40 SQL Data In: ORACLE - Param = 3, Name = STARTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 208 16:32:40 SQL Data In: ORACLE - Param = 4, Name = ENDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090429 209 16:32:40 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 210 16:32:40 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 211 16:32:40 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 212 16:32:40 SQL Execute: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 213 16:32:40 SQL Prepare: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00 214 16:32:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22898.000000 215 16:32:40 SQL Execute: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00 216 16:32:41 SQL Prepare: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 217 16:32:41 SQL Data In: ORACLE - Param = 1, Name = AS_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 218 16:32:41 SQL Data In: ORACLE - Param = 2, Name = AS_WZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6711.000000 219 16:32:41 SQL Data In: ORACLE - Param = 3, Name = STARTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 220 16:32:41 SQL Data In: ORACLE - Param = 4, Name = ENDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090429 221 16:32:41 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 222 16:32:41 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 223 16:32:41 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 224 16:32:41 SQL Execute: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 225 16:32:41 SQL Prepare: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00 226 16:32:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22899.000000 227 16:32:41 SQL Execute: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00 228 16:32:43 SQL Prepare: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=:1 229 16:32:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6711.000000 230 16:32:43 SQL Execute: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=? 231 16:32:43 SQL Prepare: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00) 232 16:32:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22899.000000 233 16:32:43 SQL Execute: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00) 234 16:32:48 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1 or WZDMBM Like :2) Order By WZDMBM,PYSM00) where Rownum<=40 235 16:32:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 236 16:32:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 237 16:32:48 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ? or WZDMBM Like ?) Order By WZDMBM,PYSM00) where Rownum<=40 238 16:32:49 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 239 16:32:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = f% 240 16:32:49 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 241 16:33:02 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1 or WZDMBM Like :2) Order By WZDMBM,PYSM00) where Rownum<=40 242 16:33:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 243 16:33:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 244 16:33:02 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ? or WZDMBM Like ?) Order By WZDMBM,PYSM00) where Rownum<=40 245 16:33:03 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 246 16:33:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = y% 247 16:33:03 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 248 16:33:03 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 249 16:33:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = yc% 250 16:33:03 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 251 16:33:03 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 252 16:33:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ycx% 253 16:33:03 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 254 16:33:03 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 255 16:33:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = ycxy% 256 16:33:03 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 257 16:33:05 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 258 16:33:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ycxyb% 259 16:33:05 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 260 16:33:05 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 261 16:33:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = ycxy% 262 16:33:05 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 263 16:33:06 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 264 16:33:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ycx% 265 16:33:06 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 266 16:33:06 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 267 16:33:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = ycxy% 268 16:33:06 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 269 16:33:07 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 270 16:33:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ycxyb% 271 16:33:07 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 272 16:33:08 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 273 16:33:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = ycxy% 274 16:33:08 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 275 16:33:13 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 276 16:33:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ycx% 277 16:33:13 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 278 16:33:13 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 279 16:33:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = ycxf% 280 16:33:13 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 281 16:33:13 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 282 16:33:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ycxfy% 283 16:33:13 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 284 16:33:14 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 285 16:33:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ycxfy% 286 16:33:14 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 287 16:33:14 SQL Prepare: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 288 16:33:14 SQL Data In: ORACLE - Param = 1, Name = AS_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 289 16:33:14 SQL Data In: ORACLE - Param = 2, Name = AS_WZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6565.000000 290 16:33:14 SQL Data In: ORACLE - Param = 3, Name = STARTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 291 16:33:14 SQL Data In: ORACLE - Param = 4, Name = ENDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090429 292 16:33:14 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 293 16:33:14 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 294 16:33:14 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 295 16:33:14 SQL Execute: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 296 16:33:14 SQL Prepare: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00 297 16:33:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22900.000000 298 16:33:14 SQL Execute: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00 299 16:33:15 SQL Prepare: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 300 16:33:15 SQL Data In: ORACLE - Param = 1, Name = AS_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 301 16:33:15 SQL Data In: ORACLE - Param = 2, Name = AS_WZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6565.000000 302 16:33:15 SQL Data In: ORACLE - Param = 3, Name = STARTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 303 16:33:15 SQL Data In: ORACLE - Param = 4, Name = ENDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090429 304 16:33:15 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 305 16:33:15 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 306 16:33:15 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 307 16:33:15 SQL Execute: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 308 16:33:15 SQL Prepare: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00 309 16:33:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22901.000000 310 16:33:15 SQL Execute: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00 311 16:33:16 SQL Prepare: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=:1 312 16:33:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6565.000000 313 16:33:16 SQL Execute: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=? 314 16:33:16 SQL Prepare: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00) 315 16:33:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22901.000000 316 16:33:16 SQL Execute: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00) 317 16:33:52 SQL Prepare: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 318 16:33:52 SQL Data In: ORACLE - Param = 1, Name = AS_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 319 16:33:52 SQL Data In: ORACLE - Param = 2, Name = AS_WZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6565.000000 320 16:33:52 SQL Data In: ORACLE - Param = 3, Name = STARTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 321 16:33:52 SQL Data In: ORACLE - Param = 4, Name = ENDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20081231 322 16:33:52 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 323 16:33:52 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 324 16:33:52 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 325 16:33:52 SQL Execute: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 326 16:33:53 SQL Prepare: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00 327 16:33:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22902.000000 328 16:33:53 SQL Execute: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00 329 16:33:53 SQL Prepare: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=:1 330 16:33:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6565.000000 331 16:33:53 SQL Execute: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=? 332 16:33:53 SQL Prepare: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00) 333 16:33:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22902.000000 334 16:33:53 SQL Execute: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00) 335 16:34:04 SQL Prepare: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 336 16:34:04 SQL Data In: ORACLE - Param = 1, Name = AS_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 337 16:34:04 SQL Data In: ORACLE - Param = 2, Name = AS_WZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6565.000000 338 16:34:04 SQL Data In: ORACLE - Param = 3, Name = STARTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 339 16:34:04 SQL Data In: ORACLE - Param = 4, Name = ENDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20091231 340 16:34:04 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 341 16:34:04 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 342 16:34:04 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 343 16:34:04 SQL Execute: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 344 16:34:04 SQL Prepare: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00 345 16:34:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22903.000000 346 16:34:04 SQL Execute: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00 347 16:34:05 SQL Prepare: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=:1 348 16:34:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6565.000000 349 16:34:05 SQL Execute: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=? 350 16:34:05 SQL Prepare: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00) 351 16:34:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22903.000000 352 16:34:05 SQL Execute: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00) 353 16:34:34 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1 or WZDMBM Like :2) Order By WZDMBM,PYSM00) where Rownum<=40 354 16:34:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 355 16:34:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 356 16:34:34 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ? or WZDMBM Like ?) Order By WZDMBM,PYSM00) where Rownum<=40 357 16:34:35 SQL Prepare: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 358 16:34:35 SQL Data In: ORACLE - Param = 1, Name = AS_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 359 16:34:35 SQL Data In: ORACLE - Param = 2, Name = AS_WZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6709.000000 360 16:34:35 SQL Data In: ORACLE - Param = 3, Name = STARTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 361 16:34:35 SQL Data In: ORACLE - Param = 4, Name = ENDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20091231 362 16:34:35 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 363 16:34:35 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 364 16:34:35 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 365 16:34:35 SQL Execute: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 366 16:34:35 SQL Prepare: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00 367 16:34:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22904.000000 368 16:34:35 SQL Execute: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00 369 16:34:38 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1 or WZDMBM Like :2) Order By WZDMBM,PYSM00) where Rownum<=40 370 16:34:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 371 16:34:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 372 16:34:38 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ? or WZDMBM Like ?) Order By WZDMBM,PYSM00) where Rownum<=40 373 16:34:39 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 374 16:34:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = f% 375 16:34:39 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 376 16:34:40 SQL Prepare: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 377 16:34:40 SQL Data In: ORACLE - Param = 1, Name = AS_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 378 16:34:40 SQL Data In: ORACLE - Param = 2, Name = AS_WZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10812.000000 379 16:34:40 SQL Data In: ORACLE - Param = 3, Name = STARTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 380 16:34:40 SQL Data In: ORACLE - Param = 4, Name = ENDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20091231 381 16:34:40 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 382 16:34:40 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 383 16:34:40 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 384 16:34:40 SQL Execute: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 385 16:34:40 SQL Prepare: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00 386 16:34:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22905.000000 387 16:34:40 SQL Execute: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00 388 16:34:41 SQL Prepare: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 389 16:34:41 SQL Data In: ORACLE - Param = 1, Name = AS_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 390 16:34:41 SQL Data In: ORACLE - Param = 2, Name = AS_WZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10812.000000 391 16:34:41 SQL Data In: ORACLE - Param = 3, Name = STARTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 392 16:34:41 SQL Data In: ORACLE - Param = 4, Name = ENDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20091231 393 16:34:41 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 394 16:34:41 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 395 16:34:41 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 396 16:34:41 SQL Execute: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 397 16:34:41 SQL Prepare: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00 398 16:34:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22906.000000 399 16:34:41 SQL Execute: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00 400 16:34:42 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1 or WZDMBM Like :2) Order By WZDMBM,PYSM00) where Rownum<=40 401 16:34:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 402 16:34:42 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 403 16:34:42 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ? or WZDMBM Like ?) Order By WZDMBM,PYSM00) where Rownum<=40 404 16:34:44 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 405 16:34:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = d% 406 16:34:44 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 407 16:34:45 SQL Prepare: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=40 408 16:34:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = ds% 409 16:34:45 SQL Execute: ORACLE - Select * from (select WZMC00,WZGG00,JLDW00,PYSM00,WBSM00,WZID00,WZXH00,WZDMBM from VW_WZ_WZXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=40 410 16:34:46 SQL Prepare: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 411 16:34:46 SQL Data In: ORACLE - Param = 1, Name = AS_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 412 16:34:46 SQL Data In: ORACLE - Param = 2, Name = AS_WZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7105.000000 413 16:34:46 SQL Data In: ORACLE - Param = 3, Name = STARTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 414 16:34:46 SQL Data In: ORACLE - Param = 4, Name = ENDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20091231 415 16:34:46 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 416 16:34:46 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 417 16:34:46 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 418 16:34:46 SQL Execute: ORACLE - BEGIN "SP_WZ_WZMXZ0_CL" (AS_KSBH00 => :AS_KSBH00,AS_WZID00 => :AS_WZID00,STARTDATE => :STARTDATE,ENDDATE => :ENDDATE,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 419 16:34:46 SQL Prepare: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00 420 16:34:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22907.000000 421 16:34:46 SQL Execute: ORACLE - SELECT SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,RCKDH0, decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH1, decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,to_number(WZSXMC) RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,to_number(SJSSL0) CKSL00,SZJSL0 CKJE00, to_number(SZJJE0) JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00 422 16:34:47 SQL Prepare: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=:1 423 16:34:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7105.000000 424 16:34:47 SQL Execute: ORACLE - select WZMC00,WZGG00,WZXH00,JLDW00,KCSX00, KCXX00,WZLBMC,WZSXMC,WZID00 from VW_WZ_WZXX00 where WZID00=? 425 16:34:47 SQL Prepare: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= :1 ORDER BY TJPX00) 426 16:34:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22907.000000 427 16:34:47 SQL Execute: ORACLE - select * from (SELECT TJPX00,QRRQ00,SHRQ00,SUBSTR(QRRQ00,1,4) QRN000, SUBSTR(SUBSTR(QRRQ00,1,6),5,6) QRY000, SUBSTR(QRRQ00,7,8) QRR000,decode(DJ0000,'0','',decode(nvl(PH0000,'0'),'0',SJSJE0,PH0000)) DJ0000, decode(DJ0000,'0','',decode(PH0000,'','出-'||RCKDH0,'入-'||RCKDH0)) RCKDH0,decode(DJ0000,'0',trim(WZMC00),trim(SHBMMC)) WZMC00, PH0000 RKJ000,SJCS00 QCDJ00, NVL(SJCJE0,0)-NVL(SDJ000,0)+NVL(SZJSL0,0) QCJE00, WZSXMC RKSL00,SDJ000 RKJE00, SJSJE0 CKJ000,SJSSL0 CKSL00,SZJSL0 CKJE00, SZJJE0 JCS000,SJCS00 JCDJ00,SJCJE0 JCJE00 FROM WZ_TEMP00 WHERE TJID00= ? ORDER BY TJPX00)