VIEW: APPS.IGFBV_PERKINS_LOANS

Source

View Text - Preformatted

SELECT LOANS.LOAN_NUMBER, LOANS.LOAN_PER_BEGIN_DATE, LOANS.LOAN_PER_END_DATE, '_LA:LOANS.LOAN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_STATUS:MEANING', LOANS.LOAN_STATUS_DATE, LOANS.ACTIVE, LOANS.ACTIVE_DATE, FABASE.CI_CAL_TYPE, FABASE.CI_SEQUENCE_NUMBER, AWD.ACCEPTED_AMT, FABASE.BASE_ID, FABASE.PERSON_ID, LOANS.LOAN_ID, LOANS.CREATED_BY, LOANS.CREATION_DATE, LOANS.LAST_UPDATED_BY, LOANS.LAST_UPDATE_DATE FROM IGF_SL_LOANS_ALL LOANS, IGF_AP_FA_BASE_REC_ALL FABASE, IGF_AW_AWARD_ALL AWD, IGF_AW_FUND_MAST_ALL FMAST, IGF_AW_FUND_CAT_ALL FCAT WHERE AWD.AWARD_ID = LOANS.AWARD_ID AND FABASE.BASE_ID = AWD.BASE_ID AND FMAST.FUND_ID = AWD.FUND_ID AND FCAT.FUND_CODE = FMAST.FUND_CODE AND FCAT.FED_FUND_CODE = 'PRK' WITH READ ONLY

View Text - HTML Formatted

SELECT LOANS.LOAN_NUMBER
, LOANS.LOAN_PER_BEGIN_DATE
, LOANS.LOAN_PER_END_DATE
, '_LA:LOANS.LOAN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_STATUS:MEANING'
, LOANS.LOAN_STATUS_DATE
, LOANS.ACTIVE
, LOANS.ACTIVE_DATE
, FABASE.CI_CAL_TYPE
, FABASE.CI_SEQUENCE_NUMBER
, AWD.ACCEPTED_AMT
, FABASE.BASE_ID
, FABASE.PERSON_ID
, LOANS.LOAN_ID
, LOANS.CREATED_BY
, LOANS.CREATION_DATE
, LOANS.LAST_UPDATED_BY
, LOANS.LAST_UPDATE_DATE
FROM IGF_SL_LOANS_ALL LOANS
, IGF_AP_FA_BASE_REC_ALL FABASE
, IGF_AW_AWARD_ALL AWD
, IGF_AW_FUND_MAST_ALL FMAST
, IGF_AW_FUND_CAT_ALL FCAT
WHERE AWD.AWARD_ID = LOANS.AWARD_ID
AND FABASE.BASE_ID = AWD.BASE_ID
AND FMAST.FUND_ID = AWD.FUND_ID
AND FCAT.FUND_CODE = FMAST.FUND_CODE
AND FCAT.FED_FUND_CODE = 'PRK' WITH READ ONLY