DBA Data[Home] [Help]

APPS.DPP_UTILITY_PVT dependencies on PO_VENDOR_CONTACTS

Line 543: FROM po_vendor_contacts poc,

539: poc.area_code
540: ||poc.phone phone,
541: poc.email_address,
542: poc.fax
543: FROM po_vendor_contacts poc,
544: ap_supplier_sites_all assa
545: WHERE assa.vendor_site_id = TO_NUMBER(p_search_text1)
546: AND assa.party_site_id = poc.org_party_site_id
547: AND assa.vendor_site_id = poc.vendor_site_id

Line 2184: po_vendor_contacts poc

2180: poc.area_code||poc.phone phone,
2181: poc.email_address ,
2182: poc.fax
2183: FROM ap_supplier_sites_all assa,
2184: po_vendor_contacts poc
2185: WHERE assa.vendor_site_id = p_vendor_site_id
2186: AND assa.vendor_site_id = poc.vendor_site_id
2187: AND assa.party_site_id = poc.org_party_site_id
2188: AND poc.vendor_contact_id = p_vendor_contact_id;