APPS.INV_LOC_WMS_PUB dependencies on MTL_RESERVATIONS

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

2533: WHEN NO_DATA_FOUND THEN
2534: NULL;
2535: END;
2536:
2537: /* Check if the locator is present in MTL_RESERVATIONS
2538: If the locator_id exists then error out:
2539: */
2540: BEGIN
2541: SELECT 1

Line 2545: FROM mtl_reservations

2541: SELECT 1
2542: INTO l_chk_flag
2543: FROM DUAL
2544: WHERE EXISTS(SELECT 1
2545: FROM mtl_reservations
2546: WHERE locator_id = l_inventory_location_id
2547: AND organization_id = l_organization_id);
2548:
2549: fnd_message.set_name('INV', 'INV_LOC_RESERVE');