Join Subledger Tables to AP_INVOICE_DISTRIBUTIONS_ALL

Summary:

I'm not sure if this belongs more in the Reporting forums, however I am looking to join any of the following Subledger accounting tables to the AP_INVOICE_DISTRIBUTIONS_ALL table.

Content (required):

I am looking to join any of the following Subledger accounting tables to the AP_INVOICE_DISTRIBUTIONS_ALL table.

xla_ae_headers xah,

xla_ae_lines xal,

fnd_application_tl fat,

gl_import_references gir,

gl_je_lines gjl,

gl_code_combinations gcc,

gl_je_headers gjh,

gl_je_batches gjb,

xla_events xe,

xla_transaction_entities xte,

ap_invoices_all aia,

hz_parties hp,

gl_ledgers gll