VIEW: APPS.IGF_AW_NEED_ANLY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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