How to join GL tables with XLA (SubLedger Accounting) tables
GL_JE_BATCHES (je_batch_id) => GL_JE_HEADERS (je_batch_id)
GL_JE_HEADERS (je_header_id) => GL_JE_LINES (je_header_id)
GL_JE_LINES (je_header_id, je_line_num) => GL_IMPORT_REFERENCES (je_header_id, je_line_num)
GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id) => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id)
XLA_AE_LINES (application_id, ae_header_id) => XLA_AE_HEADERS (application_id, ae_header_id)
XLA_AE_HEADERS (application_id, event_id) => XLA_EVENTS (application_id, event_id)
XLA_EVENTS (application_id, entity_id) => XLA.XLA_TRANSACTION_ENTITIES (application_id, entity_id) 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 obtaining receivables transactions information or with mtl_material_transactions table for obtaining material transactions information.
The entity_id mappings can be obtained from the XLA_ENTITY_ID_MAPPINGS table
[Keywords: gl_import_references, xla_ae_lines, xla_ae_headers, xla_events, drilldown, SLA, XLA]
7 comments:
We [url=http://www.casinobonus.gd]baccarat online[/url] obtain a corpulent library of unqualifiedly unsolicited casino games in regard to you to sport right here in your browser. Whether you pine for to training a mesa round plan or scarcely attempt manifest a insufficient modern slots before playing seeking real money, we have you covered. These are the rigid same games that you can engage at earnest online casinos and you can play them all for free.
[url=http://www.onlinecasinos.gd]casinos online[/url], also known as effectual casinos or Internet casinos, are online versions of red-letter ("buddy and mortar") casinos. Online casinos ok gamblers to assess as ingredient in and wager on casino games from peak to foot the Internet.
Online casinos typically up odds and payback percentages that are comparable to land-based casinos. Some online casinos contend higher payback percentages as a medicament looking all the way through chink gismo games, and some shred the low-down anent payout concord audits on their websites. Assuming that the online casino is using an fittingly programmed unsystematic figure out generator, note games like blackjack coveted an established borderline edge. The payout ditty voyage of ascertaining of these games are established to the core the rules of the game.
Uncountable online casinos retain not at composed or sense their software from companies like Microgaming, Realtime Gaming, Playtech, Supranational Mien Technology and CryptoLogic Inc.
Thanks for one's marvelous posting! I truly enjoyed reading it, you're a great author.
I will always bookmark your blog and definitely will
come back down the road. I want to encourage that you continue your great posts, have a nice evening!
Here is my homepage top online casinos
whoah this weblog is wonderful i like studying your posts.
Stay up the great work! You understand, a lot of persons are hunting around for this info,
you could help them greatly.
Here is my page; party poker bonus code existing players
I know this website provides quality based
articles and additional information, is there any
other web site which offers these kinds of data in quality?
Feel free to visit my webpage :: http://www.directtrafficmedia.co.uk/member/22878
Hmm is anyone else experiencing problems with the pictures on this blog loading?
I'm trying to find out if its a problem on my end or if it's the blog.
Any feed-back would be greatly appreciated.
Check out my homepage :: postbit.Com
Great site. A lot of useful info here. I'm sending it to some pals ans also sharing in delicious. And naturally, thank you on your sweat!
Feel free to surf to my homepage :: july party poker bonus code
Post a Comment