Supplier Contact details query in oracle apps r12
In this post , We will be discuss about the Supplier Contact details query in oracle apps r12. I will share the sql query which helps to extract the supplier contacts detail in oracle apps r12. We do maintain the supplier contact details information in oracle apps r12. This query will help to extract these supplier contact informations. Here below is the detail Supplier Contact details query in oracle apps r12.
Most Important Tables used By Supplier Contact details query in oracle apps r12
1.hz_relationships
2.PO_VENDORS
3.ap_supplier_sites_all
4.ap_supplier_contacts
5.hz_org_contacts
6.hz_parties
7.hz_parties
8.hz_contact_points
2.PO_VENDORS
3.ap_supplier_sites_all
4.ap_supplier_contacts
5.hz_org_contacts
6.hz_parties
7.hz_parties
8.hz_contact_points
Detail Supplier Contact details query in oracle apps r12
SELECT DISTINCT asu.segment1 Supplier_Number
,asu.vendor_name
,hpc.party_name Supplier_Contact_Name
,hpr.primary_phone_country_code cnt_cntry
,hpr.primary_phone_area_code phone_area
,hpr.primary_phone_number contact_phone_no
,assa.vendor_site_code Supplier_site_code
FROM
hz_relationships hr
,PO_VENDORS asu
,ap_supplier_sites_all assa
,ap_supplier_contacts asco
,hz_org_contacts hoc
,hz_parties hpc
,hz_parties hpr
,hz_contact_points hcp
WHERE hoc.party_relationship_id = hr.relationship_id
AND hr.subject_id = asu.party_id
AND hr.relationship_code = 'CONTACT'
AND hr.object_table_name = 'HZ_PARTIES'
AND asu.segment1=:P_VENDOR_NO
AND asu.vendor_id = assa.vendor_id
AND hr.object_id = hpc.party_id
AND hr.party_id = hpr.party_id
AND asco.relationship_id = hoc.party_relationship_id
AND assa.party_site_id = asco.org_party_site_id
AND hpr.party_type='PARTY_RELATIONSHIP'
AND hpr.party_id = hcp.owner_table_id
- AND hcp.owner_table_name = 'HZ_PARTIES'
0 comments:
Post a Comment