SMO_EVENT_TYPES_VL

Details

• Schema: FUSION

• Object owner: SMO

• Object type: VIEW

Columns

Name
EVENT_TYPE_ID OBJECT_VERSION_NUMBER BO_TYPE_ID BO_KIND_ID EVENT_TYPE_CODE EVENT_TYPE_NAME EVENT_TYPE_DESCRIPTION SEEDED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT SETB.EVENT_TYPE_ID EVENT_TYPE_ID, SETB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SETB.BO_TYPE_ID BO_TYPE_ID, SETB.BO_KIND_ID BO_KIND_ID, SETB.EVENT_TYPE_CODE EVENT_TYPE_CODE, SETTL.EVENT_TYPE_NAME EVENT_TYPE_NAME, SETTL.EVENT_TYPE_DESCRIPTION EVENT_TYPE_DESCRIPTION, SETB.SEEDED_FLAG SEEDED_FLAG, SETB.CREATED_BY CREATED_BY, SETB.CREATION_DATE CREATION_DATE, SETB.LAST_UPDATED_BY LAST_UPDATED_BY, SETB.LAST_UPDATE_DATE LAST_UPDATE_DATE, SETB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM SMO_EVENT_TYPES_B SETB, SMO_EVENT_TYPES_TL SETTL WHERE SETTL.EVENT_TYPE_ID = SETB.EVENT_TYPE_ID AND SETTL.LANGUAGE = USERENV('LANG')