APPS.WMS_CONTAINER_PVT dependencies on MTL_ITEM_LOCATIONS

Line 563: FROM mtl_item_locations mil

559: SELECT mil.location_weight_uom_code
560: , mil.volume_uom_code
561: INTO l_loc_wt_uom
562: , l_loc_vol_uom
563: FROM mtl_item_locations mil
564: WHERE mil.organization_id = p_organization_id
565: AND mil.subinventory_code = p_subinventory
566: AND mil.inventory_location_id = p_locator_id;
567:

Line 604: UPDATE mtl_item_locations mil

600:
601: IF ( wtdiff <> 0 OR voldiff <> 0 ) THEN
602: g_progress := 'Update Locator capacity';
603:
604: UPDATE mtl_item_locations mil
605: SET current_weight = nvl(current_weight,0) + wtdiff
606: , available_weight = nvl(available_weight,0) - wtdiff
607: , current_cubic_area = nvl(current_cubic_area,0) + voldiff
608: , available_cubic_area = nvl(available_cubic_area,0) - voldiff