Inventory Report Query
Posted: Mon May 26, 2008 5:45 am
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.
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.