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.BISFV_TARGET_LEVELS

Source

View Text - Preformatted


SELECT bis_target_levels.TARGET_LEVEL_ID , bis_target_levels.SHORT_NAME , bis_target_levels_tl.NAME , bis_target_levels_tl.DESCRIPTION , bis_target_levels.INDICATOR_ID , bis_indicators.DATASET_ID , bis_indicators.SHORT_NAME , bis_indicators_tl.NAME , bis_target_levels.ORG_LEVEL_ID , bis_levels_org.SHORT_NAME , NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_name(bis_target_levels.ORG_LEVEL_ID),bis_levels_org_tl.NAME) , bis_target_levels.TIME_LEVEL_ID , bis_levels_time.SHORT_NAME , NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_name(bis_target_levels.TIME_LEVEL_ID),bis_levels_time_tl.NAME) , bis_target_levels.DIMENSION1_LEVEL_ID , bis_levels_dim1.SHORT_NAME , NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_name(bis_target_levels.DIMENSION1_LEVEL_ID),bis_levels_dim1_tl.NAME) , bis_target_levels.DIMENSION2_LEVEL_ID , bis_levels_dim2.SHORT_NAME , NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_name(bis_target_levels.DIMENSION2_LEVEL_ID),bis_levels_dim2_tl.NAME) , bis_target_levels.DIMENSION3_LEVEL_ID , bis_levels_dim3.SHORT_NAME , NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_name(bis_target_levels.DIMENSION3_LEVEL_ID),bis_levels_dim3_tl.NAME) , bis_target_levels.DIMENSION4_LEVEL_ID , bis_levels_dim4.SHORT_NAME , NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_name(bis_target_levels.DIMENSION4_LEVEL_ID),bis_levels_dim4_tl.NAME) , bis_target_levels.DIMENSION5_LEVEL_ID , bis_levels_dim5.SHORT_NAME , NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_name(bis_target_levels.DIMENSION5_LEVEL_ID),bis_levels_dim5_tl.NAME) , bis_target_levels.DIMENSION6_LEVEL_ID , bis_levels_dim6.SHORT_NAME , NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_name(bis_target_levels.DIMENSION6_LEVEL_ID),bis_levels_dim6_tl.NAME) , bis_target_levels.DIMENSION7_LEVEL_ID , bis_levels_dim7.SHORT_NAME , NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_name(bis_target_levels.DIMENSION7_LEVEL_ID),bis_levels_dim7_tl.NAME) , bis_target_levels.WF_ITEM_TYPE , bis_target_levels.WF_PROCESS , BIS_UTILITIES_PUB.resolve_full_activity_name ( bis_target_levels.WF_PROCESS , bis_target_levels.WF_ITEM_TYPE ) , bis_target_levels.DEFAULT_ROLE_ID , bis_target_levels.DEFAULT_ROLE , BIS_UTILITIES_PUB.resolve_role_name(bis_target_levels.DEFAULT_ROLE) , bis_target_levels.DEFAULT_COMPUTING_FUNCTION_ID , BIS_UTILITIES_PUB.resolve_function_name (bis_target_levels.DEFAULT_COMPUTING_FUNCTION_ID) , BIS_UTILITIES_PUB.resolve_full_function_name (bis_target_levels.DEFAULT_COMPUTING_FUNCTION_ID) , bis_target_levels.REPORT_FUNCTION_ID , BIS_UTILITIES_PUB.resolve_function_name (bis_target_levels.REPORT_FUNCTION_ID) , BIS_UTILITIES_PUB.resolve_full_function_name (bis_target_levels.REPORT_FUNCTION_ID) , bis_target_levels_tl.UNIT_OF_MEASURE , bis_target_levels.SYSTEM_FLAG , bis_target_levels.SOURCE FROM bis_target_levels bis_target_levels , bis_target_levels_tl bis_target_levels_tl , bis_indicators bis_indicators , bis_indicators_tl bis_indicators_tl , bis_levels bis_levels_org , bis_levels_tl bis_levels_org_tl , bis_levels bis_levels_time , bis_levels_tl bis_levels_time_tl , bis_levels bis_levels_dim1 , bis_levels_tl bis_levels_dim1_tl , bis_levels bis_levels_dim2 , bis_levels_tl bis_levels_dim2_tl , bis_levels bis_levels_dim3 , bis_levels_tl bis_levels_dim3_tl , bis_levels bis_levels_dim4 , bis_levels_tl bis_levels_dim4_tl , bis_levels bis_levels_dim5 , bis_levels_tl bis_levels_dim5_tl , bis_levels bis_levels_dim6 , bis_levels_tl bis_levels_dim6_tl , bis_levels bis_levels_dim7 , bis_levels_tl bis_levels_dim7_tl WHERE bis_target_levels.TARGET_LEVEL_ID = bis_target_levels_tl.TARGET_LEVEL_ID AND bis_target_levels_tl.LANGUAGE = USERENV('LANG') AND bis_target_levels.INDICATOR_ID = bis_indicators.INDICATOR_ID AND bis_indicators.INDICATOR_ID = bis_indicators_tl.INDICATOR_ID AND bis_indicators_tl.LANGUAGE = USERENV('LANG') AND bis_target_levels.ORG_LEVEL_ID = bis_levels_org.LEVEL_ID (+) AND bis_levels_org.LEVEL_ID = bis_levels_org_tl.LEVEL_ID (+) AND (bis_target_levels.ORG_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_enabled(bis_target_levels.ORG_LEVEL_ID ), bis_levels_org.ENABLED)='T') AND bis_levels_org_tl.LANGUAGE(+) = USERENV('LANG') AND bis_target_levels.TIME_LEVEL_ID = bis_levels_time.LEVEL_ID (+) AND bis_levels_time.LEVEL_ID = bis_levels_time_tl.LEVEL_ID (+) AND (bis_target_levels.TIME_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_enabled(bis_target_levels.TIME_LEVEL_ID ), bis_levels_time.ENABLED)='T' ) AND bis_levels_time_tl.LANGUAGE(+) = USERENV('LANG') AND bis_target_levels.DIMENSION1_LEVEL_ID = bis_levels_dim1.LEVEL_ID(+) AND bis_levels_dim1.LEVEL_ID = bis_levels_dim1_tl.LEVEL_ID(+) AND (bis_target_levels.DIMENSION1_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_enabled(bis_target_levels.DIMENSION1_LEVEL_ID ), bis_levels_dim1.ENABLED)='T' ) AND bis_levels_dim1_tl.LANGUAGE(+) = USERENV('LANG') AND bis_target_levels.DIMENSION2_LEVEL_ID = bis_levels_dim2.LEVEL_ID(+) AND bis_levels_dim2.LEVEL_ID = bis_levels_dim2_tl.LEVEL_ID(+) AND (bis_target_levels.DIMENSION2_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_enabled(bis_target_levels.DIMENSION2_LEVEL_ID ), bis_levels_dim2.ENABLED)='T' ) AND bis_levels_dim2_tl.LANGUAGE(+) = USERENV('LANG') AND bis_target_levels.DIMENSION3_LEVEL_ID = bis_levels_dim3.LEVEL_ID(+) AND bis_levels_dim3.LEVEL_ID = bis_levels_dim3_tl.LEVEL_ID(+) AND (bis_target_levels.DIMENSION3_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_enabled(bis_target_levels.DIMENSION3_LEVEL_ID), bis_levels_dim3.ENABLED)='T' ) AND bis_levels_dim3_tl.LANGUAGE(+) = USERENV('LANG') AND bis_target_levels.DIMENSION4_LEVEL_ID = bis_levels_dim4.LEVEL_ID(+) AND bis_levels_dim4.LEVEL_ID = bis_levels_dim4_tl.LEVEL_ID(+) AND (bis_target_levels.DIMENSION4_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_enabled(bis_target_levels.DIMENSION4_LEVEL_ID ), bis_levels_dim4.ENABLED)='T' ) AND bis_levels_dim4_tl.LANGUAGE(+) = USERENV('LANG') AND bis_target_levels.DIMENSION5_LEVEL_ID = bis_levels_dim5.LEVEL_ID(+) AND bis_levels_dim5.LEVEL_ID = bis_levels_dim5_tl.LEVEL_ID(+) AND (bis_target_levels.DIMENSION5_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_enabled(bis_target_levels.DIMENSION5_LEVEL_ID ), bis_levels_dim5.ENABLED)='T' ) AND bis_levels_dim5_tl.LANGUAGE(+) = USERENV('LANG') AND bis_target_levels.DIMENSION6_LEVEL_ID = bis_levels_dim6.LEVEL_ID(+) AND bis_levels_dim6.LEVEL_ID = bis_levels_dim6_tl.LEVEL_ID(+) AND (bis_target_levels.DIMENSION6_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_enabled(bis_target_levels.DIMENSION6_LEVEL_ID ), bis_levels_dim6.ENABLED)='T' ) AND bis_levels_dim6_tl.LANGUAGE(+) = USERENV('LANG') AND bis_target_levels.DIMENSION7_LEVEL_ID = bis_levels_dim7.LEVEL_ID(+) AND bis_levels_dim7.LEVEL_ID = bis_levels_dim7_tl.LEVEL_ID(+) AND (bis_target_levels.DIMENSION7_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.get_customized_enabled(bis_target_levels.DIMENSION7_LEVEL_ID ), bis_levels_dim7.ENABLED)='T' ) AND bis_levels_dim7_tl.LANGUAGE(+) = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT BIS_TARGET_LEVELS.TARGET_LEVEL_ID
, BIS_TARGET_LEVELS.SHORT_NAME
, BIS_TARGET_LEVELS_TL.NAME
, BIS_TARGET_LEVELS_TL.DESCRIPTION
, BIS_TARGET_LEVELS.INDICATOR_ID
, BIS_INDICATORS.DATASET_ID
, BIS_INDICATORS.SHORT_NAME
, BIS_INDICATORS_TL.NAME
, BIS_TARGET_LEVELS.ORG_LEVEL_ID
, BIS_LEVELS_ORG.SHORT_NAME
, NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(BIS_TARGET_LEVELS.ORG_LEVEL_ID)
, BIS_LEVELS_ORG_TL.NAME)
, BIS_TARGET_LEVELS.TIME_LEVEL_ID
, BIS_LEVELS_TIME.SHORT_NAME
, NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(BIS_TARGET_LEVELS.TIME_LEVEL_ID)
, BIS_LEVELS_TIME_TL.NAME)
, BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID
, BIS_LEVELS_DIM1.SHORT_NAME
, NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID)
, BIS_LEVELS_DIM1_TL.NAME)
, BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID
, BIS_LEVELS_DIM2.SHORT_NAME
, NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID)
, BIS_LEVELS_DIM2_TL.NAME)
, BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID
, BIS_LEVELS_DIM3.SHORT_NAME
, NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID)
, BIS_LEVELS_DIM3_TL.NAME)
, BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID
, BIS_LEVELS_DIM4.SHORT_NAME
, NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID)
, BIS_LEVELS_DIM4_TL.NAME)
, BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID
, BIS_LEVELS_DIM5.SHORT_NAME
, NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID)
, BIS_LEVELS_DIM5_TL.NAME)
, BIS_TARGET_LEVELS.DIMENSION6_LEVEL_ID
, BIS_LEVELS_DIM6.SHORT_NAME
, NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(BIS_TARGET_LEVELS.DIMENSION6_LEVEL_ID)
, BIS_LEVELS_DIM6_TL.NAME)
, BIS_TARGET_LEVELS.DIMENSION7_LEVEL_ID
, BIS_LEVELS_DIM7.SHORT_NAME
, NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(BIS_TARGET_LEVELS.DIMENSION7_LEVEL_ID)
, BIS_LEVELS_DIM7_TL.NAME)
, BIS_TARGET_LEVELS.WF_ITEM_TYPE
, BIS_TARGET_LEVELS.WF_PROCESS
, BIS_UTILITIES_PUB.RESOLVE_FULL_ACTIVITY_NAME ( BIS_TARGET_LEVELS.WF_PROCESS
, BIS_TARGET_LEVELS.WF_ITEM_TYPE )
, BIS_TARGET_LEVELS.DEFAULT_ROLE_ID
, BIS_TARGET_LEVELS.DEFAULT_ROLE
, BIS_UTILITIES_PUB.RESOLVE_ROLE_NAME(BIS_TARGET_LEVELS.DEFAULT_ROLE)
, BIS_TARGET_LEVELS.DEFAULT_COMPUTING_FUNCTION_ID
, BIS_UTILITIES_PUB.RESOLVE_FUNCTION_NAME (BIS_TARGET_LEVELS.DEFAULT_COMPUTING_FUNCTION_ID)
, BIS_UTILITIES_PUB.RESOLVE_FULL_FUNCTION_NAME (BIS_TARGET_LEVELS.DEFAULT_COMPUTING_FUNCTION_ID)
, BIS_TARGET_LEVELS.REPORT_FUNCTION_ID
, BIS_UTILITIES_PUB.RESOLVE_FUNCTION_NAME (BIS_TARGET_LEVELS.REPORT_FUNCTION_ID)
, BIS_UTILITIES_PUB.RESOLVE_FULL_FUNCTION_NAME (BIS_TARGET_LEVELS.REPORT_FUNCTION_ID)
, BIS_TARGET_LEVELS_TL.UNIT_OF_MEASURE
, BIS_TARGET_LEVELS.SYSTEM_FLAG
, BIS_TARGET_LEVELS.SOURCE
FROM BIS_TARGET_LEVELS BIS_TARGET_LEVELS
, BIS_TARGET_LEVELS_TL BIS_TARGET_LEVELS_TL
, BIS_INDICATORS BIS_INDICATORS
, BIS_INDICATORS_TL BIS_INDICATORS_TL
, BIS_LEVELS BIS_LEVELS_ORG
, BIS_LEVELS_TL BIS_LEVELS_ORG_TL
, BIS_LEVELS BIS_LEVELS_TIME
, BIS_LEVELS_TL BIS_LEVELS_TIME_TL
, BIS_LEVELS BIS_LEVELS_DIM1
, BIS_LEVELS_TL BIS_LEVELS_DIM1_TL
, BIS_LEVELS BIS_LEVELS_DIM2
, BIS_LEVELS_TL BIS_LEVELS_DIM2_TL
, BIS_LEVELS BIS_LEVELS_DIM3
, BIS_LEVELS_TL BIS_LEVELS_DIM3_TL
, BIS_LEVELS BIS_LEVELS_DIM4
, BIS_LEVELS_TL BIS_LEVELS_DIM4_TL
, BIS_LEVELS BIS_LEVELS_DIM5
, BIS_LEVELS_TL BIS_LEVELS_DIM5_TL
, BIS_LEVELS BIS_LEVELS_DIM6
, BIS_LEVELS_TL BIS_LEVELS_DIM6_TL
, BIS_LEVELS BIS_LEVELS_DIM7
, BIS_LEVELS_TL BIS_LEVELS_DIM7_TL
WHERE BIS_TARGET_LEVELS.TARGET_LEVEL_ID = BIS_TARGET_LEVELS_TL.TARGET_LEVEL_ID
AND BIS_TARGET_LEVELS_TL.LANGUAGE = USERENV('LANG')
AND BIS_TARGET_LEVELS.INDICATOR_ID = BIS_INDICATORS.INDICATOR_ID
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATORS_TL.INDICATOR_ID
AND BIS_INDICATORS_TL.LANGUAGE = USERENV('LANG')
AND BIS_TARGET_LEVELS.ORG_LEVEL_ID = BIS_LEVELS_ORG.LEVEL_ID (+)
AND BIS_LEVELS_ORG.LEVEL_ID = BIS_LEVELS_ORG_TL.LEVEL_ID (+)
AND (BIS_TARGET_LEVELS.ORG_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_ENABLED(BIS_TARGET_LEVELS.ORG_LEVEL_ID )
, BIS_LEVELS_ORG.ENABLED)='T')
AND BIS_LEVELS_ORG_TL.LANGUAGE(+) = USERENV('LANG')
AND BIS_TARGET_LEVELS.TIME_LEVEL_ID = BIS_LEVELS_TIME.LEVEL_ID (+)
AND BIS_LEVELS_TIME.LEVEL_ID = BIS_LEVELS_TIME_TL.LEVEL_ID (+)
AND (BIS_TARGET_LEVELS.TIME_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_ENABLED(BIS_TARGET_LEVELS.TIME_LEVEL_ID )
, BIS_LEVELS_TIME.ENABLED)='T' )
AND BIS_LEVELS_TIME_TL.LANGUAGE(+) = USERENV('LANG')
AND BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID = BIS_LEVELS_DIM1.LEVEL_ID(+)
AND BIS_LEVELS_DIM1.LEVEL_ID = BIS_LEVELS_DIM1_TL.LEVEL_ID(+)
AND (BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_ENABLED(BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID )
, BIS_LEVELS_DIM1.ENABLED)='T' )
AND BIS_LEVELS_DIM1_TL.LANGUAGE(+) = USERENV('LANG')
AND BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID = BIS_LEVELS_DIM2.LEVEL_ID(+)
AND BIS_LEVELS_DIM2.LEVEL_ID = BIS_LEVELS_DIM2_TL.LEVEL_ID(+)
AND (BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_ENABLED(BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID )
, BIS_LEVELS_DIM2.ENABLED)='T' )
AND BIS_LEVELS_DIM2_TL.LANGUAGE(+) = USERENV('LANG')
AND BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID = BIS_LEVELS_DIM3.LEVEL_ID(+)
AND BIS_LEVELS_DIM3.LEVEL_ID = BIS_LEVELS_DIM3_TL.LEVEL_ID(+)
AND (BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_ENABLED(BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID)
, BIS_LEVELS_DIM3.ENABLED)='T' )
AND BIS_LEVELS_DIM3_TL.LANGUAGE(+) = USERENV('LANG')
AND BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID = BIS_LEVELS_DIM4.LEVEL_ID(+)
AND BIS_LEVELS_DIM4.LEVEL_ID = BIS_LEVELS_DIM4_TL.LEVEL_ID(+)
AND (BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_ENABLED(BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID )
, BIS_LEVELS_DIM4.ENABLED)='T' )
AND BIS_LEVELS_DIM4_TL.LANGUAGE(+) = USERENV('LANG')
AND BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID = BIS_LEVELS_DIM5.LEVEL_ID(+)
AND BIS_LEVELS_DIM5.LEVEL_ID = BIS_LEVELS_DIM5_TL.LEVEL_ID(+)
AND (BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_ENABLED(BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID )
, BIS_LEVELS_DIM5.ENABLED)='T' )
AND BIS_LEVELS_DIM5_TL.LANGUAGE(+) = USERENV('LANG')
AND BIS_TARGET_LEVELS.DIMENSION6_LEVEL_ID = BIS_LEVELS_DIM6.LEVEL_ID(+)
AND BIS_LEVELS_DIM6.LEVEL_ID = BIS_LEVELS_DIM6_TL.LEVEL_ID(+)
AND (BIS_TARGET_LEVELS.DIMENSION6_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_ENABLED(BIS_TARGET_LEVELS.DIMENSION6_LEVEL_ID )
, BIS_LEVELS_DIM6.ENABLED)='T' )
AND BIS_LEVELS_DIM6_TL.LANGUAGE(+) = USERENV('LANG')
AND BIS_TARGET_LEVELS.DIMENSION7_LEVEL_ID = BIS_LEVELS_DIM7.LEVEL_ID(+)
AND BIS_LEVELS_DIM7.LEVEL_ID = BIS_LEVELS_DIM7_TL.LEVEL_ID(+)
AND (BIS_TARGET_LEVELS.DIMENSION7_LEVEL_ID IS NULL OR NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_ENABLED(BIS_TARGET_LEVELS.DIMENSION7_LEVEL_ID )
, BIS_LEVELS_DIM7.ENABLED)='T' )
AND BIS_LEVELS_DIM7_TL.LANGUAGE(+) = USERENV('LANG') WITH READ ONLY