WIS_WORK_INSTRUCTIONS_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: WIS
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
WORK_INSTRUCTION_ID OBJECT_VERSION_NUMBER WORK_INSTRUCTION_NAME WORK_INSTRUCTION_DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN |
問合せ
| SQL_Statement |
|---|
|
SELECT WIB.WORK_INSTRUCTION_ID WORK_INSTRUCTION_ID, WIB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, WITL.WORK_INSTRUCTION_NAME WORK_INSTRUCTION_NAME, WITL.WORK_INSTRUCTION_DESCRIPTION WORK_INSTRUCTION_DESCRIPTION, WIB.CREATED_BY CREATED_BY, WIB.CREATION_DATE CREATION_DATE, WIB.LAST_UPDATED_BY LAST_UPDATED_BY, WIB.LAST_UPDATE_DATE LAST_UPDATE_DATE, WIB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM WIS_WORK_INSTRUCTIONS_B WIB, WIS_WORK_INSTRUCTIONS_TL WITL WHERE WIB.WORK_INSTRUCTION_ID = WITL.WORK_INSTRUCTION_ID AND WITL.LANGUAGE = USERENV('LANG') |