VIEW: APPS.IGFFV_DL_PROM_NOTE_RESPONSES

Source

View Text - Preformatted

SELECT PDETRESP.DISB_GROSS_AMT , PNOTERESP.PNOTE_ACK_DATE , PNOTERESP.PNOTE_BATCH_ID , PNOTERESP.LOAN_NUMBER , '_LA:PNOTERESP.PNOTE_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_PNOTE_STATUS:MEANING', '_LA:PNOTERESP.PNOTE_REJ_CODES:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_REJ_CODES:MEANING', PNOTERESP.MPN_IND , PNOTERESP.PNOTE_ACCEPT_AMT , '_LA:PNOTERESP.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_RESP_STATUS:MEANING', PNOTERESP.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', BATCH.DBTH_ID , PDETRESP.DLPDR_ID , PDETRESP.DLPNR_ID , PDETRESP.CREATED_BY , PDETRESP.CREATION_DATE , PDETRESP.LAST_UPDATED_BY , PDETRESP.LAST_UPDATE_DATE FROM IGF_SL_DL_PDET_RESP PDETRESP, IGF_SL_DL_PNOTE_RESP_ALL PNOTERESP, IGF_SL_DL_BATCH_ALL BATCH WHERE PDETRESP.DLPNR_ID = PNOTERESP.DLPNR_ID AND PNOTERESP.DBTH_ID = BATCH.DBTH_ID WITH READ ONLY

View Text - HTML Formatted

SELECT PDETRESP.DISB_GROSS_AMT
, PNOTERESP.PNOTE_ACK_DATE
, PNOTERESP.PNOTE_BATCH_ID
, PNOTERESP.LOAN_NUMBER
, '_LA:PNOTERESP.PNOTE_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_PNOTE_STATUS:MEANING'
, '_LA:PNOTERESP.PNOTE_REJ_CODES:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_REJ_CODES:MEANING'
, PNOTERESP.MPN_IND
, PNOTERESP.PNOTE_ACCEPT_AMT
, '_LA:PNOTERESP.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_RESP_STATUS:MEANING'
, PNOTERESP.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'
, BATCH.DBTH_ID
, PDETRESP.DLPDR_ID
, PDETRESP.DLPNR_ID
, PDETRESP.CREATED_BY
, PDETRESP.CREATION_DATE
, PDETRESP.LAST_UPDATED_BY
, PDETRESP.LAST_UPDATE_DATE
FROM IGF_SL_DL_PDET_RESP PDETRESP
, IGF_SL_DL_PNOTE_RESP_ALL PNOTERESP
, IGF_SL_DL_BATCH_ALL BATCH
WHERE PDETRESP.DLPNR_ID = PNOTERESP.DLPNR_ID
AND PNOTERESP.DBTH_ID = BATCH.DBTH_ID WITH READ ONLY