Query to get supplier email address in oracle apps r12
In this post , We will be discuss about Query to get supplier email address in oracle apps r12. This query will help to extract the supplier email address maintained in Suppliers in oracle apps r12. supplier email address , we do maintain in different locations under suppliers master. This query will help to extract the supplier email addresses from all the locations for suppliers in oracle apps r12. This is one of the important sql query for extraction supplier email communication details in oracle apps r12. Here below is the detail about Query to get supplier email address in oracle apps r12.
3 types of supplier Email addresses in oracle apps r12
1. Supplier Site Level Email addresses.
2.Supplier Remittance Email addresses.
3.Supplier Contacts Level Email Addresses.
4 Important Tables for Query to get supplier email address in oracle apps r12
1.hz_contact_points
2.iby_external_payees_all
3.ap_supplier_contacts
4.ap_supplier_sites_all
0 comments:
Post a Comment