1 11:14:20 SQL Prepare: ORACLE - BEGIN "SP_SB_DAXX00_MXZ000" (AS_KSMC00 => :AS_KSMC00,AS_ZCMC00 => :AS_ZCMC00,AS_GG0000 => :AS_GG0000,AS_XH0000 => :AS_XH0000,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_TJLB00 => :AS_TJLB00,AS_CKBH00 => :AS_CKBH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 2 11:14:20 SQL Execute: ORACLE - BEGIN "SP_SB_DAXX00_MXZ000" (AS_KSMC00 => :AS_KSMC00,AS_ZCMC00 => :AS_ZCMC00,AS_GG0000 => :AS_GG0000,AS_XH0000 => :AS_XH0000,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_TJLB00 => :AS_TJLB00,AS_CKBH00 => :AS_CKBH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 3 11:17:43 SQL Prepare: ORACLE - select DECODE(A.MC0000,'本月合计',NULL,'本年累计',NULL,substr(A.CZRQ00,1,4)) CZRQ03, DECODE(A.MC0000,'本月合计',NULL,'本年累计',NULL,substr(A.CZRQ00,5,2)) CZRQ01, DECODE(A.MC0000,'本月合计',NULL,'本年累计',NULL,substr(A.CZRQ00,7,2)) CZRQ02, A.*,(select B.BMMC00 from BM_BMBM00 B where A.XM0008=B.BMBH00(+)) BMMC00, (select D.SBLBMC from BM_SBBM00 C,BM_SBLB00 D where A.XM0009=C.SBID00(+) and C.SBLBID=D.SBLBID) SBLBMC from BM_SBTJ00_TEMP A where ID0000 =:1 order by CZRQ00,XM0007,BZ0000 4 11:17:43 SQL Execute: ORACLE - select DECODE(A.MC0000,'本月合计',NULL,'本年累计',NULL,substr(A.CZRQ00,1,4)) CZRQ03, DECODE(A.MC0000,'本月合计',NULL,'本年累计',NULL,substr(A.CZRQ00,5,2)) CZRQ01, DECODE(A.MC0000,'本月合计',NULL,'本年累计',NULL,substr(A.CZRQ00,7,2)) CZRQ02, A.*,(select B.BMMC00 from BM_BMBM00 B where A.XM0008=B.BMBH00(+)) BMMC00, (select D.SBLBMC from BM_SBBM00 C,BM_SBLB00 D where A.XM0009=C.SBID00(+) and C.SBLBID=D.SBLBID) SBLBMC from BM_SBTJ00_TEMP A where ID0000 =? order by CZRQ00,XM0007,BZ0000 5 11:18:23 SQL Prepare: ORACLE - select sysdate N from dual 6 11:18:23 SQL Execute: ORACLE - select sysdate N from dual 7 11:18:23 SQL Prepare: ORACLE - select 1 from dual where exists (select TQYF00 from SB_GDZCZJ where TQNF00 =2011 and TQYF00 =12) 8 11:18:23 SQL Execute: ORACLE - select 1 from dual where exists (select TQYF00 from SB_GDZCZJ where TQNF00 =2011 and TQYF00 =12) 9 11:18:23 SQL Prepare: ORACLE - select BMMC00,BMBH00,BH0000,SX,sum(YZ0000) YZ0000,sum(BYZJE0) BYZJE0,sum(BYBTJE) BYBTJE, sum(LJZJ00) LJZJ00,sum(JZ0000) JZ0000 from ( select ' 合计' BMMC00,0 BMBH00,'' BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 169 union all select ' 合计' BMMC00,0 BMBH00,'' BH0000, NVL(sum(F.FTJE00),0) YZ0000,0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00, NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E,SB_SYKS00 F where A.DAXXID = F.DAXXID and E.BMBH00=F.BMBH00 and a.shjszj='2' and A.SFYX00='Y' and F.SYZT00='Y' and A.CKBH00= 169 union all select ' 合计' BMMC00 ,0 BMBH00,'' BH0000, NVL(sum(a.yz0000),0) YZ0000,0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00, NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E where a.syzt00='1' and a.sfyx00='Y' and A.CKBH00=E.BMBH00 and A.CKBH00= 169 and substr(A.RZRQ00,1,6)<='201112' union all select ' 合计' BMMC00,0 BMBH00,'' BH0000,sum(nvl(b.FTJE00,0)) YZ0000,0 BYZJE0,0 BYBTJE,sum(nvl(A.LJZJ00,0)) LJZJ00,sum(nvl(A.JZ0000,YZ0000)) JZ0000,'0' SX from SB_DA0000 a,SB_SYKS00 b,BM_BMBM00 e where a.DAXXID=b.DAXXID and a.SHJSZJ='1' and a.SFYX00='Y' and b.SYZT00='Y' and not exists(select 1 from SB_GDZCZJ where DAXXID=a.DAXXID and TQNF00='2011' and TQYF00='12') and e.BMBH00=b.BMBH00 and substr(a.RZRQ00,1,6)<='201112' and A.CKBH00= 169 )group by BMMC00,BMBH00,BH0000,SX union all select BMMC00,BMBH00,BH0000,SX,sum(YZ0000) YZ0000,sum(BYZJE0) BYZJE0,sum(BYBTJE) BYBTJE, sum(LJZJ00) LJZJ00,sum(JZ0000) JZ0000 from ( SELECT BMMC00, BMBH00,BH0000, YZ0000, BYZJE0, BYBTJE, LJZJ00, JZ0000, SX FROM ( select E.BMMC00,D.TQKS00 BMBH00,E.BH0000 BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000,E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 169 group by D.TQKS00,E.BMMC00,E.BH0000,E.BMXZ00 ) union all SELECT BMMC00, BMBH00,BH0000, YZ0000, BYZJE0, BYBTJE, LJZJ00, JZ0000, SX FROM ( select E.BMMC00,F.BMBH00 BMBH00,E.BH0000 BH0000, NVL(sum(F.FTJE00),0) YZ0000, 0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00,NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000, E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_SYKS00 F where A.DAXXID = F.DAXXID and F.bmbh00=E.bmbh00 and A.SHJSZJ ='2' and A.SFYX00='Y' and F.SYZT00='Y' and A.CKBH00= 169 group by F.bmbh00,E.BMMC00,E.BH0000,E.BMXZ00 ) union all select BMMC00,e.BMBH00,BH0000,sum(nvl(b.FTJE00,0)) YZ0000,0 BYZJE0,0 BYBTJE,sum(nvl(A.LJZJ00,0)) LJZJ00,sum(nvl(A.JZ0000,YZ0000)) JZ0000,e.BMXZ00 SX from SB_DA0000 a,SB_SYKS00 b,BM_BMBM00 e where a.DAXXID=b.DAXXID and a.SHJSZJ='1' and a.SFYX00='Y' and b.SYZT00='Y' and not exists(select 1 from SB_GDZCZJ where DAXXID=a.DAXXID and TQNF00='2011' and TQYF00='12') and e.BMBH00=b.BMBH00 and substr(a.RZRQ00,1,6)<='201112' and A.CKBH00= 169 group by e.bmbh00,BMMC00,BH0000,BMXZ00 ) group by bmbh00,BMMC00,BH0000,SX union all select BMMC00,BMBH00,BH0000,SX,sum(YZ0000) YZ0000,sum(BYZJE0) BYZJE0,sum(BYBTJE) BYBTJE, sum(LJZJ00) LJZJ00,sum(JZ0000) JZ0000 from ( select ' 部门合计' BMMC00 ,1000 BMBH00,'' BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000, E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ ='1' and A.CKBH00= 169 group by E.BMXZ00 union all select ' 部门合计' BMMC00,1000 BMBH00,'' BH0000,NVL(sum(F.FTJE00),0) YZ0000,0 BYZJE0, 0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00,NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000,E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_SYKS00 F where A.DAXXID = F.DAXXID and F.bmbh00=E.bmbh00 and A.SHJSZJ = '2' and A.SFYX00='Y' and F.SYZT00='Y' and A.CKBH00= 169 group by E.BMXZ00 ) group by bmbh00,BMMC00,BH0000,SX union all select (select b.BMMC00 from BM_BMBM00 b where b.bmbh00=x.BMBH00 ) BMMC00, BMBH00,BH0000,SX,YZ0000,BYZJE0,BYBTJE,LJZJ00,JZ0000 from (select A.CKBH00 BMBH00,E.BH0000 BH0000, NVL(sum(a.yz0000),0) YZ0000,0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00, NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000, 'x' SX from SB_DA0000 A,BM_BMBM00 E where A.CKBH00=E.BMBH00 and a.syzt00='1' and a.sfyx00='Y' and A.CKBH00= 169 and substr(A.RZRQ00,1,6)<='201112' group by A.CKBH00,E.BH0000 ) X order by SX,BMBH00 10 11:18:23 SQL Execute: ORACLE - select BMMC00,BMBH00,BH0000,SX,sum(YZ0000) YZ0000,sum(BYZJE0) BYZJE0,sum(BYBTJE) BYBTJE, sum(LJZJ00) LJZJ00,sum(JZ0000) JZ0000 from ( select ' 合计' BMMC00,0 BMBH00,'' BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 169 union all select ' 合计' BMMC00,0 BMBH00,'' BH0000, NVL(sum(F.FTJE00),0) YZ0000,0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00, NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E,SB_SYKS00 F where A.DAXXID = F.DAXXID and E.BMBH00=F.BMBH00 and a.shjszj='2' and A.SFYX00='Y' and F.SYZT00='Y' and A.CKBH00= 169 union all select ' 合计' BMMC00 ,0 BMBH00,'' BH0000, NVL(sum(a.yz0000),0) YZ0000,0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00, NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E where a.syzt00='1' and a.sfyx00='Y' and A.CKBH00=E.BMBH00 and A.CKBH00= 169 and substr(A.RZRQ00,1,6)<='201112' union all select ' 合计' BMMC00,0 BMBH00,'' BH0000,sum(nvl(b.FTJE00,0)) YZ0000,0 BYZJE0,0 BYBTJE,sum(nvl(A.LJZJ00,0)) LJZJ00,sum(nvl(A.JZ0000,YZ0000)) JZ0000,'0' SX from SB_DA0000 a,SB_SYKS00 b,BM_BMBM00 e where a.DAXXID=b.DAXXID and a.SHJSZJ='1' and a.SFYX00='Y' and b.SYZT00='Y' and not exists(select 1 from SB_GDZCZJ where DAXXID=a.DAXXID and TQNF00='2011' and TQYF00='12') and e.BMBH00=b.BMBH00 and substr(a.RZRQ00,1,6)<='201112' and A.CKBH00= 169 )group by BMMC00,BMBH00,BH0000,SX union all select BMMC00,BMBH00,BH0000,SX,sum(YZ0000) YZ0000,sum(BYZJE0) BYZJE0,sum(BYBTJE) BYBTJE, sum(LJZJ00) LJZJ00,sum(JZ0000) JZ0000 from ( SELECT BMMC00, BMBH00,BH0000, YZ0000, BYZJE0, BYBTJE, LJZJ00, JZ0000, SX FROM ( select E.BMMC00,D.TQKS00 BMBH00,E.BH0000 BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000,E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 169 group by D.TQKS00,E.BMMC00,E.BH0000,E.BMXZ00 ) union all SELECT BMMC00, BMBH00,BH0000, YZ0000, BYZJE0, BYBTJE, LJZJ00, JZ0000, SX FROM ( select E.BMMC00,F.BMBH00 BMBH00,E.BH0000 BH0000, NVL(sum(F.FTJE00),0) YZ0000, 0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00,NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000, E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_SYKS00 F where A.DAXXID = F.DAXXID and F.bmbh00=E.bmbh00 and A.SHJSZJ ='2' and A.SFYX00='Y' and F.SYZT00='Y' and A.CKBH00= 169 group by F.bmbh00,E.BMMC00,E.BH0000,E.BMXZ00 ) union all select BMMC00,e.BMBH00,BH0000,sum(nvl(b.FTJE00,0)) YZ0000,0 BYZJE0,0 BYBTJE,sum(nvl(A.LJZJ00,0)) LJZJ00,sum(nvl(A.JZ0000,YZ0000)) JZ0000,e.BMXZ00 SX from SB_DA0000 a,SB_SYKS00 b,BM_BMBM00 e where a.DAXXID=b.DAXXID and a.SHJSZJ='1' and a.SFYX00='Y' and b.SYZT00='Y' and not exists(select 1 from SB_GDZCZJ where DAXXID=a.DAXXID and TQNF00='2011' and TQYF00='12') and e.BMBH00=b.BMBH00 and substr(a.RZRQ00,1,6)<='201112' and A.CKBH00= 169 group by e.bmbh00,BMMC00,BH0000,BMXZ00 ) group by bmbh00,BMMC00,BH0000,SX union all select BMMC00,BMBH00,BH0000,SX,sum(YZ0000) YZ0000,sum(BYZJE0) BYZJE0,sum(BYBTJE) BYBTJE, sum(LJZJ00) LJZJ00,sum(JZ0000) JZ0000 from ( select ' 部门合计' BMMC00 ,1000 BMBH00,'' BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000, E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ ='1' and A.CKBH00= 169 group by E.BMXZ00 union all select ' 部门合计' BMMC00,1000 BMBH00,'' BH0000,NVL(sum(F.FTJE00),0) YZ0000,0 BYZJE0, 0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00,NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000,E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_SYKS00 F where A.DAXXID = F.DAXXID and F.bmbh00=E.bmbh00 and A.SHJSZJ = '2' and A.SFYX00='Y' and F.SYZT00='Y' and A.CKBH00= 169 group by E.BMXZ00 ) group by bmbh00,BMMC00,BH0000,SX union all select (select b.BMMC00 from BM_BMBM00 b where b.bmbh00=x.BMBH00 ) BMMC00, BMBH00,BH0000,SX,YZ0000,BYZJE0,BYBTJE,LJZJ00,JZ0000 from (select A.CKBH00 BMBH00,E.BH0000 BH0000, NVL(sum(a.yz0000),0) YZ0000,0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00, NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000, 'x' SX from SB_DA0000 A,BM_BMBM00 E where A.CKBH00=E.BMBH00 and a.syzt00='1' and a.sfyx00='Y' and A.CKBH00= 169 and substr(A.RZRQ00,1,6)<='201112' group by A.CKBH00,E.BH0000 ) X order by SX,BMBH00 11 11:31:03 SQL Prepare: ORACLE - BEGIN "SP_SB_DAXX00_MXZ000" (AS_KSMC00 => :AS_KSMC00,AS_ZCMC00 => :AS_ZCMC00,AS_GG0000 => :AS_GG0000,AS_XH0000 => :AS_XH0000,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_TJLB00 => :AS_TJLB00,AS_CKBH00 => :AS_CKBH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 12 11:31:03 SQL Execute: ORACLE - BEGIN "SP_SB_DAXX00_MXZ000" (AS_KSMC00 => :AS_KSMC00,AS_ZCMC00 => :AS_ZCMC00,AS_GG0000 => :AS_GG0000,AS_XH0000 => :AS_XH0000,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_TJLB00 => :AS_TJLB00,AS_CKBH00 => :AS_CKBH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;