VIEW: APPS.PSB_WS_BUDGET_YEARS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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