VIEW: APPS.IGS_UC_MAP_OFF_RESP_V

Source

View Text - Preformatted

SELECT mor.rowid ROW_ID, mor.System_code System_code, mor.Decision_code Decision_code, Lk1.meaning Decision_Desc, mor.reply_code reply_code, Lk2.meaning reply_desc , mor.Adm_offer_resp_status Adm_offer_resp_status, ofr.description Adm_offer_resp_status_desc, mor.Closed_ind Closed_ind, mor.CREATED_BY , mor.CREATION_DATE , mor.LAST_UPDATED_BY , mor.LAST_UPDATE_DATE, mor.LAST_UPDATE_LOGIN FROM IGS_UC_MAP_OFF_RESP mor , IGS_LOOKUP_VALUES lk1 , IGS_LOOKUP_VALUES lk2 , IGS_AD_OFR_RESP_STAT ofr WHERE lk1.lookup_type = 'IGS_UC_APP_DECISION' AND lk1.lookup_code= mor.decision_code AND Lk2.lookup_type = 'IGS_UC_APP_REPLY' AND lk2.lookup_code = mor.reply_code AND ofr.adm_offer_resp_status = mor.Adm_offer_resp_status

View Text - HTML Formatted

SELECT MOR.ROWID ROW_ID
, MOR.SYSTEM_CODE SYSTEM_CODE
, MOR.DECISION_CODE DECISION_CODE
, LK1.MEANING DECISION_DESC
, MOR.REPLY_CODE REPLY_CODE
, LK2.MEANING REPLY_DESC
, MOR.ADM_OFFER_RESP_STATUS ADM_OFFER_RESP_STATUS
, OFR.DESCRIPTION ADM_OFFER_RESP_STATUS_DESC
, MOR.CLOSED_IND CLOSED_IND
, MOR.CREATED_BY
, MOR.CREATION_DATE
, MOR.LAST_UPDATED_BY
, MOR.LAST_UPDATE_DATE
, MOR.LAST_UPDATE_LOGIN
FROM IGS_UC_MAP_OFF_RESP MOR
, IGS_LOOKUP_VALUES LK1
, IGS_LOOKUP_VALUES LK2
, IGS_AD_OFR_RESP_STAT OFR
WHERE LK1.LOOKUP_TYPE = 'IGS_UC_APP_DECISION'
AND LK1.LOOKUP_CODE= MOR.DECISION_CODE
AND LK2.LOOKUP_TYPE = 'IGS_UC_APP_REPLY'
AND LK2.LOOKUP_CODE = MOR.REPLY_CODE
AND OFR.ADM_OFFER_RESP_STATUS = MOR.ADM_OFFER_RESP_STATUS