Results for “mtl_material_statuses_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MTL_MATERIAL_STATUSES_TL is the translation table for inventory material status definitions in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is owned by the INV schema and belongs to the Inventory (INV) product module, where it is documented as being used by Warehouse Management System (WMS) functionality only. Material statuses in EBS control how on-hand inventory is treated — whether stock is available for reservation, picking, shipping, or accounting — and this table supplies the language-specific status code and description text that accompanies each status definition.

The table follows the standard EBS multilingual (MLS) pattern in which a base table, MTL_MATERIAL_STATUSES_B, stores the language-independent definition keyed by STATUS_ID, and the _TL table holds translatable attributes per installed language. Under a heuristic Data Vault classification mined from the foreign key structure, this table is satellite-leaning: it carries descriptive, context-dependent attributes (code and description text) that hang off the STATUS_ID hub represented in the base table, rather than defining new business entities or relationships.

Key Information Stored

The documented physical schema exposes eleven columns. The most significant are summarized below.

• STATUS_ID — Surrogate identifier for the material status; part of the composite primary key and the foreign key to the base definition.
• LANGUAGE — Installed language code for the translated row; the second component of the composite primary key.
• STATUS_CODE — Translated short code or name presented for the material status in the given language.
• DESCRIPTION — Translated descriptive text for the material status, typically the more verbose explanation shown in WMS and Inventory forms and reports.
• SOURCE_LANG — Language of the source (base) row from which the translation was derived, used by the MLS seed and translation process.
• ZD_EDITION_NAME — Editioning column introduced by the EBS 12.2 online patching architecture; participates in the documented unique index, separating rows by edition for the cross-edition triggers and views.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking who and when each translated row was created or last maintained.

The primary key, MTL_MATERIAL_STATUSES_TL_PK, is defined over STATUS_ID and LANGUAGE. The documented unique index additionally includes ZD_EDITION_NAME (STATUS_ID, LANGUAGE, ZD_EDITION_NAME), which serves as the business-key candidate enforcing one translated row per status, language, and edition. The foreign key MTL_MATERIAL_STATUSES_TL.STATUS_ID references MTL_MATERIAL_STATUSES_B, confirming the base–translation dependency.

Common Use Cases and Queries

Typical uses involve resolving the displayable status code and description for a material status in the session or user language. A straightforward retrieval joins the translation to the base table through the STATUS_ID column:

• Listing all statuses with their translated code and description in a specified language, filtering on LANGUAGE = userenv('LANG') for the active session language, with a fallback to SOURCE_LANG when no translation exists.
• Reporting on material status definitions in multilingual deployments, where the same STATUS_ID yields multiple translated rows — one per installed language — to support localized printed output and WMS operator screens.
• Data quality audits verifying that every STATUS_ID in MTL_MATERIAL_STATUSES_B has a populated translation for each required language, and checking translation completeness against FND_LANGUAGES.
• Integration and migration scripts that must supply STATUS_CODE and DESCRIPTION text when loading status definitions into a target environment, keyed by STATUS_ID and LANGUAGE.

Related Objects

The most significant related objects are those connected through the documented key and the surrounding MLS and status-definition infrastructure.

• MTL_MATERIAL_STATUSES_B — Base table joined on STATUS_ID; the parent of the documented foreign key and the source of language-independent attributes.
• MTL_MATERIAL_STATUSES_VL — The MLS view that partitions base and translation columns across languages; the conventional access path for forms and reports.
• MTL_MATERIAL_STATUSES_TL_PK — Composite primary key and unique index (STATUS_ID, LANGUAGE, ZD_EDITION_NAME) enforcing row uniqueness.
• MTL_MATERIAL_STATUS_HISTORY — Records status changes on inventory transactions and is resolved to displayable status text through STATUS_ID.
• MTL_ONHAND_QUANTITIES / MTL_SYSTEM_ITEMS — Inventory and item tables whose status-driven behavior is described in reporting output using this translation table.
• FND_LANGUAGES — Supplies the set of installed languages that determine which LANGUAGE rows exist and are expected.
• WMS-related tables and concurrent programs — Since the object is documented as WMS-only, warehouse execution screens and reports are principal consumers of the translated codes and descriptions.