View: BSC_SYS_CALENDARS_VL

Product:	BSC - Balanced Scorecard
Description:	View of BSC_SYS_CALENDARS_B and BSC_SYS_CALENDARS_TL.
Implementation/DBA Data:	APPS.BSC_SYS_CALENDARS_VL

View Text

SELECT B.CALENDAR_ID
, B.EDW_FLAG
, B.EDW_CALENDAR_ID
, B.EDW_CALENDAR_TYPE_ID
, B.FISCAL_YEAR
, B.FISCAL_CHANGE
, B.RANGE_YR_MOD
, B.CURRENT_YEAR
, B.START_MONTH
, B.START_DAY
, TL.NAME
, TL.HELP
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM BSC_SYS_CALENDARS_B B
, BSC_SYS_CALENDARS_TL TL
WHERE B.CALENDAR_ID = TL.CALENDAR_ID
AND TL.LANGUAGE = USERENV('LANG')

Columns