APPS.INV_LOC_WMS_PUB dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 2420: /* Check if the locator is present in MTL_ONHAND_QUANTITIES_DETAIL

2416: If the value of p_validation_req_flag ='N' then
2417: delete the locator from MTL_ITEM_LOCATIONS table without validating further .
2418: Otherwise do the following steps */
2419: IF p_validation_req_flag = 'Y' THEN --If For Validation
2420: /* Check if the locator is present in MTL_ONHAND_QUANTITIES_DETAIL
2421: If the locator_id exists then error out*/
2422: BEGIN
2423: SELECT 1
2424: INTO l_chk_flag

Line 2427: FROM mtl_onhand_quantities_detail

2423: SELECT 1
2424: INTO l_chk_flag
2425: FROM DUAL
2426: WHERE EXISTS(SELECT 1
2427: FROM mtl_onhand_quantities_detail
2428: WHERE locator_id = l_inventory_location_id
2429: AND organization_id = l_organization_id);
2430:
2431: fnd_message.set_name('INV', 'INV_LOC_ONHANDQTY');