R12 中， 总账所有表中不在保存子分类账信息，如日记账表中没有任何的发票、付款等信息。
ORACLE 通过 XLA 连接(link) 总账(GL) 和子分类账(SubLedger):gl_sl_link_id。
step 1: GL -> XLA
gl.gl_je_lines.je_batch/header_id/line_num = gl.gl_import_references.je_batch/header_id/line_num gl_je_lines -> gl_import_references
gl.gl_import_references.gl_sl_link_id = xla.xla_ae_lines.gl_sl_link_id gl_import_references -> xla_ae_lines
gl.gl_import_references.gl_sl_link_table = xla.xla_ae_lines.gl_sl_link_table
step 2: XLA 连接 发票、付款等
方式一：
xla_ae_lines/xla_distribution_links -> Subledger distribution tables
1.1 如果 xla_distribution_links.source_distribution_type = 'AP_INV_DIST' (AP Invoice Distribution)
关联方式：xla_distribution_links.source_distribution_id_num_1 = ap_invoice_distributions_all.invoice_distribution_id
再走：ap_invoice_distributions_all -> ap_invoices_all -> ap_checks_all 找到发票、付款、供应商等信息
1.2 如果xla_distribution_links.source_distribution_type = 'AP_PREPAY' (预付款)
关联方式：xla_distribution_links.source_distribution_id_num_1 = ap_prepay_app_dists.prepay_app_dist_id
再走：ap_invoice_distributions_all -> ap_invoices_all -> ap_checks_all 找到发票、付款、供应商等信息
2. 如果 xla_distribution_links.source_distribution_type = 'AP_PMT_DIST' (AP Payment Distribution)
关联方式：xla_distribution_links.source_distribution_id_num_1 = ap_payment_hist_dists.invoice_payment_id
再走：ap_invoice_payments_all -> ap_checks_all
方式二：XLA_AE_LINES/XLA_AE_HEADERS/XLA_EVENTS -> Subledger events table