APPS.PO_VENDORMERGE_GRP dependencies on AP_SUPPLIER_CONTACTS

Line 113: FROM ap_supplier_contacts

109: UPDATE po_headers_draft_all pohd
110: SET pohd.vendor_id = p_vendor_id,
111: pohd.vendor_site_id = p_vendor_site_id,
112: pohd.vendor_contact_id = (SELECT vendor_contact_id
113: FROM ap_supplier_contacts
114: WHERE org_party_site_id = (SELECT party_site_id
115: FROM ap_supplier_sites_all
116: WHERE vendor_site_id = p_vendor_site_id)
117: AND per_party_id = (SELECT per_party_id

Line 118: FROM ap_supplier_contacts

114: WHERE org_party_site_id = (SELECT party_site_id
115: FROM ap_supplier_sites_all
116: WHERE vendor_site_id = p_vendor_site_id)
117: AND per_party_id = (SELECT per_party_id
118: FROM ap_supplier_contacts
119: WHERE vendor_contact_id = pohd.vendor_contact_id)),
120: pohd.last_updated_by = l_last_updated_by,
121: pohd.last_update_date = sysdate
122: WHERE pohd.vendor_id = p_dup_vendor_id

Line 160: FROM ap_supplier_contacts

156: UPDATE po_headers ph
157: SET ph.vendor_id = p_vendor_id,
158: ph.vendor_site_id = p_vendor_site_id,
159: ph.vendor_contact_id = (SELECT vendor_contact_id
160: FROM ap_supplier_contacts
161: WHERE org_party_site_id = (SELECT party_site_id
162: FROM ap_supplier_sites_all
163: WHERE vendor_site_id = p_vendor_site_id)
164: AND per_party_id = (SELECT per_party_id

Line 165: FROM ap_supplier_contacts

161: WHERE org_party_site_id = (SELECT party_site_id
162: FROM ap_supplier_sites_all
163: WHERE vendor_site_id = p_vendor_site_id)
164: AND per_party_id = (SELECT per_party_id
165: FROM ap_supplier_contacts
166: WHERE vendor_contact_id = ph.vendor_contact_id)),
167: last_updated_by = l_last_updated_by,
168: last_update_date = SYSDATE
169: WHERE ph.vendor_id = p_dup_vendor_id