FND Design Data [Home] [Help]

View: BSC_USER_PARAMETERS_VL

Product: BSC - Balanced Scorecard
Description: View of BSC_USER_PARAMETERS_B and BSC_USER_PARAMETERS_TL.
Implementation/DBA Data: ViewAPPS.BSC_USER_PARAMETERS_VL
View Text

SELECT B.PARAM_LIST_ID
, TL.TITLE
, B.APPLICATION_ID
, B.INDICATOR
, B.VIEW_TYPE
, B.VALID_FLAG
, B.ANALYSIS_MEASURES
, B.DIMENSION1
, B.DIMENSION2
, B.DIMENSION3
, B.DIMENSION4
, B.DIMENSION5
, B.DIMENSION6
, B.DIMENSION7
, B.DIMENSION8
, B.DIMENSION9
, B.DIMENSION10
, B.TIME_PERIOD
, B.DATA_SERIES
, B.CALCULATIONS
, B.BENCHMARKS
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM BSC_USER_PARAMETERS_B B
, BSC_USER_PARAMETERS_TL TL
WHERE B.PARAM_LIST_ID = TL.PARAM_LIST_ID
AND TL.LANGUAGE = USERENV('LANG')

Columns

Name
PARAM_LIST_ID
TITLE
APPLICATION_ID
INDICATOR
VIEW_TYPE
VALID_FLAG
ANALYSIS_MEASURES
DIMENSION1
DIMENSION2
DIMENSION3
DIMENSION4
DIMENSION5
DIMENSION6
DIMENSION7
DIMENSION8
DIMENSION9
DIMENSION10
TIME_PERIOD
DATA_SERIES
CALCULATIONS
BENCHMARKS
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN