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

join GL_BALANCES and XCC budget tables

in Budgetary Control 1 comment

Summary:

How to join XCC_ tables with GL_Balances

Content (please ensure you mask any confidential information):


Hi,
We have requirement of building a custom report where most of the columns are from control budget screen.
We are fetching budget columns from few budget tables mentioned below -

 

XCC_BUDGET_ACCOUNTS
XCC_CONTROL_BUDGETS
XCC_BALANCES

 

There is one column "Actuals to date" where we need to show Total of values in GL balances until selected Period. The other columns are Forecast, etc.

 

I am not able to find join between budget tables and GL_BALANCES.

 

Anyone created such type of report, can you please share SQL for this.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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