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_SUPPLIERS

Line 345: FROM ap_suppliers pov,

341: -- site has not yet been successfully merged.
342:
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

Line 382: ap_suppliers pov,

378:
379: SELECT COUNT(*)
380: INTO l_unpaid_invoices
381: FROM ap_invoices_all ai,
382: ap_suppliers pov,
383: ap_supplier_sites_all pvs
384: WHERE ai.vendor_site_id = pvs.vendor_site_id
385: AND pvs.vendor_id = pov.vendor_id
386: AND pov.party_id = p_from_fk_id

Line 432: ap_suppliers pov

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
435: and pvs.vendor_site_id = adv.duplicate_vendor_site_id
436: and nvl(adv.process, 'N') = 'I';

Line 468: ap_suppliers pov

464:
465: SELECT count(*)
466: INTO l_no_mergedto_site
467: FROM ap_supplier_sites_all pvs,
468: ap_suppliers pov
469: WHERE pov.party_id = p_from_fk_id
470: AND pov.vendor_id = pvs.vendor_id
471: AND NOT EXISTS
472: (select vendor_site_id

Line 474: ap_suppliers pov1

470: AND pov.vendor_id = pvs.vendor_id
471: AND NOT EXISTS
472: (select vendor_site_id
473: from ap_supplier_sites_all pvs1,
474: ap_suppliers pov1
475: where pov1.party_id = p_to_fk_id
476: and pov1.vendor_id = pvs1.vendor_id);
477:
478: IF l_no_mergedto_site > 0 THEN

Line 511: ap_suppliers aps

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
514: AND apss.vendor_site_id = adv.duplicate_vendor_site_id
515: AND NOT EXISTS

Line 519: ap_suppliers aps1

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
522: adv1.duplicate_vendor_site_id = apss.vendor_site_id
523: and adv1.vendor_id = apss1.vendor_id