DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on DUAL

Line 397: FROM dual

393: -- Test for an OE demand input that is tied to a WIP supply and one that is not. }}
394: BEGIN
395: SELECT 1
396: INTO l_wip_exists
397: FROM dual
398: WHERE EXISTS (SELECT reservation_id
399: FROM mtl_reservations
400: WHERE organization_id = p_organization_id
401: AND inventory_item_id = p_inventory_item_id

Line 451: FROM dual

447: -- and one that is not. }}
448: BEGIN
449: SELECT 1
450: INTO l_non_wip_exists
451: FROM dual
452: WHERE EXISTS (SELECT reservation_id
453: FROM mtl_reservations
454: WHERE organization_id = p_organization_id
455: AND inventory_item_id = p_inventory_item_id