Results for “mtl_txn_request_lines”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MTL_TXN_REQUEST_LINES is the Inventory (INV) schema table that stores the individual line records of move order requests in Oracle E-Business Suite. A move order is an internal request to move material from one location to another within or across inventory organizations, and each row in this table corresponds to a single requested movement: an item, a source subinventory and locator, a destination subinventory and locator, a quantity, and a status. The table is owned by the INV schema, is documented as VALID in both 12.1.1 and 12.2.2, and contains 95 documented columns in the 12.2.2 physical schema.
The table operates as a child of MTL_TXN_REQUEST_HEADERS, which holds the move order header information such as the move order number, transaction type, and approval status. Together, headers and lines form the complete move order document used to authorize and track material movements, including subinventory transfers, inter-org transfers, and WIP-related supply movements.
Under a heuristic Data Vault classification derived from the foreign key structure, this table is a hub. It represents the core business concept of a move order line, keyed by a stable surrogate identifier, with descriptive attributes that change over the document lifecycle. This classification is a modeling suggestion and does not affect the physical structure of the table in EBS.
Key Information Stored
The primary key is LINE_ID, supported by the unique index MTL_TXN_REQUEST_LINES_PK. Two unique indexes serve as business-key candidates: MTL_TXN_REQUEST_LINES_U1 on LINE_ID and MTL_TXN_REQUEST_LINES_U2 on the combination of HEADER_ID and LINE_NUMBER. The latter establishes the natural business identity of a line: its move order header plus its line number.
LINE_ID— surrogate primary key for the line.HEADER_ID— foreign key toMTL_TXN_REQUEST_HEADERS, tying the line to its move order.LINE_NUMBER— sequence number of the line within the move order.ORGANIZATION_ID— the inventory organization in which the movement occurs.INVENTORY_ITEM_IDandREVISION— the item and revision being moved.FROM_SUBINVENTORY_CODEandFROM_LOCATOR_ID— source subinventory and locator.TO_SUBINVENTORY_CODEandTO_LOCATOR_ID— destination subinventory and locator.TO_ORGANIZATION_ID— destination organization for inter-org transfers.QUANTITY,QUANTITY_DELIVERED, andREQUIRED_QUANTITY— requested, delivered, and required amounts.LINE_STATUSandSTATUS_DATE— current lifecycle status and its timestamp.TRANSACTION_TYPE_IDandTRANSACTION_SOURCE_TYPE_ID— classification of the transaction to be performed.LOT_NUMBER,SERIAL_NUMBER_START, andSERIAL_NUMBER_END— lot and serial control values for the movement.DATE_REQUIRED— the date by which the move is required.REFERENCE_IDandREFERENCE_TYPE_CODE— the originating document, such as a kanban card.
Common Use Cases and Queries
Move order lines are central to warehouse operations, including picking, put-away, staging, and inter-org replenishment. Typical reporting scenarios include open move orders by organization and item, aging of undelivered lines, and reconciliation between requested and delivered quantities.
A query for open lines by organization might join headers and lines as follows:
SELECT l.line_id, h.request_number, l.line_number, l.inventory_item_id, l.quantity, l.line_status FROM mtl_txn_request_headers h, mtl_txn_request_lines l WHERE h.header_id = l.header_id AND l.organization_id = :org_id AND l.line_status < 5 ORDER BY l.date_required;
To trace actual executions against a move order line, join to MTL_MATERIAL_TRANSACTIONS.MOVE_ORDER_LINE_ID, which records the completed inventory transaction. Comparing QUANTITY with QUANTITY_DELIVERED identifies partially fulfilled lines and supports backorder analysis. Move order line data also feeds picking and shipping workflows through CSP_PICKLIST_LINES, CSP_PACKLIST_LINES, and CSP_MOVEORDER_LINES.
Related Objects
The most significant related objects, based on the documented foreign key relationships, are:
MTL_TXN_REQUEST_HEADERS— parent header, joined onHEADER_ID.MTL_MATERIAL_TRANSACTIONS— references this table viaMOVE_ORDER_LINE_IDand captures the executed transaction.MTL_SYSTEM_ITEMS_BandMTL_ITEM_REVISIONS_B— item and revision definitions joined viaINVENTORY_ITEM_ID(andORGANIZATION_ID,REVISION).MTL_SECONDARY_INVENTORIES— source and destination subinventories viaFROM_SUBINVENTORY_CODEandTO_SUBINVENTORY_CODE.MTL_PARAMETERS— organization context viaORGANIZATION_IDandTO_ORGANIZATION_ID.MTL_TRANSACTION_TYPESandMTL_TXN_SOURCE_TYPES— transaction classification.MTL_LOT_NUMBERSandMTL_SERIAL_NUMBERS— lot and serial control references.MTL_KANBAN_CARDSandMTL_KANBAN_CARD_ACTIVITY— kanban-sourced move orders viaREFERENCE_IDandDOCUMENT_DETAIL_ID.WIP_REPETITIVE_SCHEDULES— reference for repetitive manufacturing supply lines viaREPETITIVE_SCHEDULE_ID.GL_CODE_COMBINATIONS— accounting reference viaTO_ACCOUNT_IDfor account transfers.
-
Move order lines table
-
Move order lines table