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

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down Link bet...