Search Results igs_in_enq_status_v

Overview

The IGS_IN_ENQ_STATUS_V view resides in the APPS schema of the Oracle E-Business Suite and belongs to the IGS — Student System product family (the Oracle Student System / Higher Education module). Within the ETRM reference material for release 12.1.1 and 12.2.2, the object is catalogued with a status of VALID but is explicitly described as Obsolete. This designation indicates that while the compiled view still exists in the database and remains queryable, Oracle no longer recommends its use for new development, and it is retained primarily for backward compatibility with legacy customizations, reports, or integrations that were built against earlier releases.

The view presents enquiry status reference data — that is, the set of statuses that can be assigned to a student enquiry record — enriched with the corresponding lookup meaning from the IGS lookup framework. Its role in reporting and integration is to provide a denormalized, human-readable representation of enquiry status codes, joining the base status entity to its lookup translation. Because of its obsolete status, it should be treated as a read-only compatibility surface rather than a supported extension point.

Underlying Base Objects

According to the documented view text, IGS_IN_ENQ_STATUS_V is defined over two objects:

• IGS_IN_ENQ_STATUS (aliased ES) — the base table holding enquiry status records, including the internal status code, description, lookup code, and audit columns.
• IGS_LOOKUPS_VIEW (aliased LKUP) — the IGS lookup view used to resolve the short lookup code (S_ENQUIRY_STATUS) into a displayable meaning.

The join condition restricts the lookup rows to LOOKUP_TYPE = 'ENQUIRY_STATUS' and matches LOOKUP_CODE to the base table's S_ENQUIRY_STATUS column. The ETRM metadata for 12.2.2 records no additional documented referenced base objects beyond these, and the owner column is left unpopulated in the excerpt. The view uses ES.ROWID as the ROW_ID column, a common Oracle Forms pattern in IGS views that supports row identification in the original form-based UI.

Key Columns

• ROW_ID — the row identifier derived from the base table ROWID, used by Oracle Forms for record navigation and update coordination.
• ENQUIRY_STATUS — the primary enquiry status identifier or code from the base table.
• DESCRIPTION — the descriptive text of the enquiry status.
• S_ENQUIRY_STATUS — the short lookup code that links to the ENQUIRY_STATUS lookup type.
• CLOSED_IND — indicates whether the enquiry status represents a closed state.
• MEANING — the translated, displayable meaning of the lookup code sourced from IGS_LOOKUPS_VIEW.
• DSP_CLOSED_IND — the closed indicator from the lookup record, exposed for display purposes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns tracking record creation and modification.

Common Use Cases and Queries

The view is typically used to populate enquiry status list-of-values, drive enquiry workflow logic based on closed status, and produce reporting output that shows user-facing status descriptions. A representative query listing all enquiry statuses with their translated meanings is:

SELECT ENQUIRY_STATUS, DESCRIPTION, S_ENQUIRY_STATUS, MEANING, CLOSED_IND, DSP_CLOSED_IND FROM APPS.IGS_IN_ENQ_STATUS_V ORDER BY ENQUIRY_STATUS;

To retrieve only the statuses that represent a closed state:

SELECT ENQUIRY_STATUS, DESCRIPTION, MEANING FROM APPS.IGS_IN_ENQ_STATUS_V WHERE DSP_CLOSED_IND = 'Y';

To count records associated with each enquiry status for a summary report, a developer might join the view back to the underlying enquiry tables on ENQUIRY_STATUS. Because the object is flagged obsolete, any new development should instead reference the current supported IGS enquiry status tables or the replacement lookup-based logic delivered in later patch levels, using this view only where existing 12.1.1 or 12.2.2 customizations depend on it.