APPS.INV_LOC_WMS_PUB dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 38: FROM mtl_onhand_quantities_detail

34: END IF;
35: END IF;
36: IF l_ret_status THEN
37: SELECT count(1) INTO l_dummy
38: FROM mtl_onhand_quantities_detail
39: WHERE locator_id = p_loc_id
40: AND organization_id = p_org_id
41: AND ROWNUM =1 ;
42: IF (l_dummy > 0 )THEN

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

2512: If the value of p_validation_req_flag ='N' then
2513: delete the locator from MTL_ITEM_LOCATIONS table without validating further .
2514: Otherwise do the following steps */
2515: IF p_validation_req_flag = 'Y' THEN --If For Validation
2516: /* Check if the locator is present in MTL_ONHAND_QUANTITIES_DETAIL
2517: If the locator_id exists then error out*/
2518: BEGIN
2519: SELECT 1
2520: INTO l_chk_flag

Line 2523: FROM mtl_onhand_quantities_detail

2519: SELECT 1
2520: INTO l_chk_flag
2521: FROM DUAL
2522: WHERE EXISTS(SELECT 1
2523: FROM mtl_onhand_quantities_detail
2524: WHERE locator_id = l_inventory_location_id
2525: AND organization_id = l_organization_id);
2526:
2527: fnd_message.set_name('INV', 'INV_LOC_ONHANDQTY');