Results for “mtl_status_attribute_values”

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

Overview

MTL_STATUS_ATTRIBUTE_VALUES is a transaction and configuration table owned by the INV (Inventory) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the attribute values that are associated with item status codes, thereby allowing the attribute-driven behavior of an item status to be persisted and evaluated by the Inventory application. An item status code in Oracle Inventory can control which transactions, attributes, or functions are permitted or prohibited for items assigned that status; MTL_STATUS_ATTRIBUTE_VALUES captures the concrete value assigned to each named attribute for each status code.

The table is best understood as a link (association) entity within a heuristic Data Vault classification. It resolves a many-to-many relationship between two hubs: MTL_ITEM_STATUS (the status definition) and MTL_ITEM_ATTRIBUTES (the attribute definition). Each row asserts that a particular attribute takes a particular value for a particular item status code. This classification is mined from the foreign key structure and should be treated as a modeling suggestion rather than a mandated design.

Key Information Stored

The documented physical schema contains 12 columns. The most significant are described below.

• INVENTORY_ITEM_STATUS_CODE — The item status code for which attribute values are recorded. This is part of the composite primary key and a foreign key to MTL_ITEM_STATUS.
• ATTRIBUTE_NAME — The name of the item attribute being assigned a value. This is the second component of the composite primary key and a foreign key to MTL_ITEM_ATTRIBUTES.
• ATTRIBUTE_VALUE — The value assigned to the attribute for the given status code. This is the payload column that drives the actual behavior or configuration.
• LAST_UPDATE_DATE — Timestamp of the most recent modification to the row.
• LAST_UPDATED_BY — The application user who last updated the row.
• CREATION_DATE — Timestamp when the row was created.
• CREATED_BY — The application user who created the row.
• LAST_UPDATE_LOGIN — The login session associated with the last update.
• REQUEST_ID — Identifier of the concurrent request that created or last modified the row, where applicable.
• PROGRAM_APPLICATION_ID — The application that owns the concurrent program responsible for the last change.
• PROGRAM_ID — The concurrent program identifier responsible for the last change.
• PROGRAM_UPDATE_DATE — The date the concurrent program performed the last update.

The primary key is defined by MTL_STATUS_ATTRIBUTE_VALUES_PK over (INVENTORY_ITEM_STATUS_CODE, ATTRIBUTE_NAME). A unique index, MTL_STATUS_ATTRIBUTE_VALUES_U1, covers the same two columns and serves as the business-key candidate. There is no separate surrogate primary key column; the business key and the primary key coincide.

Common Use Cases and Queries

Typical use cases center on determining, reporting, and troubleshooting the attribute configuration that governs item status behavior. Administrators and developers query this table to understand why a given transaction is permitted or blocked for an item, or to compare configurations across environments.

A representative query lists all attribute values for a specific status code:

• SELECT attribute_name, attribute_value FROM mtl_status_attribute_values WHERE inventory_item_status_code = :status_code;

A join to the attribute definition enriches the output with descriptive metadata:

• SELECT v.inventory_item_status_code, v.attribute_name, v.attribute_value FROM mtl_status_attribute_values v, mtl_item_attributes a WHERE v.attribute_name = a.attribute_name AND v.inventory_item_status_code = :status_code;

Reporting use cases include auditing status configurations, migrating configuration between instances, and validating that expected attribute values exist before go-live. The PROGRAM_* columns support auditing changes made through concurrent programs.

Related Objects

The following objects are most significant in relation to MTL_STATUS_ATTRIBUTE_VALUES, based on the documented foreign key and primary key relationships.

• MTL_ITEM_STATUS — Referenced via MTL_STATUS_ATTRIBUTE_VALUES.INVENTORY_ITEM_STATUS_CODE. Defines the item status codes to which attribute values are attached.
• MTL_ITEM_ATTRIBUTES — Referenced via MTL_STATUS_ATTRIBUTE_VALUES.ATTRIBUTE_NAME. Defines the item attributes that may receive a value.
• MTL_SYSTEM_ITEMS_B — Items assigned an inventory item status code that indirectly depends on the attribute configuration stored in this table.
• MTL_ITEM_STATUS_TRANSITIONS — Governs permissible status transitions and is commonly configured alongside status attribute values.
• MTL_STATUS_ATTRIBUTE_VALUES_PK / MTL_STATUS_ATTRIBUTE_VALUES_U1 — The primary key constraint and unique index enforcing uniqueness of (INVENTORY_ITEM_STATUS_CODE, ATTRIBUTE_NAME).

Together these objects form the item status configuration model within Oracle Inventory, with MTL_STATUS_ATTRIBUTE_VALUES providing the attribute-level detail that determines how a status behaves.