[Home] [Help]
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
Name |
AWARD_ID |
FUND_ID |
OFFERED_AMT |
ACCEPTED_AMT |
PAID_AMT |
AWARD_STATUS |
LD_CAL_TYPE |
LD_SEQUENCE_NUMBER |
AWARD_PRD_CD |
CI_CAL_TYPE |
CI_SEQUENCE_NUMBER |
AWARD_PRD_DESC |
BASE_ID |