1       15:40:52  SQL Prepare: 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=:1 and wpxz00<>0 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

2       15:40: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

3       15:40: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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

4       15:40: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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

5       15:40: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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

6       15:40: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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

7       15:40: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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

8       15:40: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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

9       15:40: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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

10      15:40: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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

11      15:41:12  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

12      15:41:12  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

13      15:41:12  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='11909' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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='11909' and tkksbh=150 and tkrq00 between '20010828' and '20010828'
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='11909' and ffksbh=150 and ffrq00 between '20010828' and '20010828'
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='11909' and bfksbh=150 and bfrq00 between '20010828' and '20010828'
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='11909' and dcks00=150 and rkfs00='1' and rkrq00 between '20010828' and '20010828'
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='11909' and xdksbh=150and XDRQ00 between '20010828' and '20010828'
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='11909' and pdksbh=150and QRRQ00 between '20010828' and '20010828'
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='11909' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
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='11909' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
) b
group by rq0000

14      15:41:12  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='11909' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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='11909' and tkksbh=150 and tkrq00 between '20010828' and '20010828'
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='11909' and ffksbh=150 and ffrq00 between '20010828' and '20010828'
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='11909' and bfksbh=150 and bfrq00 between '20010828' and '20010828'
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='11909' and dcks00=150 and rkfs00='1' and rkrq00 between '20010828' and '20010828'
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='11909' and xdksbh=150and XDRQ00 between '20010828' and '20010828'
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='11909' and pdksbh=150and QRRQ00 between '20010828' and '20010828'
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='11909' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
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='11909' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
) b
group by rq0000

15      15:41:13  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='11909' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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='11909' and tkksbh=150 and tkrq00 between '20010828' and '20010828'
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='11909' and ffksbh=150 and ffrq00 between '20010828' and '20010828'
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='11909' and bfksbh=150 and bfrq00 between '20010828' and '20010828'
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='11909' and dcks00=150 and rkfs00='1' and rkrq00 between '20010828' and '20010828'
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='11909' and xdksbh=150and XDRQ00 between '20010828' and '20010828'
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='11909' and pdksbh=150and QRRQ00 between '20010828' and '20010828'
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='11909' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
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='11909' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
) b
group by rq0000

16      15:41:13  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='11909' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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='11909' and tkksbh=150 and tkrq00 between '20010828' and '20010828'
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='11909' and ffksbh=150 and ffrq00 between '20010828' and '20010828'
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='11909' and bfksbh=150 and bfrq00 between '20010828' and '20010828'
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='11909' and dcks00=150 and rkfs00='1' and rkrq00 between '20010828' and '20010828'
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='11909' and xdksbh=150and XDRQ00 between '20010828' and '20010828'
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='11909' and pdksbh=150and QRRQ00 between '20010828' and '20010828'
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='11909' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
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='11909' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
) b
group by rq0000

17      15:41:13  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='11410' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

18      15:41:13  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

19      15:41:13  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='11410' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

20      15:41:13  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

21      15:41:13  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

22      15:41:13  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

23      15:41:15  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

24      15:41:15  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

25      15:41:15  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='11504' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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='11504' and tkksbh=150 and tkrq00 between '20010828' and '20010828'
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='11504' and ffksbh=150 and ffrq00 between '20010828' and '20010828'
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='11504' and bfksbh=150 and bfrq00 between '20010828' and '20010828'
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='11504' and dcks00=150 and rkfs00='1' and rkrq00 between '20010828' and '20010828'
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='11504' and xdksbh=150and XDRQ00 between '20010828' and '20010828'
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='11504' and pdksbh=150and QRRQ00 between '20010828' and '20010828'
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='11504' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
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='11504' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
) b
group by rq0000

26      15:41:15  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='11504' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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='11504' and tkksbh=150 and tkrq00 between '20010828' and '20010828'
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='11504' and ffksbh=150 and ffrq00 between '20010828' and '20010828'
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='11504' and bfksbh=150 and bfrq00 between '20010828' and '20010828'
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='11504' and dcks00=150 and rkfs00='1' and rkrq00 between '20010828' and '20010828'
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='11504' and xdksbh=150and XDRQ00 between '20010828' and '20010828'
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='11504' and pdksbh=150and QRRQ00 between '20010828' and '20010828'
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='11504' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
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='11504' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
) b
group by rq0000

27      15:41:17  SQL Prepare: 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=:1 and wpxz00<>0 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

28      15:41:17  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

29      15:41:17  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='11504' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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='11504' and tkksbh=150 and tkrq00 between '20010828' and '20010828'
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='11504' and ffksbh=150 and ffrq00 between '20010828' and '20010828'
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='11504' and bfksbh=150 and bfrq00 between '20010828' and '20010828'
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='11504' and dcks00=150 and rkfs00='1' and rkrq00 between '20010828' and '20010828'
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='11504' and xdksbh=150and XDRQ00 between '20010828' and '20010828'
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='11504' and pdksbh=150and QRRQ00 between '20010828' and '20010828'
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='11504' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
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='11504' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
) b
group by rq0000

30      15:41:17  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='11504' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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='11504' and tkksbh=150 and tkrq00 between '20010828' and '20010828'
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='11504' and ffksbh=150 and ffrq00 between '20010828' and '20010828'
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='11504' and bfksbh=150 and bfrq00 between '20010828' and '20010828'
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='11504' and dcks00=150 and rkfs00='1' and rkrq00 between '20010828' and '20010828'
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='11504' and xdksbh=150and XDRQ00 between '20010828' and '20010828'
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='11504' and pdksbh=150and QRRQ00 between '20010828' and '20010828'
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='11504' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
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='11504' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
) b
group by rq0000

31      15:41:17  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

32      15:41:17  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

33      15:41:17  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

34      15:41:17  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

35      15:41:17  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

36      15:41:17  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

37      15:41:18  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

38      15:41:18  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

39      15:41:18  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='11410' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

40      15:41:18  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

41      15:41:20  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='11410' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

42      15:41:20  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 '20010828' and '20010828' 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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
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 '20010828' and '20010828'
) b
group by rq0000

43      15:41:20  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='11203' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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='11203' and tkksbh=150 and tkrq00 between '20010828' and '20010828'
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='11203' and ffksbh=150 and ffrq00 between '20010828' and '20010828'
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='11203' and bfksbh=150 and bfrq00 between '20010828' and '20010828'
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='11203' and dcks00=150 and rkfs00='1' and rkrq00 between '20010828' and '20010828'
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='11203' and xdksbh=150and XDRQ00 between '20010828' and '20010828'
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='11203' and pdksbh=150and QRRQ00 between '20010828' and '20010828'
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='11203' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
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='11203' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
) b
group by rq0000

44      15:41:20  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='11203' and qlksbh=150 and rkrq00 between '20010828' and '20010828' 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='11203' and tkksbh=150 and tkrq00 between '20010828' and '20010828'
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='11203' and ffksbh=150 and ffrq00 between '20010828' and '20010828'
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='11203' and bfksbh=150 and bfrq00 between '20010828' and '20010828'
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='11203' and dcks00=150 and rkfs00='1' and rkrq00 between '20010828' and '20010828'
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='11203' and xdksbh=150and XDRQ00 between '20010828' and '20010828'
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='11203' and pdksbh=150and QRRQ00 between '20010828' and '20010828'
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='11203' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
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='11203' and DBKSBH=150and DBRQ00 between '20010828' and '20010828'
) b
group by rq0000