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

Line 80: FROM CSC_CUSTOMERS yt, ra_customer_merges m, hz_cust_accounts hzca

76: l_profile_val VARCHAR2(30);
77: CURSOR merged_records IS
78: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
79: ,m.customer_id, m.duplicate_id, hzca.party_id, yt.party_id
80: FROM CSC_CUSTOMERS yt, ra_customer_merges m, hz_cust_accounts hzca
81: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
82: AND m.process_flag = 'N'
83: AND m.request_id = req_id
84: AND m.set_number = set_num;

Line 159: ra_customer_merges m WHERE

155: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
156: , PROGRAM_ID=arp_standard.profile.program_id
157: , PROGRAM_UPDATE_DATE=SYSDATE
158: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
159: ra_customer_merges m WHERE
160: m.process_flag = 'N'
161: AND m.request_id = req_id
162: AND m.set_number = set_num )
163: ;

Line 199: FROM CSC_CUSTOMERS_AUDIT_HIST yt, ra_customer_merges m , hz_cust_accounts hzca

195: l_profile_val VARCHAR2(30);
196: CURSOR merged_records IS
197: SELECT distinct CUSTOMER_MERGE_HEADER_ID
198: ,m.customer_id, m.duplicate_id
199: FROM CSC_CUSTOMERS_AUDIT_HIST yt, ra_customer_merges m , hz_cust_accounts hzca
200: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
201: AND m.process_flag = 'N'
202: AND m.request_id = req_id
203: AND m.set_number = set_num;

Line 271: ra_customer_merges m WHERE

267: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
268: , PROGRAM_ID=arp_standard.profile.program_id
269: , PROGRAM_UPDATE_DATE=SYSDATE
270: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
271: ra_customer_merges m WHERE
272: m.process_flag = 'N'
273: AND m.request_id = req_id
274: AND m.set_number = set_num )
275: ;

Line 317: FROM CSC_CUSTOMIZED_PLANS yt, ra_customer_merges m , hz_cust_accounts hzca

313: l_profile_val VARCHAR2(30);
314: CURSOR merged_records IS
315: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
316: ,m.customer_id, m.duplicate_id, hzca.party_id, yt.party_id
317: FROM CSC_CUSTOMIZED_PLANS yt, ra_customer_merges m , hz_cust_accounts hzca
318: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
319: AND m.process_flag = 'N'
320: AND m.request_id = req_id
321: AND m.set_number = set_num;

Line 396: ra_customer_merges m WHERE

392: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
393: , PROGRAM_ID=arp_standard.profile.program_id
394: , PROGRAM_UPDATE_DATE=SYSDATE
395: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
396: ra_customer_merges m WHERE
397: m.process_flag = 'N'
398: AND m.request_id = req_id
399: AND m.set_number = set_num )
400: ;

Line 448: FROM CSC_CUST_PLANS yt, ra_customer_merges m , hz_cust_accounts hzca

444: CURSOR merged_records IS
445: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
446: ,yt.cust_plan_id
447: ,m.customer_id, m.duplicate_id, hzca.party_id, yt.party_id
448: FROM CSC_CUST_PLANS yt, ra_customer_merges m , hz_cust_accounts hzca
449: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
450: AND m.process_flag = 'N'
451: AND m.request_id = req_id
452: AND m.set_number = set_num;

Line 530: ra_customer_merges m WHERE

526: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
527: , PROGRAM_ID=arp_standard.profile.program_id
528: , PROGRAM_UPDATE_DATE=SYSDATE
529: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
530: ra_customer_merges m WHERE
531: m.process_flag = 'N'
532: AND m.request_id = req_id
533: AND m.set_number = set_num )
534: AND plan_id not in ( SELECT yts.plan_id FROM

Line 535: csc_cust_plans yts, ra_customer_merges m WHERE

531: m.process_flag = 'N'
532: AND m.request_id = req_id
533: AND m.set_number = set_num )
534: AND plan_id not in ( SELECT yts.plan_id FROM
535: csc_cust_plans yts, ra_customer_merges m WHERE
536: yts.cust_account_id = m.customer_id
537: AND m.process_flag = 'N'
538: AND m.request_id = req_id
539: AND m.set_number = set_num )

Line 545: ra_customer_merges m WHERE

541: l_count := l_count + SQL%ROWCOUNT;
542:
543: DELETE FROM CSC_CUST_PLANS
544: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
545: ra_customer_merges m WHERE
546: m.process_flag = 'N'
547: AND m.request_id = req_id
548: AND m.set_number = set_num )
549: AND plan_id in ( SELECT yts.plan_id FROM

Line 550: csc_cust_plans yts, ra_customer_merges m WHERE

546: m.process_flag = 'N'
547: AND m.request_id = req_id
548: AND m.set_number = set_num )
549: AND plan_id in ( SELECT yts.plan_id FROM
550: csc_cust_plans yts, ra_customer_merges m WHERE
551: yts.cust_account_id = m.customer_id
552: AND m.process_flag = 'N'
553: AND m.request_id = req_id
554: AND m.set_number = set_num )

Line 604: FROM CSC_CUST_PLANS_AUDIT yt, ra_customer_merges m , hz_cust_accounts hzca

600: CURSOR merged_records IS
601: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
602: ,yt.plan_audit_id
603: ,m.customer_id, m.duplicate_id, hzca.party_id, yt.party_id
604: FROM CSC_CUST_PLANS_AUDIT yt, ra_customer_merges m , hz_cust_accounts hzca
605: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
606: AND m.process_flag = 'N'
607: AND m.request_id = req_id
608: AND m.set_number = set_num;

Line 686: ra_customer_merges m WHERE

682: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
683: , PROGRAM_ID=arp_standard.profile.program_id
684: , PROGRAM_UPDATE_DATE=SYSDATE
685: WHERE cust_account_id in ( SELECT m.duplicate_id FROM
686: ra_customer_merges m WHERE
687: m.process_flag = 'N'
688: AND m.request_id = req_id
689: AND m.set_number = set_num )
690: AND plan_id not in ( SELECT yts.plan_id FROM

Line 691: csc_cust_plans_audit yts, ra_customer_merges m WHERE

687: m.process_flag = 'N'
688: AND m.request_id = req_id
689: AND m.set_number = set_num )
690: AND plan_id not in ( SELECT yts.plan_id FROM
691: csc_cust_plans_audit yts, ra_customer_merges m WHERE
692: yts.cust_account_id = m.customer_id
693: AND m.process_flag = 'N'
694: AND m.request_id = req_id
695: AND m.set_number = set_num )