However, in some cases you would like to have a query giving you the available quantyity of a item. Rananthaus, a tech. lead and project manager from California, pointed me to MTL_ONHAND_QUANTITIES. The query below which I wrote will give you the available quantity of an item per organisation, sub-inventory. You can use this query to build upon and enrich your application. I have tested it on a 11.5.10 instance, if you deploy it on an other version please do send me a mail or comment so I can blog that this is also working on other versions.