VIEW: APPS.IGFFV_DL_ORIGINATION_CHANGES

Source

View Text - Preformatted

SELECT CHG.LOAN_NUMBER , CHG.CHG_CODE , CHG.NEW_VALUE , '_LA:CHG.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_CHG_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', CHG.DBTH_ID , CHG.CHG_NUM , CHG.CREATED_BY , CHG.CREATION_DATE , CHG.LAST_UPDATED_BY , CHG.LAST_UPDATE_DATE FROM IGF_SL_DL_CHG_SEND_ALL CHG, IGF_SL_DL_BATCH_ALL BATCH WHERE CHG.DBTH_ID = BATCH.DBTH_ID WITH READ ONLY

View Text - HTML Formatted

SELECT CHG.LOAN_NUMBER
, CHG.CHG_CODE
, CHG.NEW_VALUE
, '_LA:CHG.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_CHG_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'
, CHG.DBTH_ID
, CHG.CHG_NUM
, CHG.CREATED_BY
, CHG.CREATION_DATE
, CHG.LAST_UPDATED_BY
, CHG.LAST_UPDATE_DATE
FROM IGF_SL_DL_CHG_SEND_ALL CHG
, IGF_SL_DL_BATCH_ALL BATCH
WHERE CHG.DBTH_ID = BATCH.DBTH_ID WITH READ ONLY