VIEW: APPS.IGFBV_DL_PNOTE_STATUS_HISTORY

Source

View Text - Preformatted

SELECT '_LA:HIST.PNOTE_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_STATUS:MEANING', HIST.PNOTE_STATUS_DATE , HIST.LOAN_ID , HIST.DLPNH_ID , HIST.CREATED_BY , HIST.CREATION_DATE , HIST.LAST_UPDATED_BY , HIST.LAST_UPDATE_DATE, LOR.P_PERSON_ID FROM IGF_SL_PNOTE_STAT_H HIST, IGF_SL_LOR_ALL LOR WHERE HIST.LOAN_ID = LOR.LOAN_ID WITH READ ONLY

View Text - HTML Formatted

SELECT '_LA:HIST.PNOTE_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_STATUS:MEANING'
, HIST.PNOTE_STATUS_DATE
, HIST.LOAN_ID
, HIST.DLPNH_ID
, HIST.CREATED_BY
, HIST.CREATION_DATE
, HIST.LAST_UPDATED_BY
, HIST.LAST_UPDATE_DATE
, LOR.P_PERSON_ID
FROM IGF_SL_PNOTE_STAT_H HIST
, IGF_SL_LOR_ALL LOR
WHERE HIST.LOAN_ID = LOR.LOAN_ID WITH READ ONLY