FFS_ACTIVITY_LINK_TYPE_VL

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
TYPE_ID REGULAR_LABEL REVERSE_LABEL STATUS SEQUENCE MIN_INTERVAL MIN_INTERVAL_VALUE MAX_INTERVAL MAX_INTERVAL_VALUE SCHEDULING ASSIGNMENT REGULAR_NAME REVERSE_NAME DELETED_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT b.TYPE_ID TYPE_ID, b.REGULAR_LABEL REGULAR_LABEL, b.REVERSE_LABEL REVERSE_LABEL, b.STATUS STATUS, b.SEQUENCE SEQUENCE, b.MIN_INTERVAL MIN_INTERVAL, b.MIN_INTERVAL_VALUE MIN_INTERVAL_VALUE, b.MAX_INTERVAL MAX_INTERVAL, b.MAX_INTERVAL_VALUE MAX_INTERVAL_VALUE, b.SCHEDULING SCHEDULING, b.ASSIGNMENT ASSIGNMENT, nvl(tl.REGULAR_NAME, b.REGULAR_LABEL) REGULAR_NAME, nvl(tl.REVERSE_NAME, b.REVERSE_LABEL) REVERSE_NAME, b.DELETED_FLAG DELETED_FLAG, 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_link_type b left join ffs_activity_link_type_tl tl on b.TYPE_ID = tl.TYPE_ID and tl.LANGUAGE = USERENV('LANG')