View: IGF_AW_NEED_ANLY_V

Product:	IGF - Financial Aid
Description:
Implementation/DBA Data:	APPS.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