Approved requisitions not generating PO's

Content

We are finding that some of our requisitions are still in process status because it requires a negotiation to turn into a PO. Oracle support supplied a sql query to create a BI report, however I can't seem to make it work. Has anyone created an analysis to help with this that they would be willing to share? The query that was supplied looked like this:

SELECT prh.requisition_number
,prl.line_number
,prl.line_status
,prl.req_po_instance_id
,prl.reqs_in_pool_flag
,ph.segment1 AS po_number
,prh.emergency_po_number
,prl.reqtopo_automation_failed