VIEW: APPS.IGFBV_FFELP_REJECTS

Source

View Text - Preformatted

SELECT EDTR.LOAN_NUMBER , '_LA:EDTR.ORIG_CHG_CODE:IGF_LOOKUPS_VIEW:IGF_SL_EDIT_ORIG_CHG_CODE:MEANING', '_LA:EDTR.SL_ERROR_CODE:IGF_LOOKUPS_VIEW:IGF_SL_ERR_CODES:MEANING', '_LA:EDTR.FIELD_NAME:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_FIELDS:MEANING', EDTR.FIELD_VALUE , AWARDS.ACCEPTED_AMT, 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, LOANS.LOAN_ID , FABASE.BASE_ID, FABASE.PERSON_ID, EDTR.EDTR_ID , EDTR.CREATED_BY , EDTR.CREATION_DATE , EDTR.LAST_UPDATED_BY , EDTR.LAST_UPDATE_DATE FROM IGF_SL_EDIT_REPORT_ALL EDTR, IGF_SL_LOANS_ALL LOANS, IGF_AW_AWARD_ALL AWARDS, IGF_AW_FUND_MAST_ALL FMAST, IGF_AW_FUND_CAT_ALL FCAT, IGF_AP_FA_BASE_REC_ALL FABASE WHERE EDTR.LOAN_NUMBER = LOANS.LOAN_NUMBER AND LOANS.AWARD_ID = AWARDS.AWARD_ID AND AWARDS.BASE_ID = FABASE.BASE_ID AND AWARDS.FUND_ID = FMAST.FUND_ID AND FMAST.FUND_CODE = FCAT.FUND_CODE AND FCAT.FED_FUND_CODE IN ('ALT','FLP','FLS','FLU') AND EDTR.SL_ERROR_TYPE = 'IGF_SL_ERR_CODES' UNION ALL SELECT EDTR.LOAN_NUMBER , '_LA:EDTR.ORIG_CHG_CODE:IGF_LOOKUPS_VIEW:IGF_SL_EDIT_ORIG_CHG_CODE:MEANING', '_LA:EDTR.SL_ERROR_CODE:IGF_LOOKUPS_VIEW:IGF_SL_CL_ERROR:MEANING', '_LA:EDTR.FIELD_NAME:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_FIELDS:MEANING', EDTR.FIELD_VALUE , AWARDS.ACCEPTED_AMT, 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, LOANS.LOAN_ID , FABASE.BASE_ID, FABASE.PERSON_ID, EDTR.EDTR_ID , EDTR.CREATED_BY , EDTR.CREATION_DATE , EDTR.LAST_UPDATED_BY , EDTR.LAST_UPDATE_DATE FROM IGF_SL_EDIT_REPORT_ALL EDTR, IGF_SL_LOANS_ALL LOANS, IGF_AW_AWARD_ALL AWARDS, IGF_AW_FUND_MAST_ALL FMAST, IGF_AW_FUND_CAT_ALL FCAT, IGF_AP_FA_BASE_REC_ALL FABASE WHERE EDTR.LOAN_NUMBER = LOANS.LOAN_NUMBER AND LOANS.AWARD_ID = AWARDS.AWARD_ID AND AWARDS.BASE_ID = FABASE.BASE_ID AND AWARDS.FUND_ID = FMAST.FUND_ID AND FMAST.FUND_CODE = FCAT.FUND_CODE AND FCAT.FED_FUND_CODE IN ('ALT','FLP','FLS','FLU') AND EDTR.SL_ERROR_TYPE = 'IGF_SL_CL_ERROR' WITH READ ONLY

View Text - HTML Formatted

SELECT EDTR.LOAN_NUMBER
, '_LA:EDTR.ORIG_CHG_CODE:IGF_LOOKUPS_VIEW:IGF_SL_EDIT_ORIG_CHG_CODE:MEANING'
, '_LA:EDTR.SL_ERROR_CODE:IGF_LOOKUPS_VIEW:IGF_SL_ERR_CODES:MEANING'
, '_LA:EDTR.FIELD_NAME:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_FIELDS:MEANING'
, EDTR.FIELD_VALUE
, AWARDS.ACCEPTED_AMT
, 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
, LOANS.LOAN_ID
, FABASE.BASE_ID
, FABASE.PERSON_ID
, EDTR.EDTR_ID
, EDTR.CREATED_BY
, EDTR.CREATION_DATE
, EDTR.LAST_UPDATED_BY
, EDTR.LAST_UPDATE_DATE
FROM IGF_SL_EDIT_REPORT_ALL EDTR
, IGF_SL_LOANS_ALL LOANS
, IGF_AW_AWARD_ALL AWARDS
, IGF_AW_FUND_MAST_ALL FMAST
, IGF_AW_FUND_CAT_ALL FCAT
, IGF_AP_FA_BASE_REC_ALL FABASE
WHERE EDTR.LOAN_NUMBER = LOANS.LOAN_NUMBER
AND LOANS.AWARD_ID = AWARDS.AWARD_ID
AND AWARDS.BASE_ID = FABASE.BASE_ID
AND AWARDS.FUND_ID = FMAST.FUND_ID
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND FCAT.FED_FUND_CODE IN ('ALT'
, 'FLP'
, 'FLS'
, 'FLU')
AND EDTR.SL_ERROR_TYPE = 'IGF_SL_ERR_CODES' UNION ALL SELECT EDTR.LOAN_NUMBER
, '_LA:EDTR.ORIG_CHG_CODE:IGF_LOOKUPS_VIEW:IGF_SL_EDIT_ORIG_CHG_CODE:MEANING'
, '_LA:EDTR.SL_ERROR_CODE:IGF_LOOKUPS_VIEW:IGF_SL_CL_ERROR:MEANING'
, '_LA:EDTR.FIELD_NAME:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_FIELDS:MEANING'
, EDTR.FIELD_VALUE
, AWARDS.ACCEPTED_AMT
, 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
, LOANS.LOAN_ID
, FABASE.BASE_ID
, FABASE.PERSON_ID
, EDTR.EDTR_ID
, EDTR.CREATED_BY
, EDTR.CREATION_DATE
, EDTR.LAST_UPDATED_BY
, EDTR.LAST_UPDATE_DATE
FROM IGF_SL_EDIT_REPORT_ALL EDTR
, IGF_SL_LOANS_ALL LOANS
, IGF_AW_AWARD_ALL AWARDS
, IGF_AW_FUND_MAST_ALL FMAST
, IGF_AW_FUND_CAT_ALL FCAT
, IGF_AP_FA_BASE_REC_ALL FABASE
WHERE EDTR.LOAN_NUMBER = LOANS.LOAN_NUMBER
AND LOANS.AWARD_ID = AWARDS.AWARD_ID
AND AWARDS.BASE_ID = FABASE.BASE_ID
AND AWARDS.FUND_ID = FMAST.FUND_ID
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND FCAT.FED_FUND_CODE IN ('ALT'
, 'FLP'
, 'FLS'
, 'FLU')
AND EDTR.SL_ERROR_TYPE = 'IGF_SL_CL_ERROR' WITH READ ONLY