FFS_ACTION_LINK_VL

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
ACTION_LINK_ID CUSTOM LABEL ENTITY INTERFACE BASE_LABEL FEATURES TYPE SERVICE_LABEL MAX_VISIBILITY URL NAME DELETED_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT b.ACTION_LINK_ID ACTION_LINK_ID, b.CUSTOM CUSTOM, b.LABEL LABEL, b.ENTITY ENTITY, b.INTERFACE INTERFACE, b.BASE_LABEL BASE_LABEL, b.FEATURES FEATURES, b.TYPE TYPE, b.SERVICE_LABEL SERVICE_LABEL, b.MAX_VISIBILITY MAX_VISIBILITY, b.URL URL, nvl (tl.NAME, b.LABEL) 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_action_link b left join ffs_action_link_tl tl on b.ACTION_LINK_ID = tl.ACTION_LINK_ID and tl.LANGUAGE = USERENV('LANG')