MSC_ENG_PARAMETERS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PARAMETER_ID PARAMETER_NAME PARAMETER_COL_TYPE PARAMETER_DEF_VALUE_NUM PARAMETER_DEF_VALUE_DATE PARAMETER_DEF_VALUE_STR CHANGE_SCALE EDITABLE DISPLAY_CATEGORY DISPLAY_GROUP CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PARAMETER_DESCRIPTION

Query

SQL_Statement

SELECT B.PARAMETER_ID, B.PARAMETER_NAME, B.PARAMETER_COL_TYPE, B.PARAMETER_DEF_VALUE_NUM, B.PARAMETER_DEF_VALUE_DATE, B.PARAMETER_DEF_VALUE_STR, B.CHANGE_SCALE, B.EDITABLE, B.DISPLAY_CATEGORY, B.DISPLAY_GROUP, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.PARAMETER_DESCRIPTION FROM MSC_ENG_PARAMETERS_B B, MSC_ENG_PARAMETERS_TL T WHERE B.PARAMETER_ID = T.PARAMETER_ID AND T.LANGUAGE = USERENV('LANG')