FFS_LAYOUT_ITEM_VL

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
ITEM_ID LAYOUT_ID LAYOUT_GROUP TYPE PARENT SORTING_ORDER ENTITY FIELD PROPERTY_ID ACTION_LINK_ID PRIVILEGE_OBJECT_ID DEFAULT_VISIBILITY FONT_STYLE FONT_SIZE TEXT_COLOR FORM_ID IS_SCANNER MIN_NUM_IMAGES MAX_NUM_IMAGES PARAMETERS TITLE DELETED_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT b.ITEM_ID ITEM_ID, b.LAYOUT_ID LAYOUT_ID, b.LAYOUT_GROUP LAYOUT_GROUP, b.TYPE TYPE, b.PARENT PARENT, b.SORTING_ORDER SORTING_ORDER, b.ENTITY ENTITY, b.FIELD FIELD, b.PROPERTY_ID PROPERTY_ID, b.ACTION_LINK_ID ACTION_LINK_ID, b.PRIVILEGE_OBJECT_ID PRIVILEGE_OBJECT_ID, b.DEFAULT_VISIBILITY DEFAULT_VISIBILITY, b.FONT_STYLE FONT_STYLE, b.FONT_SIZE FONT_SIZE, b.TEXT_COLOR TEXT_COLOR, b.FORM_ID FORM_ID, b.IS_SCANNER IS_SCANNER, b.MIN_NUM_IMAGES MIN_NUM_IMAGES, b.MAX_NUM_IMAGES MAX_NUM_IMAGES, b.PARAMETERS PARAMETERS, nullif (tl.title,'') TITLE, 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_layout_item b left join ffs_layout_item_tl tl on b.ITEM_ID = tl.ITEM_ID and tl.LANGUAGE = USERENV('LANG')