| subinventories that have no locators [message #249099] |
Tue, 03 July 2007 06:50  |
Abeer30
Messages: 110
Registered: March 2007
|
Senior Member |
|
|
hello,
I have to develop an inventory report for oracle apps:
the query i have:
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';
my problem is that there are some subinventories that have no locators and the query would only work if the line :
and il.inventory_location_id = mwb.locator_id
was not there
what shall i do to include both options in my query?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
