Oracle Fusion - Trying to recreate an OTBI analysis using a custom report

We have created an OTBI analysis that displays the following categories:

Account Code, Invoice Distribution Amount, Accounted Amount CR, Accounted Amount DR, Invoice Number, Supplier Number, Supplier, Invoice Line Description

The goal of the desired report is to display AP Invoice Payment data at the line level for each invoice for both suppliers and parties. Due to the data limits on OTBI analyses, we are trying to recreate this report using a custom SQL query. We have been able to pull back most of this data using a custom SQL statement that queries the following tables:

xla_ae_lines

xla_ae_headers