View: BIS_DISPLAY_MEASURES_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.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 )