ZMM_ACTY_SUBTYPES_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ZMM
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ACTIVITY_SUBTYPE_ID ACTIVITY_SUBTYPE_CODE ACTIVITY_TYPE_CODE LANGUAGE MEANING SOURCE_LANG ENABLED_FLAG DEFAULT_FLAG START_DATE_ACTIVE END_DATE_ACTIVE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN |
問合せ
| SQL_Statement |
|---|
|
SELECT B.ACTIVITY_SUBTYPE_ID ACTIVITY_SUBTYPE_ID, B.ACTIVITY_SUBTYPE_CODE ACTIVITY_SUBTYPE_CODE, B.ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE, T.LANGUAGE LANGUAGE, T.MEANING MEANING, T.SOURCE_LANG SOURCE_LANG, B.ENABLED_FLAG ENABLED_FLAG, B.DEFAULT_FLAG DEFAULT_FLAG, B.START_DATE_ACTIVE START_DATE_ACTIVE, B.END_DATE_ACTIVE END_DATE_ACTIVE, 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 ZMM_ACTY_SUBTYPES_B B, ZMM_ACTY_SUBTYPES_TL T WHERE B.ACTIVITY_SUBTYPE_ID = T.ACTIVITY_SUBTYPE_ID AND T.LANGUAGE = USERENV('LANG') |