1 09:36:37 Log started for: Gysystem 2 09:36:37 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.10.167','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20110325','09:36:38','scott@03081:D532D82F90473497A6743EC2F784FAE0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 09:36:37 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.10.167','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20110325','09:36:38','scott@03081:D532D82F90473497A6743EC2F784FAE0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 09:36:37 SQL Prepare: ORACLE - Commit 5 09:36:37 SQL Execute: ORACLE - Commit 6 09:36:37 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 7 09:36:37 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 09:36:37 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 9 09:36:37 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 10 09:36:37 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='03081' and CZBZ00 in ('1') 11 09:36:37 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='03081' and CZBZ00 in ('1') 12 09:36:37 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.10.167','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20110325','09:36:38','sd_Hospital@03081:F076E06E4D1C46F78896FDB25A0C73E2' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 13 09:36:37 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.10.167','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20110325','09:36:38','sd_Hospital@03081:F076E06E4D1C46F78896FDB25A0C73E2' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 14 09:36:37 SQL Prepare: ORACLE - Commit 15 09:36:37 SQL Execute: ORACLE - Commit 16 09:36:37 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='F' 17 09:36:37 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='F' 18 09:36:37 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='03081' and CZBZ00 in ('1') 19 09:36:37 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='03081' and CZBZ00 in ('1') 20 09:36:37 SQL Prepare: ORACLE - Select SYSDATE from Dual 21 09:36:37 SQL Execute: ORACLE - Select SYSDATE from Dual 22 09:36:37 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 23 09:36:37 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 24 09:36:37 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 25 09:36:37 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 26 09:36:37 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='F' 27 09:36:37 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='F' 28 09:36:37 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 29 09:36:37 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 30 09:36:37 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 31 09:36:37 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 32 09:36:37 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','0','1','2','3','4','5','6','8','9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='F' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='03081')) order by BH0000 33 09:36:37 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','0','1','2','3','4','5','6','8','9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='F' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='03081')) order by BH0000 34 09:36:37 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '03081'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'F' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='03081')) 35 09:36:37 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '03081'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'F' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='03081')) 36 09:36:37 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=711 37 09:36:37 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=711 38 09:36:37 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 39 09:36:37 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 40 09:36:37 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 41 09:36:37 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 42 09:36:37 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 43 09:36:37 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 44 09:36:37 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 45 09:36:37 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 46 09:36:37 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 47 09:36:37 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 48 09:36:37 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2499152,711,'设备科仓库-2','F',nvl('3637214',' '),'192.168.10.167#547:2026@GYSystem.exe+供应室管理子系统',150) 49 09:36:37 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2499152,711,'设备科仓库-2','F',nvl('3637214',' '),'192.168.10.167#547:2026@GYSystem.exe+供应室管理子系统',150) 50 09:36:37 SQL Prepare: ORACLE - Commit 51 09:36:37 SQL Execute: ORACLE - Commit 52 09:36:37 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 150 53 09:36:37 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 150 54 09:36:37 SQL Prepare: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 55 09:36:37 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 56 09:36:37 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.10.167' 57 09:36:37 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.10.167' 58 09:36:37 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 59 09:36:37 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 60 09:36:37 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 61 09:36:37 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 62 09:36:37 SQL Prepare: ORACLE - Commit 63 09:36:37 SQL Execute: ORACLE - Commit 64 09:36:37 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 150 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 65 09:36:37 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 150 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 66 09:36:37 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 67 09:36:37 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 68 09:36:37 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='F') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',150,')> 0) and YXQ000>='20110325' 69 09:36:37 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='F') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',150,')> 0) and YXQ000>='20110325' 70 09:36:37 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 71 09:36:37 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 72 09:36:37 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 73 09:36:37 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 74 09:36:37 SQL Prepare: ORACLE - select sysdate from dual 75 09:36:37 SQL Execute: ORACLE - select sysdate from dual 76 09:36:37 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID' 77 09:36:37 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID' 78 09:36:37 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS='VALID' 79 09:36:37 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS='VALID' 80 09:36:37 SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED' 81 09:36:37 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED' 82 09:36:37 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 83 09:36:37 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 84 09:36:37 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='F' and (( 711= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='F' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=711)))) 85 09:36:37 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='F' and (( 711= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='F' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=711)))) 86 09:36:37 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'F$%' and A.XTDM00='F' and trim(A.MKDM00)='F$'||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 BZ0000<>'0' ORDER BY B.F_TEMPTYPE,A.MKDM00 87 09:36:37 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'F$%' and A.XTDM00='F' and trim(A.MKDM00)='F$'||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 BZ0000<>'0' ORDER BY B.F_TEMPTYPE,A.MKDM00 88 09:36:37 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 ((711= 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=711)))) 89 09:36:37 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 ((711= 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=711)))) 90 09:36:37 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 711= 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=711)))) 91 09:36:37 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 711= 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=711)))) 92 09:36:37 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 711= 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=711)))) 93 09:36:37 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 711= 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=711)))) 94 09:36:37 SQL Prepare: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 95 09:36:37 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 96 09:36:37 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 711 97 09:36:37 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 711 98 09:36:37 SQL Prepare: ORACLE - Select value0,name00 from XT_XTCS00 where name00 in('GY_ZDYYCS','GY_HSQRDYSFAKSFL','GY_WPKCCXFS','GY_YJZWPLYSFZJFF','GY_WPCKTJFS','GY_WPCKTJHJXSSFWL','GY_WPRKSCCJSFYXZJLR','GY_WPHSSFHZ','WZ_SYDJJEBLSWXS','GY_WPLYSFYXBTLXTYD','GY_WPHSQRTHYYHSSFXSSZ', 'GY_WPLYQRHZDY','GY_WPHSQRXSPCXX' ) 99 09:36:37 SQL Execute: ORACLE - Select value0,name00 from XT_XTCS00 where name00 in('GY_ZDYYCS','GY_HSQRDYSFAKSFL','GY_WPKCCXFS','GY_YJZWPLYSFZJFF','GY_WPCKTJFS','GY_WPCKTJHJXSSFWL','GY_WPRKSCCJSFYXZJLR','GY_WPHSSFHZ','WZ_SYDJJEBLSWXS','GY_WPLYSFYXBTLXTYD','GY_WPHSQRTHYYHSSFXSSZ', 'GY_WPLYQRHZDY','GY_WPHSQRXSPCXX' ) 100 09:36:37 SQL Prepare: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY' 101 09:36:37 SQL Execute: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY' 102 09:36:37 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY' 103 09:36:37 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY' 104 09:36:37 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB' 105 09:36:37 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB' 106 09:36:37 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID' 107 09:36:37 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID' 108 09:36:37 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00=711 and name00='GY_QSBRLB' 109 09:36:37 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=711 and name00='GY_QSBRLB' 110 09:36:37 SQL Prepare: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A Where gyksbh=:1 and yxq000<:2 111 09:36:37 SQL Execute: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A Where gyksbh=? and yxq0000 and RKRQ00 between :2 and :3 union all select wpbh00,'' rksl00,TO_CHAR(tksl00) tksl00,'' cksl00,'' bfsl00,'' xdrksl,'' pdyksl,'' DBZJSL,'' BDBSL0,'' HSSL00,'' LYSL00 from vw_gy_wptkmx where tkzt00=1 AND TKKSBH=:4 and TKRQ00 between :5 and :6 union all select wpbh00,'' rksl00,'' tksl00,TO_CHAR(sfsl00) cksl00,'' bfsl00,'' xdrksl,'' pdyksl,'' DBZJSL,'' BDBSL0,'' HSSL00,TO_CHAR(sfsl00) LYSL00 from vw_gy_wplymx where (zt0000=3 or zt0000=4) AND FFKSBH=:7 and FFRQ00 between :8 and :9 union all select wpbh00,'' rksl00,'' tksl00,'' cksl00,TO_CHAR(bfsl00) bfsl00,'' xdrksl,'' pdyksl,'' DBZJSL,'' BDBSL0,'' HSSL00,'' LYSL00 from vw_gy_wpbfmx where bfzt00=1 AND BFKSBH=:10 and BFRQ00 between :11 and :12 UNION ALL select wpbh00,'' rksl00,'' tksl00, TO_CHAR(sjrksl) cksl00,'' bfsl00,'' xdrksl,'' pdyksl,'' DBZJSL,'' BDBSL0,'' HSSL00,'' LYSL00 from vw_gy_wprkmx where rkdzt0=2 AND DCKS00=:13 AND RKFS00='1' AND RKRQ00 between :14 and :15 union all select wpbh00,'' rksl00,'' tksl00,'' cksl00,'' bfsl00,TO_CHAR(XDSL00) xdrksl,'' pdyksl,'' DBZJSL,'' BDBSL0,'' HSSL00,'' LYSL00 from vw_gy_wpxdmx where dbbz00='Y'AND XDKSBH=:16 and XDRQ00 between :17 and :18 union all select wpbh00,'' rksl00,'' tksl00,'' cksl00,'' bfsl00,'' xdrksl,to_char(YKS000) pdyksl,'' DBZJSL,'' BDBSL0,'' HSSL00,'' LYSL00 from vw_gy_wppd00 where pdbz00='1' and PDKSBH=:19 and QRRQ00 between :20 and :21 union all select wpbh00,'' rksl00,'' tksl00,'' cksl00,'' bfsl00,'' xdrksl,'' pdyksl,to_char(DBSL00) DBZJSL,'' BDBSL0,'' HSSL00,'' LYSL00 from GY_WPDB00 where DBKSBH=:22 and DBRQ00 between :23 and :24 union all select wpbh00,'' rksl00,'' tksl00,'' cksl00,'' bfsl00,'' xdrksl,'' pdyksl,'' DBZJSL,TO_CHAR(BDBSL0) BDBSL0,'' HSSL00,'' LYSL00 from vw_gy_wpbdb0 where DBKSBH=:25 and DBRQ00 between :26 and :27 union all select wpbh00,'' rksl00,'' tksl00,'' cksl00,'' bfsl00,'' xdrksl,'' pdyksl,'' DBZJSL,'' BDBSL0,TO_CHAR(nvl(HSSL00,0)) HSSL00,'' LYSL00 from vw_gy_wphsmx where HSKSBH=:28 and HSRQ00 between :29 and :30 and hszt00='3' ) b, GY_WPKCXX C where a.wpbh00=b.wpbh00(+) and a.wpbh00=c.wpbh00(+) and c.gyksbh=:31 and exists(select 1 from gy_wpbm00 where wpbh00=c.wpbh00 and ('N'=:32 or sybz00=:33)) group by a.wpbh00,a.wpgg00,a.wpmc00,c.dqkcl0,a.wpdj00,a.wpdw00 163 09:37:01 SQL Execute: ORACLE - select a.wpbh00,DECODE(c.dqkcl0,0,'',c.dqkcl0) kcl000, a.wpmc00,a.wpgg00,sum(b.rksl00) rksl00, sum(b.tksl00) tksl00,sum(b.cksl00) cksl00, sum(b.bfsl00) bfsl00, TO_CHAR(sum(b.xdrksl)) xdrksl, a.wpdj00,a.wpdw00, sum(b.pdyksl) pdyksl,sum(b.dbzjsl) dbzjsl, sum(b.bdbsl0) bdbsl0,sum(b.lysl00)-nvl(sum(b.hssl00),0) whssl0 from gy_wpbm00 a, ( select wpbh00,TO_CHAR(sjrksl) rksl00,'' tksl00,'' cksl00,'' bfsl00,'' xdrksl,'' pdyksl,'' DBZJSL,'' BDBSL0,'' HSSL00,'' LYSL00 from vw_gy_wprkmx where rkdzt0=2 AND QLKSBH=? and wpxz00<>0 and RKRQ00 between ? and ? union all select wpbh00,'' rksl00,TO_CHAR(tksl00) tksl00,'' cksl00,'' bfsl00,'' xdrksl,'' pdyksl,'' DBZJSL,'' BDBSL0,'' HSSL00,'' LYSL00 from vw_gy_wptkmx where tkzt00=1 AND TKKSBH=? and TKRQ00 between ? and ? union all select wpbh00,'' rksl00,'' tksl00,TO_CHAR(sfsl00) cksl00,'' bfsl00,'' xdrksl,'' pdyksl,'' DBZJSL,'' BDBSL0,'' HSSL00,TO_CHAR(sfsl00) LYSL00 from vw_gy_wplymx where (zt0000=3 or zt0000=4) AND FFKSBH=? and FFRQ00 between ? and ? union all select wpbh00,'' rksl00,'' tksl00,'' cksl00,TO_CHAR(bfsl00) bfsl00,'' xdrksl,'' pdyksl,'' DBZJSL,'' BDBSL0,'' HSSL00,'' LYSL00 from vw_gy_wpbfmx where bfzt00=1 AND BFKSBH=? and BFRQ00 between ? and ? UNION ALL select wpbh00,'' rksl00,'' tksl00, TO_CHAR(sjrksl) cksl00,'' bfsl00,'' xdrksl,'' pdyksl,'' DBZJSL,'' BDBSL0,'' HSSL00,'' LYSL00 from vw_gy_wprkmx where rkdzt0=2 AND DCKS00=? AND RKFS00='1' AND RKRQ00 between ? and ? union all select wpbh00,'' rksl00,'' tksl00,'' cksl00,'' bfsl00,TO_CHAR(XDSL00) xdrksl,'' pdyksl,'' DBZJSL,'' BDBSL0,'' HSSL00,'' LYSL00 from vw_gy_wpxdmx where dbbz00='Y'AND XDKSBH=? and XDRQ00 between ? and ? union all select wpbh00,'' rksl00,'' tksl00,'' cksl00,'' bfsl00,'' xdrksl,to_char(YKS000) pdyksl,'' DBZJSL,'' BDBSL0,'' HSSL00,'' LYSL00 from vw_gy_wppd00 where pdbz00='1' and PDKSBH=? and QRRQ00 between ? and ? union all select wpbh00,'' rksl00,'' tksl00,'' cksl00,'' bfsl00,'' xdrksl,'' pdyksl,to_char(DBSL00) DBZJSL,'' BDBSL0,'' HSSL00,'' LYSL00 from GY_WPDB00 where DBKSBH=? and DBRQ00 between ? and ? union all select wpbh00,'' rksl00,'' tksl00,'' cksl00,'' bfsl00,'' xdrksl,'' pdyksl,'' DBZJSL,TO_CHAR(BDBSL0) BDBSL0,'' HSSL00,'' LYSL00 from vw_gy_wpbdb0 where DBKSBH=? and DBRQ00 between ? and ? union all select wpbh00,'' rksl00,'' tksl00,'' cksl00,'' bfsl00,'' xdrksl,'' pdyksl,'' DBZJSL,'' BDBSL0,TO_CHAR(nvl(HSSL00,0)) HSSL00,'' LYSL00 from vw_gy_wphsmx where HSKSBH=? and HSRQ00 between ? and ? and hszt00='3' ) b, GY_WPKCXX C where a.wpbh00=b.wpbh00(+) and a.wpbh00=c.wpbh00(+) and c.gyksbh=? and exists(select 1 from gy_wpbm00 where wpbh00=c.wpbh00 and ('N'=? or sybz00=?)) group by a.wpbh00,a.wpgg00,a.wpmc00,c.dqkcl0,a.wpdj00,a.wpdw00 164 09:37:01 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 165 09:37:01 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 166 09:37:01 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 167 09:37:01 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 168 09:37:01 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 169 09:37:01 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 170 09:37:32 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 171 09:37:32 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 172 09:37:32 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='11503' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='11503' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='11503' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='11503' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='11503' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='11503' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='11503' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='11503' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='11503' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 173 09:37:32 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='11503' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='11503' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='11503' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='11503' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='11503' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='11503' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='11503' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='11503' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='11503' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 174 09:37:41 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='11503' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='11503' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='11503' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='11503' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='11503' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='11503' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='11503' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='11503' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='11503' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 175 09:37:41 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='11503' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='11503' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='11503' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='11503' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='11503' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='11503' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='11503' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='11503' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='11503' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 176 09:37:41 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 177 09:37:41 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 178 09:37:41 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 179 09:37:41 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 180 09:37:41 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='12002' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='12002' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='12002' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='12002' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='12002' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='12002' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='12002' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='12002' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='12002' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 181 09:37:41 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='12002' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='12002' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='12002' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='12002' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='12002' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='12002' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='12002' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='12002' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='12002' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 182 09:37:44 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='12002' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='12002' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='12002' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='12002' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='12002' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='12002' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='12002' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='12002' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='12002' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 183 09:37:44 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='12002' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='12002' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='12002' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='12002' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='12002' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='12002' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='12002' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='12002' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='12002' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 184 09:37:44 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='30402' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='30402' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='30402' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='30402' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='30402' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='30402' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='30402' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='30402' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='30402' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 185 09:37:44 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='30402' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='30402' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='30402' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='30402' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='30402' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='30402' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='30402' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='30402' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='30402' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 186 09:37:45 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='30402' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='30402' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='30402' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='30402' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='30402' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='30402' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='30402' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='30402' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='30402' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 187 09:37:45 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='30402' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='30402' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='30402' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='30402' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='30402' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='30402' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='30402' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='30402' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='30402' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 188 09:37:45 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='40901' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='40901' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='40901' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='40901' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='40901' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='40901' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='40901' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='40901' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='40901' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 189 09:37:45 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='40901' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='40901' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='40901' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='40901' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='40901' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='40901' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='40901' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='40901' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='40901' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 190 09:37:45 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='40901' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='40901' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='40901' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='40901' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='40901' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='40901' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='40901' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='40901' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='40901' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 191 09:37:45 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='40901' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='40901' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='40901' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='40901' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='40901' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='40901' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='40901' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='40901' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='40901' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 192 09:37:45 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='45601' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='45601' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='45601' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='45601' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='45601' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='45601' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='45601' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='45601' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='45601' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 193 09:37:45 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='45601' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='45601' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='45601' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='45601' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='45601' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='45601' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='45601' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='45601' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='45601' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 194 09:37:46 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='45601' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='45601' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='45601' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='45601' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='45601' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='45601' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='45601' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='45601' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='45601' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 195 09:37:46 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='45601' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='45601' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='45601' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='45601' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='45601' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='45601' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='45601' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='45601' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='45601' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 196 09:37:46 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='41602' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='41602' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='41602' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='41602' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='41602' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='41602' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='41602' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='41602' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='41602' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 197 09:37:46 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='41602' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='41602' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='41602' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='41602' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='41602' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='41602' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='41602' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='41602' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='41602' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 198 09:37:52 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='41602' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='41602' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='41602' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='41602' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='41602' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='41602' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='41602' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='41602' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='41602' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 199 09:37:52 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='41602' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='41602' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='41602' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='41602' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='41602' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='41602' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='41602' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='41602' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='41602' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 200 09:37:52 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 201 09:37:52 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 202 09:37:52 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 203 09:37:52 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='10604' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='10604' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='10604' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='10604' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='10604' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='10604' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='10604' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 204 09:37:52 SQL Prepare: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='30902' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='30902' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='30902' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='30902' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='30902' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='30902' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='30902' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='30902' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='30902' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 205 09:37:52 SQL Execute: ORACLE - select rq0000,sum(rksl00) RKSL00,sum(tksl00) TKSL00, sum(cksl00) CKSL00, sum(bfsl00) BFSL00, sum(xdrksl) XDRKSL, sum(YKS000) YKS000, sum(DBSL00) DBSL00, sum(BDBSL0) BDBSL0 from ( select sjrksl rksl00,0 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='30902' and qlksbh=150 and rkrq00 between '20110318' and '20110325' and wpxz00<>0 union all select 0 rksl00,tksl00 tksl00,0 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, tkrq00 rq0000 from vw_gy_wptkmx where tkzt00=1 and wpbh00='30902' and tkksbh=150 and tkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sfsl00 cksl00,0 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, ffrq00 rq0000 from vw_gy_wplymx where (zt0000=3 or zt0000=4) and wpbh00='30902' and ffksbh=150 and ffrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,bfsl00 bfsl00,0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, bfrq00 rq0000 from vw_gy_wpbfmx where bfzt00=1 and wpbh00='30902' and bfksbh=150 and bfrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,sjrksl cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, rkrq00 rq0000 from vw_gy_wprkmx where rkdzt0=2 and wpbh00='30902' and dcks00=150 and rkfs00='1' and rkrq00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, xdsl00 xdrksl, 0 YKS000, 0 DBSL00, 0 BDBSL0, xdrq00 rq0000 from vw_gy_wpxdmx where dbbz00='Y' and wpbh00='30902' and xdksbh=150and XDRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, YKS000 YKS000, 0 DBSL00, 0 BDBSL0, QRRQ00 rq0000 from vw_gy_wppd00 where pdbz00='1' and wpbh00='30902' and pdksbh=150and QRRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, DBSL00 DBSL00, 0 BDBSL0, DBRQ00 rq0000 from GY_WPDB00 where wpbh00='30902' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' union all select 0 rksl00,0 tksl00,0 cksl00,0 bfsl00, 0 xdrksl, 0 YKS000, 0 DBSL00, BDBSL0 BDBSL0, DBRQ00 rq0000 from vw_gy_wpbdb0 where wpbh00='30902' and DBKSBH=150and DBRQ00 between '20110318' and '20110325' ) b group by rq0000 206 09:38:15 SQL Prepare: ORACLE - select bmmc00,bmbh00 from vw_gy_gyxgks 207 09:38:15 SQL Execute: ORACLE - select bmmc00,bmbh00 from vw_gy_gyxgks 208 09:38:15 SQL Prepare: ORACLE - select * from vw_gy_wprk00 where RKDZT0=0 AND ((RKFS00='0' AND QLKSBH=:1) OR (RKFS00='1' AND DCKS00=:2)) 209 09:38:15 SQL Execute: ORACLE - select * from vw_gy_wprk00 where RKDZT0=0 AND ((RKFS00='0' AND QLKSBH=?) OR (RKFS00='1' AND DCKS00=?)) 210 09:38:15 SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1 order by wpxz00 211 09:38:15 SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=? order by wpxz00 212 09:38:15 SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1 order by wpxz00 213 09:38:15 SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=? order by wpxz00 214 09:38:15 SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1 order by wpxz00 215 09:38:15 SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=? order by wpxz00 216 09:38:15 SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1 order by wpxz00 217 09:38:15 SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=? order by wpxz00 218 09:38:15 SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1 order by wpxz00 219 09:38:15 SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=? order by wpxz00 220 09:38:15 SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1 order by wpxz00 221 09:38:15 SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=? order by wpxz00 222 09:38:43 Log started for: 库存物资管理子系统 223 09:38:43 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.10.167','K',trim(PROGRAM)||'+'||'库存物资管理子系统',SID,serial# ,'20110325','09:38:44','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 224 09:38:43 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.10.167','K',trim(PROGRAM)||'+'||'库存物资管理子系统',SID,serial# ,'20110325','09:38:44','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 225 09:38:43 SQL Prepare: ORACLE - Commit 226 09:38:43 SQL Execute: ORACLE - Commit 227 09:38:43 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 228 09:38:43 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 229 09:38:43 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 230 09:38:43 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 231 09:38:43 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 232 09:38:43 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 233 09:38:43 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.10.167','K',trim(PROGRAM)||'+'||'库存物资管理子系统',SID,serial# ,'20110325','09:38:44','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 234 09:38:43 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.10.167','K',trim(PROGRAM)||'+'||'库存物资管理子系统',SID,serial# ,'20110325','09:38:44','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 235 09:38:43 SQL Prepare: ORACLE - Commit 236 09:38:43 SQL Execute: ORACLE - Commit 237 09:38:43 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='K' 238 09:38:43 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='K' 239 09:38:43 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 240 09:38:43 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 241 09:38:43 SQL Prepare: ORACLE - Select SYSDATE from Dual 242 09:38:43 SQL Execute: ORACLE - Select SYSDATE from Dual 243 09:38:43 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 244 09:38:43 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 245 09:38:43 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 246 09:38:43 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 247 09:38:43 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 248 09:38:43 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 249 09:38:43 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 250 09:38:43 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 251 09:38:43 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 252 09:38:43 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 253 09:38:43 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('c','0','1','5','2','9','a','8','4','b') 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 254 09:38:43 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('c','0','1','5','2','9','a','8','4','b') 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 255 09:38:47 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')) 256 09:38:47 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')) 257 09:38:47 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 258 09:38:47 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 259 09:38:47 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 260 09:38:47 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 261 09:38:47 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 262 09:38:47 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 263 09:38:47 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 264 09:38:47 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 265 09:38:47 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 266 09:38:47 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 267 09:38:47 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 268 09:38:47 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 269 09:38:47 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2499158,476,'设备科仓库-2','K',nvl('3637250',' '),'192.168.10.167#574:1389@PrjSB_kcwz.exe+库存物资管理子系统',208) 270 09:38:47 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2499158,476,'设备科仓库-2','K',nvl('3637250',' '),'192.168.10.167#574:1389@PrjSB_kcwz.exe+库存物资管理子系统',208) 271 09:38:47 SQL Prepare: ORACLE - Commit 272 09:38:47 SQL Execute: ORACLE - Commit 273 09:38:47 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 208 274 09:38:47 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 208 275 09:38:47 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 276 09:38:47 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 277 09:38:47 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.10.167' 278 09:38:47 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.10.167' 279 09:38:47 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 280 09:38:47 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 281 09:38:47 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 282 09:38:47 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 283 09:38:47 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 284 09:38:47 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 285 09:38:47 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20110325' 286 09:38:47 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20110325' 287 09:38:47 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 288 09:38:47 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 289 09:38:47 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 290 09:38:47 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 291 09:38:47 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=208 292 09:38:47 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=208 293 09:38:47 SQL Prepare: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 294 09:38:47 SQL Execute: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 295 09:38:47 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 296 09:38:47 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 297 09:38:47 SQL Prepare: ORACLE - delete SD_SB.WZ_TEMP00 298 09:38:47 SQL Execute: ORACLE - delete SD_SB.WZ_TEMP00 299 09:38:47 SQL Prepare: ORACLE - Commit 300 09:38:47 SQL Execute: ORACLE - Commit 301 09:38:47 SQL Prepare: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 302 09:38:47 SQL Execute: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 303 09:38:47 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=476 304 09:38:47 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476 305 09:38:47 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC 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)))) 306 09:38:47 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC 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)))) 307 09:38:47 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 BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 308 09:38:47 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 BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 309 09:38:47 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)))) 310 09:38:47 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)))) 311 09:38:47 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 312 09:38:47 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 313 09:38:47 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)))) 314 09:38:47 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)))) 315 09:38:53 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZRKCX' 316 09:38:53 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZRKCX' 317 09:38:53 SQL Prepare: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00 from XT_ZDYLXS where YGBH00=476 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZRKCX' and DBGRIN='DBGridEh1' order by LS0000 318 09:38:53 SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00 from XT_ZDYLXS where YGBH00=476 and BMBH00=208 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZRKCX' and DBGRIN='DBGridEh1' order by LS0000 319 09:38:53 SQL Prepare: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH 320 09:38:53 SQL Execute: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH 321 09:38:53 SQL Prepare: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 WHERE RCKBZ0 = '1' and RCKBBH<>'35' AND SFYX00 = 'Y' 322 09:38:53 SQL Execute: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 WHERE RCKBZ0 = '1' and RCKBBH<>'35' AND SFYX00 = 'Y' 323 09:38:53 SQL Prepare: ORACLE - SELECT RCKDH0,BMMC00,RCKBMC,KDRQ00,CGYGXM,BZ0000,RCKID0,KFBMBH,QRRQ00,FHBMMC FROM VW_WZ_RCK000 WHERE rckid0 in (select distinct b.RCKID0 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.RCKLB0 ='1' and c.WZDMBM||'' like :2 ||'%' AND a.QRRQ00 >=:3 AND a.QRRQ00 <=:4 and a.rcklx0<>'35' and b.BZSL00<>'0' and ((a.RCKLX0 =:5) OR (:6 = '-1'))) order by RCKDH0 desc 324 09:38:53 SQL Execute: ORACLE - SELECT RCKDH0,BMMC00,RCKBMC,KDRQ00,CGYGXM,BZ0000,RCKID0,KFBMBH,QRRQ00,FHBMMC FROM VW_WZ_RCK000 WHERE rckid0 in (select distinct b.RCKID0 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.RCKLB0 ='1' and c.WZDMBM||'' like ? ||'%' AND a.QRRQ00 >=? AND a.QRRQ00 <=? and a.rcklx0<>'35' and b.BZSL00<>'0' and ((a.RCKLX0 =?) OR (? = '-1'))) order by RCKDH0 desc 325 09:38:53 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.WZEJFL, 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,b.fprq00,b.qgksmc,b.XZZD01,b.XZZD02,b.XZZD03,b.XZZD04 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 and a.rcklx0<>'35' 326 09:38:53 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.WZEJFL, 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,b.fprq00,b.qgksmc,b.XZZD01,b.XZZD02,b.XZZD03,b.XZZD04 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=? and a.rcklx0<>'35' 327 09:38:58 SQL Prepare: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH 328 09:38:58 SQL Execute: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH 329 09:38:58 SQL Prepare: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 WHERE RCKBZ0 = '2' and RCKBBH<>'36' AND SFYX00 = 'Y' 330 09:38:58 SQL Execute: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 WHERE RCKBZ0 = '2' and RCKBBH<>'36' AND SFYX00 = 'Y' 331 09:38:58 SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC,a.RCKBMC,a.QRRQ00,a.RCKDH0,a.SHBMMC,b.FPH000,c.WZDMBM,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.WZDW00,b.CRKSL0,b.CGJ000,b.PH0000,b.YXQ000,b.CKPFJ0,b.ZJE000,b.JCS000,b.WZSXMC,a.RCKID0,c.PYSM00,c.WBSM00,b.CXBZ00,b.BZ0000,a.CGYGXM ,b.XZZD01,b.XZZD02,b.XZZD03,b.XZZD04 ,(select QRRXM0 from vw_wz_qld000 where rckid0=a.rckid0) QLQRR0 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b ,BM_WZDM00 c where a.RCKID0=b.RCKID0 and b.WZDMID=c.WZDMID and a.QRRQ00 >=:1 and a.QRRQ00 <=:2 and a.KFBMBH = :3 and (rcklx0<>'27' and rcklx0<>'36') and a.RCKLB0 = '2' and c.WZDMBM||'' like :4 ||'%' and ((A.rcklx0 =:5 ) OR (:6 = '-1')) and b.BZSL00<>0 order by a.RCKDH0 desc,b.RCKMXH 332 09:38:58 SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC,a.RCKBMC,a.QRRQ00,a.RCKDH0,a.SHBMMC,b.FPH000,c.WZDMBM,b.WZMC00,b.GGXH00,b.GG0000,b.WZXH00,b.WZDW00,b.CRKSL0,b.CGJ000,b.PH0000,b.YXQ000,b.CKPFJ0,b.ZJE000,b.JCS000,b.WZSXMC,a.RCKID0,c.PYSM00,c.WBSM00,b.CXBZ00,b.BZ0000,a.CGYGXM ,b.XZZD01,b.XZZD02,b.XZZD03,b.XZZD04 ,(select QRRXM0 from vw_wz_qld000 where rckid0=a.rckid0) QLQRR0 from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b ,BM_WZDM00 c where a.RCKID0=b.RCKID0 and b.WZDMID=c.WZDMID and a.QRRQ00 >=? and a.QRRQ00 <=? and a.KFBMBH = ? and (rcklx0<>'27' and rcklx0<>'36') and a.RCKLB0 = '2' and c.WZDMBM||'' like ? ||'%' and ((A.rcklx0 =? ) OR (? = '-1')) and b.BZSL00<>0 order by a.RCKDH0 desc,b.RCKMXH