APPS.INV_LOC_WMS_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

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

2459: WHEN NO_DATA_FOUND THEN
2460: NULL;
2461: END;
2462:
2463: /* Check if the locator is present in WMS_LICENSE_PLATE_NUMBERS
2464: If the LOCATOR_ID exists then error out*/
2465: BEGIN
2466: SELECT 1
2467: INTO l_chk_flag

Line 2470: FROM wms_license_plate_numbers

2466: SELECT 1
2467: INTO l_chk_flag
2468: FROM DUAL
2469: WHERE EXISTS(SELECT 1
2470: FROM wms_license_plate_numbers
2471: WHERE locator_id = l_inventory_location_id
2472: AND organization_id = l_organization_id);
2473:
2474: fnd_message.set_name('INV', 'INV_LOC_LPNEXIST');