Saturday, January 29, 2022

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 

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...