eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: or -- when 'from_fk' site is merged to 'to_fk' site
232: adv1.duplicate_vendor_site_id = pav.vendor_site_id

Line 347: ap_duplicate_vendors_all adv

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

Line 430: FROM ap_duplicate_vendors_all adv,

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

Line 509: FROM ap_duplicate_vendors_all adv,

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

Line 517: from ap_duplicate_vendors_all adv1,

513: AND aps.vendor_id = apss.vendor_id
514: AND apss.vendor_site_id = adv.duplicate_vendor_site_id
515: AND NOT EXISTS
516: (select adv1.vendor_site_id
517: from ap_duplicate_vendors_all adv1,
518: ap_supplier_sites_all apss1,
519: ap_suppliers aps1
520: where (adv1.vendor_site_id = apss1.vendor_site_id
521: or -- when 'from_fk' site is merged to 'to_fk' site