Maximo Open Forum

 View Only

 How to find parent items that are part of an Item Assembly Structure?

  • Inventory
Mack Parrott's profile image
Mack Parrott posted 02-06-2023 14:36

Item Assembly Structures are a hierarchy of items, defined in Item Master, sometimes referred to as a Bill of Material.  I’d like to build a saved query to find top level items that are part of an IAS.  Ideas?

Mack Parrott

Prashant Sharma's profile image
Prashant Sharma posted 02-07-2023 00:58
You can use save this Where Clause for Saved Query -

status != 'OBSOLETE' and itemnum in ( select itemnum from maximo.itemstruct where parent is null )

Related Content