We have IBM's maximo in our plant, and it's linked to the local part inventory. It is a chore to maintain though, so it becomes a system which introduces a LOT of red tape.
For example, only a few people in the maintenance team have immediate access to a PC. They may have to go to the maximo link and find spares by searching the part number, but since the system works on keywords, it becomes an extreme data entry based system where one misplaced '-' can cause issues.
It also does work order tracking, but making work orders for emergency tasks is unsustainable to an extent, as people just don't want to do data entry.
Another big aspect is to have the hierarchy of the plant. It is usually defined in a non-controls layout, which causes inventory to be all over the place again.
With all that said, there is a way to automate the work order generation and get them flying smoothly. It also offers a place for business teams to bring in their skills with inventory management.
Don't know of other systems, but Maximo is what we use, in a bad fashion at my location at least.