View: PSB_BUDGET_REVISION_ACCOUNTS_V

Product:	PSB - Public Sector Budgeting
Description:	PSB_BUDGET_REVISION_ACCOUNTS_V is a view on PSB_BUDGET_REVISION_ACCOUNTS and provides information about budget revision lines.
Implementation/DBA Data:	APPS.PSB_BUDGET_REVISION_ACCOUNTS_V

View Text

SELECT BRA.ROWID
, BRL.BUDGET_REVISION_ID
, BRA.BUDGET_REVISION_ACCT_LINE_ID
, BRA.CODE_COMBINATION_ID
, BRA.BUDGET_GROUP_ID
, BRA.GL_BUDGET_VERSION_ID
, BRA.GL_PERIOD_NAME
, BRA.CURRENCY_CODE
, BRA.ACCOUNT_TYPE
, BRA.BUDGET_BALANCE
, BRA.ACTUAL_BALANCE
, BRA.ENCUMBRANCE_BALANCE
, BRA.REVISION_TYPE
, BRA.REVISION_VALUE_TYPE
, BRA.REVISION_AMOUNT
, BRA.FUNDS_CONTROL_STATUS_CODE
, BRA.FUNDS_CONTROL_RESULTS_CODE
, BRA.FREEZE_FLAG
, BRL.VIEW_LINE_FLAG
, BRA.NOTE_ID
, BRA.FUNDS_CONTROL_TIMESTAMP
, DECODE(BRA.REVISION_VALUE_TYPE
, 'P'
, BRA. REVISION_AMOUNT)
, DECODE(BRA.REVISION_VALUE_TYPE
, 'A'
, BRA.REVISION_AMOUNT)
, GC.SEGMENT1
, GC.SEGMENT2
, GC.SEGMENT3
, GC.SEGMENT4
, GC.SEGMENT5
, GC.SEGMENT6
, GC.SEGMENT7
, GC.SEGMENT8
, GC.SEGMENT9
, GC.SEGMENT10
, GC.SEGMENT11
, GC.SEGMENT12
, GC.SEGMENT13
, GC.SEGMENT14
, GC.SEGMENT15
, GC.SEGMENT16
, GC.SEGMENT17
, GC.SEGMENT18
, GC.SEGMENT19
, GC.SEGMENT20
, GC.SEGMENT21
, GC.SEGMENT22
, GC.SEGMENT23
, GC.SEGMENT24
, GC.SEGMENT25
, GC.SEGMENT26
, GC.SEGMENT27
, GC.SEGMENT28
, GC.SEGMENT29
, GC.SEGMENT30
, BRA.LAST_UPDATE_DATE
, BRA.LAST_UPDATED_BY
, BRA.LAST_UPDATE_LOGIN
, BRA.CREATED_BY
, BRA.CREATION_DATE
FROM PSB_BUDGET_REVISION_ACCOUNTS BRA
, PSB_BUDGET_REVISION_LINES BRL
, GL_CODE_COMBINATIONS GC
WHERE BRA.BUDGET_REVISION_ACCT_LINE_ID = BRL.BUDGET_REVISION_ACCT_LINE_ID
AND BRA.CODE_COMBINATION_ID = GC.CODE_COMBINATION_ID
AND BRA.POSITION_ID IS NULL

Columns