Subledger Journals in detail

Dear All,

We are using EBS 12.2.12.

For business needs, we need subledger journal reports with data related to the transaction, for Inventory, AP & AR

For example:

==>In Inventory: we are using Lot Cost Controlled item. Organizations are OPM enabled.

There is a report <Detailed Subledger Report>, but it does not include transaction detailed data.

We need a report that include:

Account code and description, transaction date and amount, Inventory item, Transaction type (receiving, issue..etc), lot number, quantity, Period, Lot cost..etc

We have custom query, selecting data from (XLA_AE_HEADERS XAH, XLA_AE_LINES), but standard report or Query from Oracle is more reliable and trustworthy to any stakeholder.