FFS_PROPERTY_DESC_VL

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
PROPERTY_ID ENTITY LABEL TYPE TEMPLATE GUI LINE_COUNT DUPLICATE MIME_TYPES OPTIONS MAX_IMAGE_SIZE_X MAX_IMAGE_SIZE_Y XSL_REGEX XSL_TRANSFORMATOR FILE_SIZE_LIMIT APPLICATION_LABEL FUSION_BUSINESS_OBJECT FUSION_CATEGORY_LABEL NAME HINT DELETED_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT b.PROPERTY_ID PROPERTY_ID, b.ENTITY ENTITY, b.LABEL LABEL, b.TYPE TYPE, b.TEMPLATE TEMPLATE, b.GUI GUI, b.LINE_COUNT LINE_COUNT, b.DUPLICATE DUPLICATE, b.MIME_TYPES MIME_TYPES, b.OPTIONS OPTIONS, b.MAX_IMAGE_SIZE_X MAX_IMAGE_SIZE_X, b.MAX_IMAGE_SIZE_Y MAX_IMAGE_SIZE_Y, b.XSL_REGEX XSL_REGEX, b.XSL_TRANSFORMATOR XSL_TRANSFORMATOR, b.FILE_SIZE_LIMIT FILE_SIZE_LIMIT, b.APPLICATION_LABEL APPLICATION_LABEL, b.FUSION_BUSINESS_OBJECT FUSION_BUSINESS_OBJECT, b.FUSION_CATEGORY_LABEL FUSION_CATEGORY_LABEL, nullif (tl.name,'') NAME, nullif (tl.hint,'') HINT, 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_property_desc b left join ffs_property_desc_tl tl on b.PROPERTY_ID = tl.PROPERTY_ID and tl.LANGUAGE = USERENV('LANG')