View: BSC_PMF_MEAS_V

Product:	BSC - Balanced Scorecard
Description:	View of the PMF measures for IBUILDER
Implementation/DBA Data:	APPS.BSC_PMF_MEAS_V

View Text

SELECT DISTINCT A.NAME
, A.HELP
, D.SHORT_NAME
, F.NAME
, BSC_UTILITY.GET_KPI_DIM_LEVELS(A.INDICATOR
, B.DIM_SET_ID)
, BSC_UTILITY.GET_KPI_DIM_LEVEL_SHORT_NAMES(A.INDICATOR
, B.DIM_SET_ID)
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.SOURCE = 'PMF'
AND D.SHORT_NAME = E.SHORT_NAME(+)
AND E.INDICATOR_ID = F.INDICATOR_ID(+)

Columns