Query for Vendor HST Payment Details

SELECT ail.creation_date f01 --"DATE"
, (SELECT SUM(amount)
FROM ap_invoice_distributions_all
WHERE invoice_id = ai.invoice_id
AND TRUNC(creation_date) = TRUNC(ail.creation_date)) f02 --"AMOUNT RECEIVED ON THIS DATE"
, ail.amount f03 -- "HST AMOUNT"
, pov.vendor_name f04 -- " Vendor Name"
, att.NAME f05 -- "Payment Term Name
, att.creation_date f06 -- "Payment Creation Date"
FROM ap_invoice_distributions_all ail
, ap_tax_codes_all atc
, ap_invoices_all ai
, po_vendor_sites_all povs
, po_vendors pov
, ap_terms_tl att
WHERE atc.tax_id = ail.tax_code_id
AND ai.invoice_id = ail.invoice_id
AND ail.line_type_lookup_code = 'TAX'
AND TRUNC(ail.creation_date) >= '01-JUL-2010'
AND atc.NAME LIKE '%HST%'
AND att.term_id = povs.terms_id
AND povs.vendor_id = pov.vendor_id
AND povs.vendor_site_id = ai.vendor_site_id
AND att.LANGUAGE = USERENV('LANG')
ORDER BY ai.invoice_id
, ai.vendor_site_id;