AP Supplier Invoices with Payment Schedule

SELECT SUP.vendor_name AS SUPPLIER,
       INV.invoice_num AS INVOICE,
       INV.invoice_date,
       PS.payment_num,
       PS.checkrun_id,
       INV.invoice_id
FROM ap_suppliers SUP,
     ap_invoices_all INV,
     ap_payment_schedules_all PS
WHERE INV.vendor_id = SUP.vendor_id
  AND INV.invoice_id = PS.invoice_id
  AND PS.checkrun_id IS NOT NULL;