AP Suppliers 11i

Description

Categories
Enginatics
Repository
GitHub
AP suppliers (po vendors) including supplier sites and contact information

Duplicate Match restricts the output to suppliers sharing a match key with at least one other supplier and lists the shared keys. Names are compared in upper case without punctuation, spaces and legal form suffixes (Inc, Ltd, GmbH, SA and similar), the other keys without punctuation and spaces. Bank accounts are shown masked.

Spend Last 12 Months is the total of the supplier's invoices dated in the last twelve months, excluding cancelled invoices, in each operating unit's functional currency.

SQL 69 lines

Parameters 8

ParameterTypeList of values SQL
Operating UnitLOV
haouv.name=:operating_unit
SupplierLOV
pv.vendor_name=:supplier_name
Supplier NumberLOV
pv.segment1=:supplier_number
Supplier TypeLOV
pv.vendor_type_lookup_code=xxen_util.lookup_code(:vendor_type,'VENDOR TYPE',201)
CountryLOV
ftv.territory_short_name=:country
Show ContactsLOV
Y
Duplicate MatchLOV
w.match_type=:duplicate_match
Name Data Quality Issues OnlyLOV
(regexp_like(pv.vendor_name,'^[[:space:]]|[[:space:]]$|[[:space:]]{2}|[[:cntrl:]]') or regexp_like(pvsa.vendor_site_code,'^[[:space:]]|[[:space:]]$|[[:space:]]{2}|[[:cntrl:]]') or regexp_like(pvsa.address_line1,'^[[:space:]]|[[:space:]]$|[[:space:]]{2}|[[:cntrl:]]'))