HEX_CONFIG_PARAM_FEATURES_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

PARAM_FEATURE_ID BASE_PARAM_FEATURE_CODE PARAM_FEATURE_NAME DESCRIPTION PARAM_FEATURE_DEFAULT_VALUE PARAM_FEATURE_TYPE LEGACY_PARAM_FEATURE_CODE LEGACY_COMPATIBLE MANDATORY_FLAG ENABLED_FLAG PARAM_FEAT_LOOKUP_TYPE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ENTERPRISE_ID MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SGUID

Query

SQL_Statement

SELECT confparamb.PARAM_FEATURE_ID, confparamb.BASE_PARAM_FEATURE_CODE, confparamtl.PARAM_FEATURE_NAME, confparamtl.DESCRIPTION, confparamb.PARAM_FEATURE_DEFAULT_VALUE, confparamb.PARAM_FEATURE_TYPE, confparamb.LEGACY_PARAM_FEATURE_CODE, confparamb.LEGACY_COMPATIBLE, confparamb.MANDATORY_FLAG, confparamb.ENABLED_FLAG, confparamb.PARAM_FEAT_LOOKUP_TYPE, confparamb.ATTRIBUTE_CATEGORY, confparamb.ATTRIBUTE1, confparamb.ATTRIBUTE2, confparamb.ATTRIBUTE3, confparamb.ATTRIBUTE4, confparamb.ATTRIBUTE5, confparamb.ENTERPRISE_ID, confparamb.MODULE_ID, confparamb.CREATED_BY, confparamb.CREATION_DATE, confparamb.LAST_UPDATED_BY, confparamb.LAST_UPDATE_DATE, confparamb.LAST_UPDATE_LOGIN, confparamb.OBJECT_VERSION_NUMBER, confparamb.SGUID SGUID FROM HEX_CONFIG_PARAM_FEATURES_B confparamb, HEX_CONFIG_PARAM_FEATURES_TL confparamtl WHERE confparamb.PARAM_FEATURE_ID = confparamtl.PARAM_FEATURE_ID AND confparamtl.LANGUAGE = USERENV('LANG')