Is there any query available to get the GL Transfer Date of a given AP Invoice

Summary

Is there any query available to get the GL Transfer Date of a given AP Invoice

Content

We are developing a custom report in which I have to get following two information:

• Accounting Date, which is recorded in AP invoice header
• Actual GL Transfer Date

Is there any simple query available to get GL Transfer Date of a given invoice, without referring to subledger tables(xla_ae_headers)?

I am looking for something like:

Select get_gl_transfer_Date(invoice_id) from ap_invoices_all where invoice_num='INV-001'