I want a query which gives me following result.
1) Finished Goods from open sales order with order No.
2) All child item of above (Up to depth 18)
3) Ordered Qty from sales order
4) Instock Qty.
5) Planned Qty
6) Releases Qty
7) Pending to release qty
Please help me for the above query