Required query to get details in Fixed Assets

Hi Friends,

We need to get details from Oracle assets workbench. My requirement is to get periodic details of the asset with details like Asset number,asset type, Transaction Header id, Asset description, period effective ,period entered and Before asset and after asset details.

Here Before asset and After asset details is the same which we can see in asset enquiry screen after picking asset reference and then clicking on details button. When we click on details then it is showing as before and after value.

This value is showing in categories like, reclass, adjustment, transfer etc.