eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BSC_SYS_CALENDARS_VL

Product:	BSC - Balanced Scorecard (Obsolete)
Description:	View of BSC_SYS_CALENDARS_B and BSC_SYS_CALENDARS_TL.
Implementation/DBA Data:	Not implemented in this database

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

Name
CALENDAR_ID
EDW_FLAG
EDW_CALENDAR_ID
EDW_CALENDAR_TYPE_ID
FISCAL_YEAR
FISCAL_CHANGE
RANGE_YR_MOD
CURRENT_YEAR
START_MONTH
START_DAY
NAME
HELP
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN