20.11 Workflow Views
Learn about workflow metadata views and workflow runtime views.
Workflow metadata views provide information about the workflow definition at design time. The metadata views represent the workflow model in workflow designer, including the activities, parameters, variables, and participants of a workflow definition.
Workflow runtime views contain information about specific workflow instances. You can use workflow runtime views to query the current state of an active workflow instance, or to query the history of a completed workflow instance.
- Workflow Metadata Views
Learn about workflow metadata views. - Workflow Runtime Views
Learn about workflow runtime views.
Parent topic: Managing Workflows and Tasks
20.11.1 Workflow Metadata Views
Learn about workflow metadata views.
| View Name | Description |
|---|---|
APEX_APPL_WORKFLOWS |
Workflow definitions, including static ID of workflow. |
APEX_APPL_WORKFLOW_VERSIONS |
Workflow definition versions. |
APEX_APPL_WORKFLOW_ACTIVITIES |
Workflow activity definitions. |
APEX_APPL_WORKFLOW_TRANSITIONS |
Workflow transitions between activities. |
APEX_APPL_WORKFLOW_BRANCHES |
Workflow branches going out of a switch activity. |
APEX_APPL_WORKFLOW_VARIABLES |
Workflow variable definitions. |
APEX_APPL_WORKFLOW_ACT_VARS |
Workflow activity variable definitions. |
APEX_APPL_WORKFLOW_PARAMS |
Workflow parameter definitions. |
APEX_APPL_WORKFLOW_PARTICIPANT |
Workflow participant definitions. |
APEX_APPL_WORKFLOW_COMP_PARAMS |
Workflow component parameters for Page Designer. |
Parent topic: Workflow Views
20.11.2 Workflow Runtime Views
Learn about workflow runtime views.
| View Name | Description |
|---|---|
APEX_PURGEABLE_WORKFLOWS |
Purgeable workflow instances with references to the workflow definition. |
APEX_PURGEABLE_WF_ACTIVITIES |
Purgeable workflow activity instances with references to the workflow activity definition. |
APEX_PURGEABLE_WF_VARIABLES |
Purgeable workflow variable values with information about the variable value static ID, data type, and format mask. |
APEX_PURGEABLE_WF_PARTICIPANT |
Purgeable workflow participant values. |
APEX_PURGEABLE_WF_AUDIT |
Purgeable workflow audit log for workflow instances. |
APEX_WORKFLOWS |
Workflow instances with references to the workflow definition. |
APEX_WORKFLOW_ACTIVITIES |
Workflow activity instances with references to the workflow activity definition. |
APEX_WORKFLOW_PARAMETERS |
Workflow parameter values with information about the parameter value static ID, data type, and format mask. |
APEX_WORKFLOW_VARIABLES |
Workflow variable values with information about the variable value static ID, data type, and format mask. |
APEX_WORKLFOW_ACTIVITY_VARS |
Workflow activity variable values with information about the activity variable value static ID, data type, and format mask. |
APEX_WORKFLOW_PARTICIPANTS |
Workflow participant values. |
APEX_WORKFLOW_AUDIT |
Workflow audit log for workflow instances. |
Parent topic: Workflow Views