VIEW: APPS.BSC_PMF_MEAS_V

Source

View Text - Preformatted

SELECT DISTINCT a.name, a.help, d.short_name, e.name, bsc_utility.get_kpi_dim_levels(a.indicator, a.dim_set_id), bsc_utility.get_kpi_dim_level_short_names(a.indicator, a.dim_set_id) FROM bsc_kpi_analysis_options_vl a, bsc_sys_datasets_b c, bsc_sys_measures d, bis_indicators_vl e WHERE 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.source = 'PMF' and d.short_name = e.short_name

View Text - HTML Formatted

SELECT DISTINCT A.NAME
, A.HELP
, D.SHORT_NAME
, E.NAME
, BSC_UTILITY.GET_KPI_DIM_LEVELS(A.INDICATOR
, A.DIM_SET_ID)
, BSC_UTILITY.GET_KPI_DIM_LEVEL_SHORT_NAMES(A.INDICATOR
, A.DIM_SET_ID)
FROM BSC_KPI_ANALYSIS_OPTIONS_VL A
, BSC_SYS_DATASETS_B C
, BSC_SYS_MEASURES D
, BIS_INDICATORS_VL E
WHERE 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.SOURCE = 'PMF'
AND D.SHORT_NAME = E.SHORT_NAME