Query for to get PO Headers total Amount

Query for to get PO Headers total Amount, AskHareesh Blog for Oracle Apps

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



*/