VIEW: APPS.IGF_SL_REJ_EDIT_V

Source

View Text - Preformatted

SELECT FP.SYS_AWD_YEAR, FP.EDIT_CODE, FP.EDIT_CODE_TYPE, FP.EDIT_MESSAGE_TXT, FP.EDIT_CONDITION_TXT, FP.EDIT_FIX_TXT, ED.EDIT_ID, ED.EDIT_REC_ID, ED.LEVEL_CODE, ED.RESP_ERR_FIELD, ED.RESP_ERR_VALUE, ED.REPORTED_VALUE, ED.CREATED_BY, ED.CREATION_DATE, ED.LAST_UPDATED_BY, ED.LAST_UPDATE_DATE, ED.LAST_UPDATE_LOGIN, ED.PROGRAM_APPLICATION_ID, ED.PROGRAM_ID, ED.PROGRAM_UPDATE_DATE, ED.REQUEST_ID FROM IGF_SL_ED_PRC_RSLTS ED, IGF_SL_FP_EDITS FP WHERE ED.RESP_ERR_CODE = FP.EDIT_CODE

View Text - HTML Formatted

SELECT FP.SYS_AWD_YEAR
, FP.EDIT_CODE
, FP.EDIT_CODE_TYPE
, FP.EDIT_MESSAGE_TXT
, FP.EDIT_CONDITION_TXT
, FP.EDIT_FIX_TXT
, ED.EDIT_ID
, ED.EDIT_REC_ID
, ED.LEVEL_CODE
, ED.RESP_ERR_FIELD
, ED.RESP_ERR_VALUE
, ED.REPORTED_VALUE
, ED.CREATED_BY
, ED.CREATION_DATE
, ED.LAST_UPDATED_BY
, ED.LAST_UPDATE_DATE
, ED.LAST_UPDATE_LOGIN
, ED.PROGRAM_APPLICATION_ID
, ED.PROGRAM_ID
, ED.PROGRAM_UPDATE_DATE
, ED.REQUEST_ID
FROM IGF_SL_ED_PRC_RSLTS ED
, IGF_SL_FP_EDITS FP
WHERE ED.RESP_ERR_CODE = FP.EDIT_CODE