Query for to get PO Headers total Amount

Query for to get PO Headers total Amount

select      pha.segment1 po_num,
            sum ( (pla.unit_price * pla.quantity)) price  
from        po_lines_all pla, 
            po_headers_all pha  
where       pla.po_header_id = pha.po_header_id  
and         pha.type_lookup_code in ('STANDARD', 'BLANKET')   --Add as per your requirement  
--and     pha.segment1 = '506'  
--and     pha.org_id = 204        --Use when you have multiple OU  
group by   pha.segment1

Download Query