Query for Payable Invoices Data stored in Sub-Ledger Accounting -- Oracle Apps R12

Checking the Data for Payable INVOICE in Sub-Ledger Accounting

XHL_EVENTS

SELECT DISTINCT xe.*

    FROM apps.ap_invoices_all ai,

         Apps.XHL_events xe,

         Apps.XHL_transaction_entities xte

   WHERE     xte.application_id = 108

         AND xte.application_id = xe.application_id

         AND ai.invoice_id = '124567'

         AND xte.entity_code = 'AP_INVOICES'

         AND xte.source_id_int_1 = ai.invoice_id

         AND xte.entity_id = xe.entity_id

ORDER BY xe.entity_id, xe.event_number;

XHL_AE_HEADERS:

SELECT DISTINCT xeh.*

    FROM apps.XHL_ae_headers xeh,

         apps.ap_invoices_all ai,

         apps.XHL_transaction_entities xte

   WHERE     xte.application_id = 108

         AND xte.application_id = xeh.application_id

         AND ai.invoice_id = '124567'

         AND xte.entity_code = 'AP_INVOICES'

         AND xte.source_id_int_1 = ai.invoice_id

         AND xte.entity_id = xeh.entity_id

ORDER BY xeh.event_id, xeh.ae_header_id ASC;

XHL_AE_LINES:

SELECT DISTINCT xel.*,

                  fnd_flex_ext.get_segs ('SQLGL',

                                         'GL#',

                                         '41293',

                                         xel.code_combination_id)

                     "Account"

    FROM apps.XHL_ae_lines xel,

         apps.XHL_ae_headers xeh,

         apps.ap_invoices_all ai,

         apps.XHL_transaction_entities xte

   WHERE     xte.application_id = 108

         AND xel.application_id = xeh.application_id

         AND xte.application_id = xeh.application_id

         AND ai.invoice_id = '124567'

         AND xel.ae_header_id = xeh.ae_header_id

         AND xte.entity_code = 'AP_INVOICES'

         AND xte.source_id_int_1 = ai.invoice_id

         AND xte.entity_id = xeh.entity_id

ORDER BY xel.ae_header_id, xel.ae_line_num ASC;

XHL_DISTRIBUTION_LINKS:

SELECT DISTINCT xdl.*

    FROM apps.XHL_distribution_links xdl,

         apps.XHL_ae_headers xeh,

         apps.ap_invoices_all ai,

         apps.XHL_transaction_entities xte

   WHERE     xte.application_id = 108

         AND xdl.application_id = xeh.application_id

         AND xte.application_id = xeh.application_id

         AND ai.invoice_id = '124567'

         AND xdl.ae_header_id = xeh.ae_header_id

         AND xte.entity_code = 'AP_INVOICES'

         AND xte.source_id_int_1 = ai.invoice_id

         AND xte.entity_id = xeh.entity_id

ORDER BY xdl.event_id, xdl.a_header_id, xdl.ae_line_num ASC;

XHL_TRANSACTION_ENTITIES:

SELECT DISTINCT xte.*

  FROM apps.ap_invoices_all ai, apps.XHL_transaction_entities xte

 WHERE     xte.application_id = 108

       AND ai.invoice_id = '124567'

       AND xte.entity_code = 'AP_INVOICES'

       AND xte.source_id_int_1 = ai.invoice_id;

XHL_ACCOUNTING_ERRORS:

SELECT DISTINCT xae.*

  FROM apps.ap_invoices_all ai,

       apps.XHL_events xe,

       apps.XHL_transaction_entities xte,

       apps.XHL_accounting_errors xae

 WHERE     xte.application_id = 108

       AND xae.application_id = xte.application_id

       AND xte.application_id = xe.application_id

       AND ai.invoice_id = '124567'

       AND xe.event_id = xae.event_id

       AND xte.entity_code = 'AP_INVOICES'

       AND xte.source_id_int_1 = ai.invoice_id

       AND xte.entity_id = xe.entity_id;