Results for “dl_tl”

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

Overview

The APPS.EGO_ATTR_GROUPS_DL_V view is a denormalized reporting construct within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments that merges attribute group definitions, descriptive flexfield context metadata, data-level security assignments, and translatable display values into a single queryable interface. Its name conveys its purpose: "EGO_ATTR_GROUPS" identifies the EGO (Product Information Management / extensibility) attribute group entity, "DL" indicates the incorporation of data-level security information from the EGO_ATTR_GROUP_DL structure, and the trailing "V" confirms it is a database view rather than a base table. The "_TL" suffix idiom appears extensively throughout the underlying joins, reflecting the multilingual nature of the data being surfaced.

Functionally, this view answers the question: "For each attribute group (i.e., descriptive flexfield context), what are its display name, description, enabling status, multi-row behavior, security model, associated data level, and defaulting behavior — with all lookup codes decoded and all text translated into the current session language?" This makes it a critical object for reporting on flexfield configuration, for building administrative dashboards, and for integrations that need to reason about attribute group metadata programmatically.

Underlying Base Objects

The view is defined over seven documented base objects, all referenced through public synonyms in the APPS schema. It joins FND_DESCR_FLEX_CONTEXTS (the core descriptive flexfield context definition) to its extension table EGO_FND_DSC_FLX_CTX_EXT on application, flexfield name, and context code. Translatable display data comes from FND_DESCR_FLEX_CONTEXTS_TL, joined with a LANGUAGE restriction of USERENV('LANG'). Data-level security details originate from EGO_ATTR_GROUP_DL, linked to EGO_DATA_LEVEL_B through DATA_LEVEL_ID, and further to EGO_DATA_LEVEL_TL for the user-facing data level name (again filtered by USERENV('LANG')). Three aliased instances of FND_LOOKUP_VALUES (L1, L2, L3) decode the ENABLED_FLAG, MULTI_ROW, and SECURITY_TYPE codes respectively; the enabled-flag lookup specifically uses the 'YES_NO' lookup type.

Key Columns

• ATTR_GROUP_ID — Primary identifier for the attribute group, sourced from the extension table.
• APPLICATION_ID / ATTR_GROUP_TYPE / ATTR_GROUP_NAME — Composite identity of the descriptive flexfield and context code.
• ATTR_GROUP_DISP_NAME / DESCRIPTION — Translatable display name and description from FND_DESCR_FLEX_CONTEXTS_TL.
• ENABLED_CODE / ENABLED_MEANING — Raw yes/no flag and its decoded lookup meaning.
• MULTI_ROW_CODE / MULTI_ROW_MEANING — Whether the group supports multiple rows, decoded via lookups.
• SECURITY_CODE / SECURITY_MEANING — The security model applied, with L3 decoding.
• VIEW_PRIVILEGE_ID / EDIT_PRIVILEGE_ID — Privilege identifiers controlling read and modify access.
• RAISE_PRE_EVENT / RAISE_POST_EVENT — Flags governing whether pre- and post-processing events fire.
• DATA_LEVEL_ID / DATA_LEVEL_INTERNAL_NAME / DATA_LEVEL_NAME — The security data level, with the internal name from EGO_DATA_LEVEL_B and the translated name from EGO_DATA_LEVEL_TL.
• AGV_NAME, REGION_CODE, VARIANT, BEHAVIOR — Implementation attributes describing the UI region, variant, and defaulting behavior.

Common Use Cases and Queries

Typical usage includes auditing attribute group configuration, confirming which groups are enabled, and reporting the data-level security assigned to each group. Because most text columns are language-filtered, queries return values in the session's language.

• List enabled attribute groups: SELECT ATTR_GROUP_NAME, ATTR_GROUP_DISP_NAME, DATA_LEVEL_NAME FROM APPS.EGO_ATTR_GROUPS_DL_V WHERE ENABLED_CODE = 'Y' ORDER BY ATTR_GROUP_DISP_NAME;
• Report security configuration: SELECT ATTR_GROUP_DISP_NAME, SECURITY_MEANING, DATA_LEVEL_NAME FROM APPS.EGO_ATTR_GROUPS_DL_V;
• Filter by flexfield: SELECT ATTR_GROUP_NAME, MULTI_ROW_MEANING FROM APPS.EGO_ATTR_GROUPS_DL_V WHERE DESCRIPTIVE_FLEXFIELD_NAME = :flexfield_name;

Given the hidden "dl_tl" joins, this view is best approached as a read-only reporting source; underlying maintenance of attribute group security should occur through the corresponding EGO and flexfield forms or APIs.