Monday, March 31, 2025
Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down
Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down
Link between inventory and general ledger for Drilldown
SELECT xld.source_distribution_type,
xld.accounting_line_code,
xld.accounting_line_type_code,
xld.line_definition_code,
xld.event_class_code,
xld.event_type_code,
xld.rounding_class_code,
xld.unrounded_entered_cr,
xld.unrounded_entered_dr,
xld.unrounded_accounted_cr,
xld.unrounded_accounted_dr,
ael.gl_sl_link_id,
ael.gl_sl_link_table,
GJB.NAME BATCH_NAME,
gL.period_name,
gl.accounted_cr,
gl.accounted_dr,
gl.entered_cr,
gl.entered_dr,
gh.je_source,
gh.je_category,
gh.posted_date,
mta.inv_sub_ledger_id,
mta.base_transaction_value,
mta.currency_conversion_rate,
mta.rate_or_amount,
mta.currency_code,
mmt.subinventory_code,
TRUNC (mmt.transaction_date) transaction_date,
mmt.transaction_quantity,
mmt.transaction_uom,
mmt.primary_quantity,
mmt.actual_cost,
mmt.source_code,
mmt.source_line_id,
mmt.rcv_transaction_id,
msi.concatenated_segments item,
gcc.concatenated_segments GL_ACCOUNT_STRING,
ood.organization_code,
ood.organization_name,
mmt.transaction_id,
ael.ae_header_id,
ael.ae_line_num,
gl.je_header_id,
gl.je_line_num,
gcc.code_combination_id,
msi.inventory_item_id,
msi.organization_id,
gjb.je_batch_id
FROM xla_transaction_entities_upg ent,
xla_events e,
xla_distribution_links xld,
mtl_transaction_accounts mta,
mtl_material_transactions mmt,
xla_ae_headers ah,
xla_ae_lines ael,
gl_import_references gir,
gl_je_lines gl,
gl_code_combinations_kfv gcc,
gl_je_headers gh,
GL_JE_BATCHES GJB,
mtl_system_items_kfv msi,
org_organization_definitions ood
WHERE mmt.transaction_id = NVL (ent.source_id_int_1, -99)
AND ent.entity_code = 'MTL_ACCOUNTING_EVENTS'
AND ent.application_id = 707
AND ent.entity_id = e.entity_id
AND e.application_id = 707
AND e.event_id = xld.event_id
AND ah.application_id = 707
AND ah.entity_id = ent.entity_id
AND ah.event_id = e.event_id
AND ah.ledger_id = ent.ledger_id
AND ah.ae_header_id = ael.ae_header_id
AND ael.application_id = 707
AND ael.ledger_id = ah.ledger_id
AND ael.AE_HEADER_ID = xld.AE_HEADER_ID
AND ael.AE_LINE_NUM = xld.AE_LINE_NUM
AND xld.application_id = 707
AND xld.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'
AND xld.source_distribution_id_num_1 = mta.inv_sub_ledger_id
AND mta.transaction_id = mmt.transaction_id
AND ael.gl_sl_link_id = gir.gl_sl_link_id
AND ael.gl_sl_link_table = gir.gl_sl_link_table
AND gir.je_header_id = gl.je_header_id
AND gir.je_line_num = gl.je_line_num
AND gl.code_combination_id = gcc.code_Combination_id
AND gl.je_header_id = gh.je_header_id
AND GH.JE_BATCH_ID = GJB.JE_BATCH_ID
AND mta.transaction_id = mmt.transaction_id
AND mmt.inventory_item_id = msi.inventory_item_id
AND mmt.organization_id = msi.organization_id
AND msi.organization_id = ood.organization_id
Subscribe to:
Post Comments (Atom)
Great topic! The drilldown from GL to Inventory Transactions in R12 can be tricky, but using the INV to GL link queries makes tracing much easier. It’s like understanding the cost of ghostwriter—you need to track the value back to its source to see what you're really investing in.
ReplyDeleteeshikshakosh.org ensures continuous learning through flexible online resources that fit every student’s individual pace.
ReplyDeletessoids.comm provides excellent support for users needing help with SSO ID login and registration. The instructions are clear, updated, and easy to follow. It is a reliable source for Rajasthan portal guidance.
ReplyDeleteFinally discovered a platform where NewsTwice delivers exactly what modern readers need—balanced perspectives without sensationalism. The technological coverage is particularly impressive, offering insights that help me understand our rapidly changing digital landscape better.
ReplyDeleteDelighted to have found NewsMario as my primary news source for accurate and balanced reporting. Every article demonstrates thorough research and careful fact-checking throughout. I appreciate the commitment to delivering news that truly informs and empowers readers daily.
ReplyDeleteGrateful for discovering the MorroNews platform that maintains outstanding quality across all content categories. From global affairs to technology, everything is covered with depth and clarity. This website has earned my trust and daily readership effortlessly.
ReplyDeleteMahi Tech Info is a valuable resource for tech knowledge. The website delivers well-researched and clearly written content for all users.
ReplyDeleteTopnotch system built around Chiaki4Deck remote integration provides impressive stability and fluid performance. Practical features, quick setup, and dependable responsiveness stand out clearly.
ReplyDelete