Search Results mtl_status_attribute_values




Overview
Explore in AI Chat

Overview

The MTL_STATUS_ATTRIBUTE_VALUES table is a core data dictionary table within the Oracle E-Business Suite Inventory (INV) module. It functions as a junction table that defines the specific attribute-level permissions associated with item status codes. In Oracle EBS, an item status (e.g., Active, Inactive, Obsolete) controls which inventory and manufacturing transactions are allowed for an item. This table stores the granular, per-attribute settings that collectively define a status, specifying whether each discrete attribute (like "Purchasing Enabled" or "BOM Allowed") is set to 'Yes' or 'No' for a given status code. Its role is to provide the system with the rule set for validating item transactions based on status, making it fundamental to item lifecycle management and transaction control in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its composite primary key and its linkage to master reference tables. The key columns are:

Each row thus represents a single rule: for Status Code X, Attribute Y is set to Value Z.

Common Use Cases and Queries

This table is primarily accessed for configuration, validation, and reporting on item status behavior. A common administrative task is querying the complete definition of a status to understand its transactional permissions. For example, to see all attributes for the 'Active' status:

SELECT msav.attribute_name, msav.attribute_value, mia.description
FROM inv.mtl_status_attribute_values msav,
inv.mtl_item_attributes mia
WHERE msav.inventory_item_status_code = 'Active'
AND msav.attribute_name = mia.attribute_name
ORDER BY msav.attribute_name;

Conversely, to find which status codes permit a specific transaction, such as inventory transactions:

SELECT inventory_item_status_code
FROM inv.mtl_status_attribute_values
WHERE attribute_name = 'INV_TRANSACTIONS_ENABLED_FLAG'
AND attribute_value = 'Y';

This data is critical for troubleshooting when items cannot be processed in expected transactions, as the issue often traces back to a restrictive setting in this table.

Related Objects

MTL_STATUS_ATTRIBUTE_VALUES sits at the intersection of two key reference entities, as defined by its foreign keys:

  • MTL_ITEM_STATUS: The parent table containing the master list of status codes (INVENTORY_ITEM_STATUS_CODE). This table holds the code, meaning, and control level.
  • MTL_ITEM_ATTRIBUTES: The parent table defining all controllable transaction attributes (ATTRIBUTE_NAME). This provides the description and context for each attribute.

In application logic, the values stored in this table are enforced by the underlying Inventory APIs and forms, such as the Item Status and Item Master forms. When a user assigns a status to an item, the system implicitly applies all the attribute values defined in MTL_STATUS_ATTRIBUTE_VALUES for that status to govern the item's behavior.