Friday, January 27, 2017

Query to find AP Supplier Remittance Email Addresses

-----------
--- Query to find AP Supplier Remittance Email Addresses
----------

SELECT
         -- s.vendor_id,
         -- st.vendor_site_id,
         -- s.party_id,
         -- st.party_site_id,
         s.vendor_name "Vendor Name", s.segment1 "Vendor Number",
         s.vendor_type_lookup_code "Vendor Type",
         st.vendor_site_code "Vendor Site Code", ou.NAME "Operating Unit",        
         --
         iepa.remit_advice_delivery_method "Remittance Delivery Method",
         iepa.remit_advice_email "Remittance Advice Email"
    FROM ap.ap_suppliers s,
         ap.ap_supplier_sites_all st,
         hr_operating_units ou,
         iby.iby_external_payees_all iepa
   WHERE 1 = 1
     --
     -- AND s.vendor_type_lookup_code = 'EMPLOYEE'
     --
     AND TRUNC (SYSDATE) BETWEEN TRUNC (s.start_date_active)
                             AND TRUNC (NVL (s.end_date_active, SYSDATE + 1))
     AND s.enabled_flag = 'Y'
     --
     AND iepa.supplier_site_id = st.vendor_site_id
     AND iepa.payee_party_id = s.party_id
     --
     AND st.org_id = ou.organization_id
     AND st.vendor_id = s.vendor_id
     AND s.segment1 = '53602'
--
ORDER BY s.vendor_name, st.vendor_site_code;

No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...