Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Shows the mappings between the UCAS decision ,reply codes and oss offer response status codes along with the descriptions |
Implementation/DBA Data: | Not implemented in this database |
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