Results for “mtl_status_control_v”
20 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MTL_STATUS_CONTROL_V is a PL/SQL-free, read-only database view owned by the APPS schema in Oracle E-Business Suite Inventory (INV). It presents the intersection of material transaction types with their status-level transaction control rules. In EBS, material statuses govern whether a particular transaction — such as an issue, receipt, or subinventory transfer — is permitted for an item bearing a given status. The base table MTL_STATUS_TRANSACTION_CONTROL stores one row for each status/transaction-type combination, while MTL_TRANSACTION_TYPES defines the master list of transaction types. This view joins the two so that consumers can enumerate, per transaction type, which statuses are permitted or blocked.
Because it exposes denormalized, human-readable transaction descriptions alongside internal surrogate keys, the view is frequently used in reporting, data migration validation, and integration extracts. The metadata references TRANSACTION_DESCRIPTION as a key column, which corresponds directly to the alias of MTT.DESCRIPTION in the defining query. This makes the view particularly attractive when a search or report requires a readable label rather than a numeric transaction type identifier.
Underlying Base Objects
The view is defined over two SYNONYM-referenced base objects in the APPS schema:
- MTL_TRANSACTION_TYPES — the driving (left-hand) table in the outer join, aliased as
MTT. It suppliesTRANSACTION_SOURCE_TYPE_ID,TRANSACTION_TYPE_ID, andDESCRIPTION. - MTL_STATUS_TRANSACTION_CONTROL — the outer-joined (right-hand) table, aliased as
MSTC. It suppliesSTATUS_ID,IS_ALLOWED, and the row identifier.
The join is MTT.TRANSACTION_TYPE_ID = MSTC.TRANSACTION_TYPE_ID (+), an Oracle outer join, filtered by MTT.STATUS_CONTROL_FLAG = 1. The outer join ensures that transaction types which are status-controlled but have no control row for a given status still appear, with STATUS_ID null and IS_ALLOWED defaulted to 1 via NVL. The ROW_ID column is the ROWID of the control-table row; it is null when no control row exists.
Key Columns
ROW_ID— ROWID of the matchingMTL_STATUS_TRANSACTION_CONTROLrow; null where no control row is present.TRANSACTION_SOURCE_TYPE_ID— identifier of the transaction source category the transaction type belongs to.TRANSACTION_TYPE_ID— surrogate key of the material transaction type.TRANSACTION_DESCRIPTION— the readable description of the transaction type, sourced fromMTL_TRANSACTION_TYPES.DESCRIPTION.STATUS_ID— the material status whose control is described; null when no control row exists.IS_ALLOWED— flag indicating whether the transaction is permitted for the status; defaulted to 1 where the underlying value is null.
Common Use Cases and Queries
Typical uses include reporting which statuses permit a given transaction, building status/transaction matrices, validating migration data, and integrating control rules with external systems.
- List all permitted status/transaction combinations:
SELECT transaction_description, status_id FROM mtl_status_control_v WHERE is_allowed = 1; - Find blocked transactions by description:
SELECT transaction_description, status_id FROM mtl_status_control_v WHERE is_allowed = 0; - Search by readable description:
SELECT transaction_type_id, transaction_description FROM mtl_status_control_v WHERE transaction_description LIKE '%ISSUE%';
Because the view is owned by APPS, access is typically granted through the standard INV reporting responsibilities or a custom grant.
-
View: MTL_STATUS_CONTROL_V 12.2.2
APPS.MTL_STATUS_CONTROL_V·↳ MTL_STATUS_TRANSACTION_CONTROL·↳ MTL_TRANSACTION_TYPES·Explore INV module →
-
View: MTL_STATUS_CONTROL_V 12.1.1
APPS.MTL_STATUS_CONTROL_V·↳ MTL_STATUS_TRANSACTION_CONTROL·↳ MTL_TRANSACTION_TYPES·Explore INV module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - INV Tables and Views 12.2.2
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2