eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BISBV_TARGETS

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT BIS_TARGET_VALUES.TARGET_ID
, BIS_TARGET_VALUES.TARGET_LEVEL_ID
, BIS_TARGET_VALUES.PLAN_ID
, BIS_TARGET_VALUES.ORG_LEVEL_VALUE
, BIS_TARGET_VALUES.TIME_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE
, BIS_TARGET_VALUES.DIMENSION6_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_TARGET_VALUES.ROLE2_ID
, BIS_TARGET_VALUES.ROLE2
, BIS_TARGET_VALUES.ROLE3_ID
, BIS_TARGET_VALUES.ROLE3
FROM BIS_TARGET_VALUES BIS_TARGET_VALUES WITH READ ONLY

Columns

Name
TARGET_ID
TARGET_LEVEL_ID
PLAN_ID
ORG_LEVEL_VALUE_ID
TIME_LEVEL_VALUE_ID
DIM1_LEVEL_VALUE_ID
DIM2_LEVEL_VALUE_ID
DIM3_LEVEL_VALUE_ID
DIM4_LEVEL_VALUE_ID
DIM5_LEVEL_VALUE_ID
DIM6_LEVEL_VALUE_ID
DIM7_LEVEL_VALUE_ID
TARGET
RANGE1_LOW
RANGE1_HIGH
RANGE2_LOW
RANGE2_HIGH
RANGE3_LOW
RANGE3_HIGH
NOTIFY_RESP1_ID
NOTIFY_RESP1_SHORT_NAME
NOTIFY_RESP2_ID
NOTIFY_RESP2_SHORT_NAME
NOTIFY_RESP3_ID
NOTIFY_RESP3_SHORT_NAME