FFS_UTYPE_VL

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
TYPE_ID LABEL DISPLAY_PROFILE_ID STATUS IS_MAINTENANCE USER_TYPE_COMMENT APPLICATION_ID NAME DELETED_FLAG JOB_ROLES 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.DISPLAY_PROFILE_ID DISPLAY_PROFILE_ID, b.STATUS STATUS, b.IS_MAINTENANCE IS_MAINTENANCE, b.USER_TYPE_COMMENT USER_TYPE_COMMENT, b.APPLICATION_ID APPLICATION_ID, nvl (tl.NAME, b.LABEL) NAME, b.DELETED_FLAG DELETED_FLAG, b.JOB_ROLES JOB_ROLES, 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_utype b left join ffs_utype_tl tl on b.TYPE_ID = tl.TYPE_ID and tl.LANGUAGE = USERENV('LANG')