Search Results data_level_int_name




Overview
Explore in AI Chat

Overview

APPS.EGO_PAGE_ENTRIES_V is a reporting and integration view in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that presents the relationship between attribute group pages and the object attribute groups they contain. It belongs to the EGO (Engineering/Product Information) product family and is used primarily by the Oracle Product Information Management and E-Business Suite extensibility framework to drive the rendering and configuration of attribute pages in the application's web-based user interface.

The view consolidates page header information, attribute group association details, and translatable object names into a single denormalized result set. It exposes a column named DATA_LEVEL_INT_NAME, which is sourced from the DATA_LEVEL_INT_NAME column of the underlying EGO_PAGES_V view, though the ETRM metadata does not further describe its semantics. This column is frequently referenced when users investigate the internal name of a data level associated with a page entry, which is why the view surfaces it directly.

Underlying Base Objects

The view is defined over four documented base objects, joined through page and association identifiers:

A further filter, A.ENABLED_CODE = 'Y', restricts the output to enabled attribute group associations, ensuring only active configurations are returned.

Key Columns

The view returns the following columns, each aliased as documented in the view text:

  • PAGE_ID — identifier of the page.
  • ASSOCIATION_ID — identifier linking the page entry to an attribute group association.
  • OBJECT_ID / OBJECT_DISPLAY_NAME — the object identifier and its translated display name.
  • CLASSIFICATION_CODE / PAGE_ENTRY_CLASS_CODE — classification of the attribute group association and of the page entry, respectively.
  • PAGE_INTERNAL_NAME / PAGE_DISPLAY_NAME — internal and display names of the page.
  • DATA_LEVEL_INT_NAME — the internal name of the data level associated with the page, carried through from EGO_PAGES_V.
  • ATTR_GRP_APPLICATION_ID, ATTR_GROUP_TYPE, ATTR_GROUP_NAME, ATTR_GROUP_DESCRIPTION — attribute group identity and descriptive metadata.
  • SEQUENCE — ordering of the page entry.

Common Use Cases and Queries

Typical scenarios include troubleshooting which attribute groups are assigned to a page, auditing the data levels used by a specific object, and building custom reports on page configuration. A representative query filtering on the requested column is:

  • Locate all enabled page entries tied to a given data level: SELECT page_display_name, atTR_group_name, data_level_int_name FROM apps.ego_page_entries_v WHERE data_level_int_name = '&data_level';
  • List attribute groups for an object: SELECT object_display_name, attr_group_name, sequence FROM apps.ego_page_entries_v WHERE object_display_name = '&object' ORDER BY sequence;
  • Inventory page entries by classification: SELECT page_entry_class_code, COUNT(*) FROM apps.ego_page_entries_v GROUP BY page_entry_class_code;

Because the view joins only enabled associations and translates object names to the session language, results reflect the active configuration as seen by the current user's locale.