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,