1. Tables and Views for SCM
  2. WIE_WO_OP_WI_STEPS_VL

WIE_WO_OP_WI_STEPS_VL

Details

  • Schema: FUSION

  • Object owner: WIE

  • Object type: VIEW

Columns

Name

B_ROW_ID

STEP_ID

OBJECT_VERSION_NUMBER

STEP_SEQUENCE

WORK_INSTRUCTION_ID

STEP_NAME

STEP_DESCRIPTION

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

WOOPWISB.ROWID B_ROW_ID,

WOOPWISB.STEP_ID STEP_ID,

WOOPWISB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

WOOPWISB.STEP_SEQUENCE STEP_SEQUENCE,

WOOPWISB.WORK_INSTRUCTION_ID WORK_INSTRUCTION_ID,

WOOPWIST.STEP_NAME STEP_NAME,

WOOPWIST.STEP_DESCRIPTION STEP_DESCRIPTION,

WOOPWISB.CREATED_BY CREATED_BY,

WOOPWISB.CREATION_DATE CREATION_DATE,

WOOPWISB.LAST_UPDATED_BY LAST_UPDATED_BY,

WOOPWISB.LAST_UPDATE_DATE LAST_UPDATE_DATE,

WOOPWISB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM

WIE_WO_OP_WI_STEPS_B WOOPWISB,

WIE_WO_OP_WI_STEPS_TL WOOPWIST

WHERE

WOOPWIST.STEP_ID = WOOPWISB.STEP_ID AND WOOPWIST.LANGUAGE = USERENV('LANG')