Item On hand Quantity

Item on hand Quantity

SELECT   msi.segment1, SUM (mq.transaction_quantity) on_hand,
         ood.organization_name, mq.subinventory_code
    FROM apps.org_organization_definitions ood,
         apps.mtl_onhand_quantities mq,
         apps.mtl_system_items_b msi
   WHERE 1 = 1
     AND mq.organization_id = msi.organization_id
     AND ood.organization_id = msi.organization_id
     AND mq.inventory_item_id = msi.inventory_item_id
     AND msi.segment1 = :P_ITEM_CODE               ------- pass segment1 here
GROUP BY msi.segment1, ood.organization_name, mq.subinventory_code