APPS.AP_PARTYMERGE_GRP dependencies on AP_DUPLICATE_VENDORS_ALL

Line 73: ap_duplicate_vendors_all adv

69:
70: SELECT count(*)
71: INTO l_vndrsites_not_merged
72: FROM ap_supplier_sites_all pav,
73: ap_duplicate_vendors_all adv
74: WHERE pav.vendor_site_id = adv.duplicate_vendor_site_id(+)
75: AND pav.party_site_id = p_from_fk_id
76: AND nvl(adv.process_flag,'N') <> 'Y';
77:

Line 152: FROM ap_duplicate_vendors_all adv,

148: -- implies PO checkbox value 'N'
149:
150: SELECT COUNT(*)
151: INTO l_po_unchecked_sites
152: FROM ap_duplicate_vendors_all adv,
153: ap_supplier_sites_all pav
154: WHERE pav.vendor_site_id = adv.duplicate_vendor_site_id
155: AND pav.party_site_id = p_from_fk_id
156: AND nvl(adv.process, 'N') = 'I';

Line 222: FROM ap_duplicate_vendors_all adv,

218: -- not the same.
219:
220: SELECT count(*)
221: INTO l_mismatch_merge_sites
222: FROM ap_duplicate_vendors_all adv,
223: ap_supplier_sites_all pav
224: WHERE pav.party_site_id = p_from_fk_id
225: AND pav.vendor_site_id = adv.duplicate_vendor_site_id
226: AND NOT EXISTS

Line 228: from ap_duplicate_vendors_all adv1,

224: WHERE pav.party_site_id = p_from_fk_id
225: AND pav.vendor_site_id = adv.duplicate_vendor_site_id
226: AND NOT EXISTS
227: (select adv1.vendor_site_id
228: from ap_duplicate_vendors_all adv1,
229: ap_supplier_sites_all pav1
230: where adv1.vendor_site_id = pav1.vendor_site_id
231: and pav1.party_site_id = p_to_fk_id);
232:

Line 343: ap_duplicate_vendors_all adv

339: SELECT count(*)
340: INTO l_vndrsites_not_merged
341: FROM ap_suppliers pov,
342: ap_supplier_sites_all pvs,
343: ap_duplicate_vendors_all adv
344: WHERE pov.party_id = p_from_fk_id
345: AND pov.vendor_id = pvs.vendor_id
346: AND pvs.vendor_site_id = adv.duplicate_vendor_site_id (+)
347: AND nvl(adv.process_flag, 'N') <> 'Y';

Line 426: FROM ap_duplicate_vendors_all adv,

422: -- implies PO checkbox value 'N'
423:
424: SELECT COUNT(*)
425: INTO l_po_unchecked_sites
426: FROM ap_duplicate_vendors_all adv,
427: ap_supplier_sites_all pvs,
428: ap_suppliers pov
429: WHERE pov.party_id = p_from_fk_id
430: and pov.vendor_id = pvs.vendor_id

Line 505: FROM ap_duplicate_vendors_all adv,

501: -- not the same.
502: -- perf bug 5055689 - removed MJC by going to base tables
503: SELECT count(*)
504: INTO l_mismatch_merge_sites
505: FROM ap_duplicate_vendors_all adv,
506: ap_supplier_sites_all apss,
507: ap_suppliers aps
508: WHERE aps.party_id = p_from_fk_id
509: AND aps.vendor_id = apss.vendor_id

Line 513: from ap_duplicate_vendors_all adv1,

509: AND aps.vendor_id = apss.vendor_id
510: AND apss.vendor_site_id = adv.duplicate_vendor_site_id
511: AND NOT EXISTS
512: (select adv1.vendor_site_id
513: from ap_duplicate_vendors_all adv1,
514: ap_supplier_sites_all apss1,
515: ap_suppliers aps1
516: where adv1.vendor_site_id = apss1.vendor_site_id
517: and apss1.vendor_id = aps1.vendor_id