Search Results ego_item_gtn_attrs_b




Overview
Explore in AI Chat

Overview

EGO_ITEM_GTN_ATTRS_B is a table in the EGO schema (Advanced Product Catalog) within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the single-row, untranslated global trading item number (GTIN) attributes associated with a trading item. In practice, this table acts as the descriptive "base" record for trade-item-specific data such as weights, dimensions, packaging, regulatory, and marketing attributes that extend the standard inventory item definition. The "_B" suffix indicates that the table holds base-language (untranslated) columns; a corresponding "_TL" table typically carries translated, language-dependent descriptions.

With respect to Data Vault modeling heuristics mined from its foreign-key structure, this object is classified as standalone. This suggests it is best modeled as a satellite-like or reference structure keyed by its own business keys, rather than a hub or link connecting multiple entities. Its primary relationship is a single foreign key to MTL_ITEM_CATALOG_GROUPS_B through ITEM_CATALOG_GROUP_ID, anchoring the trading item to a catalog group.

Key Information Stored

The table contains 111 documented columns. The most operationally significant columns are summarized below.

The surrogate primary key is EXTENSION_ID (U2); the business-key candidates are INVENTORY_ITEM_ID combined with ORGANIZATION_ID (U1).

Common Use Cases and Queries

This table is commonly accessed when publishing or exporting trade item information (for example, to data pools such as GDSN) and when reporting on packaging, weights, and regulatory attributes of items.

  • Retrieve trade attributes for an item in an organization: 
    SELECT *
FROM   EGO.EGO_ITEM_GTN_ATTRS_B
WHERE  INVENTORY_ITEM_ID = :item_id
AND    ORGANIZATION_ID  = :org_id;
  • Join to catalog groups for reporting: 
    SELECT g.*, c.SEGMENT1, c.SEGMENT2
FROM   EGO.EGO_ITEM_GTN_ATTRS_B g,
       MTL.MTL_ITEM_CATALOG_GROUPS_B c
WHERE  g.ITEM_CATALOG_GROUP_ID = c.CATALOG_GROUP_ID
AND    g.INVENTORY_ITEM_ID = :item_id;
  • Report all GTINs ready for publication: 
    SELECT INVENTORY_ITEM_ID, EANUCC_CODE, PUBLICATION_STATUS
FROM   EGO.EGO_ITEM_GTN_ATTRS_B
WHERE  PUBLICATION_STATUS = 'PUBLISHED';
  • Audit recent changes: filter by LAST_UPDATE_DATE and LAST_UPDATED_BY.
  • Check packaging completeness: identify rows where NET_CONTENT, GROSS_WEIGHT, or QUANTITY_OF_ITEM_INNER_PACK are null.

Related Objects

  • MTL_ITEM_CATALOG_GROUPS_B — referenced by ITEM_CATALOG_GROUP_ID; the primary parent for catalog grouping.
  • EGO_ITEM_GTN_ATTRS_TL — the translated counterpart holding language-specific descriptions.
  • MTL_SYSTEM_ITEMS_B — the master item definition joined on INVENTORY_ITEM_ID and ORGANIZATION_ID.
  • EGO_ITEM_GTN_ATTRS_V — a potential view exposing the combined base and translated attributes.
  • EGO_ITEM_EXTENSIBLE_ATTRS — extensible attribute storage for related item data.
  • EGO_ITEM_GTN_CATEGORIES — category assignments for the trade item.
  • EGO_ITEM_GTN_ORGS — organization-level trade item data.
  • EGO_ITEM_PUBLISH_* public APIs — publication routines that read GTIN attributes for outbound data synchronization.

Any application integrating through the Product Information Management (PIM) publication framework should treat EGO_ITEM_GTN_ATTRS_B as the authoritative source for untranslated global trading item number attributes.