[Home] [Help]
View: PSB_WS_BUDGET_YEARS_V
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 |