← All tables
Oracle Fusion/Supply Chain/Inventory
MTL_RESERVATIONS
Reservations — hard links between a supply (on-hand, PO, WIP) and a demand (sales order, WIP component).
Key Columns
RESERVATION_IDORGANIZATION_IDINVENTORY_ITEM_IDDEMAND_SOURCE_TYPE_IDDEMAND_SOURCE_HEADER_IDDEMAND_SOURCE_LINE_IDRESERVATION_QUANTITYSUPPLY_SOURCE_TYPE_ID
Used In
InventoryOrder ManagementManufacturing
Notes
DEMAND_SOURCE_TYPE_ID 2 = sales order; DEMAND_SOURCE_LINE_ID then holds OE_ORDER_LINES_ALL.LINE_ID / DOO fulfillment line id.
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.