APPS.INV_LOC_WMS_PUB dependencies on MTL_RESERVATIONS

Line 2441: /* Check if the locator is present in MTL_RESERVATIONS

2437: WHEN NO_DATA_FOUND THEN
2438: NULL;
2439: END;
2440:
2441: /* Check if the locator is present in MTL_RESERVATIONS
2442: If the locator_id exists then error out:
2443: */
2444: BEGIN
2445: SELECT 1

Line 2449: FROM mtl_reservations

2445: SELECT 1
2446: INTO l_chk_flag
2447: FROM DUAL
2448: WHERE EXISTS(SELECT 1
2449: FROM mtl_reservations
2450: WHERE locator_id = l_inventory_location_id
2451: AND organization_id = l_organization_id);
2452:
2453: fnd_message.set_name('INV', 'INV_LOC_RESERVE');