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

Line 53: FROM IEX_SCORE_HISTORIES yt, ra_customer_merges m

49: CURSOR merged_records1 IS
50: SELECT distinct CUSTOMER_MERGE_HEADER_ID
51: ,SCORE_HISTORY_ID
52: ,SCORE_OBJECT_ID
53: FROM IEX_SCORE_HISTORIES yt, ra_customer_merges m
54: WHERE yt.SCORE_OBJECT_ID = m.DUPLICATE_ID AND
55: m.process_flag = 'N' AND
56: m.request_id = req_id AND
57: m.set_number = set_num AND

Line 64: FROM IEX_SCORE_HISTORIES yt, ra_customer_merges m

60: CURSOR merged_records2 IS
61: SELECT distinct CUSTOMER_MERGE_HEADER_ID
62: ,SCORE_HISTORY_ID
63: ,SCORE_OBJECT_ID
64: FROM IEX_SCORE_HISTORIES yt, ra_customer_merges m
65: WHERE yt.SCORE_OBJECT_ID = m.DUPLICATE_ADDRESS_ID AND
66: m.process_flag = 'N' AND
67: m.request_id = req_id AND
68: m.set_number = set_num AND

Line 75: FROM IEX_SCORE_HISTORIES yt, ra_customer_merges m

71: CURSOR merged_records3 IS
72: SELECT distinct CUSTOMER_MERGE_HEADER_ID
73: ,SCORE_HISTORY_ID
74: ,SCORE_OBJECT_ID
75: FROM IEX_SCORE_HISTORIES yt, ra_customer_merges m
76: WHERE yt.SCORE_OBJECT_ID = m.DUPLICATE_SITE_ID AND
77: m.process_flag = 'N' AND
78: m.request_id = req_id AND
79: m.set_number = set_num AND

Line 391: FROM IEX_DUNNINGS yt, ra_customer_merges m

387: CURSOR merged_records1 IS
388: SELECT distinct CUSTOMER_MERGE_HEADER_ID
389: ,DUNNING_ID
390: ,DUNNING_OBJECT_ID
391: FROM IEX_DUNNINGS yt, ra_customer_merges m
392: WHERE yt.DUNNING_OBJECT_ID = m.DUPLICATE_ID AND
393: m.process_flag = 'N' AND
394: m.request_id = req_id AND
395: m.set_number = set_num AND

Line 403: FROM IEX_DUNNINGS yt, ra_customer_merges m

399: CURSOR merged_records2 IS
400: SELECT distinct CUSTOMER_MERGE_HEADER_ID
401: ,DUNNING_ID
402: ,DUNNING_OBJECT_ID
403: FROM IEX_DUNNINGS yt, ra_customer_merges m
404: WHERE yt.DUNNING_OBJECT_ID = m.DUPLICATE_SITE_ID AND
405: m.process_flag = 'N' AND
406: m.request_id = req_id AND
407: m.set_number = set_num AND

Line 668: FROM IEX_STRATEGIES yt, ra_customer_merges m, hz_cust_accounts hca

664: ,yt.STRATEGY_ID
665: ,yt.CUST_ACCOUNT_ID
666: ,hca.party_id
667: ,yt.status_code --Added for bug#6974531 by schekuri on 14-Aug-2008
668: FROM IEX_STRATEGIES yt, ra_customer_merges m, hz_cust_accounts hca
669: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
670: hca.cust_account_id = m.customer_id AND
671: m.process_flag = 'N' AND
672: m.request_id = req_id AND

Line 682: FROM IEX_STRATEGIES yt, ra_customer_merges m

678: SELECT distinct CUSTOMER_MERGE_HEADER_ID
679: ,STRATEGY_ID
680: ,JTF_OBJECT_ID
681: ,yt.status_code --Added for bug#6974531 by schekuri on 14-Aug-2008
682: FROM IEX_STRATEGIES yt, ra_customer_merges m
683: WHERE yt.JTF_OBJECT_ID = m.DUPLICATE_ID AND
684: m.process_flag = 'N' AND
685: m.request_id = req_id AND
686: m.set_number = set_num AND

Line 695: FROM IEX_STRATEGIES yt, ra_customer_merges m

691: SELECT distinct CUSTOMER_MERGE_HEADER_ID
692: ,STRATEGY_ID
693: ,JTF_OBJECT_ID
694: ,yt.status_code --Added for bug#6974531 by schekuri on 14-Aug-2008
695: FROM IEX_STRATEGIES yt, ra_customer_merges m
696: WHERE yt.JTF_OBJECT_ID = m.DUPLICATE_SITE_ID AND
697: m.process_flag = 'N' AND
698: m.request_id = req_id AND
699: m.set_number = set_num AND

Line 1035: FROM IEX_PROMISE_DETAILS yt, ra_customer_merges m

1031: CURSOR merged_records IS
1032: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1033: ,PROMISE_DETAIL_ID
1034: ,CUST_ACCOUNT_ID
1035: FROM IEX_PROMISE_DETAILS yt, ra_customer_merges m
1036: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1037: m.process_flag = 'N' AND
1038: m.request_id = req_id AND
1039: m.set_number = set_num;

Line 1166: FROM IEX_DELINQUENCIES yt, ra_customer_merges m

1162: /* CURSOR merged_records IS
1163: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1164: ,DELINQUENCY_ID
1165: ,CUST_ACCOUNT_ID
1166: FROM IEX_DELINQUENCIES yt, ra_customer_merges m
1167: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1168: m.process_flag = 'N' AND
1169: m.request_id = req_id AND
1170: m.set_number = set_num;

Line 1176: FROM IEX_DELINQUENCIES yt, ra_customer_merges m

1172: CURSOR merged_records1 IS
1173: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1174: ,DELINQUENCY_ID
1175: ,CUSTOMER_SITE_USE_ID
1176: FROM IEX_DELINQUENCIES yt, ra_customer_merges m
1177: WHERE yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_ID AND
1178: m.process_flag = 'N' AND
1179: m.request_id = req_id AND
1180: m.set_number = set_num;

Line 1187: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m, hz_cust_accounts c

1183: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1184: ,yt.DELINQUENCY_ID
1185: ,yt.CUST_ACCOUNT_ID
1186: ,c.party_id
1187: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m, hz_cust_accounts c
1188: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1189: m.process_flag = 'N' AND
1190: m.request_id = req_id AND
1191: m.set_number = set_num and

Line 1198: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m

1194: CURSOR merged_records1 IS
1195: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1196: ,DELINQUENCY_ID
1197: ,CUSTOMER_SITE_USE_ID
1198: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m
1199: WHERE yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID AND
1200: m.process_flag = 'N' AND
1201: m.request_id = req_id AND
1202: m.set_number = set_num;