Inventory Report Query

[AIMAM]

Hello,

The following report, with the following columns is required in oracle inventory:

Item Code, Item Description, Qty on Hand, Qty Issued by X,
Qty On Order, Expected deivery date,Toatl Received Qty,
Total received Qty in 9 months,Total issued quantity in 9 months,
Average monthly consumption, total qty on hand, covering months,
total qty on order, remarks

Any guidelines in the tables and joining conditions of the query would be very helpful.