MWFL_STEP_SECURITY_GROUPS and MWFL_STEP_SECURITY_USERS

Used to get information about PPM users or security groups linked to Workflow steps.

• MWFL_STEP_SECURITY_USERS lists all users with authority to act on a given workflow step through static security group or user linkage, as defined in the workflow step dialog in the Workflow workbench.

• MWFL_STEP_SECURITY_GROUPS lists all security groups with authority to act on a step through static security group linkage.

These views can be useful for reporting on specific key workflow steps to show more detailed information that may not be available in the more general activity management views.

Sample

A report is needed to show all requests in Demand Management belonging to a given user who is eligible for one or more approval workflow steps. The view MWFL_WORKFLOW_STEPS can be used to show the workflow steps that are approval steps, and the view MREQ_REQUEST_ACTIONS will provide the request information for eligible steps:

SELECT ssu.username               ELIGIBLE_USER,
       ra.request_id              REQUEST_NUM,
       ra.request_workflow_step_label || ': '|| ra.action_name
                                  ELIGIBLE_STEP,
       ra.duration                DAYS_ELIGIBLE
FROM   mwfl_step_security_users ssu,
       mwfl_workflow_steps ws,
       mreq_request_actions ra
WHERE  ra.status_type = 'ELIGIBLE'
AND    ws.step_type = 'Approval'
AND    ra.workflow_step_id = ws.workflow_step_id
AND    ssu.workflow_step_id = ra.workflow_step_id
ORDER BY 1,2,3,4;

In this query, the workflow step identifier WORKFLOW_STEP_ID was used to join MWFL_STEP_SECURITY_USERS with the view MREQ_REQUEST_ACTIONS, to relate request workflow step information.

Dynamic workflow step security defined by tokens is not included in these views.