Search Results ego_ef_security_type




Overview
Explore in AI Chat

Overview

APPS.EGO_ATTR_GROUPS_V is an Oracle E-Business Suite view that exposes descriptive flexfield (DFF) attribute group definitions for the Oracle Product Information Management / EGO (e-Go / Engineering) schema. It consolidates the descriptive flexfield context metadata held in the FND foundation tables with the EGO-specific extension attributes stored in EGO_FND_DSC_FLX_CTX_EXT. The view therefore answers a common integration requirement: identifying each flexfield context ("attribute group") together with the extended properties such as owning party, multi-row behavior, security type, privilege identifiers, region code, business-event flags, and display dimensions. Because the underlying FND tables store base and translated context information separately, the view performs the join to the translation table and decorates coded flags with user-facing lookup meanings.

Underlying Base Objects

The view is defined over four documented synonym-referenced base objects:

  • FND_DESCR_FLEX_CONTEXTS (FL_CTX) — supplies the core context definition: application identifier, descriptive flexfield name, descriptive flex context code, and the enabled flag.
  • EGO_FND_DSC_FLX_CTX_EXT (FL_CTX_EXT) — the EGO extension table that adds attribute group ID, owning party, multi-row indicator, security type, view/edit privilege IDs, AGV name, region code, business-event flags, variant, and column/row counts.
  • FND_DESCR_FLEX_CONTEXTS_TL (TL) — the translation table providing the language-specific context display name and description, filtered to USERENV('LANG').
  • FND_LOOKUP_VALUES (L1, L2, L3) — joined three times to translate the enabled flag, multi-row flag, and security type into meaning text using the YES_NO and EGO_EF_SECURITY_TYPE lookup types.

The joins are keyed on APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, and DESCRIPTIVE_FLEX_CONTEXT_CODE across FL_CTX, FL_CTX_EXT, and TL, ensuring only flexfield contexts that have a corresponding EGO extension row are returned.

Key Columns

Common Use Cases and Queries

Typical uses include listing all attribute groups for a given flexfield, auditing security and privilege assignments, and driving integrations that consume multi-row or business-event-enabled groups.

SELECT attr_group_id,
       attr_group_type,
       attr_group_name,
       attr_group_disp_name,
       enabled_meaning,
       multi_row_meaning,
       security_meaning
FROM   apps.ego_attr_groups_v
WHERE  application_id = 401
AND    attr_group_type = 'EGO_ITEM_EFF_B';

To find groups configured for business events:

SELECT attr_group_id, attr_group_disp_name
FROM   apps.ego_attr_groups_v
WHERE  business_event_flag = 'Y';

Because the view resolves translations at runtime via USERENV('LANG'), query results reflect the session language, which makes it suitable both for end-user reporting and for language-aware integration extracts.