VIEW: APPS.IGFFV_DL_ORI_CHG_BAT_RESPONSES

Source

View Text - Preformatted

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', 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', 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, IGF_SL_DL_BATCH_ALL BATCH WHERE CHGRESP.DBTH_ID = BATCH.DBTH_ID WITH READ ONLY

View Text - HTML Formatted

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'
, 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'
, 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
, IGF_SL_DL_BATCH_ALL BATCH
WHERE CHGRESP.DBTH_ID = BATCH.DBTH_ID WITH READ ONLY