Join AP subledger transaction to GL in R12

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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s