The table name is wf_item_types_tl. We need to know the item type name (found in package).

For example, for GL approval process workflow, the item type is: GLBATCH.

select display_name, description from wf_item_types_tl where name = 'GLBATCH';

DISPLAY_NAME                                         DESCRIPTION

-------------------------------------------             ----------------------------------------------------------                                                                                                                                                                                                                                     

Journal Batch                                                 Item type for GL's Journal Approval process.                                                                                                                                                                                                     

1 rows selected

Open Workflow builder, search for workflow ‘Journal Batch’ to see the diagram processes.