R12 Supplier Emails

//R12 Supplier Emails:

SELECT pv.vendor_name
, pv.vendor_id
, pv.segment1
, pv.end_date_active “Vendor Inactive Date”
, vs.vendor_site_code
, vs.inactive_date “Site Inactive Date”
, vs.email_address “Communication Email”
–, epa.default_payment_method_code
, ipm.Payment_Method_Name “Site Payment Method”
–, epa.remit_advice_delivery_method
, epa.remit_advice_email “Remittance Advice Email”
, epa.ext_payee_id, epa.payee_party_id, epa.party_site_id, epa.supplier_site_id, epa.org_id, epa.org_type
FROM IBY_EXTERNAL_PAYEES_ALL epa, PO_VENDORS pv, PO_VENDOR_SITES_all vs, IBY_EXT_PARTY_PMT_MTHDS eppm, IBY_PAYMENT_METHODS_VL ipm
WHERE epa.ORG_ID=132
AND epa.payee_party_id = pv.party_id(+)
AND vs.vendor_id=pv.vendor_id
AND epa.party_site_id=vs.party_site_id(+)
AND epa.org_id = vs.org_id
AND ipm.payment_method_code = eppm.payment_method_code
AND eppm.Payment_flow LIKE ‘DISBURSEMENT%’
AND eppm.EXT_PMT_PARTY_ID = epa.EXT_PAYEE_ID
AND eppm.primary_flag = ‘Y’
AND pv.end_date_active IS NULL
AND pv.vendor_type_lookup_code <> ‘INTERCOMPANY’
AND pv.vendor_type_lookup_code <> ‘EMPLOYEE’
AND vs.inactive_date IS NULL
AND epa.supplier_site_id IS NOT NULL
–AND epa.payee_party_id=81369
ORDER BY pv.vendor_name, vs.vendor_site_code;–85640;