[Home] [Help]
View: BSC_SYS_BENCHMARKS_VL
Product: | BSC - Balanced Scorecard (Obsolete) |
Description: | View of BSC_SYS_BENCHMARKS_B and BSC_SYS_BENCHMARKS_TL. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT B.BM_ID
, TL.NAME
, B.COLOR
, B.DATA_TYPE
, B.SOURCE_TYPE
, B.PERIODICITY_ID
, B.NO_DISPLAY_FLAG FROM BSC_SYS_BENCHMARKS_B B
, BSC_SYS_BENCHMARKS_TL TL
WHERE B.BM_ID = TL.BM_ID
AND TL.LANGUAGE = USERENV('LANG')
Columns
BM_ID |
NAME |
COLOR |
DATA_TYPE |
SOURCE_TYPE |
PERIODICITY_ID |
NO_DISPLAY_FLAG |
Name |