VIEW: APPS.BSC_OPTS_PMF_MEAS_V

Source

View Text - Preformatted

SELECT DISTINCT a.indicator ,a.analysis_group_id AS option_group_id ,a.option_id ,a.name AS option_name ,a.help AS description ,bsc_utility.get_dataset_id(a.indicator, a.analysis_group_id, a.option_id) AS dataset_id ,c.measure_id1 AS measure_id ,d.short_name AS meas_short_name ,d.source AS meas_source ,e.indicator_id AS pmf_indicator_id ,f.name AS pmf_meas_name ,b.dim_set_id AS dim_set_id ,bsc_utility.get_kpi_dim_levels(a.indicator, b.dim_set_id) AS dim_levels FROM bsc_kpi_analysis_options_tl a ,bsc_kpi_analysis_options_b b ,bsc_sys_datasets_b c ,bsc_sys_measures d ,bis_indicators e ,bis_indicators_tl f WHERE a.indicator = b.indicator and a.analysis_group_id = b.analysis_group_id and a.option_id = b.option_id and c.dataset_id = bsc_utility.get_dataset_id(a.indicator, a.analysis_group_id, a.option_id) and d.measure_id = c.measure_id1 and d.short_name = e.short_name(+) and e.indicator_id = f.indicator_id(+)

View Text - HTML Formatted

SELECT DISTINCT A.INDICATOR
, A.ANALYSIS_GROUP_ID AS OPTION_GROUP_ID
, A.OPTION_ID
, A.NAME AS OPTION_NAME
, A.HELP AS DESCRIPTION
, BSC_UTILITY.GET_DATASET_ID(A.INDICATOR
, A.ANALYSIS_GROUP_ID
, A.OPTION_ID) AS DATASET_ID
, C.MEASURE_ID1 AS MEASURE_ID
, D.SHORT_NAME AS MEAS_SHORT_NAME
, D.SOURCE AS MEAS_SOURCE
, E.INDICATOR_ID AS PMF_INDICATOR_ID
, F.NAME AS PMF_MEAS_NAME
, B.DIM_SET_ID AS DIM_SET_ID
, BSC_UTILITY.GET_KPI_DIM_LEVELS(A.INDICATOR
, B.DIM_SET_ID) AS DIM_LEVELS
FROM BSC_KPI_ANALYSIS_OPTIONS_TL A
, BSC_KPI_ANALYSIS_OPTIONS_B B
, BSC_SYS_DATASETS_B C
, BSC_SYS_MEASURES D
, BIS_INDICATORS E
, BIS_INDICATORS_TL F
WHERE A.INDICATOR = B.INDICATOR
AND A.ANALYSIS_GROUP_ID = B.ANALYSIS_GROUP_ID
AND A.OPTION_ID = B.OPTION_ID
AND C.DATASET_ID = BSC_UTILITY.GET_DATASET_ID(A.INDICATOR
, A.ANALYSIS_GROUP_ID
, A.OPTION_ID)
AND D.MEASURE_ID = C.MEASURE_ID1
AND D.SHORT_NAME = E.SHORT_NAME(+)
AND E.INDICATOR_ID = F.INDICATOR_ID(+)