Joins between XLA, GL and AP.

Joins between XLA, GL and AP. 

XLA_AE_HEADERS xah 
XLA_AE_LINES xal 
XLA_TRANSACTION_ENTITIES xte 
XLA_DISTRIBUTION_LINKS xdl 
GL_IMPORT_REFERENCES gir 

Below are the possible joins between these XLA Tables: 

xah.ae_header_id = xal.ae_header_id 
xah.application_id = xal.application_id 
xal.application_id = xte.application_id 
xte.application_id = xdl.application_id 
xah.entity_id = xte.entity_id 
xah.ae_header_id = xdl.ae_header_id 
xah.ae_line_num = xdl.ae_line_num 
xah.event_id = xdl.event_id 
xal.gl_sl_link_id = gir.gl_sl_link_id 
xal.gl_sl_link_table = gir.gl_sl_link_table 
xah.application_id = (Different value based on Module) 

xte.entity_code = 
'TRANSACTIONS' or 
'RECEIPTS' or 
'ADJUSTMENTS' or 
'PURCHASE_ORDER' or 
'AP_INVOICES' or 
'AP_PAYMENTS' or 
'MTL_ACCOUNTING_EVENTS' or 
'WIP_ACCOUNTING_EVENTS' 

xte.source_id_int_1 = 
'INVOICE_ID' or 
'CHECK_ID' or 
'TRX_NUMBER' 

XLA_DISTRIBUTION_LINKS table join based on Source Distribution Types 

xdl.source_distribution_type = 'AP_PMT_DIST ' 
and xdl.source_distribution_id_num_1 = 
AP_PAYMENT_HIST_DISTS.payment_hist_dist_id 
--- 
xdl.source_distribution_type = 'AP_INV_DIST' 
and xdl.source_distribution_id_num_1 = 
AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_ id 
--- 
xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL' 
and xdl.source_distribution_id_num_1 = AR_DISTRIBUTIONS_ALL.line_id 
and AR_DISTRIBUTIONS_ALL.source_id = 
AR_RECEIVABLE_APPLICATIONS_ALL.receivable_applicat ion_id 
--- 
xdl.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL' 
and xdl.source_distribution_id_num_1 = 
RA_CUST_TRX_LINE_GL_DIST_ALL.cust_trx_line_gl_dist _id 
--- 
xdl.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS' 
and xdl.source_distribution_id_num_1 = 
MTL_TRANSACTION_ACCOUNTS.inv_sub_ledger_id 
--- 
xdl.source_distribution_type = 'WIP_TRANSACTION_ACCOUNTS' 
and xdl.source_distribution_id_num_1 = 
WIP_TRANSACTION_ACCOUNTS.wip_sub_ledger_id 
--- 
xdl.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER' 
and xdl.source_distribution_id_num_1 = 
RCV_RECEIVING_SUB_LEDGER.rcv_sub_ledger_id