GL_XLA_AP

SELECT
apd.*
FROM
GL.GL_LEDGERS GL
,GL.GL_JE_BATCHES GLB
,GL.GL_JE_HEADERS GLH
,GL.GL_JE_LINES GLL
,GL.GL_IMPORT_REFERENCES GLIR
,XLA.XLA_AE_LINES XLL
,XLA.XLA_AE_HEADERS XLH
,XLA.XLA_EVENTS XLE
,XLA.XLA_TRANSACTION_ENTITIES XLTE
,XLA.XLA_DISTRIBUTION_LINKS XLDL
,ap.ap_invoices_all aph
,ap.ap_invoice_lines_all apl
,ap.ap_invoice_distributions_all apd
WHERE
GL.CHART_OF_ACCOUNTS_ID = GLB.CHART_OF_ACCOUNTS_ID AND
GL.PERIOD_SET_NAME = GLB.PERIOD_SET_NAME AND
GL.ACCOUNTED_PERIOD_TYPE = GLB.ACCOUNTED_PERIOD_TYPE AND
GLB.JE_BATCH_ID = GLH.JE_BATCH_ID AND
GLH.JE_HEADER_ID = GLL.JE_HEADER_ID AND
GLL.JE_HEADER_ID = GLIR.JE_HEADER_ID AND
GLL.JE_LINE_NUM = GLIR.JE_LINE_NUM AND
GLIR.GL_SL_LINK_TABLE = XLL.GL_SL_LINK_TABLE AND
GLIR.GL_SL_LINK_ID = XLL.GL_SL_LINK_ID AND
XLL.APPLICATION_ID = XLH.APPLICATION_ID AND
XLL.AE_HEADER_ID = XLH.AE_HEADER_ID AND
XLH.APPLICATION_ID = XLE.APPLICATION_ID AND
XLH.EVENT_ID = XLE.EVENT_ID AND
XLE.APPLICATION_ID = XLTE.APPLICATION_ID AND
XLE.ENTITY_ID = XLTE.ENTITY_ID AND
XLL.APPLICATION_ID = XLDL.APPLICATION_ID AND
XLL.AE_HEADER_ID = XLDL.AE_HEADER_ID AND
XLL.AE_LINE_NUM = XLDL.AE_LINE_NUM AND
XLTE.SOURCE_ID_INT_1 = aph.invoice_id AND
aph.invoice_id = apl.invoice_id AND
apl.invoice_id = apd.invoice_id AND
apl.line_number = apd.invoice_line_number AND
XLDL.SOURCE_DISTRIBUTION_ID_NUM_1 = apd.invoice_distribution_id