PAY_TASK_PARAMETERS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name

TASK_PARAMETER_ID BASE_TASK_PARAMETER_ID BASE_TASK_ACTION_ID BASE_TASK_PARAMETER_NAME MODULE_ID OBJECT_VERSION_NUMBER DISPLAY_FLAG PARAM_DISP_TYPE PARAM_USAGE_TYPE PARAM_SEQUENCE PARAM_LOOKUP PARAM_VALUE_SET DEFAULT_TYPE DEFAULT_VAL LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID DATA_TYPE DATA_DOMAIN NAMESPACE REPETITIVE_FLAG PARAMETER_TYPE ELEMENT_NAME PARENT_TASK_PARAM_ID DRIVING_LABEL_METHOD LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE PARAM_LEVEL PARAMETER_NAME DESCRIPTION SGUID HDL_ATTRIBUTE PARAMETER_CODE

Query

SQL_Statement

SELECT b.TASK_PARAMETER_ID, b.BASE_TASK_PARAMETER_ID, b.BASE_TASK_ACTION_ID, b.BASE_TASK_PARAMETER_NAME, b.MODULE_ID, b.OBJECT_VERSION_NUMBER, b.DISPLAY_FLAG, b.PARAM_DISP_TYPE, b.PARAM_USAGE_TYPE, b.PARAM_SEQUENCE, b.PARAM_LOOKUP, b.PARAM_VALUE_SET, b.DEFAULT_TYPE, b.DEFAULT_VAL, b.LEGISLATIVE_DATA_GROUP_ID, b.LEGISLATION_CODE, b.ENTERPRISE_ID, b.DATA_TYPE, b.DATA_DOMAIN, b.NAMESPACE, b.REPETITIVE_FLAG, b.PARAMETER_TYPE, b.ELEMENT_NAME, b.PARENT_TASK_PARAM_ID, b.DRIVING_LABEL_METHOD, b.LAST_UPDATE_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN, b.CREATED_BY, b.CREATION_DATE, b.PARAM_LEVEL, tl.PARAMETER_NAME, tl.DESCRIPTION, b.SGUID SGUID, b.HDL_ATTRIBUTE, b.PARAMETER_CODE FROM PAY_TASK_PARAMETERS b, PAY_TASK_PARAMETERS_TL tl WHERE b.TASK_PARAMETER_ID = tl.TASK_PARAMETER_ID AND USERENV('LANG') = tl.LANGUAGE