VIEW: APPS.BISFV_PERFORMANCE_MEASURES

Source

View Text - Preformatted

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
   

View Text - HTML Formatted

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