DBA Data[Home] [Help]

APPS.PO_VENDORMERGE_GRP dependencies on AP_SUPPLIER_SITES_ALL

Line 115: FROM ap_supplier_sites_all

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
118: FROM ap_supplier_contacts
119: WHERE vendor_contact_id = pohd.vendor_contact_id)),

Line 162: FROM ap_supplier_sites_all

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
165: FROM ap_supplier_contacts
166: WHERE vendor_contact_id = ph.vendor_contact_id)),