FFS_FORM_VL

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
FORM_ID LABEL STATUS FIELDS UPDATED_AT CREATED_AT MODIFIED_BY VERSION TYPE NAME DELETED_FLAG APPLICATION_ID FUSION_BUSINESS_OBJECT FUSION_CATEGORY_LABEL PDF_OPTIONS HTML_TEMPLATE HTML_TEMPLATE_METADATA OFFLINE_CONFIG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT b.FORM_ID FORM_ID, b.LABEL LABEL, b.STATUS STATUS, b.FIELDS FIELDS, b.UPDATED_AT UPDATED_AT, b.CREATED_AT CREATED_AT, b.MODIFIED_BY MODIFIED_BY, b.VERSION VERSION, b.TYPE TYPE, nvl (tl.NAME, b.LABEL) NAME, b.DELETED_FLAG DELETED_FLAG, b.APPLICATION_ID APPLICATION_ID, b.FUSION_BUSINESS_OBJECT FUSION_BUSINESS_OBJECT, b.FUSION_CATEGORY_LABEL FUSION_CATEGORY_LABEL, b.PDF_OPTIONS PDF_OPTIONS, b.HTML_TEMPLATE HTML_TEMPLATE, b.HTML_TEMPLATE_METADATA HTML_TEMPLATE_METADATA, b.OFFLINE_CONFIG OFFLINE_CONFIG, 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_form b left join ffs_form_tl tl on b.FORM_ID = tl.FORM_ID and tl.LANGUAGE = USERENV('LANG')