MWFL_WORKFLOWS

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.

Sample

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:

SQL> desc mwfl_workflows;

Results

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.