Wednesday, December 15, 2021

Query to list Freight From Discount Excluded Records in Oracle APPS

SELECT supp.vendor_name
      ,supp.segment1 vendor_number
      ,supp.exclude_freight_from_discount vendor_freight_discount_excld
  ,supp_site.vendor_site_code
  ,supp_site.exclude_freight_from_discount vend_sit_freight_dis_excld
  FROM ap_suppliers supp
      ,ap_supplier_sites_all supp_site
 WHERE supp.vendor_id = supp_site.vendor_id
   AND supp.exclude_freight_from_discount  IS NULL
   AND supp_site.exclude_freight_from_discount IS NULL
ORDER BY supp.vendor_name

2 comments:

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)