AR Custom report to derive Primary and Secondary ledger jrnl details along with AR invoice informati

Hi,

We are on R12.2.4

We are working on some AR Custom report which will pull the below details from both GL Primary and GL Secondary along with details from XLA tables

1. GL Journal Batch name

2. Journal Name

3. Journal Line Number

4. Accounted Dr/Accounted Cr

5. Customer Name

6. Customer Site

7. Invoice/Receipt Number

Report format is some thing like:-

Primary Ledger Jrnl Batch Name

Primary Ledger Jrnl Name

Primary ledger JE Line number

Primary ledger Accounted Dr

Primary Ledger Accounted Cr

Secondary Ledger Jrnl Batch Name

Secondary Ledger Jrnl Name

Secondary ledger JE Line Number

Secondary ledger Accounted Dr

Secondary Ledger Accounted Cr