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:

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...