View: PSB_BUDGET_REVISION_SUMMARY_V

Product:	PSB - Public Sector Budgeting
Description:
Implementation/DBA Data:	APPS.PSB_BUDGET_REVISION_SUMMARY_V

View Text

SELECT /*+ ORDERED */ BRL.BUDGET_REVISION_ID
, BR.BUDGET_GROUP_ID
, BRA.CODE_COMBINATION_ID
, BRA.GL_BUDGET_VERSION_ID
, GBV.GL_BUDGET_NAME
, GBV.START_PERIOD
, GBV.END_PERIOD
, GBS.SET_OF_BOOKS_ID
, GSB.CHART_OF_ACCOUNTS_ID
, MIN(PSB_BUDGET_REVISIONS_PVT.GET_GL_BALANCE(BR.BUDGET_REVISION_TYPE
, 'YTD'
, GSB.SET_OF_BOOKS_ID
, GSB.ENABLE_BUDGETARY_CONTROL_FLAG
, GBV.END_PERIOD
, BRA.GL_BUDGET_VERSION_ID
, BRA.CURRENCY_CODE
, BRA.CODE_COMBINATION_ID))
, NVL(SUM(DECODE(BRA.REVISION_TYPE
, 'I'
, DECODE(BRA.REVISION_VALUE_TYPE
, 'A'
, BRA.REVISION_AMOUNT
, BRA.BUDGET_BALANCE * BRA.REVISION_AMOUNT/100)
, -(DECODE(BRA.REVISION_VALUE_TYPE
, 'A'
, BRA.REVISION_AMOUNT
, BRA.BUDGET_BALANCE * BRA.REVISION_AMOUNT/100))))
, 0)
FROM PSB_BUDGET_REVISIONS BR
, PSB_BUDGET_REVISION_LINES BRL
, PSB_BUDGET_REVISION_ACCOUNTS BRA
, PSB_GL_BUDGET_SETS GBS
, PSB_GL_BUDGETS_V GBV
, GL_PERIOD_STATUSES GPS
, GL_SETS_OF_BOOKS GSB
WHERE BRA.BUDGET_REVISION_ACCT_LINE_ID = BRL.BUDGET_REVISION_ACCT_LINE_ID
AND BRL.BUDGET_REVISION_ID = BR.BUDGET_REVISION_ID
AND BRA.GL_BUDGET_VERSION_ID = GBV.GL_BUDGET_VERSION_ID
AND BR.GL_BUDGET_SET_ID = GBV.GL_BUDGET_SET_ID
AND BRA.GL_PERIOD_NAME = GPS.PERIOD_NAME
AND BRA.POSITION_ID IS NULL
AND GPS.START_DATE >= GBV.START_DATE
AND GPS.END_DATE <= GBV.END_DATE
AND GBV.GL_BUDGET_SET_ID = GBS.GL_BUDGET_SET_ID
AND GBS.SET_OF_BOOKS_ID = GPS.SET_OF_BOOKS_ID
AND GBS.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID
AND GPS.APPLICATION_ID = 101 GROUP BY BRL.BUDGET_REVISION_ID
, BR.BUDGET_GROUP_ID
, BRA.CODE_COMBINATION_ID
, BRA.GL_BUDGET_VERSION_ID
, GBV.GL_BUDGET_NAME
, GBV.START_PERIOD
, GBV.END_PERIOD
, GBS.SET_OF_BOOKS_ID
, GSB.CHART_OF_ACCOUNTS_ID

Columns