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'
