1. Tables and Views for SCM
  2. WIS_WORK_INSTR_STEP_DETAILS_VL

WIS_WORK_INSTR_STEP_DETAILS_VL

Details

  • Schema: FUSION

  • Object owner: WIS

  • Object type: VIEW

Columns

Name

STEP_DETAIL_ID

OBJECT_VERSION_NUMBER

STEP_ID

OBJECT_TYPE

OBJECT_PK1_VALUE

DISPLAY_SLOT_NUMBER

STEP_DETAIL_TEXT

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

WISDB.STEP_DETAIL_ID,

WISDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

WISDB.STEP_ID STEP_ID,

WISDB.OBJECT_TYPE OBJECT_TYPE,

WISDB.OBJECT_PK1_VALUE OBJECT_PK1_VALUE,

WISDB.DISPLAY_SLOT_NUMBER DISPLAY_SLOT_NUMBER,

WISDTL.STEP_DETAIL_TEXT STEP_DETAIL_TEXT,

WISDB.CREATED_BY CREATED_BY,

WISDB.CREATION_DATE CREATION_DATE,

WISDB.LAST_UPDATED_BY LAST_UPDATED_BY,

WISDB.LAST_UPDATE_DATE LAST_UPDATE_DATE,

WISDB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM

WIS_WORK_INSTR_STEP_DETAILS_B WISDB,

WIS_WORK_INSTR_STEP_DETAILS_TL WISDTL

WHERE

WISDB.STEP_DETAIL_ID = WISDTL.STEP_DETAIL_ID AND WISDTL.LANGUAGE = USERENV('LANG')