[Home] [Help]
View: PSBBV_BUDGET_REVISION_POSITION
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT BRL.BUDGET_REVISION_ID
, BRP.BUDGET_REVISION_POS_LINE_ID
, BRP.POSITION_ID
, BRP.BUDGET_GROUP_ID
, BRP.EFFECTIVE_START_DATE
, BRP.EFFECTIVE_END_DATE
, BRP.REVISION_TYPE
, BRP.REVISION_VALUE_TYPE
, BRP.REVISION_VALUE
, BRP.NOTE_ID
FROM PSB_BUDGET_REVISION_POSITIONS BRP
, PSB_BUDGET_REVISION_POS_LINES BRL
WHERE BRP.BUDGET_REVISION_POS_LINE_ID = BRL.BUDGET_REVISION_POS_LINE_ID WITH READ ONLY
Columns
Name |
BUDGET_REVISION_ID |
BUDGET_REVISION_POS_LINE_ID |
POSITION_ID |
BUDGET_GROUP_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
REVISION_TYPE |
REVISION_VALUE_TYPE |
REVISION_VALUE |
NOTE_ID |