Product: | IGF - Financial Aid |
---|---|
Description: | Base view for the entity that holds Direct Loan Origination Batch Responses |
Implementation/DBA Data: | APPS.IGFBV_DL_ORIG_BATCH_RESPONSES |
SELECT LORESP.ORIG_BATCH_ID
, LORESP.LOAN_NUMBER
, LORESP.ORIG_ACK_DATE
, '_LA:LORESP.ORIG_STATUS_FLAG:IGF_LOOKUPS_VIEW:IGF_SL_ORIG_STATUS_FLAG:MEANING'
, LORESP.ORIG_REJECT_REASONS
, '_LA:LORESP.PNOTE_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_PNOTE_STATUS:MEANING'
, LORESP.PNOTE_ID
, LORESP.PNOTE_ACCEPT_AMT
, LORESP.LOAN_AMOUNT_ACCEPTED
, '_LA:LORESP.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_RESP_STATUS:MEANING'
, LORESP.ELEC_MPN_IND
, LORESP.DBTH_ID
, LORESP.LOR_RESP_NUM
, LORESP.CREATED_BY
, LORESP.CREATION_DATE
, LORESP.LAST_UPDATED_BY
, LORESP.LAST_UPDATE_DATE
FROM IGF_SL_DL_LOR_RESP_ALL LORESP WITH READ ONLY