Query to get PO total amount in oracle fusion

 /* Formatted on 11/24/2021 11:03:32 AM (QP5 v5.294) */

SELECT SUM (NVL ( (spl.unit_price * spl.quantity), 0)) po_total_amount

   FROM po_headers_all sph, po_lines_all spl

  WHERE     sph.po_header_id = spl.po_header_id

        AND sph.type_lookup_code = 'STANDARD'

        AND sph.po_header_id = po_headers_all.po_header_id