Search Results ego_gtin_attrs_tl_v




Overview
Explore in AI Chat

Overview

The EGO_GTIN_ATTRS_TL_V view is a reporting and integration object owned by the APPS schema within the EGO (Advanced Product Catalog) product module of Oracle E-Business Suite. It is documented in Oracle's ETRM metadata for 12.1.1 and 12.2.2 and carries a documented status of VALID. As its description states, the view exposes a single row of translated Global Trade Item Number (GTIN) attributes — the data used to describe trade items in the global supply chain, including descriptive size, functional and invoice names, warranty text, and trade item finish descriptions.

Practically, this view joins inventory item master data, translated item descriptions, cross-reference records holding the GTIN value, and the EGO trade item attribute table for GTIN-specific descriptive attributes. Because it combines the translated (TL) language rows of both the item description and the GTIN attribute records, it is designed for multi-language reporting, label generation, catalog publishing, and outbound integration to trading partners and data pools. It is not a transactional table; it is a denormalized, read-only projection intended for querying rather than maintenance.

Underlying Base Objects

According to the documented view text, EGO_GTIN_ATTRS_TL_V is defined over the following objects, all exposed as synonyms in the APPS schema:

The joins are narrow and deliberate: MTL_CROSS_REFERENCES is restricted to GTIN type and to the item's primary UOM code, and MTL_PARAMETERS enforces the master organization relationship. The LANGUAGE column is derived via DECODE on MST.LANGUAGE, mapping 'US' to 'EN' while leaving other language codes unchanged, which normalizes the language identifier for consumers.

Key Columns

The view exposes the following twelve columns:

  • INVENTORY_ITEM_ID — primary inventory item identifier; the principal join key to other item-based reporting objects.
  • ORGANIZATION_ID — inventory organization identifier for the item record.
  • GLOBAL_TRADE_ITEM_NUMBER — the GTIN value sourced from MTL_CROSS_REFERENCES.CROSS_REFERENCE, the field most commonly used in barcode and trade item matching.
  • LANGUAGE — normalized language code (for example, 'US' becomes 'EN', with SOURCE_LANG indicating the origin language).
  • SOURCE_LANG — the language from which the translation originated.
  • DESCRIPTIVE_SIZE — a GTIN attribute describing the trade item's size.
  • FUNCTIONAL_NAME — the functional name of the trade item.
  • INVOICE_NAME — the name used on invoices for the trade item.
  • WARRANTY_DESCRIPTION — warranty text associated with the trade item.
  • TRADE_ITEM_FINISH_DESCRIPTION — finish or presentation description.
  • DESCRIPTION_SHORT — a short description attribute for the GTIN.
  • ADDITIONAL_TRADE_ITEM_DESC — the translated item description from MTL_SYSTEM_ITEMS_TL, providing an extended trade item description.

Common Use Cases and Queries

This view is typically used when a report or interface must present GTIN data together with its translated descriptive attributes for a specific language. Typical scenarios include trade item catalog publishes, barcode label verification, and data pool synchronization reporting.

  • Retrieve the GTIN and its attributes for a single item in a target language.
  • List all items in an organization that have GTIN records, along with their functional and invoice names.
  • Verify that GTIN cross-references exist and are positioned on the primary UOM.

A representative query is:

SELECT inventory_item_id,
       organization_id,
       global_trade_item_number,
       language,
       functional_name,
       invoice_name
  FROM apps.ego_gtin_attrs_tl_v
 WHERE organization_id = :org_id
   AND language = 'EN'
   AND inventory_item_id = :item_id;

Because the view is restricted to the master organization through MTL_PARAMETERS, queries should supply an organization that participates as the master organization, and should filter on LANGUAGE to obtain a single translation row per item.