[Home] [Help]
View: BIS_DISPLAY_MEASURES_V
View Text
(
SELECT BIS_IND.SHORT_NAME SHORT_NAME
,
DECODE(BSC_DSET.SOURCE
, 'BSC'
, BSC_DSET.NAME
, NVL(MEAS_EXT_VL.NAME
, IND_TL.NAME)) NAME
,
NVL(MEAS_EXT_VL.DESCRIPTION
, IND_TL.DESCRIPTION)
DESCRIPTION
, BIS_IND.ACTUAL_DATA_SOURCE ACTUAL_DATA_SOURCE
,
BIS_IND.FUNCTION_NAME FUNCTION_NAME
, NVL(MEAS_EXT_VL.FUNCTIONAL_AREA_ID
,
(SELECT FUNCTIONAL_AREA_ID
FROM BIS_FUNCTIONAL_AREAS
WHERE SHORT_NAME = 'BIS_UNN')) FUNCTIONAL_AREA_ID
, NVL(BIS_FUNC.NAME
,
(SELECT NAME
FROM BIS_FUNCTIONAL_AREAS_VL
WHERE SHORT_NAME = 'BIS_UNN'))
FUNCTION_AREA_NAME
, NVL(BIS_FUNC.SHORT_NAME
, 'BIS_UNN')
FUNCTION_AREA_SHORT_NAME
, MEAS_APP.APPLICATION_ID APPLICATION_ID
,
BIS_IND.ENABLED
, DECODE (BIS_IND.CREATED_BY
, 1
, 'Y'
, 2
, 'Y'
, 120
, 'Y'
, 'N') ISSEED
,
NVL(BIS_IND.OBSOLETE
, 'F') OBSOLETE
, BIS_IND.MEASURE_TYPE MEASURE_TYPE
FROM BIS_MEASURES_EXTENSION_VL MEAS_EXT_VL
, BIS_INDICATORS_TL IND_TL
,
BIS_INDICATORS BIS_IND
, BIS_APPLICATION_MEASURES MEAS_APP
,
BIS_FUNCTIONAL_AREAS_VL BIS_FUNC
, BSC_SYS_DATASETS_VL BSC_DSET
WHERE BIS_IND.SHORT_NAME = MEAS_EXT_VL.MEASURE_SHORT_NAME (+)
AND BIS_FUNC.FUNCTIONAL_AREA_ID = NVL(MEAS_EXT_VL.FUNCTIONAL_AREA_ID
,
(SELECT FUNCTIONAL_AREA_ID
FROM BIS_FUNCTIONAL_AREAS_VL
WHERE SHORT_NAME = 'BIS_UNN')) AND
BIS_IND.INDICATOR_ID = IND_TL.INDICATOR_ID
AND IND_TL.LANGUAGE =
USERENV('LANG')
AND BIS_IND.INDICATOR_ID = MEAS_APP.INDICATOR_ID
AND BSC_DSET.DATASET_ID = BIS_IND.DATASET_ID
)