You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need a Non-Unique Index on CSE_PARTS_LIST_COMPONENTS by Org and Item

Received Response
edited Mar 26, 2020 12:55PM in Maintenance 4 comments


To find obsolete MRO inventory parts we need an index into the CSE_PARTS_LIST_COMPONENTS table to search it effectively


Our client uses the Asset Parts List extensively and associates every MRO item to an asset. (Common items are associated to the warehouse.) Once an asset is retired very likely there could be MRO items associated with that asset in the warehouse taking up space, items that they could sell to recoup some of their cost.

A non-unique index on the CSE_PARTS_LIST_COMPONENTS table by Item_Organization_ID and Item_ID would allow us to quickly compare the warehouse's inventory with the Assets Parts List to see whether these obsolete inventory items exist.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!