SQL Query to extract Item Locators

Summary:

SQL Query to extract Item Locators

Content (please ensure you mask any confidential information):

Hi - I wondered if anyone might be able to help please, with advising about a query that can be used to extract the Locator for an Inventory Item?

This is the navigation I am following:

Manufacturing and Supply Chain Materials Management > Manage Subinventories and Locators

Search for and select Subinventory > Manage Item Subinventories:

Select Item > Manage Item Locators:

Locator for item is returned:

I can get Location data from INV_ONHAND_QUANTITIES_DETAIL but I don't want to use that table because items without any On Hand QTY still have Locators associated with them.