Search Results fl_ctx_ext

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

• ATTR_GROUP_ID — primary identifier of the attribute group from the EGO extension table.
• APPLICATION_ID — owning application of the descriptive flexfield.
• ATTR_GROUP_TYPE — the descriptive flexfield name, i.e., the flexfield the group belongs to.
• ATTR_GROUP_NAME / ATTR_GROUP_DISP_NAME / DESCRIPTION — context code, translated display name, and translated description.
• OWNING_PARTY_ID — party that owns the attribute group.
• ENABLED_CODE / ENABLED_MEANING — enabled flag and its YES_NO lookup meaning.
• MULTI_ROW_CODE / MULTI_ROW_MEANING — whether the group supports multiple rows, plus meaning.
• SECURITY_CODE / SECURITY_MEANING — security type code and its EGO_EF_SECURITY_TYPE lookup meaning.
• VIEW_PRIVILEGE_ID / EDIT_PRIVILEGE_ID — privileges controlling view and edit access.
• AGV_NAME, REGION_CODE, VARIANT — attribute group view name, region, and variant metadata.
• BUSINESS_EVENT_FLAG / PRE_BUSINESS_EVENT_FLAG — business event integration indicators.
• NUM_OF_COLS / NUM_OF_ROWS — configured column and row dimensions.

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.