VIEW: APPS.IGFFV_DL_ORIG_BATCH_RESPONSES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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