SVC_WO_ACTIVITY_TYPES_VL

Details

• Schema: FUSION

• Object owner: SVC

• Object type: VIEW

Columns

Name
WO_ACTIVITY_TYPE_ID WO_ACTIVITY_TYPE_NUMBER WO_ACTIVITY_TYPE_CD WO_INTEGRATION_CD FS_ACTIVITY_TYPE_ID FS_ACTIVITY_TYPE_CD ENABLED_FLAG DISPLAY_SEQUENCE ESTIMATED_DURATION NAME DESCRIPTION CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT b.WO_ACTIVITY_TYPE_ID WO_ACTIVITY_TYPE_ID, b.WO_ACTIVITY_TYPE_NUMBER WO_ACTIVITY_TYPE_NUMBER, b.WO_ACTIVITY_TYPE_CD WO_ACTIVITY_TYPE_CD, b.WO_INTEGRATION_CD WO_INTEGRATION_CD, b.FS_ACTIVITY_TYPE_ID FS_ACTIVITY_TYPE_ID, b.FS_ACTIVITY_TYPE_CD FS_ACTIVITY_TYPE_CD, b.ENABLED_FLAG ENABLED_FLAG, b.DISPLAY_SEQUENCE DISPLAY_SEQUENCE, b.ESTIMATED_DURATION ESTIMATED_DURATION, tl.NAME NAME, tl.DESCRIPTION DESCRIPTION, b.CREATION_DATE CREATION_DATE, b.CREATED_BY CREATED_BY, b.LAST_UPDATE_DATE LAST_UPDATE_DATE, b.LAST_UPDATED_BY LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM svc_wo_activity_types_b b, svc_wo_activity_types_tl tl WHERE b.WO_ACTIVITY_TYPE_ID = tl.WO_ACTIVITY_TYPE_ID AND tl.LANGUAGE = USERENV('LANG')