SELECT DISTINCT
DATA.INDICATOR ,
DATA.ANALYSIS_OPTION0 AS A0 ,
DATA.ANALYSIS_OPTION1 AS A1 ,
DATA.ANALYSIS_OPTION2 AS A2 ,
DATA.SERIES_ID AS SERIES_ID ,
NVL(BASIC.DIM_SET_ID , 0) AS DIM_SET_ID ,
DATA.DATASET_ID ,
DATA.DEFAULT_VALUE AS DEFAULT_VALUE ,
DATA.KPI_MEASURE_ID
FROM
BSC_DB_BASIC_DIM_SETS_V BASIC ,
BSC_KPI_ANALYSIS_MEASURES_VL DATA
WHERE
DATA.INDICATOR = BASIC.INDICATOR (+)
AND DATA.ANALYSIS_OPTION0 = BASIC.A0 (+)
AND DATA.ANALYSIS_OPTION1 = BASIC.A1 (+)
AND DATA.ANALYSIS_OPTION2 = BASIC.A2 (+)
APPS.BSC_DB_DATASET_DIM_SETS_V
[Home] [Help]