Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds the information about the Awards given to students |
Implementation/DBA Data: | APPS.IGFFV_STUDENT_AWARDS |
SELECT AWD.AWARD_ID
, AWD.OFFERED_AMT
, AWD.ACCEPTED_AMT
, AWD.PAID_AMT
, AWD.PACKAGING_TYPE
, '_LA:AWD.MANUAL_UPDATE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, AWD.AWARD_DATE
, '_LA:AWD.AWARD_STATUS:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING'
, AWD.ALT_PELL_SCHEDULE
, '_LA:AWD.LEGACY_RECORD_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, PE.PARTY_NUMBER
, PE.PARTY_NAME
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, RVSN.DESCP
, AWD.RVSN_ID
, AWD.AWARD_NUMBER_TXT
, ADPLANS. AWD_DIST_PLAN_CD
, ADPLANS. AWD_DIST_PLAN_CD_DESC
, ADPLANS. DIST_PLAN_METHOD_CODE
, AWD.BATCH_ID
, '_DF:IGF:IGF_AW_AWARD_ALL_FLEX:AWD'
, '_LA:AWD.PUBLISH_IN_SS_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, ADPLANS.ADPLANS_ID
, AWD.FUND_ID
, AWD.BASE_ID
, AWD.CREATED_BY
, AWD.CREATION_DATE
, AWD.LAST_UPDATED_BY
, AWD.LAST_UPDATE_DATE
, FACON.PERSON_ID
FROM IGF_AW_AWARD_ALL AWD
, IGF_AW_FUND_MAST_ALL FMAST
, IGS_CA_INST_ALL CI
, IGF_AP_FA_BASE_REC_ALL FACON
, HZ_PARTIES PE
, IGF_AW_AWD_RVSN_RSN_ALL RVSN
, IGF_AW_AWD_DIST_PLANS ADPLANS
WHERE AWD.FUND_ID = FMAST.FUND_ID
AND FMAST.CI_CAL_TYPE = CI.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND AWD.BASE_ID = FACON.BASE_ID AND PE.PARTY_ID =FACON.PERSON_ID
AND AWD.RVSN_ID = RVSN.RVSN_ID (+) AND AWD.ADPLANS_ID = ADPLANS.ADPLANS_ID (+) WITH READ ONLY