View: IGF_AW_YEAR_GRP_V

Product:	IGF - Financial Aid
Description:	Stores the Total Offered Amount,Accepted Amount and Paid Amount for a Student and for a Fund
Implementation/DBA Data:	APPS.IGF_AW_YEAR_GRP_V

View Text

SELECT AWD.BASE_ID
, FCAT.DESCRIPTION
, SUM(NVL(AWD.OFFERED_AMT
, 0))
, SUM(NVL(AWD.ACCEPTED_AMT
, 0))
, SUM(NVL(AWD.PAID_AMT
, 0))
FROM IGF_AW_AWARD_ALL AWD
, IGF_AW_FUND_MAST_ALL FMAST
, IGF_AW_FUND_CAT_ALL FCAT
WHERE AWD.FUND_ID = FMAST.FUND_ID
AND FMAST.FUND_CODE=FCAT.FUND_CODE
AND AWD.AWARD_STATUS IN ('OFFERED'
, 'ACCEPTED') GROUP BY AWD.BASE_ID
, FCAT.DESCRIPTION

Columns