Payment data in Sub-Ledger Accounting (XLA) – R12

To check the Payment Data related to the   Payable INVOICE ( Invoice_id = 166014 ) in Sub-Ledger Accounting (XLA). All the queries given in this post and their related posts were tested in R12.1.1 Instance.

XLA_EVENTS

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       = ‘166014’

AND   xte.entity_code      = ‘AP_PAYMENTS’

AND   xte.source_id_int_1  = aip.check_id

AND   xte.entity_id        = xe.entity_id

ORDER BY 

      xe.entity_id,

      xe.event_number;

 

XLA_AE_HEADERS

SELECT DISTINCT xeh.*

FROM   xla_ae_headers xeh,

       ap_invoice_payments_all aip,

       xla.xla_transaction_entities xte

WHERE  xte.application_id = 200

AND    xte.application_id   = xeh.application_id

AND    aip.invoice_id       = ‘166014’

AND    xte.entity_code      = ‘AP_PAYMENTS’

AND    xte.source_id_int_1  = aip.check_id

AND    xte.entity_id        = xeh.entity_id

ORDER BY 

       xeh.event_id,

       xeh.ae_header_id ASC;

 

XLA_AE_LINES  

SELECT DISTINCT xel.*,

       fnd_flex_ext.get_segs(‘SQLGL’,‘GL#’, ‘50577’ , xel.code_combination_id) “Account”

FROM   xla_ae_lines xel,

       xla_ae_headers xeh,

       ap_invoice_payments_all aip,

       xla.xla_transaction_entities xte

WHERE  xte.application_id = 200

AND    xel.application_id   = xeh.application_id

AND    xte.application_id   = xeh.application_id

AND    aip.invoice_id       = ‘166014’

AND    xel.ae_header_id     = xeh.ae_header_id

AND    xte.entity_code      = ‘AP_PAYMENTS’

AND    xte.source_id_int_1  = aip.check_id

AND    xte.entity_id        = xeh.entity_id

ORDER BY 

       xel.ae_header_id,

       xel.ae_line_num ASC;

XLA_DISTRIBUTION_LINKS

SELECT DISTINCT xdl.*

FROM   xla_distribution_links xdl,

       xla_ae_headers xeh,

       ap_invoice_payments_all aip,

       xla.xla_transaction_entities xte

WHERE  xte.application_id = 200

AND    xdl.application_id   = xeh.application_id

AND    xte.application_id   = xeh.application_id

AND    aip.invoice_id       = ‘166014’

AND    xdl.ae_header_id     = xeh.ae_header_id

AND    xte.entity_code      = ‘AP_PAYMENTS’

AND    xte.source_id_int_1  = aip.check_id

AND    xte.entity_id        = xeh.entity_id