You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!