Required SQL Query

Dear All,

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

Ashish Gupte