Payment Data in Sub-Ledger Accounting in Oracle Applications

Checking the PAYMENT Data for Payable INVOICE in Subledger Accounting

APPS.XHI_EVENTS

  SELECT DISTINCT xe.*

    FROM apps.ap_invoice_payments_all aip,

         apps.XHI_EVENTS xe,

         apps.XHI_Transaction_Entities xte

   WHERE     xte.application_id = 108

         AND xte.application_id = xe.application_id

         AND aip.invoice_id = '123456'

         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;

XHI_AE_HEADERS:

SELECT DISTINCT xeh.*

    FROM XHI_ae_headers xeh,

         apps.ap_invoice_payments_all aip,

         apps.XHI_Transaction_Entities xte

   WHERE     xte.application_id = 108

         AND xte.application_id = xeh.application_id

         AND aip.invoice_id = '1234567'

         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;

XHI_AE_LINES:

SELECT DISTINCT xel.*,

                  fnd_flex_ext.get_segs ('SQLGL',

                                         'GL#',

                                         ' 41293',

                                         xel.code_combination_id)

                     "Account"

    FROM apps.XHI_ae_lines xel,

         Apps.XHI_ae_headers xeh,

         apps.ap_invoice_payments_all aip,

         apps.XHI_Transaction_Entities xte

   WHERE     xte.application_id = 108

         AND xel.application_id = xeh.application_id

         AND xte.application_id = xeh.application_id

         AND aip.invoice_id = '1234567'

         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;

XHI_DISTRIBUTION_LINKS:

SELECT DISTINCT xdl.*

  FROM apps.XHI_distribution_links xdl,

       apps.XHI_ae_headers xeh,

       apps.ap_invoice_payments_all aip,

       apps.XHI_Transaction_Entities xte

 WHERE     xte.application_id = 108

       AND xdl.application_id = xeh.application_id

       AND xte.application_id = xeh.application_id

       AND aip.invoice_id = '1234567'

       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;