I have written several queries using SQLPlus for eventual use with Discoverer for Oracle Inventory Management.

Using the table APPS.MTL_ONHAND_QUANTITIES I can generate a list of on hand balances by Item. I have used an outer join to INV.MTL_SYSTEM_ITEMS_B to return items where zero balance occurs as a record in the on hand balances table only occurs if the balance <> zero. Trouble is there is no Locator available for these zero balance items, and I was wondering how other people had dealt with this previously ?

My only other idea is to look up last issue locator in the transactions file prior to zero balance and populate the field with this? Also, off the top of my head: If I used presepcified locators(for items) I guess this could be another lookup....

Can anyone offer some advice ?

Kind regards

RF