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

Query to find View Accounting in Manage Revenue Distributions

Received Response
edited Mar 21, 2024 8:13AM in Project Management 2 comments


Can you please help me with table joins to get the View Accounting for Contract --> Manage Revenue Distributions


Contract Management --> Revenue

Task: Manage Revenue Distributions

Select BU and Period and COntract number.


From the Result, Click on View Accounting.

I am unable to do the join.

I tried to get the CCID from code_combination table and then got the xla tables from there. But unable to join the xla to okc table or pjc_exp_items

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


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