Give me SQL to find AP invoices by supplier.

AP Invoices by Supplier

SQLOracle Fusion · Financials · APHigh confidenceGenerated

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

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

Relevant tables

AP_INVOICES_ALL

Curated

Invoice header

Key columns

INVOICE_IDINVOICE_NUMVENDOR_IDINVOICE_AMOUNTINVOICE_DATE

Key columns

Table	Key columns
AP_INVOICES_ALL	INVOICE_IDINVOICE_NUMVENDOR_IDINVOICE_AMOUNTINVOICE_DATE

Give me SQL to find AP invoices by supplier.

SQL

Bind variables

Relevant tables

Key columns

Related questions