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

Line 346: ap_supplier_sites_all pvs,

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
350: AND pvs.vendor_site_id = adv.duplicate_vendor_site_id (+)

Line 383: ap_supplier_sites_all pvs

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
387: AND nvl(ai.payment_status_flag,'N') <> 'Y';

Line 431: ap_supplier_sites_all pvs,

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

Line 467: FROM ap_supplier_sites_all pvs,

463: -- i.e. just having vendors will not help.
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

Line 473: from ap_supplier_sites_all pvs1,

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

Line 510: ap_supplier_sites_all apss,

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

Line 518: ap_supplier_sites_all apss1,

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