Not able to find join between budget tables and GL_BALANCES
Summary:
We have a requirement to build a custom report where most of the columns are from the control budget screen under budgetary control.
We are fetching budget columns from a few tables mentioned below -
XCC_BUDGET_ACCOUNTS
XCC_CONTROL_BUDGETS
XCC_BALANCES
There is a 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.
Content (please ensure you mask any confidential information):
0