PA Pay When Paid Release Audit

		SELECT DISTINCT
				prj.segment1   project_number ,
				prj.name                ,
				ap.invoice_num          ,
				pov.vendor_name      contractor   ,
				poh.segment1  contract   ,
				ap.invoice_currency_code ,
				ap.invoice_amount       ,
				rep.exception   
		FROM    
				AP_INVOICES ap        ,
				AP_INVOICE_LINES apl      ,
				po_vendors pov            ,
				PO_headers poh        ,
				PA_PWP_RELEASE_REPORT rep ,
				pa_projects prj 
		WHERE   
				prj.project_id   = rep.project_id
				AND ap.invoice_id    = rep.ap_invoice_id
				AND ap.invoice_id    = apl.invoice_id
				AND pov.vendor_id    = ap.vendor_id
				AND apl.po_header_id = poh.po_header_id(+)   
				AND rep.request_id   = :P_REQUEST_ID 
        AND  rep.EXCEPTION   IS  NOT NULL