Find who a Requisition is sitting with

Summary

Want a Report that shows who a recruitment requisition is sitting with

Content

Hello all,

In Oracle Recruitment Cloud, we have recruitment requisitions. I've been tasked with finding out what stage of approval a requisition is at, and the name of the person who the approval is pending with. 

I've got as far as linking the Checklist and Task tables, along with the person information, but I don't know where I'd find the requisition number which, for us, is a 5 digit number. 

If anyone could help me with that, and with finding some meaningful statuses perhaps that would be greatly appreciated.