Oracle Fusion/Supply Chain/Inventory

MTL_TXN_REQUEST_HEADERS

Move order headers — a request to move material between subinventories or issue it to an account / job.

Key Columns

HEADER_IDREQUEST_NUMBERORGANIZATION_IDMOVE_ORDER_TYPETRANSACTION_TYPE_IDSTATUS_DATE

Child Tables

MTL_TXN_REQUEST_LINES

Move order lines — item, quantity, source and destination subinventory, and the line's allocation / transact status.

Common Joins

MTL_TXN_REQUEST_LINESvia HEADER_ID

The item lines on the move order.

Used In

InventoryManufacturing

Notes

MOVE_ORDER_TYPE 1 = move order requisition, 2 = replenishment, 3 = pick wave, 6 = WIP.

Inventory supply, demand and reservations

Inbound supply is summarised in MTL_SUPPLY; MTL_RESERVATIONS hard-links a supply to a demand such as a sales order line. Internal movement is requested through move orders (MTL_TXN_REQUEST_HEADERS / _LINES) and executed as MTL_MATERIAL_TRANSACTIONS.