Search Results master_org_extension_id




Overview
Explore in AI Chat

Overview

The EGO_GTN_MUL_ATTR_CHG_B table is an Advanced Product Catalog (EGO) transactional storage object in Oracle E-Business Suite 12.1.1 and 12.2.2. It exists to hold pending changes for developer-defined multirow attribute groups submitted through the Product Information Management (PIM) change management workflow. Rather than writing attribute edits directly into the live item definition, the application stages them here so that they can be reviewed, approved, and subsequently applied to the published item record. Because the table shares the same logical attribute set as the base multirow attribute group structure but is scoped to a change line, it acts as the change-staging counterpart to the production attribute table.

From a dimensional modeling perspective, the mined foreign-key structure classifies this table as standalone, meaning it has no outbound hierarchy to a larger hub or link beyond its two parent references. It is best understood as a change-scoped attribute container: a hub-like anchor keyed by extension and change identifiers, surrounded by business attribute values, rather than a true Data Vault satellite attached to a master hub.

Key Information Stored

The unique index EGO_GTN_MUL_ATTR_CHG_B_U1 covers EXTENSION_ID, CHANGE_LINE_ID, and ACD_TYPE, establishing the business-key candidate that identifies one pending attribute change record. Key columns include:

Common Use Cases and Queries

Typical uses include auditing pending PIM attribute changes, reconciling changes to their change orders before approval, and reporting on compliance attributes awaiting implementation. A representative query joins staging rows to the change header:

  • Pending changes by item: SELECT CHANGE_LINE_ID, ACD_TYPE, COUNTRY_OF_ORIGIN FROM EGO_GTN_MUL_ATTR_CHG_B WHERE INVENTORY_ITEM_ID = :item_id.
  • Changes awaiting implementation: filter on IMPLEMENTATION_DATE IS NULL grouped by CHANGE_ID.
  • Manufacturer-restricted attribute review: join MANUFACTURER_ID to MTL_MANUFACTURERS.

Related Objects

The most significant related objects, grounded in the documented foreign keys and column semantics, are:

  • MTL_ITEM_CATALOG_GROUPS_B — joined on ITEM_CATALOG_GROUP_ID.
  • MTL_MANUFACTURERS — joined on MANUFACTURER_ID.
  • EGO_GTN_MUL_ATTR_CHG_TL — the translated/detail counterpart typically paired with the _B staging table.
  • The change order tables referenced through CHANGE_ID and CHANGE_LINE_ID.
  • The item extension structures referenced through EXTENSION_ID and MASTER_ORG_EXTENSION_ID.