Inventory Report Query [message #322774] |
Mon, 26 May 2008 03:45 |
Abeer30
Messages: 110 Registered: March 2007
|
Senior Member |
|
|
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.
|
|
|