Results for “mtl_txn_request_lines_u2”
10 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MTL_TXN_REQUEST_LINES is the transactional line-level table within the Oracle Inventory (INV) schema that stores all move order lines in Oracle EBS 12.1.1 and 12.2.2. The table is owned by INV and is registered in FND Design Data as INV.MTL_TXN_REQUEST_LINES with a status of VALID. Each row represents a request to move a specified quantity of an item from a source location or subinventory to a destination location, subinventory, or account. Every move order line must belong to a specific move order header, enforced through the HEADER_ID foreign key to MTL_TXN_REQUEST_HEADERS.
The table participates directly in the move order lifecycle. When a line is detailed or pick released, the detailed quantity is updated on the line and corresponding transaction rows are inserted into MTL_MATERIAL_TRANSACTIONS_TEMP. When those pending transactions are subsequently transacted, the delivered quantity (QUANTITY_DELIVERED) is updated on the line, providing a running reconciliation between what was requested, what was picked, and what was moved. The table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and all indexes are held in APPS_TS_TX_IDX.
From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying MTL_TXN_REQUEST_LINES as a hub. It carries a single-column surrogate primary key (LINE_ID) and holds many foreign-key references to independent master entities such as items, subinventories, transaction types, and organizations, which is characteristic of a hub surrounded by referenced dimensions and subsequent link/satellite structures.
Key Information Stored
The table contains 95 documented columns. The most operationally significant columns include:
- LINE_ID – Surrogate primary key for the move order line; enforced by unique index MTL_TXN_REQUEST_LINES_U1 and by MTL_TXN_REQUEST_LINES_PK.
- HEADER_ID – Foreign key to MTL_TXN_REQUEST_HEADERS, tying the line to its parent move order.
- LINE_NUMBER – Sequential line number within the header; together with HEADER_ID it forms the business-key candidate enforced by unique index MTL_TXN_REQUEST_LINES_U2.
- ORGANIZATION_ID – Source inventory organization (FK to MTL_PARAMETERS).
- INVENTORY_ITEM_ID – Item being moved (FK to MTL_SYSTEM_ITEMS_B).
- FROM_SUBINVENTORY_CODE / TO_SUBINVENTORY_CODE – Source and destination subinventories.
- FROM_LOCATOR_ID / TO_LOCATOR_ID – Source and destination locators.
- TO_ACCOUNT_ID – Destination account for account-based moves (FK to GL_CODE_COMBINATIONS).
- QUANTITY, QUANTITY_DETAILED, QUANTITY_DELIVERED – Requested, picked/detailed, and transacted quantities.
- LINE_STATUS – Current status of the line in the move order flow.
- TRANSACTION_TYPE_ID / TRANSACTION_SOURCE_TYPE_ID / TXN_SOURCE_ID – Transaction classification and source references.
- REVISION, LOT_NUMBER, SERIAL_NUMBER_START, SERIAL_NUMBER_END – Item revision and lot/serial control attributes.
- DATE_REQUIRED, PICK_SLIP_NUMBER, PICK_SLIP_DATE – Scheduling and pick slip tracking.
- TO_ORGANIZATION_ID – Destination organization for inter-org move orders.
- LPN_ID / TO_LPN_ID – License plate numbers used in warehouse management flows.
Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), the 15 ATTRIBUTE columns plus ATTRIBUTE_CATEGORY, and request/program tracking columns (REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID) complete the schema.
Common Use Cases and Queries
Typical scenarios include tracking open move order lines, reconciling pick slip activity, monitoring inter-org transfer requests, and reporting on move order throughput. The unique index MTL_TXN_REQUEST_LINES_U2 on (HEADER_ID, LINE_NUMBER) is commonly used to retrieve a specific line within a header.
Query all lines belonging to a move order header:
- SELECT LINE_ID, LINE_NUMBER, INVENTORY_ITEM_ID, QUANTITY, QUANTITY_DETAILED, QUANTITY_DELIVERED, LINE_STATUS FROM MTL_TXN_REQUEST_LINES WHERE HEADER_ID = :header_id ORDER BY LINE_NUMBER;
Locate open lines by organization and status (utilizes MTL_TXN_REQUEST_LINES_N2, which covers ORGANIZATION_ID, LINE_STATUS, FROM_SUBINVENTORY_CODE, TO_SUBINVENTORY_CODE):
- SELECT h.REQUEST_NUMBER, l.LINE_NUMBER, l.INVENTORY_ITEM_ID, l.FROM_SUBINVENTORY_CODE, l.TO_SUBINVENTORY_CODE, l.QUANTITY, l.QUANTITY_DELIVERED FROM MTL_TXN_REQUEST_LINES l, MTL_TXN_REQUEST_HEADERS h WHERE l.HEADER_ID = h.HEADER_ID AND l.ORGANIZATION_ID = :org_id AND l.LINE_STATUS = :status;
Trace consumed lines back to inventory transactions via MTL_MATERIAL_TRANSACTIONS.MOVE_ORDER_LINE_ID, and report delivered-versus-requested variance to highlight short picks. Pending transactions can be inspected through MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TEMP_ID. Pick slip reporting uses MTL_TXN_REQUEST_LINES_N5 on PICK_SLIP_NUMBER, while kanban-driven moves join on REFERENCE_ID against MTL_KANBAN_CARDS.
Related Objects
The following tables reference or are referenced by MTL_TXN_REQUEST_LINES through documented foreign keys:
- MTL_TXN_REQUEST_HEADERS – Parent move order header; joined on HEADER_ID.
- MTL_MATERIAL_TRANSACTIONS / MTL_MATERIAL_TRANSACTIONS_TEMP – Reference the line via MOVE_ORDER_LINE_ID; the temp table holds pending transactions before completion.
- MTL_SYSTEM_ITEMS_B – Item definition referenced via INVENTORY_ITEM_ID.
- MTL_SECONDARY_INVENTORIES – Source and destination subinventories via FROM_SUBINVENTORY_CODE and TO_SUBINVENTORY_CODE.
- MTL_PARAMETERS – Source and destination organizations (ORGANIZATION_ID, TO_ORGANIZATION_ID).
- MTL_TRANSACTION_TYPES / MTL_TXN_SOURCE_TYPES – Transaction classification references.
- MTL_KANBAN_CARDS – Kanban-driven moves through REFERENCE_ID.
- WMS_TRANSACTIONS_TEMP / WMS_TXN_CONTEXT_TEMP – Warehouse management processing tables that carry LINE_ID references.
- CSP_MOVEORDER_LINES, CSP_PICKLIST_LINES, CSP_PACKLIST_LINES – Shipping execution downstream tables referencing LINE_ID.
- WIP_REPETITIVE_SCHEDULES / WIP_ENTITY_ID – Manufacturing supply references for move order lines generated by WIP.
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
Move order lines table
-
Move order lines table
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2