[Home] [Help]
View: IGF_AW_FUND_DET_GRP_V
Product: | IGF - Financial Aid |
Description: | Stores the Fund Code wise Total Offered Amount ,Accepted Amount and Paid Amount for a student |
Implementation/DBA Data: |
APPS.IGF_AW_FUND_DET_GRP_V
|
View Text
SELECT FA.CI_CAL_TYPE
, FA.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, FM.FUND_CODE
, SUM(NVL(AWD.OFFERED_AMT
, 0))
, SUM(NVL(AWD.ACCEPTED_AMT
, 0))
, SUM(NVL(AWD.PAID_AMT
, 0))
, FA.PERSON_NUMBER
FROM IGF_AW_AWARD_V AWD
, IGF_AW_FUND_MAST FM
, IGF_AP_FA_CON_V FA
, IGS_CA_INST CI
WHERE AWD.FUND_ID = FM.FUND_ID
AND CI.CAL_TYPE = FA.CI_CAL_TYPE
AND AWD.AWARD_STATUS IN ('OFFERED'
, 'ACCEPTED')
AND CI.SEQUENCE_NUMBER=FA.CI_SEQUENCE_NUMBER
AND AWD.BASE_ID=FA.BASE_ID GROUP BY FA.CI_CAL_TYPE
, FA.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, FM.FUND_CODE
, FA.PERSON_NUMBER
Columns
Name |
CI_CAL_TYPE |
CI_SEQUENCE_NUMBER |
CI_ALTERNATE_CODE |
CI_START_DT |
CI_END_DT |
FUND_CODE |
OFFRD_AMT |
ACCPT_AMT |
PAID_AMT |
PERSON_NUMBER |