VCS_PARAMETERS_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: VCS
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PARAMETER_ID PARAMETER_CODE DATA_TYPE_CODE DATA_TYPE_CODE_2 NAME REFERENCE_TYPE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN |
問合せ
| SQL_Statement |
|---|
|
SELECT B.PARAMETER_ID PARAMETER_ID, B.PARAMETER_CODE PARAMETER_CODE, B.DATA_TYPE_CODE DATA_TYPE_CODE, B.DATA_TYPE_CODE_2 DATA_TYPE_CODE_2, T.NAME NAME, B.REFERENCE_TYPE REFERENCE_TYPE, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM vcs_parameters_b B, vcs_parameters_tl T WHERE B.PARAMETER_ID = T.PARAMETER_ID AND T.LANGUAGE = USERENV('LANG') |