1       09:42:36  SQL Prepare: ORACLE - SELECT * FROM (
SELECT CRBMBH,
ZY0000 AS TJXMMC,
SUM(DECODE(LBBH00,'0',FCJE00,0)) AS XYLSJE,
SUM(DECODE(LBBH00,'1',FCJE00,0)) AS CYLSJE,
SUM(DECODE(LBBH00,'2',FCJE00,0)) AS ZYLSJE,
SUM(DECODE(LBBH00,'3',FCJE00,0)) AS YXLSJE,
SUM(DECODE(LBBH00,'0',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS XYGJJE,
SUM(DECODE(LBBH00,'1',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS CYGJJE,
SUM(DECODE(LBBH00,'2',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS ZYGJJE,
SUM(DECODE(LBBH00,'3',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS YXGJJE
FROM VW_YK_CKJZCX 
WHERE YKBMBH+0=:1
AND RCLXBH like :2
AND JZRQ00>=:3 AND JZRQ00<=:4 
AND JZRQ00||JZSJ00>=:5 AND JZRQ00||JZSJ00<=:6 
GROUP BY  CRBMBH,ZY0000
UNION ALL SELECT 9999999 CRBMBH,
'出合计' TJXMMC,
SUM(DECODE(LBBH00,'0',FCJE00,0)) AS XYLSJE,
SUM(DECODE(LBBH00,'1',FCJE00,0)) AS CYLSJE,
SUM(DECODE(LBBH00,'2',FCJE00,0)) AS ZYLSJE,
SUM(DECODE(LBBH00,'3',FCJE00,0)) AS YXLSJE,
SUM(DECODE(LBBH00,'0',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS XYGJJE,
SUM(DECODE(LBBH00,'1',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS CYGJJE,
SUM(DECODE(LBBH00,'2',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS ZYGJJE,
SUM(DECODE(LBBH00,'3',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS YXGJJE
FROM VW_YK_CKJZCX 
WHERE YKBMBH+0=:7
AND RCLXBH like :8
AND JZRQ00>=:9 AND JZRQ00<=:10 
AND JZRQ00||JZSJ00>=:11 AND JZRQ00||JZSJ00<=:12 
) ORDER BY  CRBMBH

2       09:42:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000
3       09:42:36  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 08%
4       09:42:36  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130301
5       09:42:36  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130331
6       09:42:36  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2013030100:00:00
7       09:42:36  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2013033123:59:59
8       09:42:36  SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000
9       09:42:36  SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 08%
10      09:42:36  SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130301
11      09:42:36  SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130331
12      09:42:36  SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2013030100:00:00
13      09:42:36  SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2013033123:59:59
14      09:42:36  SQL Execute: ORACLE - SELECT * FROM (
SELECT CRBMBH,
ZY0000 AS TJXMMC,
SUM(DECODE(LBBH00,'0',FCJE00,0)) AS XYLSJE,
SUM(DECODE(LBBH00,'1',FCJE00,0)) AS CYLSJE,
SUM(DECODE(LBBH00,'2',FCJE00,0)) AS ZYLSJE,
SUM(DECODE(LBBH00,'3',FCJE00,0)) AS YXLSJE,
SUM(DECODE(LBBH00,'0',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS XYGJJE,
SUM(DECODE(LBBH00,'1',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS CYGJJE,
SUM(DECODE(LBBH00,'2',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS ZYGJJE,
SUM(DECODE(LBBH00,'3',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS YXGJJE
FROM VW_YK_CKJZCX 
WHERE YKBMBH+0=?
AND RCLXBH like ?
AND JZRQ00>=? AND JZRQ00<=? 
AND JZRQ00||JZSJ00>=? AND JZRQ00||JZSJ00<=? 
GROUP BY  CRBMBH,ZY0000
UNION ALL SELECT 9999999 CRBMBH,
'出合计' TJXMMC,
SUM(DECODE(LBBH00,'0',FCJE00,0)) AS XYLSJE,
SUM(DECODE(LBBH00,'1',FCJE00,0)) AS CYLSJE,
SUM(DECODE(LBBH00,'2',FCJE00,0)) AS ZYLSJE,
SUM(DECODE(LBBH00,'3',FCJE00,0)) AS YXLSJE,
SUM(DECODE(LBBH00,'0',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS XYGJJE,
SUM(DECODE(LBBH00,'1',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS CYGJJE,
SUM(DECODE(LBBH00,'2',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS ZYGJJE,
SUM(DECODE(LBBH00,'3',nvl(GJFCJE,decode(nvl(fcdj00,0),0,0,round(fcje00/fcdj00*gjdj00,2))),0)) AS YXGJJE
FROM VW_YK_CKJZCX 
WHERE YKBMBH+0=?
AND RCLXBH like ?
AND JZRQ00>=? AND JZRQ00<=? 
AND JZRQ00||JZSJ00>=? AND JZRQ00||JZSJ00<=? 
) ORDER BY  CRBMBH