Inventory Management - EBS (MOSC)

MOSC Banner

How to create a SQL Expression to honor SO Reservations

edited Mar 9, 2020 5:03AM in Inventory Management - EBS (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center