How to join subledger tables to costing tables in Fusion
Summary:
Subledger tables to costing tables join
Content (required):
Hi Gurus
Need assistance on how to join the subledger tables to the costing tables. My current script starts in GL and I have done all the joins down to the XLA_TRANSACTION_ENTITIES table but now I need to take it further down to the subledger of Cost Accounting.
Any assistance would be appreciated
Thanks
Cheryl
Version (include the version you are using, if applicable):
select distinct
gp.PERIOD_YEAR GL_PERIOD_YEAR,
gp.PERIOD_NAME GL_PERIOD_NAME,
gjb.je_batch_id GL_BATCH_ID,
gjb.NAME GL_BATCH_NAME,
Tagged:
0