機械翻訳について

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')