1. Tables and Views for SCM
  2. SMO_COMMAND_TYPES_VL

SMO_COMMAND_TYPES_VL

Details

  • Schema: FUSION

  • Object owner: SMO

  • Object type: VIEW

Columns

Name

COMMAND_TYPE_ID

OBJECT_VERSION_NUMBER

BO_TYPE_ID

BO_KIND_ID

COMMAND_TYPE_CODE

EVENT_TYPE_ID

COMMAND_TYPE_NAME

COMMAND_TYPE_DESCRIPTION

SEEDED_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

SCTB.COMMAND_TYPE_ID COMMAND_TYPE_ID,

SCTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

SCTB.BO_TYPE_ID BO_TYPE_ID,

SCTB.BO_KIND_ID BO_KIND_ID,

SCTB.COMMAND_TYPE_CODE COMMAND_TYPE_CODE,

SCTB.EVENT_TYPE_ID EVENT_TYPE_ID,

SCTTL.COMMAND_TYPE_NAME COMMAND_TYPE_NAME,

SCTTL.COMMAND_TYPE_DESCRIPTION COMMAND_TYPE_DESCRIPTION,

SCTB.SEEDED_FLAG SEEDED_FLAG,

SCTB.CREATED_BY CREATED_BY,

SCTB.CREATION_DATE CREATION_DATE,

SCTB.LAST_UPDATED_BY LAST_UPDATED_BY,

SCTB.LAST_UPDATE_DATE LAST_UPDATE_DATE,

SCTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM

SMO_COMMAND_TYPES_B SCTB,

SMO_COMMAND_TYPES_TL SCTTL

WHERE

SCTTL.COMMAND_TYPE_ID = SCTB.COMMAND_TYPE_ID AND SCTTL.LANGUAGE = USERENV('LANG')