[Home] [Help]
View: BSC_SYS_COLORS_VL
Product: | BSC - Balanced Scorecard (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT
B.COLOR_ID
,
B.SHORT_NAME
,
TL.NAME
,
TL.DESCRIPTION
,
TL.PROTOTYPE_LABEL
,
B.PERF_SEQUENCE
,
B.COLOR
,
B.USER_COLOR
,
B.FORECAST_COLOR
,
B.USER_FORECAST_COLOR
,
B.NUMERIC_EQUIVALENT
,
B.USER_NUMERIC_EQUIVALENT
,
B.USER_IMAGE_ID
,
B.CREATED_BY
,
B.CREATION_DATE
,
B.LAST_UPDATED_BY
,
B.LAST_UPDATE_DATE
,
B.LAST_UPDATE_LOGIN
FROM
BSC_SYS_COLORS_B B
,
BSC_SYS_COLORS_TL TL
WHERE
B.COLOR_ID = TL.COLOR_ID
AND TL.LANGUAGE = USERENV('LANG')