The Link between GL to SLA and reference columns in GL | Enterprise.
Join GL tables with XLA (SubLedger Accounting) tables – Oracle Apps To…, The Link between GL to SLA and reference columns in GL | Enterprise.
Subledger Accounting (SLA) in R12 ~ Welcome to Oracle ERP, 12/4/2019 · xla.xla_ transaction_entities xte, xla_ae_headers xah, xla_ae_lines xal, gl.gl_ import_references gir, gl_je_lines gjl, gl_je_headers gjh WHERE 1 = 1 AND aia.invoice_id = aipa.invoice_id AND aipa.check_id = aca.check_id AND aca.check_id = NVL (“SOURCE_ID_INT_1”, (-99)) AND xte.entity_code = ‘AP_PAYMENTS’ AND xte.application_id = 200, 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. For e.g you join the xla.xla_ transaction_entities table with ra_customer_trx_all for …
6/6/2009 · xla.xla_ transaction_entities (source_id_int_1) filtered by application_id 222, entity_code TRANSACTIONS and ledger_id -> ra_customer_trx_all (customer_trx_id) for that set_of_books_id. Note: a) There is an index on xla.xla_ transaction_entities on the following columns. application_id entity_code ledger_id nvl(source_id_int_1,-99) nvl(source_id_int_2,-99), 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, 3/4/2015 · xla.xla_ transaction_entities xte where xte.application_id =200 and xeh.application_id =200 and xe.application_id =200 … find ap invoice data in gl_ import_references table: select distinct gir.* from gl_ import_references gir, xla_ae_lines ael, xla_ae_headers aeh, xla_events aea, 11/2/2017 · The Link between GL to SLA and reference columns in GL_IMPORT_REFERENCES. Since there is always a one-to-one correspondence between XLA_AE_LINES and GL_IMPORT_REFERENCES, they are used to link GL and the subledgers. GL_IMPORT_REFERENCES.gl_sl_link_id => XLA_AE_LINES.gl_sl_link_id..
11/5/2012 · xla_ transaction_entities xla_distribution_links gl_ import_references xla_ transaction_entities .entity_code in (‘transactions’, receipts’, ‘adjustments’, ‘purchase_order’, ‘ap_invoices’, ‘ap_payments’, ‘mtl_accounting_events’, ‘wip_accounting_events’ ‘expenditures’–.
6/4/2013 · gl.gl_ import_references imp, xla.xla_ae_lines xal, 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’.
4/21/2021 · xla.xla_ transaction_entities xte, xla_ae_headers xah, xla_ae_lines xal, gl.gl_ import_references gir, gl_je_lines gjl, gl_je_headers gjh WHERE 1 = 1 AND aia.invoice_id = aipa.invoice_id AND aipa.check_id = aca.check_id AND aca.check_id = NVL.
5/2/2017 · FROM GL_ IMPORT_REFERENCES . WHERE JE_HEADER_ID = V_JE_HEADER_ID Step 3: And to get to the relevant lines in sub-ledger modules we need to find lines against the identified GL_SL_LINK_IDs from XLA_AE_LINES table. Here is the query to get to the sub-ledger lines … Ap invoices invoice is is stored in .xla_ transaction_entities as xte.source_id_int_1.
