1 10:32:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 2 10:32:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 3 10:32:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 4 10:32:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 5 10:32:52 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 6 10:32:52 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 7 10:32:52 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 8 10:32:52 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 9 10:32:52 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 10 10:32:52 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 11 10:32:52 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 12 10:32:52 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 13 10:32:52 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 14 10:32:52 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 15 10:32:52 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 16 10:32:52 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 17 10:32:52 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 18 10:32:52 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 19 10:32:52 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 20 10:32:52 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 21 10:32:52 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 22 10:32:52 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 23 10:32:52 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 24 10:32:52 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 25 10:32:52 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 26 10:32:52 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 27 10:32:52 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 28 10:32:52 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 29 10:32:52 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 30 10:32:52 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 31 10:32:52 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 32 10:32:52 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 33 10:32:52 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 34 10:32:52 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 35 10:32: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 36 10:32: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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 37 10:32: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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 38 10:32: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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 39 10:32:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 40 10:32:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 41 10:32:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 42 10:32:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 43 10:32:52 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 44 10:32:52 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 45 10:32:52 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 46 10:32:52 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 47 10:32:52 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 48 10:32:52 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 49 10:32:52 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 50 10:32:52 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 51 10:32:52 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 52 10:32:52 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 53 10:32:52 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 54 10:32:52 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 55 10:32:52 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 56 10:32:52 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 57 10:32:52 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 58 10:32:52 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 59 10:32:52 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 60 10:32:52 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 61 10:32:52 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 62 10:32:52 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 63 10:32:52 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 64 10:32:52 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 65 10:32:52 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 66 10:32:52 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 67 10:32:52 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 68 10:32:52 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110325 69 10:32:52 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 70 10:32:52 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 71 10:32:52 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 72 10:32:52 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 73 10:32: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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 74 10:32: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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 75 10:32: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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 76 10:32: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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 77 10:32:53 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 78 10:32:53 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='11410' and qlksbh=150 and rkrq00 between '20110325' 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='11410' and tkksbh=150 and tkrq00 between '20110325' 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='11410' and ffksbh=150 and ffrq00 between '20110325' 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='11410' and bfksbh=150 and bfrq00 between '20110325' 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='11410' and dcks00=150 and rkfs00='1' and rkrq00 between '20110325' 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='11410' and xdksbh=150and XDRQ00 between '20110325' 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='11410' and pdksbh=150and QRRQ00 between '20110325' 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='11410' and DBKSBH=150and DBRQ00 between '20110325' 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='11410' and DBKSBH=150and DBRQ00 between '20110325' and '20110325' ) b group by rq0000 79 10:32:59 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='11410' and qlksbh=150 and rkrq00 between '20110325' 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='11410' and tkksbh=150 and tkrq00 between '20110325' 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='11410' and ffksbh=150 and ffrq00 between '20110325' 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='11410' and bfksbh=150 and bfrq00 between '20110325' 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='11410' and dcks00=150 and rkfs00='1' and rkrq00 between '20110325' 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='11410' and xdksbh=150and XDRQ00 between '20110325' 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='11410' and pdksbh=150and QRRQ00 between '20110325' 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='11410' and DBKSBH=150and DBRQ00 between '20110325' 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='11410' and DBKSBH=150and DBRQ00 between '20110325' and '20110325' ) b group by rq0000 80 10:32:59 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 81 10:32:59 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 82 10:32:59 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 83 10:33:00 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 84 10:33:00 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='31303' and qlksbh=150 and rkrq00 between '20110325' 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='31303' and tkksbh=150 and tkrq00 between '20110325' 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='31303' and ffksbh=150 and ffrq00 between '20110325' 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='31303' and bfksbh=150 and bfrq00 between '20110325' 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='31303' and dcks00=150 and rkfs00='1' and rkrq00 between '20110325' 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='31303' and xdksbh=150and XDRQ00 between '20110325' 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='31303' and pdksbh=150and QRRQ00 between '20110325' 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='31303' and DBKSBH=150and DBRQ00 between '20110325' 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='31303' and DBKSBH=150and DBRQ00 between '20110325' and '20110325' ) b group by rq0000 85 10:33: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='31303' and qlksbh=150 and rkrq00 between '20110325' 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='31303' and tkksbh=150 and tkrq00 between '20110325' 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='31303' and ffksbh=150 and ffrq00 between '20110325' 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='31303' and bfksbh=150 and bfrq00 between '20110325' 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='31303' and dcks00=150 and rkfs00='1' and rkrq00 between '20110325' 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='31303' and xdksbh=150and XDRQ00 between '20110325' 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='31303' and pdksbh=150and QRRQ00 between '20110325' 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='31303' and DBKSBH=150and DBRQ00 between '20110325' 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='31303' and DBKSBH=150and DBRQ00 between '20110325' and '20110325' ) b group by rq0000 86 10:33: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='30902' and qlksbh=150 and rkrq00 between '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 87 10:33:02 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 88 10:33:02 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 89 10:33:02 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000 90 10:33:02 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' 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 '20110325' and '20110325' ) b group by rq0000