Finance

SELECT xe.event_id,
       xe.application_id,
       xe.event_type_code,
       xe.event_date,
       xe.event_number
  FROM xla.xla_transaction_entities xte, xla.xla_events xe
 WHERE     xte.source_i...

--Query to get AR invoice SLA and GL details

SELECT rct.trx_number,
       b.name        batch_name,
       h.name        journal_name,
       b.description batch_description,
       h.je_category,
 ...

---SLA entries not transferred to GL

SELECT h.ledger_id,
       l.ae_header_id,
       h.accounting_date,
       h.period_name,
       h.entity_id,
       l.gl_sl_link_id,
       l.gl_sl_link_table,
...

SELECT SUBSTR (a.OWNER, 1, 20),
         SUBSTR (a.NAME, 1, 30),
         SUBSTR (a.TYPE, 1, 20),
         SUBSTR (u.status, 1, 10) Stat,
         u.last_ddl_time,
         SUBSTR (text, 1, 80)   Desc...

SELECT rct.receipt_number,
         b.name      batch_name,
         h.name      journal_name,
         b.description batch_description,
         h.je_category,
         h.je_source,
         h.period...

--AR Applications and xla
SELECT ard.source_id,
       xdl.SOURCE_DISTRIBUTION_TYPE,
       xal.ACCOUNTING_CLASS_CODE,
       ard.SOURCE_ID,
       ard.SOURCE_TABLE,
       ard.SOURCE_TYPE,
       rct...

--AP invoice and SLA details
SELECT hou.name                                    operating_unit,
       aia.invoice_num,
       aia.invoice_currency_code,
       aia.creation_date,
       aia.invoice_d...

--Query to get AR invoice SLA details
SELECT rct.trx_number,
       rct.customer_trx_id,
       rctd.cust_trx_line_gl_dist_id,
       xal.entered_dr,
       xal.entered_cr,
       xal.code_combination...

SELECT terr.territory_short_name country,
         hr.name                 operating_unit,
         loc.address1,
         acctsites.cust_acct_site_id,
         acctsites.party_site_id,
         accts...

--Credit card bank details
SELECT * FROM AP_CARD_PROGRAMS_ALL


--Employee credit card details
SELECT ac.ROWID        row_id,
       ac.employee_id,
       ac.card_number,
       ac.card_id,
       ac...

--Customer Account Tax Registration Details

SELECT party_name,
       account_number,
       ps.party_site_number,
       (SELECT LISTAGG (al.meaning, ', ') WITHIN GROUP (ORDER BY al.meaning)
       ...

--PO Requisition Debug XML

SELECT por.segment1 REQ_NUMBER,
       por.requisition_header_id,
       porl.line_num,
       VT.REQUEST_ID,
       debug.REQUEST_NAME,
       debug.MESSAGE_TYPE,
       d...