1. Tables and Views for SCM
  2. CML_INVOICES_V

CML_INVOICES_V

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: VIEW

Query

SQL_Statement

SELECT

invoice_id,

invoice_line_number,

substr(

LISTAGG(DISTINCT invoice_number, ', ' ON OVERFLOW TRUNCATE),

1,

500) invoice_number,

MAX(vendor_site_id) vendor_site_id,

MAX(vendor_id) vendor_id,

MIN(invoice_creation_date) invoice_creation_date

FROM

cmr_ap_invoice_dtls

GROUP BY

invoice_id,

invoice_line_number