Example SQL:

SELECT *
FROM   ap_checks_all
WHERE  check_id = 10210

SELECT *
FROM   ap_invoice_payments_all
WHERE  check_id = 10210

SELECT ae_header_id
,      ae_line_num
,      source_distribution_type
,      source_distribution_id_num_1
FROM   xla_distribution_links
WHERE  event_id = 97837
AND    source_distribution_type = 'AP_PMT_DIST'

SELECT *
FROM   xla_ae_headers
WHERE  ae_header_id = 91149

SELECT *
FROM   xla_ae_lines
WHERE  ae_header_id = 91149
AND    accounting_class_code = 'CASH_CLEARING'

SELECT *
FROM   gl_import_references
WHERE  gl_sl_link_id = 361258
AND    gl_sl_link_table = 'XLAJEL'

SELECT *
FROM   gl_je_lines
WHERE  je_header_id = 1679
AND    je_line_num = 17