Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Project subledger - tables or views for distribution links

edited Jul 17, 2024 6:34PM in General Ledger & Intercompany 2 comments

Summary:

I am looking to construct queries to pull subledger detail for Projects

Content (please ensure you mask any confidential information):

I am looking to construct queries to pull subledger detail for Projects, I found; - How To Link Projects Transactions To Subledger Accounting (SLA) (Doc ID 1274575.1); but the tables that it lists do not exist, does anyone have a working note for this, for joins from xla_distribution_links, in particular I am trying to find where the SOURCE_DISTRIBUTION_TYPE in ('R','Revenue - Event Revenue', 'Revenue - Normal Revenue') for the first I think the table joins to PJC_COST_DIST_LINES_ALL, but would appreciate it anyone can confirm.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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