FND Design Data [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: ViewAPPS.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