VIEW: APPS.BISFV_TARGETS

Source

View Text - Preformatted

SELECT bis_target_values.TARGET_ID , bis_target_values.TARGET_LEVEL_ID , bis_target_levels.SHORT_NAME , bis_target_levels_tl.NAME , bis_target_values.PLAN_ID , bis_business_plans.SHORT_NAME , bis_business_plans_tl.NAME , bis_target_values.ORG_LEVEL_VALUE , bis_target_values.ORG_LEVEL_VALUE , bis_target_values.TIME_LEVEL_VALUE , bis_target_values.TIME_LEVEL_VALUE , bis_target_values.DIMENSION1_LEVEL_VALUE , bis_target_values.DIMENSION1_LEVEL_VALUE , bis_target_values.DIMENSION2_LEVEL_VALUE , bis_target_values.DIMENSION2_LEVEL_VALUE , bis_target_values.DIMENSION3_LEVEL_VALUE , bis_target_values.DIMENSION3_LEVEL_VALUE , bis_target_values.DIMENSION4_LEVEL_VALUE , bis_target_values.DIMENSION4_LEVEL_VALUE , bis_target_values.DIMENSION5_LEVEL_VALUE , bis_target_values.DIMENSION5_LEVEL_VALUE , bis_target_values.DIMENSION6_LEVEL_VALUE , bis_target_values.DIMENSION6_LEVEL_VALUE , bis_target_values.DIMENSION7_LEVEL_VALUE , bis_target_values.DIMENSION7_LEVEL_VALUE , bis_target_values.TARGET , bis_target_values.RANGE1_LOW , bis_target_values.RANGE1_HIGH , bis_target_values.RANGE2_LOW , bis_target_values.RANGE2_HIGH , bis_target_values.RANGE3_LOW , bis_target_values.RANGE3_HIGH , bis_target_values.ROLE1_ID , bis_target_values.ROLE1 , BIS_UTILITIES_PUB.resolve_role_name(bis_target_values.ROLE1) , bis_target_values.ROLE2_ID , bis_target_values.ROLE2 , BIS_UTILITIES_PUB.resolve_role_name(bis_target_values.ROLE2) , bis_target_values.ROLE3_ID , bis_target_values.ROLE3 , BIS_UTILITIES_PUB.resolve_role_name(bis_target_values.ROLE3) FROM bis_target_values bis_target_values , bis_target_levels bis_target_levels , bis_target_levels_tl bis_target_levels_tl , bis_business_plans bis_business_plans , bis_business_plans_tl bis_business_plans_tl WHERE bis_target_values.TARGET_LEVEL_ID = bis_target_levels.TARGET_LEVEL_ID AND bis_target_levels.TARGET_LEVEL_ID = bis_target_levels_tl.TARGET_LEVEL_ID AND bis_target_levels_tl.LANGUAGE = USERENV('LANG') AND bis_target_values.PLAN_ID = bis_business_plans.PLAN_ID AND bis_business_plans.PLAN_ID = bis_business_plans_tl.PLAN_ID AND bis_business_plans_tl.LANGUAGE = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT BIS_TARGET_VALUES.TARGET_ID
, BIS_TARGET_VALUES.TARGET_LEVEL_ID
, BIS_TARGET_LEVELS.SHORT_NAME
, BIS_TARGET_LEVELS_TL.NAME
, BIS_TARGET_VALUES.PLAN_ID
, BIS_BUSINESS_PLANS.SHORT_NAME
, BIS_BUSINESS_PLANS_TL.NAME
, BIS_TARGET_VALUES.ORG_LEVEL_VALUE
, BIS_TARGET_VALUES.ORG_LEVEL_VALUE
, BIS_TARGET_VALUES.TIME_LEVEL_VALUE
, BIS_TARGET_VALUES.TIME_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION6_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION6_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION7_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION7_LEVEL_VALUE
, BIS_TARGET_VALUES.TARGET
, BIS_TARGET_VALUES.RANGE1_LOW
, BIS_TARGET_VALUES.RANGE1_HIGH
, BIS_TARGET_VALUES.RANGE2_LOW
, BIS_TARGET_VALUES.RANGE2_HIGH
, BIS_TARGET_VALUES.RANGE3_LOW
, BIS_TARGET_VALUES.RANGE3_HIGH
, BIS_TARGET_VALUES.ROLE1_ID
, BIS_TARGET_VALUES.ROLE1
, BIS_UTILITIES_PUB.RESOLVE_ROLE_NAME(BIS_TARGET_VALUES.ROLE1)
, BIS_TARGET_VALUES.ROLE2_ID
, BIS_TARGET_VALUES.ROLE2
, BIS_UTILITIES_PUB.RESOLVE_ROLE_NAME(BIS_TARGET_VALUES.ROLE2)
, BIS_TARGET_VALUES.ROLE3_ID
, BIS_TARGET_VALUES.ROLE3
, BIS_UTILITIES_PUB.RESOLVE_ROLE_NAME(BIS_TARGET_VALUES.ROLE3)
FROM BIS_TARGET_VALUES BIS_TARGET_VALUES
, BIS_TARGET_LEVELS BIS_TARGET_LEVELS
, BIS_TARGET_LEVELS_TL BIS_TARGET_LEVELS_TL
, BIS_BUSINESS_PLANS BIS_BUSINESS_PLANS
, BIS_BUSINESS_PLANS_TL BIS_BUSINESS_PLANS_TL
WHERE BIS_TARGET_VALUES.TARGET_LEVEL_ID = BIS_TARGET_LEVELS.TARGET_LEVEL_ID
AND BIS_TARGET_LEVELS.TARGET_LEVEL_ID = BIS_TARGET_LEVELS_TL.TARGET_LEVEL_ID
AND BIS_TARGET_LEVELS_TL.LANGUAGE = USERENV('LANG')
AND BIS_TARGET_VALUES.PLAN_ID = BIS_BUSINESS_PLANS.PLAN_ID
AND BIS_BUSINESS_PLANS.PLAN_ID = BIS_BUSINESS_PLANS_TL.PLAN_ID
AND BIS_BUSINESS_PLANS_TL.LANGUAGE = USERENV('LANG') WITH READ ONLY