1 16:19:53 Log started for: 库存物资管理子系统 2 16:19:53 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:19:53 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:19:53 SQL Prepare: ORACLE - Commit 5 16:19:53 SQL Execute: ORACLE - Commit 6 16:19:53 SQL Prepare: ORACLE - Select SYSDATE from Dual 7 16:19:53 SQL Execute: ORACLE - Select SYSDATE from Dual 8 16:19:53 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 9 16:19:53 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 10 16:19:53 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 11 16:19:53 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 12 16:19:53 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 13 16:19:53 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 14 16:19:53 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 15 16:19:53 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 16 16:19:53 SQL Prepare: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='K' 17 16:19:53 SQL Execute: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='K' 18 16:19:54 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 19 16:19:54 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 20 16:19: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')) 21 16:19: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')) 22 16:19:58 SQL Prepare: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00='1' 23 16:19:58 SQL Execute: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00='1' 24 16:19:58 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 25 16:19:58 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 26 16:19:58 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 27 16:19:58 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 28 16:19:58 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 29 16:19:58 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 30 16:19:58 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 31 16:19:58 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 32 16:19: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 33 16:19: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 34 16:19:58 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 35 16:19:58 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 36 16:19:58 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 37 16:19:58 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 38 16:19:58 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1675838,476,'wlzx-2','K',nvl('2951090',' '),'',208) 39 16:19:58 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1675838,476,'wlzx-2','K',nvl('2951090',' '),'',208) 40 16:19:58 SQL Prepare: ORACLE - Commit 41 16:19:58 SQL Execute: ORACLE - Commit 42 16:19:58 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 208 43 16:19:58 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 208 44 16:19:58 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20090320' 45 16:19:58 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20090320' 46 16:19:58 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=208 47 16:19:58 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=208 48 16:19:58 SQL Prepare: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 49 16:19:58 SQL Execute: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 50 16:19:58 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 51 16:19:58 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 52 16:19:58 SQL Prepare: ORACLE - delete SD_SB.WZ_TEMP00 53 16:19:58 SQL Execute: ORACLE - delete SD_SB.WZ_TEMP00 54 16:19:59 SQL Prepare: ORACLE - Commit 55 16:19:59 SQL Execute: ORACLE - Commit 56 16:19:59 SQL Prepare: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 57 16:19:59 SQL Execute: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 58 16:19:59 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=476 59 16:19:59 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476 60 16:19:59 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)))) 61 16:19:59 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)))) 62 16:19:59 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 63 16:19:59 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 64 16:19:59 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)))) 65 16:19:59 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)))) 66 16:19:59 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 67 16:19:59 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 68 16:19:59 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)))) 69 16:19:59 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)))) 70 16:20:11 SQL Prepare: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH 71 16:20:11 SQL Execute: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH 72 16:20:11 SQL Prepare: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 WHERE RCKBZ0 = '1' AND SFYX00 = 'Y' 73 16:20:11 SQL Execute: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 WHERE RCKBZ0 = '1' AND SFYX00 = 'Y' 74 16:20:11 SQL Prepare: ORACLE - SELECT a.RCKDH0,a.BMMC00,a.RCKBMC,a.KDRQ00,a.CGYGXM,a.BZ0000,a.RCKID0,a.KFBMBH,a.QRRQ00,a.FHBMMC FROM VW_WZ_RCK000 a, VW_WZ_RCKMX0 b,bm_wzdm00 c WHERE a.rckid0=b.rckid0 and c.WZDMID=b.WZDMID and a.KFBMBH = :1 AND a.KDRQ00 >=:2 AND a.KDRQ00 <=:3 AND a.RCKLB0 ='1' and b.BZSL00<>'0' and ((a.RCKLX0 =:4) OR (:5 = '-1')) and c.WZDMBM||'' like :6 ||'%'order by a.RCKDH0 desc 75 16:20:11 SQL Execute: ORACLE - SELECT a.RCKDH0,a.BMMC00,a.RCKBMC,a.KDRQ00,a.CGYGXM,a.BZ0000,a.RCKID0,a.KFBMBH,a.QRRQ00,a.FHBMMC FROM VW_WZ_RCK000 a, VW_WZ_RCKMX0 b,bm_wzdm00 c WHERE a.rckid0=b.rckid0 and c.WZDMID=b.WZDMID and a.KFBMBH = ? AND a.KDRQ00 >=? AND a.KDRQ00 <=? AND a.RCKLB0 ='1' and b.BZSL00<>'0' and ((a.RCKLX0 =?) OR (? = '-1')) and c.WZDMBM||'' like ? ||'%'order by a.RCKDH0 desc 76 16:20:12 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 77 16:20:12 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 78 16:20:12 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 79 16:20:12 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 80 16:20:14 SQL Prepare: ORACLE - SELECT a.RCKDH0,a.BMMC00,a.RCKBMC,a.KDRQ00,a.CGYGXM,a.BZ0000,a.RCKID0,a.KFBMBH,a.QRRQ00,a.FHBMMC FROM VW_WZ_RCK000 a, VW_WZ_RCKMX0 b,bm_wzdm00 c WHERE a.rckid0=b.rckid0 and c.WZDMID=b.WZDMID and a.KFBMBH = :1 AND a.KDRQ00 >=:2 AND a.KDRQ00 <=:3 AND a.RCKLB0 ='1' and b.BZSL00<>'0' and ((a.RCKLX0 =:4) OR (:5 = '-1')) and c.WZDMBM||'' like :6 ||'%'order by a.RCKDH0 desc 81 16:20:14 SQL Execute: ORACLE - SELECT a.RCKDH0,a.BMMC00,a.RCKBMC,a.KDRQ00,a.CGYGXM,a.BZ0000,a.RCKID0,a.KFBMBH,a.QRRQ00,a.FHBMMC FROM VW_WZ_RCK000 a, VW_WZ_RCKMX0 b,bm_wzdm00 c WHERE a.rckid0=b.rckid0 and c.WZDMID=b.WZDMID and a.KFBMBH = ? AND a.KDRQ00 >=? AND a.KDRQ00 <=? AND a.RCKLB0 ='1' and b.BZSL00<>'0' and ((a.RCKLX0 =?) OR (? = '-1')) and c.WZDMBM||'' like ? ||'%'order by a.RCKDH0 desc 82 16:20:14 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 83 16:20:14 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 84 16:20:14 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 85 16:20:14 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 86 16:20:15 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 87 16:20:15 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 88 16:20:15 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 89 16:20:15 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 90 16:20:27 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 91 16:20:27 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 92 16:20:27 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 93 16:20:27 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 94 16:20:28 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 95 16:20:28 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 96 16:20:28 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 97 16:20:28 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 98 16:20:34 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 99 16:20:34 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 100 16:20:35 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 101 16:20:35 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 102 16:20:35 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 103 16:20:35 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 104 16:20:35 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 105 16:20:35 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 106 16:20:36 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 107 16:20:36 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 108 16:20:36 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 109 16:20:36 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 110 16:20:38 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 111 16:20:38 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 112 16:20:38 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 113 16:20:38 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 114 16:20:39 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 115 16:20:39 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 116 16:20:39 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 117 16:20:39 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 118 16:20:39 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 119 16:20:39 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 120 16:20:40 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 121 16:20:40 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 122 16:20:40 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 123 16:20:40 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 124 16:20:46 SQL Prepare: ORACLE - SELECT * FROM BM_WZSX00 125 16:20:46 SQL Execute: ORACLE - SELECT * FROM BM_WZSX00 126 16:20:46 SQL Prepare: ORACLE - SELECT YJFLID,YJFLMC FROM BM_WZYJFL WHERE YJFLBH LIKE '1%' ORDER BY YJFLID 127 16:20:46 SQL Execute: ORACLE - SELECT YJFLID,YJFLMC FROM BM_WZYJFL WHERE YJFLBH LIKE '1%' ORDER BY YJFLID 128 16:20:46 SQL Prepare: ORACLE - select a.wzid00,a.wzdmid,b.wzmc00,b.wzdw00,b.pysm00,b.wbsm00,a.wzgg00, a.wzxh00,a.cjid00,d.SCCJZW,a.kcsx00,a.kcxx00,a.rkdj00,a.ckdj00, a.hgh000,a.bzdw00,a.jldw00,a.bzbhsl,a.zbxh00,a.tsfwn0,a.sfxmid, e.xmmc00,a.sxdm00,b.wzdmbm,a.gjmc00,c.WZSXMC,a.SFYX00,a.GZHC00,b.BH0000,a.WZJCL0 from WZ_WZXX00 a,BM_WZDM00 b,BM_WZSX00 c,VW_BM_WZSCCJ d,bm_yysfxm e where a.WZDMID = b.WZDMID and a.SXDM00 = c.WZSXBH and a.CJID00=d.CJID00(+) and a.sfxmid=e.sfxmid(+) and a.SFYX00='Y' and b.WZDMBM like '1%' and b.KFBMBH =208 order by a.WZDMID 129 16:20:46 SQL Execute: ORACLE - select a.wzid00,a.wzdmid,b.wzmc00,b.wzdw00,b.pysm00,b.wbsm00,a.wzgg00, a.wzxh00,a.cjid00,d.SCCJZW,a.kcsx00,a.kcxx00,a.rkdj00,a.ckdj00, a.hgh000,a.bzdw00,a.jldw00,a.bzbhsl,a.zbxh00,a.tsfwn0,a.sfxmid, e.xmmc00,a.sxdm00,b.wzdmbm,a.gjmc00,c.WZSXMC,a.SFYX00,a.GZHC00,b.BH0000,a.WZJCL0 from WZ_WZXX00 a,BM_WZDM00 b,BM_WZSX00 c,VW_BM_WZSCCJ d,bm_yysfxm e where a.WZDMID = b.WZDMID and a.SXDM00 = c.WZSXBH and a.CJID00=d.CJID00(+) and a.sfxmid=e.sfxmid(+) and a.SFYX00='Y' and b.WZDMBM like '1%' and b.KFBMBH =208 order by a.WZDMID 130 16:20:46 SQL Prepare: ORACLE - SELECT FLBH00,TRIM(FLMC00) FLMC00,YJBH00,EJBH00,SJBH00 FROM VW_WZ_WZFL01 ORDER BY FLBH00 131 16:20:46 SQL Execute: ORACLE - SELECT FLBH00,TRIM(FLMC00) FLMC00,YJBH00,EJBH00,SJBH00 FROM VW_WZ_WZFL01 ORDER BY FLBH00 132 16:20:46 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZZDWH' 133 16:20:46 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZZDWH' 134 16:20:46 SQL Prepare: ORACLE - select LS0000,SFXS00 from XT_ZDYLXS where YGBH00=476 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZZDWH' and DBGRIN='DBGridEh1' order by LS0000 135 16:20:46 SQL Execute: ORACLE - select LS0000,SFXS00 from XT_ZDYLXS where YGBH00=476 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZZDWH' and DBGRIN='DBGridEh1' order by LS0000 136 16:20:57 SQL Prepare: ORACLE - select a.wzid00,a.wzdmid,b.wzmc00,b.wzdw00,b.pysm00,b.wbsm00,a.wzgg00, a.wzxh00,a.cjid00,d.SCCJZW,a.kcsx00,a.kcxx00,a.rkdj00,a.ckdj00, a.hgh000,a.bzdw00,a.jldw00,a.bzbhsl,a.zbxh00,a.tsfwn0,a.sfxmid, e.xmmc00,a.sxdm00,b.wzdmbm,a.gjmc00,c.WZSXMC,a.SFYX00,a.GZHC00,b.BH0000,a.WZJCL0 from WZ_WZXX00 a,BM_WZDM00 b,BM_WZSX00 c,VW_BM_WZSCCJ d,bm_yysfxm e where a.WZDMID = b.WZDMID and a.SXDM00 = c.WZSXBH and a.CJID00=d.CJID00(+) and a.sfxmid=e.sfxmid(+) and a.SFYX00='Y' and b.WZDMBM like '1%' and b.KFBMBH =208 order by a.WZDMID 137 16:20:57 SQL Execute: ORACLE - select a.wzid00,a.wzdmid,b.wzmc00,b.wzdw00,b.pysm00,b.wbsm00,a.wzgg00, a.wzxh00,a.cjid00,d.SCCJZW,a.kcsx00,a.kcxx00,a.rkdj00,a.ckdj00, a.hgh000,a.bzdw00,a.jldw00,a.bzbhsl,a.zbxh00,a.tsfwn0,a.sfxmid, e.xmmc00,a.sxdm00,b.wzdmbm,a.gjmc00,c.WZSXMC,a.SFYX00,a.GZHC00,b.BH0000,a.WZJCL0 from WZ_WZXX00 a,BM_WZDM00 b,BM_WZSX00 c,VW_BM_WZSCCJ d,bm_yysfxm e where a.WZDMID = b.WZDMID and a.SXDM00 = c.WZSXBH and a.CJID00=d.CJID00(+) and a.sfxmid=e.sfxmid(+) and a.SFYX00='Y' and b.WZDMBM like '1%' and b.KFBMBH =208 order by a.WZDMID 138 16:20:58 SQL Prepare: ORACLE - select a.wzid00,a.wzdmid,b.wzmc00,b.wzdw00,b.pysm00,b.wbsm00,a.wzgg00, a.wzxh00,a.cjid00,d.SCCJZW,a.kcsx00,a.kcxx00,a.rkdj00,a.ckdj00, a.hgh000,a.bzdw00,a.jldw00,a.bzbhsl,a.zbxh00,a.tsfwn0,a.sfxmid, e.xmmc00,a.sxdm00,b.wzdmbm,a.gjmc00,c.WZSXMC,a.SFYX00,a.GZHC00,b.BH0000,a.WZJCL0 from WZ_WZXX00 a,BM_WZDM00 b,BM_WZSX00 c,VW_BM_WZSCCJ d,bm_yysfxm e where a.WZDMID = b.WZDMID and a.SXDM00 = c.WZSXBH and a.CJID00=d.CJID00(+) and a.sfxmid=e.sfxmid(+) and a.SFYX00='Y' and b.KFBMBH =208 order by a.WZDMID 139 16:20:58 SQL Execute: ORACLE - select a.wzid00,a.wzdmid,b.wzmc00,b.wzdw00,b.pysm00,b.wbsm00,a.wzgg00, a.wzxh00,a.cjid00,d.SCCJZW,a.kcsx00,a.kcxx00,a.rkdj00,a.ckdj00, a.hgh000,a.bzdw00,a.jldw00,a.bzbhsl,a.zbxh00,a.tsfwn0,a.sfxmid, e.xmmc00,a.sxdm00,b.wzdmbm,a.gjmc00,c.WZSXMC,a.SFYX00,a.GZHC00,b.BH0000,a.WZJCL0 from WZ_WZXX00 a,BM_WZDM00 b,BM_WZSX00 c,VW_BM_WZSCCJ d,bm_yysfxm e where a.WZDMID = b.WZDMID and a.SXDM00 = c.WZSXBH and a.CJID00=d.CJID00(+) and a.sfxmid=e.sfxmid(+) and a.SFYX00='Y' and b.KFBMBH =208 order by a.WZDMID 140 16:21:05 SQL Prepare: ORACLE - select a.wzid00,a.wzdmid,b.wzmc00,b.wzdw00,b.pysm00,b.wbsm00,a.wzgg00, a.wzxh00,a.cjid00,d.SCCJZW,a.kcsx00,a.kcxx00,a.rkdj00,a.ckdj00, a.hgh000,a.bzdw00,a.jldw00,a.bzbhsl,a.zbxh00,a.tsfwn0,a.sfxmid, e.xmmc00,a.sxdm00,b.wzdmbm,a.gjmc00,c.WZSXMC,a.SFYX00,a.GZHC00,b.BH0000,a.WZJCL0 from WZ_WZXX00 a,BM_WZDM00 b,BM_WZSX00 c,VW_BM_WZSCCJ d,bm_yysfxm e where a.WZDMID = b.WZDMID and a.SXDM00 = c.WZSXBH and a.CJID00=d.CJID00(+) and a.sfxmid=e.sfxmid(+) and a.SFYX00='Y' and b.KFBMBH =208 order by a.WZDMID 141 16:21:05 SQL Execute: ORACLE - select a.wzid00,a.wzdmid,b.wzmc00,b.wzdw00,b.pysm00,b.wbsm00,a.wzgg00, a.wzxh00,a.cjid00,d.SCCJZW,a.kcsx00,a.kcxx00,a.rkdj00,a.ckdj00, a.hgh000,a.bzdw00,a.jldw00,a.bzbhsl,a.zbxh00,a.tsfwn0,a.sfxmid, e.xmmc00,a.sxdm00,b.wzdmbm,a.gjmc00,c.WZSXMC,a.SFYX00,a.GZHC00,b.BH0000,a.WZJCL0 from WZ_WZXX00 a,BM_WZDM00 b,BM_WZSX00 c,VW_BM_WZSCCJ d,bm_yysfxm e where a.WZDMID = b.WZDMID and a.SXDM00 = c.WZSXBH and a.CJID00=d.CJID00(+) and a.sfxmid=e.sfxmid(+) and a.SFYX00='Y' and b.KFBMBH =208 order by a.WZDMID 142 16:21:26 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 143 16:21:26 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 144 16:21:26 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 145 16:21:26 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 146 16:21:27 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 147 16:21:27 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 148 16:21:27 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 149 16:21:27 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 150 16:21:29 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 151 16:21:29 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 152 16:21:29 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 153 16:21:29 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 154 16:21:29 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 155 16:21:29 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 156 16:21:29 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 157 16:21:29 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 158 16:21:29 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 159 16:21:29 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 160 16:21:30 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 161 16:21:30 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 162 16:21:30 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 163 16:21:30 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 164 16:21:30 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 165 16:21:30 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 166 16:21:30 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 167 16:21:30 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 168 16:21:30 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 169 16:21:30 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 170 16:21:30 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 171 16:21:30 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 172 16:21:31 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 173 16:21:31 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 174 16:21:31 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 175 16:21:31 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=? 176 16:21:31 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=:1 177 16:21:31 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC, a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00, b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, b.WZJCL0,b.LSJ000 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKID0=?