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.

VIEW: APPS.BSC_DB_COLOR_KPI_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'