Product: | BIS - Applications BIS |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BISFV_TARGETS |
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