Search Results mtl_item_revisions_tl




Overview
Explore in AI Chat

Overview

MTL_ITEM_REVISIONS_TL is the translation (TL) table for item revisions in Oracle E-Business Suite Inventory (INV). It stores the language-dependent DESCRIPTION column for each revision of an inventory item, allowing revision descriptions to be presented in multiple installed languages. The base (non-translated) attributes of a revision — including the revision label, effective dates, and status — reside in MTL_ITEM_REVISIONS_B, while MTL_ITEM_REVISIONS_TL holds only the translatable description text keyed to a specific LANGUAGE.

The table is owned by the INV schema and is marked VALID in both Oracle EBS 12.1.1 and 12.2.2. Under the heuristic Data Vault classification mined from its foreign key structure, this object is satellite-leaning: it hangs off the base revision entity and carries descriptive, language-qualified attributes rather than defining new business relationships. It should be modeled as an attribute satellite of the item revision, not as a hub or link.

Key Information Stored

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

  • INVENTORY_ITEM_ID — identifies the inventory item whose revision is being described; part of the primary key.
  • ORGANIZATION_ID — the inventory organization context for the item revision; part of the primary key.
  • REVISION_ID — the specific revision record; part of the primary key.
  • LANGUAGE — the NLS language code of the translated row; part of the primary key and the discriminator for the translation.
  • SOURCE_LANG — indicates the source language of the description, supporting translation workflows.
  • DESCRIPTION — the actual translated revision description text, the sole business payload of the table.
  • CREATION_DATE / CREATED_BY — audit columns recording row creation.
  • LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — audit columns recording the most recent modification and the login session that made it.

The surrogate primary key is MTL_ITEM_REVISIONS_TL_PK (INVENTORY_ITEM_ID, ORGANIZATION_ID, REVISION_ID, LANGUAGE). Two unique indexes act as business-key candidates: MTL_ITEM_REVISIONS_TL_U1 (INVENTORY_ITEM_ID, ORGANIZATION_ID, REVISION_ID, LANGUAGE) and MTL_ITEM_REVISIONS_TL_U2 (REVISION_ID, LANGUAGE). The foreign key to MTL_ITEM_REVISIONS_B ties each translated row back to its base revision.

Common Use Cases and Queries

Typical uses include multilingual revision reporting, translation completeness checks, and joins to the base table for revision labels.

  • Retrieve descriptions for a specific language: 
    SELECT b.inventory_item_id, b.revision,
       tl.description
FROM   mtl_item_revisions_b b,
       mtl_item_revisions_tl tl
WHERE  b.inventory_item_id = tl.inventory_item_id
AND    b.organization_id   = tl.organization_id
AND    b.revision_id       = tl.revision_id
AND    tl.language         = USERENV('LANG');
  • Identify revisions lacking a translation in a target language.
  • Audit recent changes via LAST_UPDATE_DATE and LAST_UPDATED_BY.
  • Feed downstream pick, pack, and label printing reports that require localized revision text.

Related Objects

  • MTL_ITEM_REVISIONS_B — the base table holding non-translated revision attributes; joined on INVENTORY_ITEM_ID, ORGANIZATION_ID, and REVISION_ID.
  • MTL_SYSTEM_ITEMS_B — the inventory item master, joined on INVENTORY_ITEM_ID and ORGANIZATION_ID.
  • MTL_ITEM_REVISIONS_VL — the language view exposing base and translated columns together.
  • MTL_SYSTEM_ITEMS_VL — the item view that surfaces revisions in a locale-aware manner.
  • FND_LANGUAGES — provides the installed languages referenced by the LANGUAGE column.
  • MTL_ITEM_LOCATIONS and revision-related INV APIs consume revision data for inventory transactions and label printing.

Together these objects form the revision definition and presentation layer within the Inventory module.