Product: | IGF - Financial Aid |
---|---|
Description: | Base view for the entity that holds Financial Aid Direct Loan Origination Change Batch Responses |
Implementation/DBA Data: | APPS.IGFBV_DL_ORI_CHG_BAT_RESPONSES |
SELECT CHGRESP.LOAN_NUMBER
, CHGRESP.CHG_CODE
, '_LA:CHGRESP.REJECT_CODE:IGF_LOOKUPS_VIEW:IGF_SL_DL_CHG_REJ_CODES:MEANING'
, CHGRESP.NEW_VALUE
, '_LA:CHGRESP.LOAN_IDENT_ERR_CODE:IGF_LOOKUPS_VIEW:IGF_SL_DL_CHG_REJ_CODES:MEANING'
, '_LA:CHGRESP.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_RESP_STATUS:MEANING'
, CHGRESP.BATCH_ID
, CHGRESP.DBTH_ID
, CHGRESP.RESP_NUM
, CHGRESP.CREATED_BY
, CHGRESP.CREATION_DATE
, CHGRESP.LAST_UPDATED_BY
, CHGRESP.LAST_UPDATE_DATE
FROM IGF_SL_DL_CHG_RESP_ALL CHGRESP WITH READ ONLY