Results for “marvin_code”

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

Overview

IGSFV_UC_OFFER_CONDITIONS is an APPS-schema view in the Oracle E-Business Suite IGS (Student System) product. It is classified in ETRM as a "Full View" for Offer Conditions within the generic condition library. In the Oracle EBS architecture, "Full View" (FV) objects are the reporting-facing counterparts to underlying "Full" (F) base tables and Business (B) views. They are conventionally created as read-only projections, and the IGSFV_UC_OFFER_CONDITIONS definition confirms this pattern by terminating in WITH READ ONLY. The view exposes the complete set of offer condition attributes — including descriptive text, status, decision, and audit columns — so that reporting, integration, and downstream student-system processes can consume offer-condition data without touching the base table directly. Its status is documented as VALID, indicating the view compiles cleanly in the 12.1.1 and 12.2.2 environments.

Underlying Base Objects

The view is defined over a single base object, IGS_UC_OFFER_CONDS, aliased as CO in the SELECT statement. The ETRM extract for this view documents "Referenced base objects: none documented," but the view text itself explicitly names APPS.IGS_UC_OFFER_CONDS as the source. IGS_UC_OFFER_CONDS is the physical condition-library table that stores offer conditions maintained against admissions offers in the Student System. Because the view is a straight, non-joining projection — a one-to-one column mapping from CO to the view's output — there is no aggregation, filtering, or join logic to reconcile. Consequently, every row in IGS_UC_OFFER_CONDS appears in the view, and the view inherits the table's read consistency. The WITH READ ONLY clause prevents DML through the view, so any maintenance of offer conditions must occur against the base table or through the supported IGS forms and APIs.

Key Columns

• CONDITION_CATEGORY — Classifies the offer condition within the generic condition library.
• CONDITION_NAME — The name identifying the specific offer condition.
• EFFECTIVE_FROM / EFFECTIVE_TO — The date range during which the condition is valid.
• STATUS — The condition's status code, resolved through the IGS_LOOKUP_VALUES lookup type IGS_UC_COND_STATUS.
• _LA:STATUS_DESC — A derived (non-column) attribute that returns the meaningful description for STATUS via the lookup mechanism, using the MEANING lookup column.
• MARVIN_CODE — An external/reference code associated with the condition.
• SUMMARY_OF_CONDITIONS (SUMM_OF_COND) — The summary text of the condition; this column directly matches the user's search term "summary_of_conditions."
• LETTER_TEXT — The letter/notification text associated with the condition.
• DECISION — The decision recorded against the condition.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard EBS audit columns.

Common Use Cases and Queries

Typical consumers of this view include admissions reporting, offer-letter generation, and integrations that synchronize condition data with external systems (for example, UCAS-style feeds keyed on MARVIN_CODE). A standard query retrieves active conditions with their decoded status:

SELECT condition_category,
       condition_name,
       summary_of_conditions,
       effective_from,
       effective_to,
       status,
       "_LA:STATUS_DESC" status_description
FROM   apps.igsfv_uc_offer_conditions
WHERE  TRUNC(SYSDATE) BETWEEN effective_from AND NVL(effective_to, TRUNC(SYSDATE));

To search by the summary text specifically, a targeted query such as WHERE UPPER(summary_of_conditions) LIKE '%&keyword%' supports condition-library lookups. Because the view is read only, all such queries are safe for concurrent reporting and carry no write-back risk to the underlying IGS_UC_OFFER_CONDS table.