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 341: FROM ap_suppliers pov,

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

Line 378: ap_suppliers pov,

374:
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

Line 428: ap_suppliers pov

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
432: and nvl(adv.process, 'N') = 'I';

Line 464: ap_suppliers pov

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
468: (select vendor_site_id

Line 470: ap_suppliers pov1

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:
474: IF l_no_mergedto_site > 0 THEN

Line 507: ap_suppliers aps

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
511: AND NOT EXISTS

Line 515: ap_suppliers aps1

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);
519: