VIEW: APPS.IGFBV_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', AWD.RVSN_ID, AWD.AWARD_NUMBER_TXT, 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', AWD.FUND_ID, AWD.BASE_ID, AWD.CREATED_BY, AWD.CREATION_DATE, AWD.LAST_UPDATED_BY, AWD.LAST_UPDATE_DATE, FABASE.PERSON_ID FROM IGF_AW_AWARD_ALL AWD, IGF_AP_FA_BASE_REC_ALL FABASE WHERE AWD.BASE_ID = FABASE.BASE_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'
, AWD.RVSN_ID
, AWD.AWARD_NUMBER_TXT
, 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'
, AWD.FUND_ID
, AWD.BASE_ID
, AWD.CREATED_BY
, AWD.CREATION_DATE
, AWD.LAST_UPDATED_BY
, AWD.LAST_UPDATE_DATE
, FABASE.PERSON_ID
FROM IGF_AW_AWARD_ALL AWD
, IGF_AP_FA_BASE_REC_ALL FABASE
WHERE AWD.BASE_ID = FABASE.BASE_ID WITH READ ONLY