APPS.AP_PARTYMERGE_GRP dependencies on AP_SUPPLIER_SITES_ALL

Line 72: FROM ap_supplier_sites_all pav,

68: -- case 3 will be taken care of(resulting in count(*) = 0)
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';

Line 106: ap_supplier_sites_all pav

102:
103: SELECT COUNT(*)
104: INTO l_unpaid_invoices
105: FROM ap_invoices_all ai,
106: ap_supplier_sites_all pav
107: WHERE ai.vendor_site_id = pav.vendor_site_id
108: AND pav.party_site_id = p_from_fk_id
109: AND nvl(ai.payment_status_flag,'N') <> 'Y';
110:

Line 153: ap_supplier_sites_all pav

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';
157:

Line 184: FROM ap_supplier_sites_all pav

180: -- associated with the merged-to Party/Party Site.
181:
182: SELECT count(*)
183: INTO l_no_mergedto_site
184: FROM ap_supplier_sites_all pav
185: WHERE pav.party_site_id = p_from_fk_id
186: AND NOT EXISTS
187: (select vendor_site_id
188: from ap_supplier_sites_all pav1

Line 188: from ap_supplier_sites_all pav1

184: FROM ap_supplier_sites_all pav
185: WHERE pav.party_site_id = p_from_fk_id
186: AND NOT EXISTS
187: (select vendor_site_id
188: from ap_supplier_sites_all pav1
189: where pav1.party_site_id = p_to_fk_id);
190:
191: IF l_no_mergedto_site > 0 THEN
192:

Line 223: ap_supplier_sites_all pav

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
227: (select adv1.vendor_site_id

Line 229: ap_supplier_sites_all pav1

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:
233: IF l_mismatch_merge_sites > 0 THEN

Line 342: ap_supplier_sites_all pvs,

338:
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 (+)

Line 379: ap_supplier_sites_all pvs

375: SELECT COUNT(*)
376: INTO l_unpaid_invoices
377: FROM ap_invoices_all ai,
378: ap_suppliers pov,
379: ap_supplier_sites_all pvs
380: WHERE ai.vendor_site_id = pvs.vendor_site_id
381: AND pvs.vendor_id = pov.vendor_id
382: AND pov.party_id = p_from_fk_id
383: AND nvl(ai.payment_status_flag,'N') <> 'Y';

Line 427: ap_supplier_sites_all pvs,

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
431: and pvs.vendor_site_id = adv.duplicate_vendor_site_id

Line 463: FROM ap_supplier_sites_all pvs,

459: -- i.e. just having vendors will not help.
460:
461: SELECT count(*)
462: INTO l_no_mergedto_site
463: FROM ap_supplier_sites_all pvs,
464: ap_suppliers pov
465: WHERE pov.party_id = p_from_fk_id
466: AND pov.vendor_id = pvs.vendor_id
467: AND NOT EXISTS

Line 469: from ap_supplier_sites_all pvs1,

465: WHERE pov.party_id = p_from_fk_id
466: AND pov.vendor_id = pvs.vendor_id
467: AND NOT EXISTS
468: (select vendor_site_id
469: from ap_supplier_sites_all pvs1,
470: ap_suppliers pov1
471: where pov1.party_id = p_to_fk_id
472: and pov1.vendor_id = pvs1.vendor_id);
473:

Line 506: ap_supplier_sites_all apss,

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
510: AND apss.vendor_site_id = adv.duplicate_vendor_site_id

Line 514: ap_supplier_sites_all apss1,

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
518: and aps1.party_id = p_to_fk_id);