Results for “attr_group_name”

50+ results




Overview
Explore in AI Chat

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

Overview

EGO_ATTR_GROUP_OBJ_IDS_V is a seeded, VALID view owned by the APPS schema within the EGO – Advanced Product Catalog module of Oracle E-Business Suite, applicable to releases 12.1.1 and 12.2.2. The view consolidates all user-defined attribute groups that are associated with a specific object by joining extension-table registration data, descriptive flexfield definitions, and the attribute group definition view. It serves as the canonical reporting and integration surface for answering the question of which attribute groups are attached to which catalog objects, and how those groups are configured with respect to enablement, multi-row behavior, and security.

Its practical significance lies in exposing both the coded values (for example, ENABLED_CODE and SECURITY_CODE) and their translated meanings (ENABLED_MEANING and SECURITY_MEANING). Because the underlying descriptive flexfield translated table is filtered on USERENV('LANG'), the view inherently resolves language-dependent text for the session language, which makes it suitable for both transactional queries and multilingual user interfaces.

Underlying Base Objects

The documented referenced objects are EGO_ATTR_GROUPS_V (VIEW), EGO_OBJECT_EXT_TABLES_B (SYNONYM), FND_DESCRIPTIVE_FLEXS (SYNONYM), FND_DESCRIPTIVE_FLEXS_TL (SYNONYM), and FND_TABLES (SYNONYM). The join topology is as follows:

  • EGO_OBJECT_EXT_TABLES_B provides the APPLICATION_ID, OBJECT_ID, and EXT_TABLE_NAME anchoring the object to its extension table.
  • FND_TABLES links the extension table by APPLICATION_ID and TABLE_NAME, validating that the table is registered.
  • FND_DESCRIPTIVE_FLEXS and FND_DESCRIPTIVE_FLEXS_TL supply the DESCRIPTIVE_FLEXFIELD_NAME, with FND_TABLES-type matching through APPLICATION_TABLE_NAME and translated names resolved through the _TL table using USERENV('LANG').
  • EGO_ATTR_GROUPS_V supplies the attribute group content and coded column meanings, joined on APPLICATION_ID and DESCRIPTIVE_FLEXFIELD_NAME equal to ATTR_GROUP_TYPE.

Key Columns

  • APPLICATION_ID – the application owning the object and flexfield context.
  • OBJECT_ID – identifier of the catalog object associated with the attribute group.
  • DESCRIPTIVE_FLEXFIELD_NAME – the descriptive flexfield backing the attribute group.
  • ATTR_GROUP_NAME / ATTR_GROUP_DISP_NAME – internal and display names of the attribute group.
  • ENABLED_CODE / ENABLED_MEANING – enablement flag and its translated meaning; this pairing is the field users most often search for ("enabled_meaning") when filtering active versus inactive groups.
  • MULTI_ROW_CODE / MULTI_ROW_MEANING – whether the group permits multiple rows and its translation.
  • SECURITY_CODE / SECURITY_MEANING – security classification and its meaning.
  • OWNING_PARTY_ID – party owning the attribute group.
  • DESCRIPTION – descriptive text for the group.

Common Use Cases and Queries

Typical scenarios include auditing which attribute groups are enabled for a given object, generating reports of security and multi-row configuration, and feeding integration extracts that require translated meanings rather than codes.

  • Identify all enabled attribute groups for an object:
    SELECT object_id, attr_group_disp_name, enabled_meaning FROM ego_attr_group_obj_ids_v WHERE enabled_code = 'Y';
  • Search by translated meaning, mirroring the "enabled_meaning" lookup:
    SELECT * FROM ego_attr_group_obj_ids_v WHERE enabled_meaning = 'Yes' AND multi_row_code = 'Y';
  • Security and ownership audit:
    SELECT security_meaning, owning_party_id, attr_group_name FROM ego_attr_group_obj_ids_v;