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.ARP_CMERGE_ARCPF dependencies on RA_CUSTOMER_MERGES

Line 110: FROM AR_CREDIT_HISTORIES yt, ra_customer_merges m

106: ) IS
107:
108: CURSOR c1 is
109: SELECT CREDIT_HISTORY_ID
110: FROM AR_CREDIT_HISTORIES yt, ra_customer_merges m
111: WHERE yt.customer_id = m.duplicate_id
112: AND yt.site_use_id = m.duplicate_site_id
113: AND m.process_flag = 'N'
114: AND m.request_id = req_id

Line 121: FROM AR_CREDIT_HISTORIES yt, ra_customer_merges m

117: FOR UPDATE NOWAIT;
118:
119: CURSOR c2 is
120: SELECT CREDIT_HISTORY_ID
121: FROM AR_CREDIT_HISTORIES yt, ra_customer_merges m
122: WHERE yt.customer_id = m.duplicate_id
123: AND m.process_flag = 'N'
124: AND m.request_id = req_id
125: AND m.set_number = set_num

Line 157: FROM ra_customer_merges m

153:
154: DELETE FROM AR_CREDIT_HISTORIES yt
155: WHERE (customer_id, site_use_id) IN (
156: SELECT m.duplicate_id, m.duplicate_site_id
157: FROM ra_customer_merges m
158: WHERE m.process_flag = 'N'
159: AND m.request_id = req_id
160: AND m.set_number = set_num
161: AND m.delete_duplicate_flag = 'Y');

Line 176: FROM ra_customer_merges m

172:
173: DELETE FROM AR_CREDIT_HISTORIES yt
174: WHERE customer_id IN (
175: SELECT m.duplicate_id
176: FROM ra_customer_merges m
177: WHERE m.process_flag = 'N'
178: AND m.request_id = req_id
179: AND m.set_number = set_num
180: AND m.delete_duplicate_flag = 'Y' )

Line 242: FROM hz_customer_profiles, ra_customer_merges m

238:
239: --cursor c1 and c2 work in inactive mode.
240: CURSOR c1 is
241: SELECT cust_account_profile_id
242: FROM hz_customer_profiles, ra_customer_merges m
243: WHERE site_use_id = m.duplicate_site_id
244: AND m.process_flag = 'N'
245: AND m.request_id = req_id
246: AND m.set_number = set_num

Line 251: FROM hz_customer_profiles yt, ra_customer_merges m

247: FOR UPDATE NOWAIT;
248:
249: CURSOR c2 is
250: SELECT cust_account_profile_id
251: FROM hz_customer_profiles yt, ra_customer_merges m
252: WHERE cust_account_id = m.duplicate_id
253: AND m.process_flag = 'N'
254: AND m.request_id = req_id
255: AND m.set_number = set_num

Line 268: FROM hz_customer_profiles yt, ra_customer_merges m

264:
265: --cursor c3 work in 'delete' mode.
266: CURSOR c3 is
267: SELECT cust_account_profile_id
268: FROM hz_customer_profiles yt, ra_customer_merges m
269: WHERE cust_account_id = m.duplicate_id
270: AND m.process_flag = 'N'
271: AND m.request_id = req_id
272: AND m.set_number = set_num

Line 319: FROM ra_customer_merges m

315: program_id = arp_standard.profile.program_id,
316: program_update_date = sysdate
317: WHERE site_use_id IN (
318: SELECT m.duplicate_site_id
319: FROM ra_customer_merges m
320: WHERE m.process_flag = 'N'
321: AND m.request_id = req_id
322: AND m.set_number = set_num
323: AND m.delete_duplicate_flag = 'N' ) ;

Line 345: FROM ra_customer_merges m

341: program_id = arp_standard.profile.program_id,
342: program_update_date = sysdate
343: WHERE cust_account_id IN (
344: SELECT m.duplicate_id
345: FROM ra_customer_merges m
346: WHERE m.process_flag = 'N'
347: AND m.request_id = req_id
348: AND m.set_number = set_num
349: AND m.delete_duplicate_flag = 'N' )

Line 374: FROM ra_customer_merges m

370: UPDATE hz_customer_profiles
371: SET status = 'D'
372: WHERE site_use_id IN (
373: SELECT m.duplicate_site_id
374: FROM ra_customer_merges m
375: WHERE m.process_flag = 'N'
376: AND m.request_id = req_id
377: AND m.set_number = set_num
378: AND m.delete_duplicate_flag = 'Y' ) ;

Line 393: FROM ra_customer_merges m

389: UPDATE hz_customer_profiles yt
390: SET status = 'D'
391: WHERE cust_account_id IN (
392: SELECT m.duplicate_id
393: FROM ra_customer_merges m
394: WHERE m.process_flag = 'N'
395: AND m.request_id = req_id
396: AND m.set_number = set_num
397: AND m.delete_duplicate_flag = 'Y' )

