FFS_INVENTORY_TYPE_VL

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
TYPE_ID LABEL FEATURES STATUS MODEL_PROPERTY_ID QUANTITIES_PRECISION NAME DELETED_FLAG 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.FEATURES FEATURES, b.STATUS STATUS, b.MODEL_PROPERTY_ID MODEL_PROPERTY_ID, b.QUANTITIES_PRECISION QUANTITIES_PRECISION, nullif (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_inventory_type b left join ffs_inventory_type_tl tl on b.TYPE_ID = tl.TYPE_ID and tl.LANGUAGE = USERENV('LANG')