DBA Data[Home] [Help]

APPS.PO_VENDORMERGE_GRP dependencies on PO_VENDOR_SITES

Line 378: from po_vendor_sites pvs1

374: from po_vendors pov1
375: where pov1.vendor_id =
376: p_vendor_id),
377: prl.suggested_vendor_location = (select pvs1.vendor_site_code
378: from po_vendor_sites pvs1
379: where pvs1.vendor_site_id =
380: p_vendor_site_id)
381: WHERE prl.suggested_vendor_name in (select pov2.vendor_name
382: from po_vendors pov2

Line 386: from po_vendor_sites pvs2

382: from po_vendors pov2
383: where pov2.vendor_id =
384: p_dup_vendor_id)
385: AND prl.suggested_vendor_location in (select pvs2.vendor_site_code
386: from po_vendor_sites pvs2
387: where vendor_site_id =
388: p_dup_vendor_site_id)
389: AND NOT EXISTS (SELECT 'CLM Document'
390: FROM Po_Requisition_Headers_All prha