[Home] [Help]
View: BSC_SYS_BENCHMARKS_VL
| Product: | BSC - Balanced Scorecard |
| Description: | View of BSC_SYS_BENCHMARKS_B and BSC_SYS_BENCHMARKS_TL. |
| Implementation/DBA Data: |
APPS.BSC_SYS_BENCHMARKS_VL
|
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
| Name |
| BM_ID |
| NAME |
| COLOR |
| DATA_TYPE |
| SOURCE_TYPE |
| PERIODICITY_ID |
| NO_DISPLAY_FLAG |