PER_EXT_TYPE_PARAMS

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
EXT_TYPE_PARAM_ID EXT_TYPE_CODE TYPE_PARAM_NAME BASE_TYPE_PARAM_NAME ESS_TYPE_PARAM_NAME XML_TAG_NAME DATA_TYPE ALLOWED_IN_EXPRESSION DESCRIPTION MODULE_ID LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_ID ENTERPRISE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER DEFAULT_HIDE_FLAG

Name

EXT_TYPE_PARAM_ID

EXT_TYPE_CODE

TYPE_PARAM_NAME

BASE_TYPE_PARAM_NAME

ESS_TYPE_PARAM_NAME

XML_TAG_NAME

DATA_TYPE

ALLOWED_IN_EXPRESSION

DESCRIPTION

MODULE_ID

LEGISLATION_CODE

LEGISLATIVE_DATA_GROUP_ID

ENTERPRISE_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

DEFAULT_HIDE_FLAG

Query

SQL_Statement
SELECT param.EXT_TYPE_PARAM_ID EXT_TYPE_PARAM_ID, param.EXT_TYPE_CODE EXT_TYPE_CODE, param_tl.TYPE_PARAM_NAME TYPE_PARAM_NAME, param.BASE_TYPE_PARAM_NAME BASE_TYPE_PARAM_NAME, param.ESS_TYPE_PARAM_NAME ESS_TYPE_PARAM_NAME, param.XML_TAG_NAME XML_TAG_NAME, param.DATA_TYPE DATA_TYPE, param.ALLOWED_IN_EXPRESSION ALLOWED_IN_EXPRESSION, param_tl.DESCRIPTION DESCRIPTION, param.MODULE_ID MODULE_ID, 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, param.DEFAULT_HIDE_FLAG DEFAULT_HIDE_FLAG FROM PER_EXT_TYPE_PARAMS_B param, PER_EXT_TYPE_PARAMS_TL param_tl WHERE param.EXT_TYPE_PARAM_ID = param_tl.EXT_TYPE_PARAM_ID AND param_tl.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

param.EXT_TYPE_PARAM_ID EXT_TYPE_PARAM_ID,

param.EXT_TYPE_CODE EXT_TYPE_CODE,

param_tl.TYPE_PARAM_NAME TYPE_PARAM_NAME,

param.BASE_TYPE_PARAM_NAME BASE_TYPE_PARAM_NAME,

param.ESS_TYPE_PARAM_NAME ESS_TYPE_PARAM_NAME,

param.XML_TAG_NAME XML_TAG_NAME,

param.DATA_TYPE DATA_TYPE,

param.ALLOWED_IN_EXPRESSION ALLOWED_IN_EXPRESSION,

param_tl.DESCRIPTION DESCRIPTION,

param.MODULE_ID MODULE_ID,

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,

param.DEFAULT_HIDE_FLAG DEFAULT_HIDE_FLAG

FROM

PER_EXT_TYPE_PARAMS_B param,

PER_EXT_TYPE_PARAMS_TL param_tl

WHERE

param.EXT_TYPE_PARAM_ID = param_tl.EXT_TYPE_PARAM_ID AND param_tl.LANGUAGE = USERENV('LANG')