The source_id_int_1 column of xla.xla_ transaction_entities stores the primary_id value for the transactions. You can join the xla.xla_ transaction_entities table with the corresponding transactions table for obtaining additional information of the transaction.
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.entity_id = xte.entity_id, 10/30/2017 · 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, 6/4/2013 · xla.xla_ ae _headers xah, xla.xla_events xe, xla.xla_ transaction_entities xte, ap.ap_invoices_all inv WHERE 1 = 1 AND gjh.je_header_id = gjl.je_header_id AND gjl.status || ” = ‘P’ AND gjl.code_combination_id = gcc.code_combination_id AND gjh.period_name = glp.period_name AND glp.period_set_name = :p_period_set_name AND glp.adjustment_period_flag …
6/4/2013 · xla.xla_ ae _headers xah, xla.xla_events xe, xla.xla_ transaction_entities xte, ar_cash_receipts_all acr WHERE 1 = 1 AND gjh.je_header_id = gjl.je_header_id AND gjl.status || ” = ‘P’ AND gjl.code_combination_id = gcc.code_combination_id AND gjh.period_name = glp.period_name AND glp.period_set_name = :p_period_set_name AND glp.adjustment_period …
Join GL tables with XLA (SubLedger Accounting) tables – Oracle Apps To…, Oracle e learning: Joins between XLA, GL and AP.
All About Oracle Apps: Subledger Accounting In Detail, 10/24/2016 · You can see the accounting in XLA_ AE _HEADERS and XLA_AE_LINES. XLA_ AE _HEADERS.accounting_entry_status_code is ‘D’ XLA_EVENTS.process_status_code is ‘D’ XLA_EVENTS.event_status_code is ‘U’ You can run create accounting on this transaction again and again, which will delete the old journal entries and create new ones.
4/5/2013 · NOTE: For every transaction, it will create an entity_id in xla_ transaction_entities table. This column we use to make link between transaction entities and xla ae headers table. By default at first time for an entity, one event will be there.
2 days ago · XLA_ AE _HEADERS XLA_AE_LINES GL_IMPORT_REFERENCES GL_JE_LINES GL_JE_HEADERS GL_BALANCES. NOTE: For every transaction, it will create an entity_id in xla_ transaction_entities table. This column we use to make link between transaction entities and xla ae headers table. By default at first time for an entity, one event will be there.
1 day ago · xla.xla_ transaction_entities xte, xla_ ae _headers xah, … Above query wass wrong.. there is no link between Invoice and XLA tables. Reply Delete. Replies. Reply. arif 3 April 2019 at 22:37. … PA Billing Events tables joins (1) PA invoice details in Fusion (1) PA Invoice tables in Fusion (1)
