1 09:38:59 SQL Prepare: ORACLE - SELECT * FROM ( SELECT CRBMBH,ZY0000 AS TJXMMC, SUM(DECODE(LBBH00,'0',SLJE00,0)) AS XYLSJE, SUM(DECODE(LBBH00,'1',SLJE00,0)) AS CYLSJE, SUM(DECODE(LBBH00,'2',SLJE00,0)) AS ZYLSJE, SUM(DECODE(LBBH00,'3',SLJE00,0)) AS YXLSJE, SUM(DECODE(LBBH00,'0',GJJE00,0)) AS XYGJJE, SUM(DECODE(LBBH00,'1',GJJE00,0)) AS CYGJJE, SUM(DECODE(LBBH00,'2',GJJE00,0)) AS ZYGJJE, SUM(DECODE(LBBH00,'3',GJJE00,0)) AS YXGJJE, SUM(DECODE(LBBH00,'0',CJGJJE,0)) AS XYCJJE, SUM(DECODE(LBBH00,'1',CJGJJE,0)) AS CYCJJE, SUM(DECODE(LBBH00,'2',CJGJJE,0)) AS ZYCJJE, SUM(DECODE(LBBH00,'3',CJGJJE,0)) AS YXCJJE, SUM(DECODE(LBBH00,'0',ZKJE00,0)) AS XYZKJE, SUM(DECODE(LBBH00,'1',ZKJE00,0)) AS CYZKJE, SUM(DECODE(LBBH00,'2',ZKJE00,0)) AS ZYZKJE, SUM(DECODE(LBBH00,'3',ZKJE00,0)) AS YXZKJE, KHYY00,YHZH00 FROM(SELECT DJH000,CRBMBH,DECODE(NVL(INSTR(ZY0000,','),0),0,ZY0000,SUBSTR(ZY0000,1,INSTR(ZY0000,',')-1)) ZY0000,LBBH00,ZKJE00,KHYY00,YHZH00, SUM(SLJE00) SLJE00,SUM(decode(RCLXBH,'10',decode((select trim(value0) from xt_xtcs00 where name00='YK_CJJESFDLGL'),'Y',0,nvl(YGJJE0,GJJE00)), NVL(nvl(YGJJE0,nvl(GJJE00,decode(nvl(SLDJ00,0),0,0,round(SLJE00/SLDJ00*GJDJ00,2)))),0))) GJJE00,SUM(ROUND(SLSL00*PFDJ00,2)) PFJE00, sum(decode((select trim(value0) from xt_xtcs00 where name00='YK_CJJESFDLGL'),'Y',decode(RCLXBH,'10',nvl(YGJJE0,GJJE00),0),0)) CJGJJE FROM VW_YK_RKJZCX WHERE YKBMBH+0=:1 AND RCLXBH like :2 AND JZRQ00>=:3 AND JZRQ00<=:4 AND JZRQ00||JZSJ00>=:5 AND JZRQ00||JZSJ00<=:6 AND SFSH00 like :7 GROUP BY DJH000,CRBMBH,DECODE(NVL(INSTR(ZY0000,','),0),0,ZY0000,SUBSTR(ZY0000,1,INSTR(ZY0000,',')-1)),LBBH00,ZKJE00,KHYY00,YHZH00) GROUP BY CRBMBH,ZY0000,KHYY00,YHZH00 UNION ALL SELECT 9999999 CRBMBH,'进合计' TJXMMC, SUM(DECODE(LBBH00,'0',SLJE00,0)) AS XYLSJE, SUM(DECODE(LBBH00,'1',SLJE00,0)) AS CYLSJE, SUM(DECODE(LBBH00,'2',SLJE00,0)) AS ZYLSJE, SUM(DECODE(LBBH00,'3',SLJE00,0)) AS ZYLSJE, SUM(DECODE(LBBH00,'0',GJJE00,0)) AS XYGJJE, SUM(DECODE(LBBH00,'1',GJJE00,0)) AS CYGJJE, SUM(DECODE(LBBH00,'2',GJJE00,0)) AS ZYGJJE, SUM(DECODE(LBBH00,'3',GJJE00,0)) AS ZYGJJE, SUM(DECODE(LBBH00,'0',CJGJJE,0)) AS XYCJJE, SUM(DECODE(LBBH00,'1',CJGJJE,0)) AS CYCJJE, SUM(DECODE(LBBH00,'2',CJGJJE,0)) AS ZYCJJE, SUM(DECODE(LBBH00,'3',CJGJJE,0)) AS ZYCJJE, SUM(DECODE(LBBH00,'0',ZKJE00,0)) AS XYZKJE, SUM(DECODE(LBBH00,'1',ZKJE00,0)) AS CYZKJE, SUM(DECODE(LBBH00,'2',ZKJE00,0)) AS ZYZKJE, SUM(DECODE(LBBH00,'3',ZKJE00,0)) AS ZYZKJE, NULL KHYY00, NULL YHZH00 FROM(SELECT DJH000,CRBMBH,DECODE(NVL(INSTR(ZY0000,','),0),0,ZY0000,SUBSTR(ZY0000,1,INSTR(ZY0000,',')-1)) ZY0000,LBBH00,ZKJE00,KHYY00,YHZH00, SUM(SLJE00) SLJE00,SUM(decode(RCLXBH,'10',decode((select trim(value0) from xt_xtcs00 where name00='YK_CJJESFDLGL'),'Y',0,nvl(YGJJE0,GJJE00)), NVL(nvl(YGJJE0,nvl(GJJE00,decode(nvl(SLDJ00,0),0,0,round(SLJE00/SLDJ00*GJDJ00,2)))),0))) GJJE00,SUM(ROUND(SLSL00*PFDJ00,2)) PFJE00, sum(decode((select trim(value0) from xt_xtcs00 where name00='YK_CJJESFDLGL'),'Y',decode(RCLXBH,'10',nvl(YGJJE0,GJJE00),0),0)) CJGJJE FROM VW_YK_RKJZCX WHERE YKBMBH+0=:8 AND RCLXBH like :9 AND JZRQ00>=:10 AND JZRQ00<=:11 AND JZRQ00||JZSJ00>=:12 AND JZRQ00||JZSJ00<=:13 AND SFSH00 like :14 GROUP BY DJH000,CRBMBH,DECODE(NVL(INSTR(ZY0000,','),0),0,ZY0000,SUBSTR(ZY0000,1,INSTR(ZY0000,',')-1)),LBBH00,ZKJE00,KHYY00,YHZH00) ) ORDER BY CRBMBH 2 09:38:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 3 09:38:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 09% 4 09:38:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130301 5 09:38:59 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130402 6 09:38:59 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2013030100:00:00 7 09:38:59 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2013040223:59:59 8 09:38:59 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 9 09:38:59 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 10 09:38:59 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 09% 11 09:38:59 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130301 12 09:38:59 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130402 13 09:38:59 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2013030100:00:00 14 09:38:59 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2013040223:59:59 15 09:38:59 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 16 09:38:59 SQL Execute: ORACLE - SELECT * FROM ( SELECT CRBMBH,ZY0000 AS TJXMMC, SUM(DECODE(LBBH00,'0',SLJE00,0)) AS XYLSJE, SUM(DECODE(LBBH00,'1',SLJE00,0)) AS CYLSJE, SUM(DECODE(LBBH00,'2',SLJE00,0)) AS ZYLSJE, SUM(DECODE(LBBH00,'3',SLJE00,0)) AS YXLSJE, SUM(DECODE(LBBH00,'0',GJJE00,0)) AS XYGJJE, SUM(DECODE(LBBH00,'1',GJJE00,0)) AS CYGJJE, SUM(DECODE(LBBH00,'2',GJJE00,0)) AS ZYGJJE, SUM(DECODE(LBBH00,'3',GJJE00,0)) AS YXGJJE, SUM(DECODE(LBBH00,'0',CJGJJE,0)) AS XYCJJE, SUM(DECODE(LBBH00,'1',CJGJJE,0)) AS CYCJJE, SUM(DECODE(LBBH00,'2',CJGJJE,0)) AS ZYCJJE, SUM(DECODE(LBBH00,'3',CJGJJE,0)) AS YXCJJE, SUM(DECODE(LBBH00,'0',ZKJE00,0)) AS XYZKJE, SUM(DECODE(LBBH00,'1',ZKJE00,0)) AS CYZKJE, SUM(DECODE(LBBH00,'2',ZKJE00,0)) AS ZYZKJE, SUM(DECODE(LBBH00,'3',ZKJE00,0)) AS YXZKJE, KHYY00,YHZH00 FROM(SELECT DJH000,CRBMBH,DECODE(NVL(INSTR(ZY0000,','),0),0,ZY0000,SUBSTR(ZY0000,1,INSTR(ZY0000,',')-1)) ZY0000,LBBH00,ZKJE00,KHYY00,YHZH00, SUM(SLJE00) SLJE00,SUM(decode(RCLXBH,'10',decode((select trim(value0) from xt_xtcs00 where name00='YK_CJJESFDLGL'),'Y',0,nvl(YGJJE0,GJJE00)), NVL(nvl(YGJJE0,nvl(GJJE00,decode(nvl(SLDJ00,0),0,0,round(SLJE00/SLDJ00*GJDJ00,2)))),0))) GJJE00,SUM(ROUND(SLSL00*PFDJ00,2)) PFJE00, sum(decode((select trim(value0) from xt_xtcs00 where name00='YK_CJJESFDLGL'),'Y',decode(RCLXBH,'10',nvl(YGJJE0,GJJE00),0),0)) CJGJJE FROM VW_YK_RKJZCX WHERE YKBMBH+0=? AND RCLXBH like ? AND JZRQ00>=? AND JZRQ00<=? AND JZRQ00||JZSJ00>=? AND JZRQ00||JZSJ00<=? AND SFSH00 like ? GROUP BY DJH000,CRBMBH,DECODE(NVL(INSTR(ZY0000,','),0),0,ZY0000,SUBSTR(ZY0000,1,INSTR(ZY0000,',')-1)),LBBH00,ZKJE00,KHYY00,YHZH00) GROUP BY CRBMBH,ZY0000,KHYY00,YHZH00 UNION ALL SELECT 9999999 CRBMBH,'进合计' TJXMMC, SUM(DECODE(LBBH00,'0',SLJE00,0)) AS XYLSJE, SUM(DECODE(LBBH00,'1',SLJE00,0)) AS CYLSJE, SUM(DECODE(LBBH00,'2',SLJE00,0)) AS ZYLSJE, SUM(DECODE(LBBH00,'3',SLJE00,0)) AS ZYLSJE, SUM(DECODE(LBBH00,'0',GJJE00,0)) AS XYGJJE, SUM(DECODE(LBBH00,'1',GJJE00,0)) AS CYGJJE, SUM(DECODE(LBBH00,'2',GJJE00,0)) AS ZYGJJE, SUM(DECODE(LBBH00,'3',GJJE00,0)) AS ZYGJJE, SUM(DECODE(LBBH00,'0',CJGJJE,0)) AS XYCJJE, SUM(DECODE(LBBH00,'1',CJGJJE,0)) AS CYCJJE, SUM(DECODE(LBBH00,'2',CJGJJE,0)) AS ZYCJJE, SUM(DECODE(LBBH00,'3',CJGJJE,0)) AS ZYCJJE, SUM(DECODE(LBBH00,'0',ZKJE00,0)) AS XYZKJE, SUM(DECODE(LBBH00,'1',ZKJE00,0)) AS CYZKJE, SUM(DECODE(LBBH00,'2',ZKJE00,0)) AS ZYZKJE, SUM(DECODE(LBBH00,'3',ZKJE00,0)) AS ZYZKJE, NULL KHYY00, NULL YHZH00 FROM(SELECT DJH000,CRBMBH,DECODE(NVL(INSTR(ZY0000,','),0),0,ZY0000,SUBSTR(ZY0000,1,INSTR(ZY0000,',')-1)) ZY0000,LBBH00,ZKJE00,KHYY00,YHZH00, SUM(SLJE00) SLJE00,SUM(decode(RCLXBH,'10',decode((select trim(value0) from xt_xtcs00 where name00='YK_CJJESFDLGL'),'Y',0,nvl(YGJJE0,GJJE00)), NVL(nvl(YGJJE0,nvl(GJJE00,decode(nvl(SLDJ00,0),0,0,round(SLJE00/SLDJ00*GJDJ00,2)))),0))) GJJE00,SUM(ROUND(SLSL00*PFDJ00,2)) PFJE00, sum(decode((select trim(value0) from xt_xtcs00 where name00='YK_CJJESFDLGL'),'Y',decode(RCLXBH,'10',nvl(YGJJE0,GJJE00),0),0)) CJGJJE FROM VW_YK_RKJZCX WHERE YKBMBH+0=? AND RCLXBH like ? AND JZRQ00>=? AND JZRQ00<=? AND JZRQ00||JZSJ00>=? AND JZRQ00||JZSJ00<=? AND SFSH00 like ? GROUP BY DJH000,CRBMBH,DECODE(NVL(INSTR(ZY0000,','),0),0,ZY0000,SUBSTR(ZY0000,1,INSTR(ZY0000,',')-1)),LBBH00,ZKJE00,KHYY00,YHZH00) ) ORDER BY CRBMBH