View: IGF_AW_CORRESP_LD_V

Product:	IGF - Financial Aid
Description:
Implementation/DBA Data:	APPS.IGF_AW_CORRESP_LD_V

View Text

SELECT AWD.BASE_ID
, FMAST.DESCRIPTION FUND
, FMAST.FUND_CODE
, AWD.FUND_ID
, ADISB.LD_CAL_TYPE
, ADISB.LD_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE TERM
, SUM(NVL(ADISB.DISB_GROSS_AMT
, 0)) TOT_AWARD
, SUM(NVL(ADISB.DISB_PAID_AMT
, 0)) TOT_PAID
FROM IGF_AW_AWD_DISB_ALL ADISB
, IGS_CA_INST CI
, IGF_AW_AWARD AWD
, IGF_AW_FUND_MAST FMAST
WHERE AWD.AWARD_ID = ADISB.AWARD_ID
AND AWD.FUND_ID = FMAST.FUND_ID
AND ADISB.LD_CAL_TYPE =CI.CAL_TYPE
AND ADISB.LD_SEQUENCE_NUMBER=CI.SEQUENCE_NUMBER GROUP BY AWD.BASE_ID
, ADISB.AWARD_ID
, AWD.FUND_ID
, FMAST.DESCRIPTION
, FMAST.FUND_CODE
, ADISB.LD_CAL_TYPE
, ADISB.LD_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE

Columns