Search Results mtl_material_statuses_tl




Overview
Explore in AI Chat

Overview

The MTL_MATERIAL_STATUSES_TL table is a translation table within the Oracle E-Business Suite Inventory (INV) module. Its core function is to store user-defined, language-specific descriptions for inventory material statuses. This table operates in conjunction with its base table, MTL_MATERIAL_STATUSES_B, which holds the language-independent definition and control attributes for each status. As indicated in the official documentation, this table is specifically utilized by the Warehouse Management System (WMS) functionality. It enables the system to present status names and descriptions in the language of the user's session, supporting multilingual implementations of Oracle EBS.

Key Information Stored

The table stores the translated text for material statuses, which are codes used to control the usability and transactionability of items and lots within inventory. The primary columns include STATUS_ID, which is the foreign key linking to the base definition in MTL_MATERIAL_STATUSES_B, and LANGUAGE, which holds the language code (e.g., 'US' for American English). The most critical user-facing column is DESCRIPTION, which contains the translated, descriptive name of the status (e.g., "Available", "Hold", "Quarantine") as it should appear in reports and forms for that language. The table also typically includes standard Oracle Applications columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY for auditing.

Common Use Cases and Queries

A primary use case is generating reports or building user interfaces that display material statuses in the correct locale. For instance, a warehouse pick slip report would join to this table to show status descriptions in the user's language. Common queries involve joining the translation table to the base table to get a complete, language-specific view of all defined statuses.

  • Sample Query to Retrieve Translated Statuses:
    SELECT msb.STATUS_CODE, mstl.DESCRIPTION, msb.DISABLE_DATE
    FROM INV.MTL_MATERIAL_STATUSES_B msb,
    INV.MTL_MATERIAL_STATUSES_TL mstl
    WHERE msb.STATUS_ID = mstl.STATUS_ID
    AND mstl.LANGUAGE = USERENV('LANG')
    ORDER BY msb.STATUS_CODE;
  • Data Fix Scenario: Updating a translated description for a specific status and language would target this table directly, using the STATUS_ID and LANGUAGE as the unique key.

Related Objects

The MTL_MATERIAL_STATUSES_TL table has a direct and critical relationship with its base table, as documented in the provided metadata.

  • MTL_MATERIAL_STATUSES_B: This is the primary related object. The foreign key MTL_MATERIAL_STATUSES_TL.STATUS_ID references MTL_MATERIAL_STATUSES_B.STATUS_ID. All translations are meaningless without a corresponding base definition. The base table holds the enabling/disabling flag, status code, and transaction controls.
  • Dependent Views/APIs: While not explicitly listed in the metadata, standard Oracle Applications views (such as MTL_MATERIAL_STATUSES_VL, where 'VL' denotes View, Localized) are typically built upon the _B and _TL tables to provide a single access point for translated data. Inventory and WMS APIs that retrieve or validate material statuses will internally reference these tables.