Search Results status_code_ndb

Overview

MTL_STAT_ATTRIB_VALUES_ALL_V is an Oracle E-Business Suite Inventory (INV) view owned by the APPS schema. Per the ETRM metadata, its documented description is "10SC ONLY," indicating that the object is restricted in scope and is not part of the general-purpose Inventory data model. The view presents status attribute values assigned to inventory items, joining item status attribute definitions to their controlling lookup values. Its naming convention reflects the "ALL" pattern common to EBS multi-organization views, though the underlying data is drawn from status attribute value records rather than being organization-stripped in the view text itself.

The view is designed to expose, for each inventory item status code, the attribute name, its displayed (GUI) name, the attribute value, and the control level meaning associated with the status. It is used in reporting and integration contexts where an application needs to resolve item status attribute assignments into human-readable or code-based values, particularly when the STATUS_CODE_NDB lookup code is relevant — the search term associated with this view.

Underlying Base Objects

The view text references three documented base objects:

• MTL_STATUS_ATTRIBUTE_VALUES (SYNONYM) — the driving table, aliased B, which stores the attribute name and attribute value assigned to each inventory item status code. Its ROWID is exposed as ROW_ID.
• MTL_ITEM_ATTRIBUTES (SYNONYM) — aliased C, joined on ATTRIBUTE_NAME = C.ATTRIBUTE_NAME, supplying the user-visible attribute name (USER_ATTRIBUTE_NAME_GUI) and the status control code used to drive the lookup join.
• MFG_LOOKUPS (VIEW) — aliased MFG1, restricted to LOOKUP_TYPE = 'ITEM_STATUS_CONTROL' and joined on LOOKUP_CODE = C.STATUS_CONTROL_CODE, providing the decoded control level meaning and the STATUS_CODE_NDB lookup code.

The relationship is therefore a three-way join: attribute values are keyed by attribute name to item attribute definitions, and those definitions are keyed by status control code to the ITEM_STATUS_CONTROL lookup set. This structure allows a single row of the view to carry both the raw status attribute data and its decoded control-level semantics.

Key Columns

• INVENTORY_ITEM_STATUS_CODE — the inventory item status code to which the attributes apply.
• STATUS_CODE_NDB — the lookup code drawn from MFG_LOOKUPS for the ITEM_STATUS_CONTROL lookup type; this is the column most directly relevant to searches on status_code_ndb.
• CONTROL_LEVEL_DISP — the decoded meaning of the status control level from MFG_LOOKUPS.
• ATTRIBUTE_NAME / ATTRIBUTE_NAME_DISP — the internal attribute name and its GUI display name from MTL_ITEM_ATTRIBUTES.
• ATTRIBUTE_VALUE / OLD_ATTRIBUTE_VALUE — the current attribute value, mirrored in both columns.
• Audit and concurrency columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and REQUEST_ID, inherited from the base attribute value rows, supporting change tracking and concurrent program identification.
• ROW_ID — the ROWID of the underlying MTL_STATUS_ATTRIBUTE_VALUES row.

Common Use Cases and Queries

Typical scenarios include auditing which attribute values are defined for a given item status, resolving the control level associated with a status, and extracting the STATUS_CODE_NDB values for downstream interface or conversion logic.

To list all attribute values for a specific status code:

• SELECT inventory_item_status_code, status_code_ndb, attribute_name, attribute_value FROM mtl_stat_attrib_values_all_v WHERE inventory_item_status_code = :p_status;

To locate rows by the searched term status_code_ndb:

• SELECT inventory_item_status_code, control_level_disp, attribute_name_disp, attribute_value FROM mtl_stat_attrib_values_all_v WHERE status_code_ndb = :p_ndb;

Because the view is documented as "10SC ONLY" and its text does not filter by organization, consumers should validate applicability within their specific implementation before relying on it for general Inventory reporting. Where broader or organization-scoped output is required, direct queries against MTL_STATUS_ATTRIBUTE_VALUES joined to MTL_ITEM_ATTRIBUTES and MFG_LOOKUPS are preferable and mirror the documented view definition exactly.