Following query returns Demand and reservation information used in Available To Promise, Planning and other Manufacturing functions.
There are three major row types stored in the table
· Summary Demand rows
· Open Demand Rows
· Reservation Rows.
SELECT SUBSTR (md.demand_id, 1, 8) ID,
SUBSTR (demand_source_header_id, 1, 8) demand_source_header_id,
SUBSTR (parent_demand_id, 1, 8) parent_demand_id,
SUBSTR (demand_source_line, 1, 10) demand_source_line_id,
SUBSTR (demand_source_delivery, 1, 10) demand_source_delivery,
SUBSTR (inventory_item_id, 1, 10) “Item Id”,
(SELECT UNIQUE msi.description
FROM mtl_system_items_b msi
WHERE msi.inventory_item_id =
SUBSTR (md.inventory_item_id,
1,
10
)) “Item Description”,
SUBSTR (inventory_item_id, 1, 10) item_id,
SUBSTR (organization_id, 1, 5) organization_id,
SUBSTR (reservation_quantity, 1, 5) reservation_quantity,
SUBSTR (primary_uom_quantity, 1, 5) primary_uom_quantity,
SUBSTR (reservation_type, 1, 5) reservation_type,
SUBSTR (requirement_date, 1, 10) requirement_date,
SUBSTR (subinventory, 1, 10) subinventory,
SUBSTR (serial_number, 1, 10) srl_num,
SUBSTR (lot_number, 1, 10) lot_num
FROM mtl_demand md
