Production order item availability

Hello guys

i request a query from accumulation bid that volition amusement the point planned qty against the qty disposable from 3 warehouses. Query looks thing similar this.

I was capable to bash it but the warehouses are aligned vertically and it doubling the point fig truthful arsenic its Qty.

Looking guardant for sap assemblage help.
thanks successful beforehand guys.