VIEW: APPS.IGFFV_DL_ORIG_CREDIT_RESPONSES

Source

View Text - Preformatted

SELECT DLLORCRR.LOAN_NUMBER , '_LA:DLLORCRR.CREDIT_OVERRIDE:IGF_LOOKUPS_VIEW:IGF_SL_CREDIT_OVERRIDE:MEANING', DLLORCRR.CREDIT_DECISION_DATE , '_LA:DLLORCRR.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_RESP_STATUS:MEANING', DLLORCRR.ENDORSER_AMOUNT , '_LA:DLLORCRR.MPN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_STATUS:MEANING', DLLORCRR.MPN_ID , '_LA:DLLORCRR.MPN_TYPE:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_TYPE:MEANING', DLLORCRR.MPN_INDICATOR , 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', DLLORCRR.DBTH_ID , DLLORCRR.LOR_RESP_NUM , DLLORCRR.CREATED_BY , DLLORCRR.CREATION_DATE , DLLORCRR.LAST_UPDATED_BY , DLLORCRR.LAST_UPDATE_DATE FROM IGF_SL_DL_LOR_CRRESP_ALL DLLORCRR, IGF_SL_DL_BATCH_ALL BATCH WHERE DLLORCRR.DBTH_ID = BATCH.DBTH_ID WITH READ ONLY

View Text - HTML Formatted

SELECT DLLORCRR.LOAN_NUMBER
, '_LA:DLLORCRR.CREDIT_OVERRIDE:IGF_LOOKUPS_VIEW:IGF_SL_CREDIT_OVERRIDE:MEANING'
, DLLORCRR.CREDIT_DECISION_DATE
, '_LA:DLLORCRR.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_RESP_STATUS:MEANING'
, DLLORCRR.ENDORSER_AMOUNT
, '_LA:DLLORCRR.MPN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_STATUS:MEANING'
, DLLORCRR.MPN_ID
, '_LA:DLLORCRR.MPN_TYPE:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_TYPE:MEANING'
, DLLORCRR.MPN_INDICATOR
, 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'
, DLLORCRR.DBTH_ID
, DLLORCRR.LOR_RESP_NUM
, DLLORCRR.CREATED_BY
, DLLORCRR.CREATION_DATE
, DLLORCRR.LAST_UPDATED_BY
, DLLORCRR.LAST_UPDATE_DATE
FROM IGF_SL_DL_LOR_CRRESP_ALL DLLORCRR
, IGF_SL_DL_BATCH_ALL BATCH
WHERE DLLORCRR.DBTH_ID = BATCH.DBTH_ID WITH READ ONLY