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.