1. Tables and Views for SCM
  2. WIE_WO_OP_WORK_INSTRUCTIONS_VL

WIE_WO_OP_WORK_INSTRUCTIONS_VL

Details

  • Schema: FUSION

  • Object owner: WIE

  • Object type: VIEW

Columns

Name

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

Query

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