PAY_FLOW_TASK_PARAMETERS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name

FLOW_TASK_PARAM_ID BASE_FLOW_TASK_PARAM_ID BASE_PARAMETER_NAME MODULE_ID OBJECT_VERSION_NUMBER BASE_FLOW_TASK_ID BASE_FLOW_PARAMETER_ID BASE_TASK_PARAMETER_ID DISPLAY_FLAG PARAM_DISP_TYPE PARAM_USAGE_TYPE PARAM_VALUE_SET PARAM_LOOKUP PARAM_SEQUENCE DEFAULT_TYPE DEFAULT_VAL LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE PARAMETER_NAME DESCRIPTION SGUID

Query

SQL_Statement

SELECT b.FLOW_TASK_PARAM_ID, b.BASE_FLOW_TASK_PARAM_ID, b.BASE_PARAMETER_NAME, b.MODULE_ID, b.OBJECT_VERSION_NUMBER, b.BASE_FLOW_TASK_ID, b.BASE_FLOW_PARAMETER_ID, b.BASE_TASK_PARAMETER_ID, b.DISPLAY_FLAG, b.PARAM_DISP_TYPE, b.PARAM_USAGE_TYPE, b.PARAM_VALUE_SET, b.PARAM_LOOKUP, b.PARAM_SEQUENCE, b.DEFAULT_TYPE, b.DEFAULT_VAL, b.LEGISLATIVE_DATA_GROUP_ID, b.LEGISLATION_CODE, b.ENTERPRISE_ID, b.LAST_UPDATE_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN, b.CREATED_BY, b.CREATION_DATE, tl.PARAMETER_NAME, tl.DESCRIPTION, b.SGUID SGUID FROM PAY_FLOW_TASK_PARAMETERS b, PAY_FLOW_TASK_PARAMETERS_TL tl WHERE b.FLOW_TASK_PARAM_ID = tl.FLOW_TASK_PARAM_ID AND USERENV('LANG') = tl.LANGUAGE