[Home] [Help]
View: PSB_WS_BUDGET_YEARS_V
| Product: | PSB - Public Sector Budgeting (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT WS.WORKSHEET_ID
, WS.NAME
, BC.NAME
, BP.BUDGET_PERIOD_ID
, BP.NAME
, YTVL.YEAR_CATEGORY_TYPE
, YTVL.NAME
, YTVL.SEQUENCE_NUMBER
FROM PSB_WORKSHEETS WS
, PSB_BUDGET_CALENDARS BC
, PSB_BUDGET_PERIODS BP
, PSB_BUDGET_YEAR_TYPES YTVL
WHERE WS.BUDGET_CALENDAR_ID = BC.BUDGET_CALENDAR_ID
AND BC.BUDGET_CALENDAR_ID = BP.BUDGET_CALENDAR_ID
AND BP.BUDGET_YEAR_TYPE_ID = YTVL.BUDGET_YEAR_TYPE_ID
Columns
| Name |
| WORKSHEET_ID |
| WORKSHEET_NAME |
| CALENDAR_NAME |
| BUDGET_PERIOD_ID |
| BUDGET_PERIOD_NAME |
| YEAR_CATEGORY_TYPE |
| YEAR_TYPE_NAME |
| SEQUENCE_NUMBER |