Product: | BIS - Applications BIS |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BISFV_TARGET_LEVELS |
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.SHORT_NAME
, BIS_INDICATORS_TL.NAME
, BIS_TARGET_LEVELS.ORG_LEVEL_ID
, BIS_LEVELS_ORG.SHORT_NAME
, BIS_LEVELS_ORG_TL.NAME
, BIS_TARGET_LEVELS.TIME_LEVEL_ID
, BIS_LEVELS_TIME.SHORT_NAME
, BIS_LEVELS_TIME_TL.NAME
, BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID
, BIS_LEVELS_DIM1.SHORT_NAME
, BIS_LEVELS_DIM1_TL.NAME
, BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID
, BIS_LEVELS_DIM2.SHORT_NAME
, BIS_LEVELS_DIM2_TL.NAME
, BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID
, BIS_LEVELS_DIM3.SHORT_NAME
, BIS_LEVELS_DIM3_TL.NAME
, BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID
, BIS_LEVELS_DIM4.SHORT_NAME
, BIS_LEVELS_DIM4_TL.NAME
, BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID
, BIS_LEVELS_DIM5.SHORT_NAME
, BIS_LEVELS_DIM5_TL.NAME
, BIS_TARGET_LEVELS.DIMENSION6_LEVEL_ID
, BIS_LEVELS_DIM6.SHORT_NAME
, BIS_LEVELS_DIM6_TL.NAME
, BIS_TARGET_LEVELS.DIMENSION7_LEVEL_ID
, BIS_LEVELS_DIM7.SHORT_NAME
, 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_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_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_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_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_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_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_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_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_LEVELS_DIM7_TL.LANGUAGE(+) = USERENV('LANG') WITH READ ONLY