View: BISFV_PERFORMANCE_MEASURES

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BISFV_PERFORMANCE_MEASURES

View Text

SELECT BIS_INDICATORS.INDICATOR_ID
, BIS_INDICATORS.SHORT_NAME
, BIS_INDICATORS_TL.NAME
, BIS_INDICATORS_TL.DESCRIPTION
, BIS_INDICATOR_DIMENSIONS_DIM1.DIMENSION_ID
, BIS_DIMENSIONS_DIM1.SHORT_NAME
, BIS_DIMENSIONS_DIM1_TL.NAME
, BIS_INDICATOR_DIMENSIONS_DIM2.DIMENSION_ID
, BIS_DIMENSIONS_DIM2.SHORT_NAME
, BIS_DIMENSIONS_DIM2_TL.NAME
, BIS_INDICATOR_DIMENSIONS_DIM3.DIMENSION_ID
, BIS_DIMENSIONS_DIM3.SHORT_NAME
, BIS_DIMENSIONS_DIM3_TL.NAME
, BIS_INDICATOR_DIMENSIONS_DIM4.DIMENSION_ID
, BIS_DIMENSIONS_DIM4.SHORT_NAME
, BIS_DIMENSIONS_DIM4_TL.NAME
, BIS_INDICATOR_DIMENSIONS_DIM5.DIMENSION_ID
, BIS_DIMENSIONS_DIM5.SHORT_NAME
, BIS_DIMENSIONS_DIM5_TL.NAME
, BIS_INDICATOR_DIMENSIONS_DIM6.DIMENSION_ID
, BIS_DIMENSIONS_DIM6.SHORT_NAME
, BIS_DIMENSIONS_DIM6_TL.NAME
, BIS_INDICATOR_DIMENSIONS_DIM7.DIMENSION_ID
, BIS_DIMENSIONS_DIM7.SHORT_NAME
, BIS_DIMENSIONS_DIM7_TL.NAME
, BIS_INDICATORS.UOM_CLASS
, BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE
, BIS_INDICATORS.ACTUAL_DATA_SOURCE
, BIS_INDICATORS.FUNCTION_NAME
, BIS_INDICATORS.COMPARISON_SOURCE
, BIS_INDICATORS.INCREASE_IN_MEASURE
, BIS_INDICATORS.ENABLE_LINK
, BIS_INDICATORS.DATASET_ID
, BIS_INDICATORS.ENABLED
, NVL(BIS_INDICATORS.OBSOLETE
, 'F') OBSOLETE
, BIS_INDICATORS.MEASURE_TYPE
FROM BIS_INDICATORS BIS_INDICATORS
, BIS_INDICATORS_TL BIS_INDICATORS_TL
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM1
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM2
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM3
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM4
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM5
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM6
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM7
, BIS_DIMENSIONS BIS_DIMENSIONS_DIM1
, BIS_DIMENSIONS_TL BIS_DIMENSIONS_DIM1_TL
, BIS_DIMENSIONS BIS_DIMENSIONS_DIM2
, BIS_DIMENSIONS_TL BIS_DIMENSIONS_DIM2_TL
, BIS_DIMENSIONS BIS_DIMENSIONS_DIM3
, BIS_DIMENSIONS_TL BIS_DIMENSIONS_DIM3_TL
, BIS_DIMENSIONS BIS_DIMENSIONS_DIM4
, BIS_DIMENSIONS_TL BIS_DIMENSIONS_DIM4_TL
, BIS_DIMENSIONS BIS_DIMENSIONS_DIM5
, BIS_DIMENSIONS_TL BIS_DIMENSIONS_DIM5_TL
, BIS_DIMENSIONS BIS_DIMENSIONS_DIM6
, BIS_DIMENSIONS_TL BIS_DIMENSIONS_DIM6_TL
, BIS_DIMENSIONS BIS_DIMENSIONS_DIM7
, BIS_DIMENSIONS_TL BIS_DIMENSIONS_DIM7_TL
WHERE BIS_INDICATORS.INDICATOR_ID = BIS_INDICATORS_TL.INDICATOR_ID
AND BIS_INDICATORS_TL.LANGUAGE = USERENV('LANG') /* DIM1 */
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM1.INDICATOR_ID(+)
AND 1 = BIS_INDICATOR_DIMENSIONS_DIM1.SEQUENCE_NO(+)
AND BIS_INDICATOR_DIMENSIONS_DIM1.DIMENSION_ID = BIS_DIMENSIONS_DIM1.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM1.DIMENSION_ID = BIS_DIMENSIONS_DIM1_TL.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM1_TL.LANGUAGE(+) = USERENV('LANG') /* DIM2 */
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM2.INDICATOR_ID(+)
AND 2 = BIS_INDICATOR_DIMENSIONS_DIM2.SEQUENCE_NO(+)
AND BIS_INDICATOR_DIMENSIONS_DIM2.DIMENSION_ID = BIS_DIMENSIONS_DIM2.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM2.DIMENSION_ID = BIS_DIMENSIONS_DIM2_TL.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM2.DIMENSION_ID = BIS_DIMENSIONS_DIM2_TL.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM2_TL.LANGUAGE(+) = USERENV('LANG') /* DIM3 */
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM3.INDICATOR_ID(+)
AND 3 = BIS_INDICATOR_DIMENSIONS_DIM3.SEQUENCE_NO(+)
AND BIS_INDICATOR_DIMENSIONS_DIM3.DIMENSION_ID = BIS_DIMENSIONS_DIM3.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM3.DIMENSION_ID = BIS_DIMENSIONS_DIM3_TL.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM3_TL.LANGUAGE(+) = USERENV('LANG') /* DIM4 */
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM4.INDICATOR_ID(+)
AND 4 = BIS_INDICATOR_DIMENSIONS_DIM4.SEQUENCE_NO(+)
AND BIS_INDICATOR_DIMENSIONS_DIM4.DIMENSION_ID = BIS_DIMENSIONS_DIM4.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM4.DIMENSION_ID = BIS_DIMENSIONS_DIM4_TL.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM4_TL.LANGUAGE(+) = USERENV('LANG') /* DIM5 */
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM5.INDICATOR_ID(+)
AND 5 = BIS_INDICATOR_DIMENSIONS_DIM5.SEQUENCE_NO(+)
AND BIS_INDICATOR_DIMENSIONS_DIM5.DIMENSION_ID = BIS_DIMENSIONS_DIM5.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM5.DIMENSION_ID = BIS_DIMENSIONS_DIM5_TL.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM5_TL.LANGUAGE(+) = USERENV('LANG') /* DIM6 */
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM6.INDICATOR_ID(+)
AND 6 = BIS_INDICATOR_DIMENSIONS_DIM6.SEQUENCE_NO(+)
AND BIS_INDICATOR_DIMENSIONS_DIM6.DIMENSION_ID = BIS_DIMENSIONS_DIM6.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM6.DIMENSION_ID = BIS_DIMENSIONS_DIM6_TL.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM6_TL.LANGUAGE(+) = USERENV('LANG') /* DIM7 */
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM7.INDICATOR_ID(+)
AND 7 = BIS_INDICATOR_DIMENSIONS_DIM7.SEQUENCE_NO(+)
AND BIS_INDICATOR_DIMENSIONS_DIM7.DIMENSION_ID = BIS_DIMENSIONS_DIM7.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM7.DIMENSION_ID = BIS_DIMENSIONS_DIM7_TL.DIMENSION_ID(+)
AND BIS_DIMENSIONS_DIM7_TL.LANGUAGE(+) = USERENV('LANG') WITH READ ONLY

Columns