tables for creating stock aging report

hello all,

i DUNO if i am posting in the correct section ,

I need to design a report for stock aging  showing onhand item with received date, cost, and the supplier of the items, i have a problem is that the onhand item may be mixed with different reciept and different supplier, what tables should I use to do this report, can someone advise me the relationship of the tables.

I have this sql getting the supplier of the on hand item but, with only some of the item from Po receipt will display the supplier, i use the CREATE_TRANSACTION_ID from MTL_ONHAND_QTY_COST_V to link with the transaction_id from ,rcv_transactions , where it will be the transaction id in the material transaction search interface, rma receipt and misscellaneous will also output in the result, i also want to have the supplier of these receipt, and i found some of the id will be sales order pick, the qty is the sames of the onhand now.