Line 461: FROM HZ_CUST_PROFILE_AMTS, ra_customer_merges m

457:
458: --cursor c1 and c2 work in inactive mode.
459: CURSOR c1 is
460: SELECT CUST_ACCT_PROFILE_AMT_ID
461: FROM HZ_CUST_PROFILE_AMTS, ra_customer_merges m
462: WHERE site_use_id = m.duplicate_site_id
463: AND m.process_flag = 'N'
464: AND m.request_id = req_id
465: AND m.set_number = set_num

Line 471: FROM HZ_CUST_PROFILE_AMTS yt, ra_customer_merges m

467: FOR UPDATE NOWAIT;
468:
469: CURSOR c2 is
470: SELECT CUST_ACCT_PROFILE_AMT_ID
471: FROM HZ_CUST_PROFILE_AMTS yt, ra_customer_merges m
472: WHERE cust_account_id = m.duplicate_id
473: AND m.process_flag = 'N'
474: AND m.request_id = req_id
475: AND m.set_number = set_num

Line 518: FROM ra_customer_merges m

514: program_id = arp_standard.profile.program_id,
515: program_update_date = sysdate
516: WHERE site_use_id IN (
517: SELECT m.duplicate_site_id
518: FROM ra_customer_merges m
519: WHERE m.process_flag = 'N'
520: AND m.request_id = req_id
521: AND m.set_number = set_num
522: AND m.delete_duplicate_flag = 'N' );

Line 543: FROM ra_customer_merges m

539: program_id = arp_standard.profile.program_id,
540: program_update_date = sysdate
541: WHERE cust_account_id IN (
542: SELECT m.duplicate_id
543: FROM ra_customer_merges m
544: WHERE m.process_flag = 'N'
545: AND m.request_id = req_id
546: AND m.set_number = set_num
547: AND m.delete_duplicate_flag = 'N' )

Line 605: FROM HZ_CUSTOMER_PROFILES, ra_customer_merges m

601: ) IS
602:
603: CURSOR profiles IS
604: SELECT cust_account_profile_id
605: FROM HZ_CUSTOMER_PROFILES, ra_customer_merges m
606: WHERE cust_account_id = m.duplicate_id
607: AND m.process_flag = 'N'
608: AND m.request_id = req_id
609: AND m.set_number = set_num

Line 616: FROM HZ_CUST_PROFILE_AMTS, ra_customer_merges m

612: FOR UPDATE NOWAIT;
613:
614: CURSOR profile_amt_site IS
615: SELECT CUST_ACCT_PROFILE_AMT_ID
616: FROM HZ_CUST_PROFILE_AMTS, ra_customer_merges m
617: WHERE site_use_id = m.duplicate_site_id
618: AND m.process_flag = 'N'
619: AND m.request_id = req_id
620: AND m.set_number = set_num

Line 626: FROM HZ_CUST_PROFILE_AMTS yt, ra_customer_merges m

622: FOR UPDATE NOWAIT;
623:
624: CURSOR profile_amt_acct IS
625: SELECT CUST_ACCT_PROFILE_AMT_ID
626: FROM HZ_CUST_PROFILE_AMTS yt, ra_customer_merges m
627: WHERE cust_account_id = m.duplicate_id
628: AND m.process_flag = 'N'
629: AND m.request_id = req_id
630: AND m.set_number = set_num

Line 664: FROM ra_customer_merges m

660:
661: DELETE FROM HZ_CUSTOMER_PROFILES
662: WHERE cust_account_id IN (
663: SELECT m.duplicate_id
664: FROM ra_customer_merges m
665: WHERE m.process_flag = 'N'
666: AND m.request_id = req_id
667: AND m.set_number = set_num
668: AND m.delete_duplicate_flag = 'Y' )

Line 691: FROM ra_customer_merges m

687: --site level
688: DELETE FROM HZ_CUST_PROFILE_AMTS yt
689: WHERE site_use_id IN (
690: SELECT m.duplicate_site_id
691: FROM ra_customer_merges m
692: WHERE m.process_flag = 'N'
693: AND m.request_id = req_id
694: AND m.set_number = set_num
695: AND m.delete_duplicate_flag = 'Y' );

Line 709: FROM ra_customer_merges m

705: --account level
706: DELETE FROM HZ_CUST_PROFILE_AMTS yt
707: WHERE cust_account_id IN (
708: SELECT m.duplicate_id
709: FROM ra_customer_merges m
710: WHERE m.process_flag = 'N'
711: AND m.request_id = req_id
712: AND m.set_number = set_num
713: AND m.delete_duplicate_flag = 'Y' )