Search Results ego_vs_display_codes_v




Overview
Explore in AI Chat

Overview

EGO_VS_DISPLAY_CODES_V is a public Oracle E-Business Suite view owned by the APPS schema and defined within the EGO (Advanced Product Catalog) product family. As documented in the ETRM metadata, the view contains the applicable display codes for Value Sets supported in the EGO application. In practical terms, it is a curated, filtered lookup view that exposes the small subset of lookup values the Advanced Product Catalog requires when rendering value set selections in its user interface and in any downstream integration that mirrors that behavior.

Because the EGO product relies on flexfield value sets for catalog attributes, item classification, and related descriptive elements, it needs a consistent way to determine how a value set should be presented to the user—most notably whether a value set should be displayed as a long list. Rather than querying the underlying lookup table directly, EGO components and any custom extensions referencing the same behavior should consume this view, which already restricts rows to the supported lookup type and codes. This makes the view a reliable, low-risk integration point for reports and extensions.

The view is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. It carries no DML semantics of its own; it is read-only and inherits its availability from the underlying lookup data maintained by application patching and setup.

Underlying Base Objects

The view is defined over a single base object: FND_LOOKUP_VALUES, referenced through the APPS schema. FND_LOOKUP_VALUES is the core Oracle Application Object Library table that stores all lookup types and their associated codes, meanings, descriptions, enabled flags, and effective date ranges. The ETRM metadata lists FND_LOOKUP_VALUES as a synonym reference, confirming that the view is a thin projection over that table rather than a join across multiple objects.

The view text applies several fixed predicates that define its scope. It restricts LOOKUP_TYPE to 'FLEX_VALUESET_LONGLIST_FLAG', limits LOOKUP_CODE to 'N' and 'X', fixes VIEW_APPLICATION_ID to 0, and filters LANGUAGE to USERENV('LANG'). The effect is that only the two display-code values relevant to value set long-list behavior, for the current session language, are returned. The join to FND_LOOKUP_VALUES is therefore a filtered selection rather than a relational join, which is why the column list maps almost directly onto lookup table columns.

Key Columns

  • LOOKUP_CODE — The lookup code identifying the display behavior. Documented allowed values are 'N' and 'X' within this view.
  • MEANING — The translatable, user-facing meaning associated with the lookup code; used for display and reporting labels.
  • ENABLED_FLAG — Indicates whether the lookup value is currently enabled; consumers typically filter on 'Y' to retrieve only active codes.
  • START_DATE — Aliased from START_DATE_ACTIVE in FND_LOOKUP_VALUES; the date from which the display code becomes effective.
  • END_DATE — Aliased from END_DATE_ACTIVE; the date through which the display code remains effective.

Common Use Cases and Queries

The view is most often used to validate or interpret the display behavior of a value set before presenting it in a catalog or configuration screen, and to drive reports that document how value sets are configured for long-list presentation. A representative query retrieves only currently enabled codes:

SELECT lookup_code, meaning, enabled_flag, start_date, end_date FROM apps.ego_vs_display_codes_v WHERE enabled_flag = 'Y';

Because the view already filters on LOOKUP_TYPE, VIEW_APPLICATION_ID, and LANGUAGE, no additional lookup-type predicate is required. Reports that need to align with EGO's long-list behavior can join this view to flexfield value set definitions on the display code to produce a consolidated listing of value sets and their presentation flags. Extensions should treat the view as read-only and avoid assuming that additional lookup codes will appear, since the view text restricts results to 'N' and 'X'.