Product: | BIS - Applications BIS |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BIS_TARGET_VALUES_V |
SELECT A.TARGET_ID
, A.TARGET_LEVEL_ID
, A.PLAN_ID
, B.NAME PLAN_NAME
, A.ORG_LEVEL_VALUE
, A.TIME_LEVEL_VALUE
, A.DIMENSION1_LEVEL_VALUE
, A.DIMENSION2_LEVEL_VALUE
, A.DIMENSION3_LEVEL_VALUE
, A.DIMENSION4_LEVEL_VALUE
, A.DIMENSION5_LEVEL_VALUE
, A.DIMENSION6_LEVEL_VALUE
, A.DIMENSION7_LEVEL_VALUE
, A.TARGET
, A.RANGE1_LOW
, A.RANGE1_HIGH
, A.RANGE2_LOW
, A.RANGE2_HIGH
, A.RANGE3_LOW
, A.RANGE3_HIGH
, A.ROLE1_ID
, A.ROLE2_ID
, A.ROLE3_ID
, A.ROLE1
, A.ROLE2
, A.ROLE3
, A.ROWID ROW_ID
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
FROM BIS_TARGET_VALUES A
, BIS_BUSINESS_PLANS_VL B
WHERE A.PLAN_ID = B.PLAN_ID