View: BSC_DB_COLOR_KPI_V

Product:	BSC - Balanced Scorecard
Description:
Implementation/DBA Data:	APPS.BSC_DB_COLOR_KPI_V

View Text

SELECT TI.TAB_ID AS TAB_ID
, TI.INDICATOR AS INDICATOR
, KPI.PERIODICITY_ID
, KPI_DIM.NAME AS COMP_LEVEL_NAME
, KPI_DIM.LEVEL_PK_COL AS COMP_LEVEL_PK_COL
, KPI_D.DIM_SET_ID
, NVL(KPI_C.DEFAULT_VALUE
, 0) AS YTD_FLAG FROM BSC_TAB_INDICATORS TI
, BSC_KPIS_B KPI
, BSC_DB_COLOR_KPI_DEFAULTS_V KPI_D
, BSC_KPI_CALCULATIONS KPI_C
, BSC_KPI_DIM_LEVELS_VL KPI_DIM WHERE KPI.PROTOTYPE_FLAG <> 2 AND KPI_C.CALCULATION_ID =2 AND TI.INDICATOR = KPI.INDICATOR AND KPI.INDICATOR = KPI_D.INDICATOR AND KPI.INDICATOR = KPI_C.INDICATOR (+) AND KPI_D.INDICATOR =KPI_DIM.INDICATOR(+) AND KPI_D.DIM_SET_ID = KPI_DIM.DIM_SET_ID(+) AND KPI_DIM.DEFAULT_VALUE(+) = 'C'

Columns