[Home] [Help]
View: IGF_AW_ADISB_COA_MATCH_V
Product: | IGF - Financial Aid |
Description: | Retrieves the awards that a student has to the extent of his common Cost of Attendance terms. |
Implementation/DBA Data: |
APPS.IGF_AW_ADISB_COA_MATCH_V
|
View Text
SELECT AWD.BASE_ID
, AWD.FUND_ID
, DISB.AWARD_ID
, DISB.DISB_NUM
, DISB.LD_CAL_TYPE
, DISB.LD_SEQUENCE_NUMBER
, DISB.DISB_GROSS_AMT
, DISB.DISB_NET_AMT
, DISB.DISB_DATE
, DISB.TRANS_TYPE
FROM IGF_AW_AWARD_ALL AWD
, IGF_AW_AWD_DISB_ALL DISB
, IGF_AW_COA_ITM_TERMS COA
WHERE AWD.AWARD_ID = DISB.AWARD_ID
AND AWD.AWARD_STATUS IN ('OFFERED'
, 'ACCEPTED')
AND AWD.BASE_ID = COA.BASE_ID
AND DISB.LD_CAL_TYPE = COA.LD_CAL_TYPE
AND DISB.LD_SEQUENCE_NUMBER = COA.LD_SEQUENCE_NUMBER
Columns
Name |
BASE_ID |
FUND_ID |
AWARD_ID |
DISB_NUM |
LD_CAL_TYPE |
LD_SEQUENCE_NUMBER |
DISB_GROSS_AMT |
DISB_NET_AMT |
DISB_DATE |
TRANS_TYPE |