How to create a SQL Expression to honor SO Reservations
How to create a SQL Expression in Oracle WMS Rules to honor SO Reservations.
Using a query with pick from the locator which is reserved at the Sales Order
select mr.locator_id
from mtl_reservations mr,oe_order_lines_all oel,
where 1=1
and mr.organization_id = oel.ship_from_org_id
and mr.inventory_item_id = oel.inventory_item_id
and mr.demand_source_line_id = oel.line_id
and mr.organization_id = ?? ACTUAL TRANSACTION DRIVEN PARAMETER
and mr.inventory_item_id = ?? ACTUAL TRANSACTION DRIVEN PARAMETER
and oel.line_id = ?? ACTUAL TRANSACTION DRIVEN PARAMETER