Use to access basic configuration details of workflows.
To include workflow information in a report, you can join the WORKFLOW_ID column in this view with the same column in Workflow transaction views (for example, MREQ_REQUEST_ACTIONS). The view MWFL_WORKFLOW has columns for the main workflow definition fields present on the first tab of the workflow detail window in the PPM Workbench, and also includes a column for each workflow user data field defined in the system.
If the system has three workflow user data fields defined, this view will contain three columns that use the user data fields' token names as view column names. If these three user data fields have the tokens DEPARTMENT, ADMINSTRATOR_USERNAME, and WORKFLOW_MANAGER, then the MWFL_WORKFLOWS view would contain three columns with these names:
Name Null? Type ------------------------------- -------- ---- WORKFLOW NOT NULL VARCHAR2(80) WORKFLOW_DESCRIPTION VARCHAR2(240) ... SUB_WORKFLOW_FLAG VARCHAR2(1) DEPARTMENT VARCHAR2(200) ADMINISTRATOR_USERNAME VARCHAR2(200) WORKFLOW_MANAGER VARCHAR2(200) CREATED_BY_USERNAME NOT NULL VARCHAR2(30) CREATION_DATE NOT NULL DATE ...
By default this view returns both reference and non-reference workflows in the system.
PPM provides reference copies of some workflows, which are disabled and not usable by PPM transactions, and as such are rarely of reporting interest. The view column REFERENCE_FLAG can be used to filter results. To only show active, non-reference workflows while using MWFL_WORKFLOWS view, include
REFERENCE_FLAG = 'N' in the query.