Search Results ego_item_gtn_attrs_tl




Overview
Explore in AI Chat

Overview

EGO_ITEM_GTN_ATTRS_TL is a translation table within the EGO (Advanced Product Catalog) schema of Oracle E-Business Suite. It stores the language-specific, translated descriptive attributes of the Global Trading Item Number (GTN) assigned to inventory items. In EBS terminology, the "_TL" suffix denotes a Translation table, meaning it holds one row per language per parent entity, while the corresponding base table (EGO_ITEM_GTN_ATTRS_B) stores the language-independent data. Because GTN attributes are frequently surfaced to downstream systems, catalogs, and external partners, the translated values contained here are critical for producing human-readable, localized item descriptions.

The table is documented as valid and populated as a single-row-per-language structure. It is classified heuristically as a standalone data object in the mined Data Vault model, meaning it is not part of a larger hub/link/satellite cluster. As a modeling suggestion, it is most naturally treated as a satellite attached to the item catalog group hub, since it carries descriptive, language-dependent attributes about a trading item rather than serving as an independent business key holder. Its foreign key relationship to EGO_ITEM_GTN_ATTRS_B via the shared key columns reinforces this interpretation.

Key Information Stored

The table contains 20 documented columns. The most significant are:

The unique index EGO_ITEM_GTN_ATTRS_TL_U2 on (EXTENSION_ID, LANGUAGE) provides an alternate business-key candidate. No surrogate sequence-based primary key column is documented separately, so the U1 index functions as the de facto primary identifier.

Common Use Cases and Queries

Typical uses include generating localized trade documentation, exporting GTN descriptions to partner systems, and auditing translation completeness across languages.

  • Retrieve translated GTN attributes for a specific item in a given language: 
    SELECT tl.*
FROM   ego_item_gtn_attrs_tl tl
WHERE  tl.inventory_item_id = :item_id
AND    tl.organization_id  = :org_id
AND    tl.language         = USERENV('LANG');
  • Identify English (or base-language) GTN records for data-quality review by filtering on SOURCE_LANG = 'US'.
  • Detect missing translations by comparing the base table against the _TL table using an outer join on (INVENTORY_ITEM_ID, ORGANIZATION_ID).
  • Report catalog-wide GTN descriptions joined to MTL_ITEM_CATALOG_GROUPS_B on ITEM_CATALOG_GROUP_ID for classification-based reporting.

Related Objects

  • EGO_ITEM_GTN_ATTRS_B — base (non-translated) GTN attribute table joined on EXTENSION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID.
  • MTL_ITEM_CATALOG_GROUPS_B — referenced via ITEM_CATALOG_GROUP_ID.
  • MTL_SYSTEM_ITEMS_B / MTL_SYSTEM_ITEMS_TL — item master for INVENTORY_ITEM_ID.
  • MTL_ITEM_REVISIONS_B — revision definitions for REVISION_ID.
  • FND_LANGUAGES — validates LANGUAGE and SOURCE_LANG codes.
  • EGO Advanced Product Catalog APIs for importing and maintaining GTN attributes.