FFS_ACTIVITY_TYPE_VL

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name

TYPE_ID LABEL STATUS NODE_TYPE GROUP_ID FEATURES PENDING_COLOR STARTED_COLOR COMPLETE_COLOR SUSPENDED_COLOR CANCELLED_COLOR NOTDONE_COLOR NOT_ORDERED_COLOR WARNING_COLOR SEGMENT_MIN_DURATION SEGMENT_MAX_DURATION_PER_DAY SEGMENT_ROUND_TO SEGMENT_SW_RESERVATION SEGMENT_MAX_DAYS_TO_SKIP DEFAULT_DURATION_AVG ENROUTE_COLOR NAME CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT b.TYPE_ID TYPE_ID, b.LABEL LABEL, b.STATUS STATUS, b.NODE_TYPE NODE_TYPE, b.GROUP_ID GROUP_ID, b.FEATURES FEATURES, b.PENDING_COLOR PENDING_COLOR, b.STARTED_COLOR STARTED_COLOR, b.COMPLETE_COLOR COMPLETE_COLOR, b.SUSPENDED_COLOR SUSPENDED_COLOR, b.CANCELLED_COLOR CANCELLED_COLOR, b.NOTDONE_COLOR NOTDONE_COLOR, b.NOT_ORDERED_COLOR NOT_ORDERED_COLOR, b.WARNING_COLOR WARNING_COLOR, b.SEGMENT_MIN_DURATION SEGMENT_MIN_DURATION, b.SEGMENT_MAX_DURATION_PER_DAY SEGMENT_MAX_DURATION_PER_DAY, b.SEGMENT_ROUND_TO SEGMENT_ROUND_TO, b.SEGMENT_SW_RESERVATION SEGMENT_SW_RESERVATION, b.SEGMENT_MAX_DAYS_TO_SKIP SEGMENT_MAX_DAYS_TO_SKIP, b.DEFAULT_DURATION_AVG DEFAULT_DURATION_AVG, b.ENROUTE_COLOR ENROUTE_COLOR, nvl (tl.NAME, b.LABEL) NAME, 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 from ffs_activity_type b left join ffs_activity_type_tl tl on b.TYPE_ID = tl.TYPE_ID and tl.LANGUAGE = USERENV('LANG')