VIEW: APPS.BIS_DISPLAY_MEASURES_V

Source

View Text - Preformatted

(
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
)

View Text - HTML Formatted

( 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 )