对应的SQL,代码如下:
WITH TMP_RESULT AS
(SELECT A.ACCT_ID,
A.PRD_INST_ID,A.OFR_ID,
A.FEE_TYPE,A.ACCT_ITEM_TYPE_ID...,
B.ACCT_ITEM_TYPE_NAME,A.FLUX,
A.RATE_DURATION,A.CHARGE
FROM V_DAT_M_21 A,
TB_BIL_ACCT_ITEM_TYPE...= B.ACCT_ITEM_TYPE_ID
)
SELECT C.ACCT_ID,C.PRD_INST_ID,
C.OFR_ID,E.OFR_NAME,
C.FEE_TYPE,C.ACCT_ITEM_TYPE_ID...,C.ACCT_ITEM_TYPE_ID,
C.ACCT_ITEM_TYPE_NAME,C.FLUX,
C.RATE_DURATION,C.CHARGE
FROM TMP_RESULT C
WHERE...A.PRD_INST_ID
AND A.ACCT_ITEM_TYPE_ID = B.ACCT_ITEM_TYPE_ID
)
SELECT distinct C.ACCT_ID,C.PRD_INST_ID