Query - Oracle Payment Details

SELECT DISTINCT TRUNC((SYSDATE-A.CREATION_DATE)) AGING ,     A.INVOICE_ID ,     A.INVOICE_NUM ,     A.SOURCE ,     A.INVOICE_AMOUNT ,     A.PO_NUMBER ,     A.VENDOR_ID ,     (SELECT VENDOR_NAME FROM APPS.AP_SUPPLIERS WHERE VENDOR_ID =A.vendor_id) VENDOR_NAME ,     (SELECT AGENT_NAME FROM APPS.PO_AGENTS_V PAV, APPS.PO_HEADERS_ALL PHA WHERE PAV.AGENT_ID = PHA.AGENT_ID AND PHA.SEGMENT1 = A.PO_NUMBER) BUYER_NAME ,     (SELECT closed_code||' - '||AUTHORIZATION_STATUS FROM APPS.PO_headers_all PHA WHERE PHA.SEGMENT1 = A.PO_NUMBER) PO_STATUS FROM  APPS.AP_INVOICES_INTERFACE A ,     APPS.AP_INVOICE_LINES_INTERFACE B WHERE NVL(A.STATUS,'UNPROCESSED')!= 'PROCESSED' AND A.INVOICE_ID = B.INVOICE_ID (+) AND A.SOURCE LIKE 'XML%' AND A.SOURCE!='XML_GATEWAY_PRE' and a.po_number not like '313%' ORDER BY AGING  desc