Results for “wms_txn_request_lines_trace_v”

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

Overview

The WMS_TXN_REQUEST_LINES_TRACE_V view is a reporting and integration object owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Warehouse Management (WMS) module. It presents a consolidated, denormalized view of move order transaction lines together with their header context, transaction type classifications, and the secondary inventory attributes of both the source and destination subinventories. The object carries a documented status of VALID in ETRM 12.2.2.

Its principal purpose is to support tracing of transaction request lines through the move order lifecycle. Rather than requiring consumers to join MTL_TXN_REQUEST_LINES to MTL_TXN_REQUEST_HEADERS, MTL_TRANSACTION_TYPES, and MTL_SECONDARY_INVENTORIES repeatedly, the view exposes line-level detail alongside descriptive columns such as MOVE_ORDER_TYPE_NAME, TRANSACTION_TYPE_NAME, and the destination subinventory's locator, asset, and quantity-tracking characteristics. This makes it well suited to operational reporting, data extraction, and downstream integration where a flat row per move order line is required.

Underlying Base Objects

The view text is defined over a set of APPS synonyms and one lookup view. The documented referenced base objects are:

• MTL_TXN_REQUEST_LINES (synonym) — the driving table, aliased MTRL; supplies line-level attributes including subinventory and locator identifiers, quantities, and status.
• MTL_TXN_REQUEST_HEADERS (synonym) — aliased MTRH; supplies REQUEST_NUMBER, MOVE_ORDER_TYPE, and header description.
• MTL_TRANSACTION_TYPES (synonym) — aliased MTT; supplies transaction source, type, action, and type name.
• MTL_SECONDARY_INVENTORIES (synonym) — aliased twice as MSS (from subinventory) and MSS1 (to subinventory); supplies locator type, asset inventory flag, quantity-tracked flag, and material account.
• MFG_LOOKUPS (view) — aliased MFG2; resolves the move order type code to its display meaning.
• WMS_RULE_TRACE_HEADERS (synonym) — aliased WRTH; supplies TOTAL_QTY and audit columns.
• WMS_LICENSE_PLATE_NUMBERS (synonym) and CST_COST_GROUPS (synonym) — additional referenced objects in the dependency list.

Standard EBS multi-org and language (MLS) security applies to the underlying inventory tables.

Key Columns

The view exposes a broad column set. Notable groupings include:

• Identifiers: LINE_ID, HEADER_ID, LINE_NUMBER, REQUEST_NUMBER, ORGANIZATION_ID, INVENTORY_ITEM_ID, REVISION.
• Source location: FROM_SUBINVENTORY_ID, FROM_SUBINVENTORY_CODE, FROM_LOCATOR_ID, plus derived FROM_SUB_LOCATOR_TYPE, FROM_SUB_ASSET, FROM_SUB_QUANTITY_TRACKED, FROM_SUB_MATERIAL_ACCOUNT.
• Destination location (the subject of the user's search term): TO_SUBINVENTORY_CODE, TO_SUBINVENTORY_ID, TO_LOCATOR_ID, TO_ACCOUNT_ID, SHIP_TO_LOCATION_ID. The TO_SUBINVENTORY_ID column is the foreign key to MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY for the receiving subinventory, and it is joined to the MSS1 alias to derive TO_SUB_LOCATOR_TYPE, TO_SUB_ASSET, TO_SUB_QUANTITY_TRACKED, and TO_SUB_MATERIAL_ACCOUNT.
• Classification: MOVE_ORDER_TYPE, MOVE_ORDER_TYPE_NAME, TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_TYPE_ID, TRANSACTION_TYPE_NAME, TRANSACTION_ACTION_ID.
• Quantities and status: QUANTITY (from WRTH.TOTAL_QTY), QUANTITY_DELIVERED, QUANTITY_DETAILED, UOM_CODE, LINE_STATUS, STATUS_DATE, DATE_REQUIRED, LOT_NUMBER, SERIAL_NUMBER_START, SERIAL_NUMBER_END.

Common Use Cases and Queries

Typical scenarios include move order status reporting, subinventory demand analysis, and traceability of put-away or replenishment activity. The following query filters by destination subinventory and move order type:

• SELECT request_number, line_number, to_subinventory_code, to_locator_id, to_sub_quantity_tracked, quantity, line_status FROM wms_txn_request_lines_trace_v WHERE to_subinventory_id = :p_sub AND organization_id = :p_org;
• SELECT transaction_type_name, move_order_type_name, COUNT(*) FROM wms_txn_request_lines_trace_v GROUP BY transaction_type_name, move_order_type_name;
• SELECT request_number, inventory_item_id, from_subinventory_code, to_subinventory_code, quantity_delivered FROM wms_txn_request_lines_trace_v WHERE reference = :p_ref;

Because join logic and lookup decoding are pre-applied, the view is appropriate for read-only reporting and extraction. Performance depends on indexes underlying the keyed tables, particularly on ORGANIZATION_ID, HEADER_ID, and TO_SUBINVENTORY_ID.