[Home] [Help]
View: IGF_AW_STUD_AWDS_V
Product: | IGF - Financial Aid |
Description: | Stores the Load Calendar wise Sum of Award Amount and Paid Amount for a Student |
Implementation/DBA Data: |
APPS.IGF_AW_STUD_AWDS_V
|
View Text
SELECT AWD.ROW_ID
, AWD.BASE_ID
, AWD.FUND_ID
, LOAD.ALTERNATE_CODE
, LOAD.START_DT
, LOAD.END_DT
, SUM(NVL(AWDISB.DISB_GROSS_AMT
, AWDISB.DISB_ACCEPTED_AMT))
, 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.ROW_ID
, AWD.BASE_ID
, AWD.FUND_ID
, LOAD.ALTERNATE_CODE
, LOAD.START_DT
, LOAD.END_DT
Columns
Name |
ROW_ID |
BASE_ID |
FUND_ID |
LD_ALTERNATE_CODE |
LD_START_DT |
LD_END_DT |
AWARDED_AMT |
PAID_AMT |