Skip to main content
OracleOps AI
← All tables
Oracle Fusion/Supply Chain/Inventory

MTL_TXN_REQUEST_LINES

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

Key Columns

LINE_IDHEADER_IDINVENTORY_ITEM_IDORGANIZATION_IDQUANTITYQUANTITY_DELIVEREDFROM_SUBINVENTORY_CODETO_SUBINVENTORY_CODELINE_STATUS

Parent Table

MTL_TXN_REQUEST_HEADERS

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

Used In

Inventory

Notes

LINE_STATUS 7 = pre-approved, 5 = approved / open, 3 = closed, 6 = cancelled.

Related

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.

Ask Oracle AI about MTL_TXN_REQUEST_LINES