View: BSC_SYS_PERIODICITIES_VL

Product:	BSC - Balanced Scorecard
Description:	View of BSC_SYS_PERIODICITIES and BSC_SYS_PERIODICITIES_TL.
Implementation/DBA Data:	APPS.BSC_SYS_PERIODICITIES_VL

View Text

SELECT B.PERIODICITY_ID
, B.NUM_OF_PERIODS
, B.SOURCE
, B.NUM_OF_SUBPERIODS
, B.PERIOD_COL_NAME
, B.SUBPERIOD_COL_NAME
, B.YEARLY_FLAG
, B.EDW_FLAG
, B.CALENDAR_ID
, B.EDW_PERIODICITY_ID
, B.CUSTOM_CODE
, B.DB_COLUMN_NAME
, B.PERIODICITY_TYPE
, L.MEANING AS NAME
FROM BSC_SYS_PERIODICITIES B
, BSC_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'BSC_PERIODICITY'
AND B.PERIODICITY_TYPE = L.LOOKUP_CODE UNION SELECT B.PERIODICITY_ID
, B.NUM_OF_PERIODS
, B.SOURCE
, B.NUM_OF_SUBPERIODS
, B.PERIOD_COL_NAME
, B.SUBPERIOD_COL_NAME
, B.YEARLY_FLAG
, B.EDW_FLAG
, B.CALENDAR_ID
, B.EDW_PERIODICITY_ID
, B.CUSTOM_CODE
, B.DB_COLUMN_NAME
, B.PERIODICITY_TYPE
, TL.NAME
FROM BSC_SYS_PERIODICITIES B
, BSC_SYS_PERIODICITIES_TL TL
WHERE B.PERIODICITY_ID = TL.PERIODICITY_ID
AND TL.LANGUAGE = USERENV('LANG')
AND (B.EDW_FLAG <> 0 OR B.CUSTOM_CODE <> 0)

Columns