Search Results MTL_TXN_REQUEST_LINES

Overview

The MTL_TXN_REQUEST_LINES table is a core transactional entity within the Oracle E-Business Suite Inventory (INV) module, specifically for versions 12.1.1 and 12.2.2. It serves as the detailed lines table for move orders, which are internal requests to transfer material within or between organizations. Each record represents a single line item on a move order header, defining the specific item, quantity, source, destination, and other control attributes required to execute a material transaction. The table's integrity is maintained through a primary key on LINE_ID and a comprehensive network of foreign key relationships to master and transactional data across Inventory, Warehouse Management (WMS), and General Ledger.

Key Information Stored

The table stores detailed line-level data for move order requests. The primary identifier is the LINE_ID. Critical columns include HEADER_ID, linking the line to its parent record in MTL_TXN_REQUEST_HEADERS, and the core transaction-defining attributes: INVENTORY_ITEM_ID, ORGANIZATION_ID, QUANTITY, and UOM_CODE. Source and destination details are captured in FROM_SUBINVENTORY_CODE, FROM_LOCATOR_ID, TO_SUBINVENTORY_CODE, and TO_LOCATOR_ID. Transaction control is managed via TRANSACTION_TYPE_ID and TRANSACTION_SOURCE_TYPE_ID. For lot- and serial-controlled items, the table stores LOT_NUMBER, SERIAL_NUMBER_START, and SERIAL_NUMBER_END. Other significant columns include REASON_ID, STATUS (tracking the line's approval and transacted state), TO_ACCOUNT_ID for accounting, and PICK_STRATEGY_ID/PUT_AWAY_STRATEGY_ID for WMS-directed tasks.

Common Use Cases and Queries

This table is central to move order execution, reporting, and troubleshooting. Common operational queries involve identifying lines pending pick release or transaction completion. For example, to find all pending lines for a specific item, a query would join MTL_TXN_REQUEST_LINES to MTL_TXN_REQUEST_HEADERS and filter on STATUS and INVENTORY_ITEM_ID. Reporting on move order volume by subinventory typically aggregates quantities from this table grouped by FROM_SUBINVENTORY_CODE. When diagnosing transaction errors, developers often trace the source data from the MTL_MATERIAL_TRANSACTIONS table back to the originating line in MTL_TXN_REQUEST_LINES via the TRANSACTION_SOURCE_ID and TRANSACTION_SOURCE_LINE_ID columns. Data fixes for stuck move order lines are performed directly on this table, primarily updating the STATUS column after validating business rules.

Related Objects

MTL_TXN_REQUEST_LINES has extensive foreign key relationships, as documented in the ETRM. Key dependencies include:

• MTL_TXN_REQUEST_HEADERS: The parent header via HEADER_ID.
• MTL_SYSTEM_ITEMS_B: Validates the item and organization (INVENTORY_ITEM_ID, ORGANIZATION_ID).
• MTL_SECONDARY_INVENTORIES: Validates source and destination subinventories (FROM_SUBINVENTORY_CODE, TO_SUBINVENTORY_CODE with ORGANIZATION_ID).
• MTL_TRANSACTION_TYPES & MTL_TXN_SOURCE_TYPES: Define the transaction action and source (TRANSACTION_TYPE_ID, TRANSACTION_SOURCE_TYPE_ID).
• MTL_LOT_NUMBERS & MTL_SERIAL_NUMBERS: Validate lot and serial data for controlled items.
• GL_CODE_COMBINATIONS: The destination account (TO_ACCOUNT_ID).
• MTL_TRANSACTION_REASONS: The reason code (REASON_ID).
• WMS_STRATEGIES_B: Picking and put-away strategies (PICK_STRATEGY_ID, PUT_AWAY_STRATEGY_ID).