View: IGF_AW_AWDS_SUM_V

Product:	IGF - Financial Aid
Description:	Summarized awards based on Load Calendar
Implementation/DBA Data:	APPS.IGF_AW_AWDS_SUM_V

View Text

SELECT AWD.BASE_ID
, AWD.AWARD_ID
, AWD.FUND_ID
, AWDISB.LD_CAL_TYPE
, AWDISB.LD_SEQUENCE_NUMBER
, LOAD.ALTERNATE_CODE
, LOAD.START_DT
, LOAD.END_DT
, SUM(NVL(AWDISB.DISB_GROSS_AMT
, 0))
, SUM(NVL(AWDISB.DISB_ACCEPTED_AMT
, 0))
, SUM(NVL(AWDISB.DISB_PAID_AMT
, 0))
FROM IGF_AW_AWARD AWD
, IGF_AW_AWD_DISB AWDISB
, IGS_CA_INST LOAD
WHERE AWD.AWARD_ID = AWDISB.AWARD_ID
AND LOAD.CAL_TYPE = AWDISB.LD_CAL_TYPE
AND LOAD.SEQUENCE_NUMBER = AWDISB.LD_SEQUENCE_NUMBER GROUP BY AWD.BASE_ID
, AWD.AWARD_ID
, AWD.FUND_ID
, AWDISB.LD_CAL_TYPE
, AWDISB.LD_SEQUENCE_NUMBER
, LOAD.ALTERNATE_CODE
, LOAD.START_DT
, LOAD.END_DT

Columns