MSC_FCST_METHODS_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
METHOD_NAME METHOD_DESCRIPTION METHOD_ID METHOD_CODE BY_DEFAULT_ACTIVE DEF_MIN_OBSERVATION DEF_MAX_OBSERVATION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER MTHD_REL_MCH_TYPE |
問合せ
| SQL_Statement |
|---|
|
SELECT tl.METHOD_NAME, tl.METHOD_DESCRIPTION, b.METHOD_ID, b.METHOD_CODE, b.BY_DEFAULT_ACTIVE, b.DEF_MIN_OBSERVATION, b.DEF_MAX_OBSERVATION, b.CREATED_BY, b.CREATION_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER , b.MTHD_REL_MCH_TYPE FROM MSC_FCST_METHODS_TL tl, MSC_FCST_METHODS_B b WHERE b.METHOD_ID = tl.METHOD_ID AND tl.LANGUAGE = USERENV('LANG') |