View: IGF_AW_SS_DISB_V

Product:	IGF - Financial Aid
Description:	Holds Disbursement details of Awards that are published to Student Self-Service
Implementation/DBA Data:	APPS.IGF_AW_SS_DISB_V

View Text

SELECT DISB.AWARD_ID
, AWD.FUND_ID
, SUM (DISB.DISB_GROSS_AMT) OFFERED_AMT
, SUM (DISB.DISB_ACCEPTED_AMT) ACCEPTED_AMT
, SUM (DISB.DISB_PAID_AMT) PAID_AMT
, AWD.AWARD_STATUS
, DISB.LD_CAL_TYPE
, DISB.LD_SEQUENCE_NUMBER
, APRD.AWARD_PRD_CD
, APRD.CI_CAL_TYPE
, APRD.CI_SEQUENCE_NUMBER
, APRD.AWARD_PRD_DESC
, FA.BASE_ID
FROM IGF_AW_AWARD_ALL AWD
, IGF_AW_AWD_DISB_ALL DISB
, IGF_AW_AWARD_PRD APRD
, IGF_AP_FA_BASE_REC_ALL FA
WHERE AWD.AWARD_ID = DISB.AWARD_ID
AND FA.BASE_ID = AWD.BASE_ID
AND FA.CI_CAL_TYPE = APRD.CI_CAL_TYPE
AND FA.CI_SEQUENCE_NUMBER = APRD.CI_SEQUENCE_NUMBER
AND NVL (AWD.PUBLISH_IN_SS_FLAG
, 'N') = 'Y'
AND NOT EXISTS ( SELECT LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
FROM IGF_AW_AWD_DISB_ALL DISB1 WHERE DISB1.AWARD_ID = AWD.AWARD_ID MINUS SELECT LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
FROM IGF_AW_AWD_PRD_TERM APT WHERE APRD.CI_CAL_TYPE = APT.CI_CAL_TYPE
AND APRD.CI_SEQUENCE_NUMBER = APT.CI_SEQUENCE_NUMBER
AND APRD.AWARD_PRD_CD = APT.AWARD_PRD_CD) GROUP BY DISB.AWARD_ID
, AWD.FUND_ID
, DISB.LD_CAL_TYPE
, DISB.LD_SEQUENCE_NUMBER
, AWD.AWARD_STATUS
, APRD.AWARD_PRD_CD
, APRD.CI_CAL_TYPE
, APRD.CI_SEQUENCE_NUMBER
, APRD.AWARD_PRD_DESC
, FA.BASE_ID ORDER BY DISB.AWARD_ID
, APRD.AWARD_PRD_CD

Columns