[Home] [Help]
View: PSBBV_BUDGET_GROUPS
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT BG.SHORT_NAME
, BGR.SHORT_NAME
, BG.NAME
, BG.EFFECTIVE_START_DATE
, BG.EFFECTIVE_END_DATE
, BG.NUM_PROPOSED_YEARS
, BG.ROOT_BUDGET_GROUP
, BG.FREEZE_HIERARCHY_FLAG
, BG.DESCRIPTION
, BG.NARRATIVE_DESCRIPTION
, BG.BUDGET_GROUP_ID
, BG.ROOT_BUDGET_GROUP_ID
, BG.LAST_UPDATE_DATE
, BG.LAST_UPDATED_BY
, BG.CREATED_BY
, BG.CREATION_DATE
FROM PSB_BUDGET_GROUPS BG
, PSB_BUDGET_GROUPS BGR
WHERE BG.ROOT_BUDGET_GROUP_ID = BGR.BUDGET_GROUP_ID (+) WITH READ ONLY
Columns
Name |
BUDGET_GROUP_SHORT_NAME |
ROOT_SHORT_NAME |
BUDGET_GROUP_NAME |
START_EFFECTIVE_DATE |
END_EFFECTIVE_DATE |
BUDGET_GROUP_NUM_PROPOSED_YRS |
ROOT_BUDGET_GROUP |
FREEZE_HIERARCHY_FLAG |
BUDGET_GROUP_DESCRIPTION |
NARRATIVE_DESCRIPTION |
BUDGET_GROUP_ID |
ROOT_BUDGET_GROUP_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |