I need to return the latest component subinventory and locator in a work definition in an OTBI query — Cloud Customer Connect
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

I need to return the latest component subinventory and locator in a work definition in an OTBI query

in Manufacturing 2 comments

I'm looking to extract out the the latest version of a work definitions, the components within a work definition and the subinventory and locators.

I curently have an OTBI query, that returns the latest version of a work definition item, using end date = Null, but it is returning the component item from all versions,

In the example below, the item is 103853MK with a current revision work definition of 2. It has a single component within it, 103853, but which is the correct subinventory/locator, as one is in V1 and the other is from V2?

Item Name

Item User Item Type

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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