DBA Data[Home] [Help]

APPS.PO_VENDORMERGE_GRP dependencies on PO_VENDOR_SITES

Line 301: from po_vendor_sites pvs1

297: from po_vendors pov1
298: where pov1.vendor_id =
299: p_vendor_id),
300: suggested_vendor_location = (select pvs1.vendor_site_code
301: from po_vendor_sites pvs1
302: where pvs1.vendor_site_id =
303: p_vendor_site_id)
304: WHERE suggested_vendor_name in (select pov2.vendor_name
305: from po_vendors pov2

Line 309: from po_vendor_sites pvs2

305: from po_vendors pov2
306: where pov2.vendor_id =
307: p_dup_vendor_id)
308: AND suggested_vendor_location in (select pvs2.vendor_site_code
309: from po_vendor_sites pvs2
310: where vendor_site_id =
311: p_dup_vendor_site_id);
312:
313: