PER_EXT_PARAMETERS_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

EXT_PARAM_ID EXT_DEFINITION_ID XML_TAG_NAME DATA_TYPE ESS_PARAM_NAME LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_ID ENTERPRISE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER PARAM_NAME MODULE_ID BASE_PARAM_NAME DESCRIPTION ALLOWED_IN_EXPRESSION GENERATED PARAM_SEQUENCE DEFAULT_TYPE DEFAULT_VAL DISPLAY_FLAG PARAM_LOOKUP PARAM_USAGE_TYPE PARAM_DISP_TYPE PARAM_VALUE_SET SGUID

Query

SQL_Statement

SELECT param.EXT_PARAM_ID EXT_PARAM_ID, param.EXT_DEFINITION_ID EXT_DEFINITION_ID, param.XML_TAG_NAME XML_TAG_NAME, param.DATA_TYPE DATA_TYPE, param.ESS_PARAM_NAME ESS_PARAM_NAME, param.LEGISLATION_CODE LEGISLATION_CODE, param.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, param.ENTERPRISE_ID ENTERPRISE_ID, param.CREATED_BY CREATED_BY, param.CREATION_DATE CREATION_DATE, param.LAST_UPDATED_BY LAST_UPDATED_BY, param.LAST_UPDATE_DATE LAST_UPDATE_DATE, param.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, param.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, param_tl.PARAM_NAME PARAM_NAME, param.MODULE_ID MODULE_ID, param.BASE_PARAM_NAME BASE_PARAM_NAME, param_tl.DESCRIPTION DESCRIPTION, param.ALLOWED_IN_EXPRESSION ALLOWED_IN_EXPRESSION, param.GENERATED GENERATED, param.PARAM_SEQUENCE PARAM_SEQUENCE, param.DEFAULT_TYPE DEFAULT_TYPE, param.DEFAULT_VAL DEFAULT_VAL, param.DISPLAY_FLAG DISPLAY_FLAG, param.PARAM_LOOKUP PARAM_LOOKUP, param.PARAM_USAGE_TYPE PARAM_USAGE_TYPE, param.PARAM_DISP_TYPE PARAM_DISP_TYPE, param.PARAM_VALUE_SET PARAM_VALUE_SET, param.SGUID SGUID FROM PER_EXT_PARAMETERS_B param, PER_EXT_PARAMETERS_TL param_tl WHERE param.EXT_PARAM_ID = param_tl.EXT_PARAM_ID AND param_tl.LANGUAGE = USERENV('LANG')