eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PSB_BUDGET_REVISION_ACCOUNTS_V

Product:	PSB - Public Sector Budgeting (Obsolete)
Description:	PSB_BUDGET_REVISION_ACCOUNTS_V is a view on PSB_BUDGET_REVISION_ACCOUNTS and provides information about budget revision lines.
Implementation/DBA Data:	Not implemented in this database

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

Name
ROW_ID
BUDGET_REVISION_ID
BUDGET_REVISION_ACCT_LINE_ID
CODE_COMBINATION_ID
BUDGET_GROUP_ID
GL_BUDGET_VERSION_ID
GL_PERIOD_NAME
CURRENCY_CODE
ACCOUNT_TYPE
BUDGET_BALANCE
ACTUAL_BALANCE
ENCUMBRANCE_BALANCE
REVISION_TYPE
REVISION_VALUE_TYPE
REVISION_AMOUNT
FUNDS_CONTROL_STATUS_CODE
FUNDS_CONTROL_RESULTS_CODE
FREEZE_FLAG
VIEW_LINE_FLAG
NOTE_ID
FUNDS_CONTROL_TIMESTAMP
PERCENT_REVISED
AMOUNT_REVISED
SEGMENT1
SEGMENT2
SEGMENT3
SEGMENT4
SEGMENT5
SEGMENT6
SEGMENT7
SEGMENT8
SEGMENT9
SEGMENT10
SEGMENT11
SEGMENT12
SEGMENT13
SEGMENT14
SEGMENT15
SEGMENT16
SEGMENT17
SEGMENT18
SEGMENT19
SEGMENT20
SEGMENT21
SEGMENT22
SEGMENT23
SEGMENT24
SEGMENT25
SEGMENT26
SEGMENT27
SEGMENT28
SEGMENT29
SEGMENT30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE