MSC_GRP_CLASSIFICATIONS_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
GROUP_ID CLASSIFICATION_ID CLASSIFICATION_NAME CLASSIFICATION_DESC CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CLASSIFICATION_CODE |
問合せ
| SQL_Statement |
|---|
|
SELECT b.GROUP_ID, b.CLASSIFICATION_ID, tl.CLASSIFICATION_NAME, tl.CLASSIFICATION_DESC, b.CREATED_BY, b.CREATION_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER , b.CLASSIFICATION_CODE FROM MSC_GRP_CLASSIFICATIONS_B b, MSC_GRP_CLASSIFICATIONS_TL tl WHERE b.CLASSIFICATION_ID = tl.CLASSIFICATION_ID AND tl.LANGUAGE = USERENV('LANG') |