1. Tables and Views for SCM
  2. SMO_EVENT_TYPE_ATTRIBUTES_VL

SMO_EVENT_TYPE_ATTRIBUTES_VL

Details

  • Schema: FUSION

  • Object owner: SMO

  • Object type: VIEW

Columns

Name

EVENT_TYPE_ATTRIBUTE_ID

OBJECT_VERSION_NUMBER

EVENT_TYPE_ID

ATTRIBUTE_CODE

ATTRIBUTE_NAME

ATTRIBUTE_DESCRIPTION

DATA_TYPE

MANDATORY_FLAG

UOM_CODE

MIN_NUMERIC_VALUE

MAX_NUMERIC_VALUE

TARGET_NUMERIC_VALUE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

SETAB.EVENT_TYPE_ATTRIBUTE_ID EVENT_TYPE_ATTRIBUTE_ID,

SETAB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

SETAB.EVENT_TYPE_ID EVENT_TYPE_ID,

SETAB.ATTRIBUTE_CODE ATTRIBUTE_CODE,

SETATL.ATTRIBUTE_NAME ATTRIBUTE_NAME,

SETATL.ATTRIBUTE_DESCRIPTION ATTRIBUTE_DESCRIPTION,

SETAB.DATA_TYPE DATA_TYPE,

SETAB.MANDATORY_FLAG MANDATORY_FLAG,

SETAB.UOM_CODE UOM_CODE,

SETAB.MIN_NUMERIC_VALUE MIN_NUMERIC_VALUE,

SETAB.MAX_NUMERIC_VALUE MAX_NUMERIC_VALUE,

SETAB.TARGET_NUMERIC_VALUE TARGET_NUMERIC_VALUE,

SETAB.CREATED_BY CREATED_BY,

SETAB.CREATION_DATE CREATION_DATE,

SETAB.LAST_UPDATED_BY LAST_UPDATED_BY,

SETAB.LAST_UPDATE_DATE LAST_UPDATE_DATE,

SETAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM

SMO_EVENT_TYPE_ATTRIBUTES_B SETAB,

SMO_EVENT_TYPE_ATTRIBUTES_TL SETATL

WHERE

SETATL.EVENT_TYPE_ATTRIBUTE_ID = SETAB.EVENT_TYPE_ATTRIBUTE_ID AND SETATL.LANGUAGE = USERENV('LANG')