1. Tables and Views for SCM
  2. WIS_WORK_INSTRUCTIONS_VL

WIS_WORK_INSTRUCTIONS_VL

Details

  • Schema: FUSION

  • Object owner: WIS

  • Object type: VIEW

Columns

Name

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

Query

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