Has anyone created reports that identify who has approved a transaction (requisition or expense repo

Boise State has a requirement to provide campus end-users with a report (or reports) that will allow them to search for the approval information on transactions (requisitions and expense reports) regardless if they were involved in the specific transaction or its approval process.

The desire is to provide a campus dashboard that would allow the end-user to enter a transaction number, an accounting segment and/or preparer/requester information and to have results returned that show who is involved in the approval string, who has taken action and who has not.     

Has anyone had similar requirement and developed SQL that we could model?      Thank you.