eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BISBV_PERFORMANCE_MEASURES

Source

View Text - Preformatted


SELECT bis_indicators.INDICATOR_ID MEASURE_ID , bis_indicators.SHORT_NAME MEASURE_SHORT_NAME , bis_indicators_tl.NAME MEASURE_NAME , bis_indicators_tl.DESCRIPTION DESCRIPTION , bis_indicator_dimensions_dim1.DIMENSION_ID DIMENSION1_ID , bis_indicator_dimensions_dim2.DIMENSION_ID DIMENSION2_ID , bis_indicator_dimensions_dim3.DIMENSION_ID DIMENSION3_ID , bis_indicator_dimensions_dim4.DIMENSION_ID DIMENSION4_ID , bis_indicator_dimensions_dim5.DIMENSION_ID DIMENSION5_ID , bis_indicator_dimensions_dim6.DIMENSION_ID DIMENSION6_ID , bis_indicator_dimensions_dim7.DIMENSION_ID DIMENSION7_ID , bis_indicators.UOM_CLASS UNIT_OF_MEASURE_CLASS , bis_indicators.ACTUAL_DATA_SOURCE_TYPE ACTUAL_DATA_SOURCE_TYPE , bis_indicators.ACTUAL_DATA_SOURCE ACTUAL_DATA_SOURCE , bis_indicators.FUNCTION_NAME FUNCTION_NAME , bis_indicators.COMPARISON_SOURCE COMPARISON_SOURCE , bis_indicators.INCREASE_IN_MEASURE INCREASE_IN_MEASURE , bis_indicators.ENABLE_LINK ENABLE_LINK , bis_indicators.DATASET_ID DATASET_ID , bis_indicators.ENABLED ENABLED , NVL(bis_indicators.OBSOLETE,'F') OBSOLETE , bis_indicators.MEASURE_TYPE 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 WHERE bis_indicators.INDICATOR_ID = bis_indicators_tl.INDICATOR_ID AND bis_indicators_tl.LANGUAGE = USERENV('LANG') AND bis_indicators.INDICATOR_ID = bis_indicator_dimensions_dim1.INDICATOR_ID(+) AND 1 = bis_indicator_dimensions_dim1.SEQUENCE_NO(+) AND bis_indicators.INDICATOR_ID = bis_indicator_dimensions_dim2.INDICATOR_ID(+) AND 2 = bis_indicator_dimensions_dim2.SEQUENCE_NO(+) AND bis_indicators.INDICATOR_ID = bis_indicator_dimensions_dim3.INDICATOR_ID(+) AND 3 = bis_indicator_dimensions_dim3.SEQUENCE_NO(+) AND bis_indicators.INDICATOR_ID = bis_indicator_dimensions_dim4.INDICATOR_ID(+) AND 4 = bis_indicator_dimensions_dim4.SEQUENCE_NO(+) AND bis_indicators.INDICATOR_ID = bis_indicator_dimensions_dim5.INDICATOR_ID(+) AND 5 = bis_indicator_dimensions_dim5.SEQUENCE_NO(+) AND bis_indicators.INDICATOR_ID = bis_indicator_dimensions_dim6.INDICATOR_ID(+) AND 6 = bis_indicator_dimensions_dim6.SEQUENCE_NO(+) AND bis_indicators.INDICATOR_ID = bis_indicator_dimensions_dim7.INDICATOR_ID(+) AND 7 = bis_indicator_dimensions_dim7.SEQUENCE_NO(+) WITH READ ONLY

View Text - HTML Formatted

SELECT BIS_INDICATORS.INDICATOR_ID MEASURE_ID
, BIS_INDICATORS.SHORT_NAME MEASURE_SHORT_NAME
, BIS_INDICATORS_TL.NAME MEASURE_NAME
, BIS_INDICATORS_TL.DESCRIPTION DESCRIPTION
, BIS_INDICATOR_DIMENSIONS_DIM1.DIMENSION_ID DIMENSION1_ID
, BIS_INDICATOR_DIMENSIONS_DIM2.DIMENSION_ID DIMENSION2_ID
, BIS_INDICATOR_DIMENSIONS_DIM3.DIMENSION_ID DIMENSION3_ID
, BIS_INDICATOR_DIMENSIONS_DIM4.DIMENSION_ID DIMENSION4_ID
, BIS_INDICATOR_DIMENSIONS_DIM5.DIMENSION_ID DIMENSION5_ID
, BIS_INDICATOR_DIMENSIONS_DIM6.DIMENSION_ID DIMENSION6_ID
, BIS_INDICATOR_DIMENSIONS_DIM7.DIMENSION_ID DIMENSION7_ID
, BIS_INDICATORS.UOM_CLASS UNIT_OF_MEASURE_CLASS
, BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE ACTUAL_DATA_SOURCE_TYPE
, BIS_INDICATORS.ACTUAL_DATA_SOURCE ACTUAL_DATA_SOURCE
, BIS_INDICATORS.FUNCTION_NAME FUNCTION_NAME
, BIS_INDICATORS.COMPARISON_SOURCE COMPARISON_SOURCE
, BIS_INDICATORS.INCREASE_IN_MEASURE INCREASE_IN_MEASURE
, BIS_INDICATORS.ENABLE_LINK ENABLE_LINK
, BIS_INDICATORS.DATASET_ID DATASET_ID
, BIS_INDICATORS.ENABLED ENABLED
, NVL(BIS_INDICATORS.OBSOLETE
, 'F') OBSOLETE
, BIS_INDICATORS.MEASURE_TYPE 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
WHERE BIS_INDICATORS.INDICATOR_ID = BIS_INDICATORS_TL.INDICATOR_ID
AND BIS_INDICATORS_TL.LANGUAGE = USERENV('LANG')
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM1.INDICATOR_ID(+)
AND 1 = BIS_INDICATOR_DIMENSIONS_DIM1.SEQUENCE_NO(+)
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM2.INDICATOR_ID(+)
AND 2 = BIS_INDICATOR_DIMENSIONS_DIM2.SEQUENCE_NO(+)
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM3.INDICATOR_ID(+)
AND 3 = BIS_INDICATOR_DIMENSIONS_DIM3.SEQUENCE_NO(+)
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM4.INDICATOR_ID(+)
AND 4 = BIS_INDICATOR_DIMENSIONS_DIM4.SEQUENCE_NO(+)
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM5.INDICATOR_ID(+)
AND 5 = BIS_INDICATOR_DIMENSIONS_DIM5.SEQUENCE_NO(+)
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM6.INDICATOR_ID(+)
AND 6 = BIS_INDICATOR_DIMENSIONS_DIM6.SEQUENCE_NO(+)
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM7.INDICATOR_ID(+)
AND 7 = BIS_INDICATOR_DIMENSIONS_DIM7.SEQUENCE_NO(+) WITH READ ONLY