WIE_WO_OP_WORK_INSTRUCTIONS_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: WIE
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
B_ROW_ID WORK_INSTRUCTION_ID OBJECT_VERSION_NUMBER ORGANIZATION_ID WORK_ORDER_ID WO_OPERATION_ID WORK_INSTRUCTION_NAME WORK_INSTRUCTION_DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN |
問合せ
| SQL_Statement |
|---|
|
SELECT WOOPWIB.ROWID B_ROW_ID, WOOPWIB.WORK_INSTRUCTION_ID WORK_INSTRUCTION_ID, WOOPWIB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, WOOPWIB.ORGANIZATION_ID ORGANIZATION_ID, WOOPWIB.WORK_ORDER_ID WORK_ORDER_ID, WOOPWIB.WO_OPERATION_ID WO_OPERATION_ID, WOOPWIT.WORK_INSTRUCTION_NAME WORK_INSTRUCTION_NAME, WOOPWIT.WORK_INSTRUCTION_DESCRIPTION WORK_INSTRUCTION_DESCRIPTION, WOOPWIB.CREATED_BY CREATED_BY, WOOPWIB.CREATION_DATE CREATION_DATE, WOOPWIB.LAST_UPDATED_BY LAST_UPDATED_BY, WOOPWIB.LAST_UPDATE_DATE LAST_UPDATE_DATE, WOOPWIB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM WIE_WO_OP_WORK_INSTRUCTIONS_B WOOPWIB, WIE_WO_OP_WORK_INSTRUCTIONS_TL WOOPWIT WHERE WOOPWIT.WORK_INSTRUCTION_ID = WOOPWIB.WORK_INSTRUCTION_ID AND WOOPWIT.LANGUAGE = USERENV('LANG') |