XLA_EVENTS Query

http://aporaclepayables.blogspot.com/2016/02/xlaevents-query.html

XLA_EVENTS_PAYMENTS
------------------
select distinct xe.*
  from ap_invoice_payments_all      aip,
       xla_events                   xe,
       xla.xla_transaction_entities xte
 where xte.application_id = 200
   and xte.application_id = xe.application_id
   and aip.invoice_id = '73936'
   and xte.entity_code = 'AP_PAYMENTS'
   and xte.source_id_int_1 = aip.check_id
   and xte.entity_id = xe.entity_id
 
 
 
XLA_EVENTS_INVOICE
------------------
select distinct xe.*
  from ap_invoices_all ai, xla_events xe, xla.xla_transaction_entities xte
 where xte.application_id = 200
   and xte.application_id = xe.application_id
   and ai.invoice_id = '73936'
   and xte.entity_code = 'AP_INVOICES'
   and xte.source_id_int_1 = ai.invoice_id
   and xte.entity_id = xe.entity_id