SQL & PL/SQL

Hi,

Working on EBS Version: 11.5.10.2

I need to create a new inventory aging report based on these below transactions types name and consider only positive quantity.

Transactions Types Names :
----------------------------------------
RMA Receipt
Miscellaneous receipt
WIP Assy Completion
PO Receipt
WIP Component Return
Cycle Count Adjust
PO Rcpt Adjust
Account receipt
WIP Assembly Return
WIP Neg Comp Issue

As of aging till current date < 31 days
31-60 days
61-90 days
91- 180 days
181 - 365 days
366 - 730 days If anybody has already developed this report, please let me have the query same or need help on this issue.


Thanks and Regards