View: BSC_BIS_DIM_LEVELS_V

Product:	BSC - Balanced Scorecard
Description:	View of the BIS/BSC dimension levels for IBUILDER
Implementation/DBA Data:	APPS.BSC_BIS_DIM_LEVELS_V

View Text

SELECT DISTINCT NVL(SL.DIM_LEVEL_ID
, -999) DIM_LEVEL_ID
, IL.NAME NAME
, IL.SHORT_NAME
, IL.DIMENSION_ID
, DECODE(IL.SOURCE
, 'EDW'
, IL.SHORT_NAME || '_LTC'
, IL.LEVEL_VALUES_VIEW_NAME ) LEVEL_VIEW_NAME
, SL.LEVEL_VIEW_NAME BSC_LEVEL_VIEW_NAME
, NVL(SL.SOURCE
, 'PMF') BSC_SOURCE
, IL.SOURCE SOURCE
, DECODE(SL.SOURCE
, NULL
, 0
, 'PMF'
, 1
, 0 ) IMPORTED_FLAG
FROM BIS_LEVELS_VL IL
, BSC_SYS_DIM_LEVELS_VL SL
WHERE IL.SHORT_NAME = SL.SHORT_NAME (+) UNION (SELECT DISTINCT DIM_LEVEL_ID
, NAME
, SHORT_NAME
, -999 DIMENSION_ID
, LEVEL_VIEW_NAME LEVEL_VIEW_NAME
, LEVEL_VIEW_NAME BSC_LEVEL_VIEW_NAME
, SL.SOURCE BSC_SOURCE
, SL.SOURCE SOURCE
, 0 IMPORTED_FLAG
FROM BSC_SYS_DIM_LEVELS_VL SL
WHERE SL.SOURCE = 'BSC')

Columns