APPS.WMS_CONTAINER_PVT dependencies on MTL_ITEM_LOCATIONS

Line 569: FROM mtl_item_locations mil

565: SELECT mil.location_weight_uom_code
566: , mil.volume_uom_code
567: INTO l_loc_wt_uom
568: , l_loc_vol_uom
569: FROM mtl_item_locations mil
570: WHERE mil.organization_id = p_organization_id
571: AND mil.subinventory_code = p_subinventory
572: AND mil.inventory_location_id = p_locator_id;
573:

Line 610: UPDATE mtl_item_locations mil

606:
607: IF ( wtdiff <> 0 OR voldiff <> 0 ) THEN
608: g_progress := 'Update Locator capacity';
609:
610: UPDATE mtl_item_locations mil
611: SET current_weight = nvl(current_weight,0) + wtdiff
612: , available_weight = nvl(available_weight,0) - wtdiff
613: , current_cubic_area = nvl(current_cubic_area,0) + voldiff
614: , available_cubic_area = nvl(available_cubic_area,0) - voldiff