Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds Direct Loan Origination Batch Responses |
Implementation/DBA Data: | APPS.IGFFV_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
, BATCH.BATCH_ID
, BATCH.BTH_CREATION_DATE
, '_LA:BATCH.BATCH_REJ_CODE:IGF_LOOKUPS_VIEW:IGF_SL_DL_BATCH_REJ:MEANING'
, BATCH.BATCH_TYPE
, BATCH.SEND_RESP
, '_LA:BATCH.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_BATCH_STATUS:MEANING'
, 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
, IGF_SL_DL_BATCH_ALL BATCH
WHERE LORESP.DBTH_ID = BATCH.DBTH_ID WITH READ ONLY