PO Outstand Balance

query1:
=======
SELECT PHA.PO_HEADER_ID,
PHA.SEGMENT1 "PO Number",
SUM(PLA.UNIT_PRICE*PLA.QUANTITY) "PO Total"
FROM
PO_HEADERS_ALL PHA,
PO_LINES_ALL PLA
WHERE
PHA.PO_HEADER_ID IN( PLA.PO_HEADER_ID)
AND PHA.TYPE_LOOKUP_CODE ='STANDARD'
GROUP BY
PHA.PO_HEADER_ID,PHA.SEGMENT1


query2:
=======
SELECT
DISTINCT(AIA.INVOICE_NUM) "Invoice Number",
AIA.INVOICE_DATE "Invoice Date",
AIA.INVOICE_AMOUNT "Invoice Amount",
AIA.AMOUNT_PAID "Amount Paid",
PDA.PO_HEADER_ID
FROM
AP_INVOICES_ALL AIA,
AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
PO_DISTRIBUTIONS_ALL PDA
WHERE
AIA.INVOICE_ID IN (AIDA.INVOICE_ID)
AND
AIDA.PO_DISTRIBUTION_ID IN(PDA.PO_DISTRIBUTION_ID);