View: IGF_AW_STUD_AWD_TOTAL_V

Product:	IGF - Financial Aid
Description:	This view sums up awards for a given student for all Award Years
Implementation/DBA Data:	APPS.IGF_AW_STUD_AWD_TOTAL_V

View Text

SELECT PE.PARTY_NUMBER PERSON_NUMBER
, SUM(NVL(AWD.OFFERED_AMT
, 0))
, SUM(NVL(AWD.ACCEPTED_AMT
, 0))
, SUM(NVL(AWD.PAID_AMT
, 0))
FROM IGF_AW_AWARD AWD
, IGF_AP_FA_BASE_REC FA
, HZ_PARTIES PE
WHERE AWD.AWARD_STATUS IN ('ACCEPTED'
, 'OFFERED'
, 'REVISED')
AND AWD.BASE_ID = FA.BASE_ID
AND FA.PERSON_ID = PE.PARTY_ID GROUP BY PE.PARTY_NUMBER

Columns