VIEW: APPS.PSB_BUDGET_REVISION_SUMMARY_V

Source

View Text - Preformatted

SELECT /*+ ORDERED */ BRL.BUDGET_REVISION_ID, BR.BUDGET_GROUP_ID, BRA.CODE_COMBINATION_ID, BR.CURRENCY_CODE, 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, BR.CURRENCY_CODE, 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

View Text - HTML Formatted

SELECT /*+ ORDERED */ BRL.BUDGET_REVISION_ID
, BR.BUDGET_GROUP_ID
, BRA.CODE_COMBINATION_ID
, BR.CURRENCY_CODE
, 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
, BR.CURRENCY_CODE
, 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