[Home] [Help]
View: BIS_TARGET_VALUES_V
Product: | BIS - Applications BIS |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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
Columns
Name |
TARGET_ID |
TARGET_LEVEL_ID |
PLAN_ID |
PLAN_NAME |
ORG_LEVEL_VALUE |
TIME_LEVEL_VALUE |
DIMENSION1_LEVEL_VALUE |
DIMENSION2_LEVEL_VALUE |
DIMENSION3_LEVEL_VALUE |
DIMENSION4_LEVEL_VALUE |
DIMENSION5_LEVEL_VALUE |
DIMENSION6_LEVEL_VALUE |
DIMENSION7_LEVEL_VALUE |
TARGET |
RANGE1_LOW |
RANGE1_HIGH |
RANGE2_LOW |
RANGE2_HIGH |
RANGE3_LOW |
RANGE3_HIGH |
ROLE1_ID |
ROLE2_ID |
ROLE3_ID |
ROLE1 |
ROLE2 |
ROLE3 |
ROW_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |