Inventory Stock Report with custom criteria

Hello,

I need help on how to get the Stock Detail information with below information:

1. Item, Qty On hand, Qty Available, Lot No, Location, Unit Standard Cost (Cost Type 07), Unit Actual Cost (Cost Type 09), Transaction date.
2. Inventory Aging with the same data as no 1. but with custom Aging period that we can defined based on our needs.

Is there any report In JDE that can provide that information? , or if we need to use SQL, kindly help to provide which table we can use to get the data.

Note: We are using JDE Enterprise 9.2

Thank You.