AP to GL reconciliation - How to pull all Payables Accounts

Hello experts,

  We are on EBS R12.1.2. Our purpose is to extract feeds from subledgers (AP, AR, FA, Projects etc.), so that it can be tied to General ledger extract. The reconciliation will be done by a third party software.

1. From SLA tables, I want to find every account and corresponding balance amount for a given date range. How to do it for AP subledger ?. I would like to capture all scenarios of AP Accounting, so that am comprehensively reconciling with GL extract ? Any functional / technical pointers will be of IMMENSE help to us.

Thanks for your valuable time.

Ravi