产品成立明细查询过程

SELECT ROWNUM 序号, T.客户姓名,t.期限, T.进账金额
FROM (SELECT c.cpqc 产品名称,cp.khmc 客户姓名,
(SELECT qx.sm FROM TXSXM_CPQX qx WHERE qx.id=cp.cpqx) 期限,
t.jzje/10000 进账金额 FROM tcpyy cp,tfp_cpdm c,
(SELECT t.cpyyid cpyyid,SUM(t.jzje) jzje FROM tzjjz t WHERE t.shzt=2 AND t.zjzt=1 and T.JZJE>0 GROUP BY t.cpyyid) t
WHERE cp.id=t.cpyyid
AND cp.cpid=c.id
AND (cp.CPID = ? OR (EXISTS (SELECT 1
FROM TFP_CPDM D
WHERE D.CPDM_TA = C.FCPDM_TA
AND D.ID = ?
AND D.FCPDM_TA IS NULL)
AND
? = 1))
ORDER BY 进账金额)t
UNION
SELECT NULL 序号,
‘总计’ 客户姓名,
NULL 期限,
SUM(t.jzje/ 10000) 进账金额
FROM tcpyy cp,tfp_cpdm c,
(SELECT t.cpyyid cpyyid,SUM(t.jzje) jzje FROM tzjjz t WHERE t.shzt=2 AND t.zjzt=1 and T.JZJE>0 GROUP BY t.cpyyid) t
WHERE cp.id=t.cpyyid
AND cp.cpid=c.id
AND (cp.CPID = ? OR (EXISTS (SELECT 1
FROM TFP_CPDM D
WHERE D.CPDM_TA = C.FCPDM_TA
AND D.ID = ?
AND D.FCPDM_TA IS NULL)
AND
? = 1))