APPS.INV_LOC_WMS_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 2559: /* Check if the locator is present in WMS_LICENSE_PLATE_NUMBERS

2555: WHEN NO_DATA_FOUND THEN
2556: NULL;
2557: END;
2558:
2559: /* Check if the locator is present in WMS_LICENSE_PLATE_NUMBERS
2560: If the LOCATOR_ID exists then error out*/
2561: BEGIN
2562: SELECT 1
2563: INTO l_chk_flag

Line 2566: FROM wms_license_plate_numbers

2562: SELECT 1
2563: INTO l_chk_flag
2564: FROM DUAL
2565: WHERE EXISTS(SELECT 1
2566: FROM wms_license_plate_numbers
2567: WHERE locator_id = l_inventory_location_id
2568: AND organization_id = l_organization_id);
2569:
2570: fnd_message.set_name('INV', 'INV_LOC_LPNEXIST');