OracleOps AI
← Answer Library

Give me SQL to find AP invoices by supplier.

AP Invoices by Supplier

Oracle Fusion · Financials · AP

SQL RequestHigh confidence

Returns invoice header data for a given supplier (vendor).

Grounded in: Curated SQL pattern — AP

SQL

SQL
SELECT
  invoice_id,
  invoice_num,
  invoice_amount,
  invoice_currency_code,
  invoice_date,
  payment_status_flag
FROM ap_invoices_all
WHERE vendor_id = :vendor_id
ORDER BY invoice_date DESC;

Bind Variables

:vendor_idSupplier (vendor) ID

Key Tables

AP_INVOICES_ALL

Invoice header

Related Questions

Have a follow-up, or a different question?

Continue in Ask Oracle AI