Total Pageviews

May 11, 2017

5/11/2017 02:35:00 PM
Oracle apps Inventory Locators

 Oracle Applications :Inventory :Locators

Functional:

Is it possible to  use same locator for two different sub inventory locations ?


Locator to Sub inventory is a one-to-one relationship. Sub inventory to Locator is a one to many.  We have to create different locator.


Technical :
Query sub inventories with locators and those with no locators


select
mwb.organization_id, mwb.organization_code,
mwb.subinventory_code,
mwb.locator_id, mwb.locator,
mwb.inventory_item_id, mwb.item, mwb.item_description,
mwb.uom, mwb.on_hand
,cic.item_cost
from MTL_ONHAND_TOTAL_MWB_V mwb
,cst_item_cost_type_v cic
,mtl_item_locations_kfv il
where 1=1
and cic.inventory_item_id = mwb.inventory_item_id
and cic.organization_id = mwb.organization_id
and cic.COST_TYPE = 'Average'
and il.inventory_location_id(+) = mwb.locator_id
and mwb.SUBINVENTORY_CODE = 'xxx'