VIEW: APPS.IGFFV_STUDENT_AWARDS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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