Search Results page_entry_class_code

Overview

The EGO_PAGE_ENTRIES_V view is a reporting and integration object within the Oracle E-Business Suite Advanced Product Catalog (EGO) module, owned by the APPS schema and validated in releases 12.1.1 and 12.2.2. It exposes the entries that compose User-Defined Pages, joining each page entry to its target attribute group association, page definition, and object display name. Because User-Defined Pages in Advanced Product Catalog allow administrators to assemble ad hoc groups of attributes for catalog data capture, this view is the primary read-only interface for reporting which attribute groups appear on which pages, in what sequence, and under which classification. The view relies on the session language through USERENV('LANG') and filters to enabled associations only, so it returns the effective, localized page layout rather than the full configuration set. For users searching on the column term "attr_group_description," the view is the documented source of that attribute, carried forward from EGO_OBJ_ATTR_GRP_ASSOCS_V.

Underlying Base Objects

EGO_PAGE_ENTRIES_V is defined over four documented objects. EGO_PAGE_ENTRIES_B supplies the physical page entry rows, providing PAGE_ID, ASSOCIATION_ID, CLASSIFICATION_CODE, and SEQUENCE. EGO_PAGES_V supplies page-level metadata, contributing PAGE_INTERNAL_NAME, PAGE_DISPLAY_NAME, and DATA_LEVEL_INT_NAME. EGO_OBJ_ATTR_GRP_ASSOCS_V supplies the attribute group association, exposing OBJECT_ID, CLASSIFICATION_CODE, and the ATTR_GROUP_APPLICATION_ID, ATTR_GROUP_TYPE, ATTR_GROUP_NAME, and ATTR_GROUP_DESCRIPTION columns. FND_OBJECTS_TL provides the language-translated OBJECT_DISPLAY_NAME. The joins are inner joins keyed on PAGE_ID, ASSOCIATION_ID, and OBJECT_ID, with a language filter on FND_OBJECTS_TL and a mandatory ENABLED_CODE = 'Y' predicate on the association view. Because two of the referenced objects are themselves views and two are synonyms to base objects, the view is a layered abstraction rather than a direct table read.

Key Columns

• PAGE_ID — Identifier of the user-defined page entry's parent page.
• ASSOCIATION_ID — Identifier linking the entry to its attribute group association.
• OBJECT_ID / OBJECT_DISPLAY_NAME — The catalog object and its language-specific display name.
• CLASSIFICATION_CODE — Classification from the association; PAGE_ENTRY_CLASS_CODE is the classification stored on the page entry itself.
• PAGE_INTERNAL_NAME / PAGE_DISPLAY_NAME — Internal and user-facing names of the page.
• DATA_LEVEL_INT_NAME — Internal data level name governing the page's scope.
• ATTR_GRP_APPLICATION_ID / ATTR_GROUP_TYPE / ATTR_GROUP_NAME — The attribute group's owning application, type, and name.
• ATTR_GROUP_DESCRIPTION — Descriptive text for the attribute group, the column most frequently used when searching by "attr_group_description."
• SEQUENCE — Display order of the entry within the page.

Common Use Cases and Queries

Typical uses include auditing page layouts, reporting attribute groups per page for catalog governance, and extracting page definitions for integration or migration. A representative query retrieving all entries for a page follows:

• SELECT page_display_name, attr_group_name, attr_group_description, sequence FROM apps.ego_page_entries_v WHERE page_id = :p_page_id ORDER BY sequence;
• SELECT object_display_name, attr_group_type, attr_group_name FROM apps.ego_page_entries_v WHERE attr_group_description LIKE '%Specification%';
• SELECT classification_code, attr_group_name, sequence FROM apps.ego_page_entries_v WHERE data_level_int_name = :p_level;

These queries return only enabled associations and are translated to the caller's session language, so results reflect the active catalog configuration. Oracle Proprietary, Confidential Information.