Results for “multi_row_code”

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

Overview

The EGO_ATTR_GROUPS_DL_V view is a denormalized, business-facing presentation of attribute group definitions used by the Advanced Product Catalog (EGO) module in Oracle E-Business Suite 12.1.1 and 12.2.2. It consolidates descriptive flexfield context information, attribute group extension attributes, data level security configuration, and lookup-derived meaning columns into a single queryable structure. Attribute groups in EGO represent named collections of descriptive flexfield segments that describe items, and this view surfaces both the technical identifiers and the user-facing display names required for reporting, integration, and functional analysis. The view belongs to the APPS schema and relies on USERENV('LANG') to return translated descriptions and data level names in the session language. It is most commonly used when administrators and developers need to audit which attribute groups exist, how they are named, and which data level governs their behavior, without joining the underlying flexfield and extension objects manually.

The view is especially relevant to searches involving FL_CTX_EXT, since the EGO_FND_DSC_FLX_CTX_EXT table (aliased FL_CTX_EXT in the view text) is the EGO extension that carries attribute-group-specific metadata such as the attribute group ID, owning party, multi-row flag, security type, and region code.

Underlying Base Objects

EGO_ATTR_GROUPS_DL_V is defined over seven documented base objects, all accessed through APPS synonyms:

• FND_DESCR_FLEX_CONTEXTS (FL_CTX) — the standard descriptive flexfield context definition, supplying application ID, flexfield name, context code, and enabled flag.
• FND_DESCR_FLEX_CONTEXTS_TL (TL) — the translated context names and descriptions, joined on language.
• EGO_FND_DSC_FLX_CTX_EXT (FL_CTX_EXT) — the EGO extension table holding ATTR_GROUP_ID, OWNING_PARTY_ID, MULTI_ROW, SECURITY_TYPE, AGV_NAME, REGION_CODE, and VARIANT.
• EGO_ATTR_GROUP_DL (DL) — the data level assignment for each attribute group, including privilege IDs, pre/post event flags, and defaulting behavior.
• EGO_DATA_LEVEL_B (DL_B) and EGO_DATA_LEVEL_TL (DL_TL) — the data level base and translated tables providing internal and user-facing data level names.
• FND_LOOKUP_VALUES (L1, L2, L3) — three lookup joins that translate enabled, multi-row, and security codes into readable meanings.

Key Columns

The view exposes ATTR_GROUP_ID as the primary business key, ATTR_GROUP_TYPE (the descriptive flexfield name) and ATTR_GROUP_NAME (the context code) as the technical identity, and ATTR_GROUP_DISP_NAME plus DESCRIPTION as the translated display values. Security and behavior are represented through ENABLED_CODE/ENABLED_MEANING, MULTI_ROW_CODE/MULTI_ROW_MEANING, and SECURITY_CODE/SECURITY_MEANING. Data level governance appears as DATA_LEVEL_ID, DATA_LEVEL_INTERNAL_NAME, and DATA_LEVEL_NAME. Privilege and event configuration is exposed via VIEW_PRIVILEGE_ID, EDIT_PRIVILEGE_ID, RAISE_PRE_EVENT, RAISE_POST_EVENT, and BEHAVIOR (mapped from DL.DEFAULTING).

Common Use Cases and Queries

Typical usage includes auditing attribute group configuration for a given flexfield context, identifying the data level applied to each group, and validating security or multi-row behavior across item catalogs. A representative query follows:

• SELECT ATTR_GROUP_ID, ATTR_GROUP_NAME, ATTR_GROUP_DISP_NAME, DATA_LEVEL_NAME, ENABLED_MEANING FROM APPS.EGO_ATTR_GROUPS_DL_V WHERE ATTR_GROUP_TYPE = :p_flexfield ORDER BY ATTR_GROUP_DISP_NAME;
• Filtering on MULTI_ROW_CODE or SECURITY_CODE supports validation of attribute group behavior during implementations or upgrades.