Write Oracle Fusion SQL
in plain language.
Instantly.

WITH overdue_invoices AS (
    SELECT invoice_id,
           MIN(due_date) AS due_date
      FROM fusion.ap_payment_schedules_all
     WHERE payment_status_flag <> 'Y'
       AND NVL(amount_remaining, 0) <> 0
     GROUP BY invoice_id
)
SELECT hp.party_name AS supplier_name,
       ai.invoice_amount,
       TRUNC(SYSDATE) - TRUNC(oi.due_date) AS days_overdue
  FROM fusion.ap_invoices_all ai
  JOIN overdue_invoices oi
    ON oi.invoice_id = ai.invoice_id
  JOIN fusion.poz_suppliers ps
    ON ps.vendor_id = ai.vendor_id
  JOIN fusion.hz_parties hp
    ON hp.party_id = ps.party_id
 WHERE ai.cancelled_date IS NULL
   AND oi.due_date >= TRUNC(SYSDATE) - 60
   AND oi.due_date <  TRUNC(SYSDATE)
 ORDER BY days_overdue DESC;