I am attempting to create two reports to show where our approval workflows are being used. First, I want to create a report that contains a row for each application resource, with a column containing the name of the approval workflow chosen in the Request tab of the application resource. Second, I would like to create a report containing a row for each request form, with columns for the request form name, the request workflow name, the form approval workflow name, the form fulfillment workflow name, and a column with the application associated to the form (if there is one). Is there a place, either on the database or elsewhere, where these relationships are stored? Attached are images showing the specific relationships I want to capture.
Check T_AV_CR_WORKFLOWS
Object_ID column is the id of the form or the application.