Test Report

select asu.vendor_name,poh.segment1 PO_Num,pol.line_num
 
 
from po_headers_all poh,po_lines_all pol,ap_suppliers asu
where poh.po_header_id = pol.po_header_id
and poh.vendor_id = asu.vendor_id
order by 1