The Scottish corporate giant that has played a leading role throughout Aberdeen’s oil and gas era is being taken over.…