PAY_FLOW_TASKS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name

FLOW_TASK_ID BASE_FLOW_TASK_ID BASE_FLOW_TASK_NAME MODULE_ID OBJECT_VERSION_NUMBER BASE_TASK_ID BASE_FLOW_ID DEST_UI_URL CATEGORY_TYPE SUB_CATEGORY_TYPE PRE_CUSTOM_SERVICE POST_CUSTOM_SERVICE OFFSET_VALUE OFFSET_FLOW_PARAMETER_ID LEGISLATIVE_DATA_GROUP_ID ENTERPRISE_ID LEGISLATION_CODE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE START_DATE_OFFSET_ID START_DATE_OFFSET_VALUE START_NOTIF_FLAG END_NOTIF_FLAG OVERDUE_NOTIF_FLAG WARNING_NOTIF_FLAG ERROR_NOTIF_FLAG START_SCH_TIME_DEF_ID FLOW_TASK_NAME CHECKLIST_NAME DESCRIPTION FORMULA_ID START_SCH_FORMULA_ID SUBMITTING_USER_FLAG SGUID ESS_REQUEST_CATEGORY IGNORE_PREREQ_FLAG EMP_ALERT_CODE CMPLETD_ALRTS_NOTIF_FLAG CRITICAL_ALERTS_NOTIF_FLAG CORR_PROCESSES_NOTIF_FLAG OUTBOUND_ENABLED_FLAG INACTIVE_FLAG

Query

SQL_Statement

SELECT b.FLOW_TASK_ID, b.BASE_FLOW_TASK_ID, b.BASE_FLOW_TASK_NAME, b.MODULE_ID, b.OBJECT_VERSION_NUMBER, b.BASE_TASK_ID, b.BASE_FLOW_ID, b.DEST_UI_URL, b.CATEGORY_TYPE, b.SUB_CATEGORY_TYPE, b.PRE_CUSTOM_SERVICE, b.POST_CUSTOM_SERVICE, b.OFFSET_VALUE, b.OFFSET_FLOW_PARAMETER_ID, b.LEGISLATIVE_DATA_GROUP_ID, b.ENTERPRISE_ID, b.LEGISLATION_CODE, b.LAST_UPDATE_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN, b.CREATED_BY, b.CREATION_DATE, b.START_DATE_OFFSET_ID, b.START_DATE_OFFSET_VALUE, b.START_NOTIF_FLAG, b.END_NOTIF_FLAG, b.OVERDUE_NOTIF_FLAG, b.WARNING_NOTIF_FLAG, b.ERROR_NOTIF_FLAG, b.START_SCH_TIME_DEF_ID, tl.FLOW_TASK_NAME, tl.CHECKLIST_NAME, tl.DESCRIPTION, b.FORMULA_ID, b.START_SCH_FORMULA_ID, b.SUBMITTING_USER_FLAG, b.SGUID SGUID, b.ESS_REQUEST_CATEGORY, b.IGNORE_PREREQ_FLAG, b.EMP_ALERT_CODE, b.CMPLETD_ALRTS_NOTIF_FLAG, b.CRITICAL_ALERTS_NOTIF_FLAG, b.CORR_PROCESSES_NOTIF_FLAG, b.OUTBOUND_ENABLED_FLAG, b.INACTIVE_FLAG FROM PAY_FLOW_TASKS b, PAY_FLOW_TASKS_TL tl WHERE b.FLOW_TASK_ID = tl.FLOW_TASK_ID AND USERENV('LANG') = tl.LANGUAGE