[Home] [Help]
View: IGF_AW_NEED_ANLY_V
View Text
SELECT FABASE.BASE_ID
, FABASE.COA_F
, FABASE.COA_F
, FABASE.EFC_I
, FABASE.EFC_F
, SUM(NVL(DECODE(FMAST.FM_FC_METHD
, 'I'
, AWD.PAID_AMT
, 0)
, 0)) PAID_I
, SUM(NVL(DECODE(FMAST.FM_FC_METHD
, 'F'
, AWD.PAID_AMT
, 0)
, 0)) PAID_F
FROM IGF_AP_FA_BASE_REC FABASE
, IGF_AW_AWARD AWD
, IGF_AW_FUND_MAST FMAST
WHERE FABASE.BASE_ID = AWD.BASE_ID
AND AWD.FUND_ID = FMAST.FUND_ID GROUP BY FABASE.BASE_ID
, FABASE.COA_I
, FABASE.COA_F
, FABASE.EFC_I
, FABASE.EFC_F
Columns
Name |
BASE_ID |
IM_COA |
IM_EFC |
IM_PAID_AMT |
FM_COA |
FM_EFC |
FM_PAID_AMT |