Query to get Inventory on hand quantity details in fusion.

SELECT esi.inventory_item_id,

esi.item_number,

esi.organization_id,

inv.organization_code,

esi.enabled_flag,

esi.end_date_active,

ohq.transaction_quantity onhand_qty

  FROM fusion.egp_system_items_b esi,

fusion.inv_org_parameters inv,

fusion.inv_onhand_quantities_detail ohq

 WHERE  inv.organization_id=esi.organization_id

   AND inv.organization_id=ohq.organization_id

   AND esi.inventory_item_id=ohq.inventory_item_id