I need to display the invoices which are on hold along with the requestors managers hierarchy for re

Hi,

I have wriiten the below query1 .It displays the invoices which are on hold along with requestor details. I need the reporting managerial hierarchy list along with these details. I have written query2 which fetched the managerial list. but I am unable to join these 2 queries. Can anyone please help.

Query1:

SELECT  aph.invoice_id "INVOICE ID",

        aph.line_location_id "LINE LOCATION ID",

        pod.deliver_to_person_id "REQUESTER ID",

        req_p.full_name "REQUESTER NAME",

        poh.agent_id "AGENT ID",

        prh.preparer_id "PREPARER ID",

        prep_p.full_name "PREPARER NAME",

        SUBSTR(pov.vendor_name,1,80) "SUPPLIER",

        poh.segment1 || '/' || pol.line_num "PO NUM/LINE NUM",