APPS.INV_MATERIAL_STATUS_PUB dependencies on MTL_ITEM_LOCATIONS

Line 131: SELECT status_id INTO l_old_status_id FROM mtl_item_locations

127:
128: elsif p_object_type = 'L' THEN
129: --Bug 14028205 Added the select statement
130: BEGIN
131: SELECT status_id INTO l_old_status_id FROM mtl_item_locations
132: WHERE organization_id = l_status_rec.organization_id
133: and inventory_location_id = l_status_rec.locator_id;
134: EXCEPTION
135: WHEN OTHERS THEN

Line 150: update mtl_item_locations

146: ,p_inventory_item_id => l_status_rec.inventory_item_id) ;
147:
148:
149: IF ( l_loc_fl ) then
150: update mtl_item_locations
151: set status_id = l_status_rec.status_id
152: , last_updated_by = l_status_rec.last_updated_by
153: , last_update_date = l_status_rec.last_update_date
154: , last_update_login = l_status_rec.last_update_login