Home » Applications » Oracle Fusion Apps & E-Business Suite » How to find Item Quantities in Inventory
How to find Item Quantities in Inventory [message #233083] Tue, 24 April 2007 10:08 Go to next message
world.apps
Messages: 70
Registered: January 2007
Location: Hyderabad
Member
Hi,

Could anybody tell me which inventory tables in back end have the onhand_quantity, available_quantity and reseved_quatity information.

Thanks in advance

Re: How to find Item Quantities in Inventory [message #233316 is a reply to message #233083] Wed, 25 April 2007 11:15 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
SELECT
si.secondary_inventory_name     subinv, 
si.description                         subinv_desc,
msi.description            item_description,
moh.revision                item_revision, 
moh.locator_id             locator_id,
msi.inventory_item_id        item_id,
msi.primary_uom_code      uom_code, 
nvl(moh.transaction_quantity,0)  item_qty
FROM 
   MTL_SYSTEM_ITEMS            msi,   
   MTL_ONHAND_QUANTITIES moh,
   MTL_SECONDARY_INVENTORIES si,
   MTL_ITEM_LOCATIONS mil
WHERE 
si.secondary_inventory_name = moh.subinventory_code(+)
and si.organization_id = moh.organization_id (+)
and moh.organization_id = msi.organization_id(+)
and moh.inventory_item_id = msi.inventory_item_id (+)
and moh.locator_id = mil.inventory_location_id(+) 
and moh.organization_id = mil.organization_id(+)
and si.quantity_tracked = 1
and si.organization_id = 
and msi.inventory_item_id =
ORDER BY 
si.secondary_inventory_name


try above you add sum so that you will one totalled record
Re: How to find Item Quantities in Inventory [message #233472 is a reply to message #233316] Thu, 26 April 2007 04:31 Go to previous message
world.apps
Messages: 70
Registered: January 2007
Location: Hyderabad
Member
Hi,

Thanks a lot.

Previous Topic: Oracle Service Contrats Conversion
Next Topic: PO_Requisition Workflows
Goto Forum:
  


Current Time: Tue Dec 06 16:18:45 CST 2016

Total time taken to generate the page: 0.08987 seconds