Results for “igs_uc_app_decision”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_UC_MAP_OFF_RESP_V is a reporting view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases within the Oracle Student System / IGS (Student Systems) product family. Its name, "MAP_OFF_RESP," indicates that it maps offer responses — the decisions and replies associated with admission offers — to administrative offer response statuses. The view is owned by the APPS schema and is designed to present decoded, human-readable values in place of raw lookup codes, making it directly suitable for reporting, concurrent programs, and integration extracts.

The view resolves three lookup relationships simultaneously: the decision code, the reply code, and the administrative offer response status. The user query string "reply_desc" corresponds to one of the columns this view exposes, which is generated by joining the reply code to the IGS_LOOKUP_VALUES table to obtain its meaning. This makes the view particularly useful when a developer or analyst needs to display admission offer responses with descriptive text rather than internal codes.

Underlying Base Objects

The documentation does not list separate base objects, but the view text itself defines the objects it is built over. The view is defined on a single driving table plus three reference sources:

• IGS_UC_MAP_OFF_RESP — the driving mapping table (aliased MOR), which stores system code, decision code, reply code, administrative offer response status, and closed indicator.
• IGS_LOOKUP_VALUES (LK1) — joined on lookup_type = 'IGS_UC_APP_DECISION' and lookup_code = MOR.decision_code to supply the decision description.
• IGS_LOOKUP_VALUES (LK2) — joined on lookup_type = 'IGS_UC_APP_REPLY' and lookup_code = MOR.reply_code to supply the reply description (the "reply_desc" column referenced in the search).
• IGS_AD_OFR_RESP_STAT (OFR) — joined on adm_offer_resp_status = MOR.Adm_offer_resp_status to supply the administrative offer response status description.

Because IGS_LOOKUP_VALUES is referenced twice under different aliases and lookup types, developers should be aware that the view inherently assumes valid, existing lookup values for both the decision and reply codes; unmatched codes are excluded by the inner joins.

Key Columns

• ROW_ID — the ROWID of the underlying mapping row, useful for identifying individual records.
• SYSTEM_CODE — the source system code associated with the mapping.
• DECISION_CODE / DECISION_DESC — the raw decision code and its decoded meaning from the IGS_UC_APP_DECISION lookup.
• REPLY_CODE / REPLY_DESC — the raw reply code and its decoded meaning from the IGS_UC_APP_REPLY lookup.
• ADM_OFFER_RESP_STATUS / ADM_OFFER_RESP_STATUS_DESC — the administrative offer response status code and its description.
• CLOSED_IND — flag indicating whether the mapping record is closed.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical scenarios include displaying admission offer responses in inquiry forms or reports, validating mappings between decision/reply codes and administrative statuses, and driving integration extracts that require descriptive values.

To retrieve records filtered on reply description:

SELECT decision_code, decision_desc,
       reply_code, reply_desc,
       adm_offer_resp_status, adm_offer_resp_status_desc,
       closed_ind
FROM   apps.igs_uc_map_off_resp_v
WHERE  reply_desc = :p_reply_desc;

To list all active mappings with their descriptive statuses:

SELECT system_code,
       decision_desc,
       reply_desc,
       adm_offer_resp_status_desc
FROM   apps.igs_uc_map_off_resp_v
WHERE  closed_ind = 'N'
ORDER  BY system_code, decision_desc, reply_desc;

Because the view is built entirely from joins, it is read-only and should be queried rather than updated directly; updates must target the underlying IGS_UC_MAP_OFF_RESP table.