DBA Data[Home] [Help]

APPS.DPP_UTILITY_PVT dependencies on PO_VENDOR_CONTACTS

Line 571: FROM po_vendor_contacts poc,

567: poc.area_code
568: ||poc.phone phone,
569: poc.email_address,
570: poc.fax
571: FROM po_vendor_contacts poc,
572: ap_supplier_sites_all assa
573: WHERE assa.vendor_site_id = TO_NUMBER(p_search_text1)
574: AND assa.party_site_id = poc.org_party_site_id
575: AND assa.vendor_site_id = poc.vendor_site_id

Line 2098: po_vendor_contacts poc

2094: poc.area_code||poc.phone phone,
2095: poc.email_address ,
2096: poc.fax
2097: FROM ap_supplier_sites_all assa,
2098: po_vendor_contacts poc
2099: WHERE assa.vendor_site_id = p_vendor_site_id
2100: AND assa.vendor_site_id = poc.vendor_site_id
2101: AND assa.party_site_id = poc.org_party_site_id
2102: AND poc.vendor_contact_id = p_vendor_contact_id;