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 418: FROM IEX_DUNNINGS yt, ra_customer_merges m

414: CURSOR merged_records1 IS
415: SELECT distinct CUSTOMER_MERGE_HEADER_ID
416: ,DUNNING_ID
417: ,DUNNING_OBJECT_ID
418: FROM IEX_DUNNINGS yt, ra_customer_merges m
419: WHERE yt.DUNNING_OBJECT_ID = m.DUPLICATE_ID AND
420: m.process_flag = 'N' AND
421: m.request_id = req_id AND
422: m.set_number = set_num AND

Line 430: FROM IEX_DUNNINGS yt, ra_customer_merges m

426: CURSOR merged_records2 IS
427: SELECT distinct CUSTOMER_MERGE_HEADER_ID
428: ,DUNNING_ID
429: ,DUNNING_OBJECT_ID
430: FROM IEX_DUNNINGS yt, ra_customer_merges m
431: WHERE yt.DUNNING_OBJECT_ID = m.DUPLICATE_SITE_ID AND
432: m.process_flag = 'N' AND
433: m.request_id = req_id AND
434: m.set_number = set_num AND

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

744: ,yt.STRATEGY_ID
745: ,yt.CUST_ACCOUNT_ID
746: ,hca.party_id
747: ,yt.status_code --Added for bug#6974531 by schekuri on 14-Aug-2008
748: FROM IEX_STRATEGIES yt, ra_customer_merges m, hz_cust_accounts hca
749: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
750: hca.cust_account_id = m.customer_id AND
751: m.process_flag = 'N' AND
752: m.request_id = req_id AND

Line 762: FROM IEX_STRATEGIES yt, ra_customer_merges m

758: SELECT distinct CUSTOMER_MERGE_HEADER_ID
759: ,STRATEGY_ID
760: ,JTF_OBJECT_ID
761: ,yt.status_code --Added for bug#6974531 by schekuri on 14-Aug-2008
762: FROM IEX_STRATEGIES yt, ra_customer_merges m
763: WHERE yt.JTF_OBJECT_ID = m.DUPLICATE_ID AND
764: m.process_flag = 'N' AND
765: m.request_id = req_id AND
766: m.set_number = set_num AND

Line 775: FROM IEX_STRATEGIES yt, ra_customer_merges m

771: SELECT distinct CUSTOMER_MERGE_HEADER_ID
772: ,STRATEGY_ID
773: ,JTF_OBJECT_ID
774: ,yt.status_code --Added for bug#6974531 by schekuri on 14-Aug-2008
775: FROM IEX_STRATEGIES yt, ra_customer_merges m
776: WHERE yt.JTF_OBJECT_ID = m.DUPLICATE_SITE_ID AND
777: m.process_flag = 'N' AND
778: m.request_id = req_id AND
779: m.set_number = set_num AND

Line 1148: FROM IEX_PROMISE_DETAILS yt, ra_customer_merges m,ar_payment_schedules_all ps,iex_delinquencies_all del

1144: CURSOR merged_records IS
1145: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1146: ,yt.PROMISE_DETAIL_ID
1147: ,yt.CUST_ACCOUNT_ID
1148: FROM IEX_PROMISE_DETAILS yt, ra_customer_merges m,ar_payment_schedules_all ps,iex_delinquencies_all del
1149: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1150: m.process_flag = 'N' AND
1151: m.request_id = req_id AND
1152: m.set_number = set_num AND

Line 1283: FROM IEX_DELINQUENCIES yt, ra_customer_merges m

1279: /* CURSOR merged_records IS
1280: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1281: ,DELINQUENCY_ID
1282: ,CUST_ACCOUNT_ID
1283: FROM IEX_DELINQUENCIES yt, ra_customer_merges m
1284: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1285: m.process_flag = 'N' AND
1286: m.request_id = req_id AND
1287: m.set_number = set_num;

Line 1293: FROM IEX_DELINQUENCIES yt, ra_customer_merges m

1289: CURSOR merged_records1 IS
1290: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1291: ,DELINQUENCY_ID
1292: ,CUSTOMER_SITE_USE_ID
1293: FROM IEX_DELINQUENCIES yt, ra_customer_merges m
1294: WHERE yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_ID AND
1295: m.process_flag = 'N' AND
1296: m.request_id = req_id AND
1297: m.set_number = set_num;

Line 1305: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m, hz_cust_accounts c, ar_payment_schedules_all ps

1301: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1302: ,yt.DELINQUENCY_ID
1303: ,yt.CUST_ACCOUNT_ID
1304: ,c.party_id
1305: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m, hz_cust_accounts c, ar_payment_schedules_all ps
1306: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1307: m.process_flag = 'N' AND
1308: m.request_id = req_id AND
1309: m.set_number = set_num and

Line 1318: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m,ar_payment_schedules_all ar

1314: CURSOR merged_records1 IS
1315: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1316: ,yt.DELINQUENCY_ID
1317: ,yt.CUSTOMER_SITE_USE_ID
1318: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m,ar_payment_schedules_all ar
1319: WHERE yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID AND
1320: m.process_flag = 'N' AND
1321: m.request_id = req_id AND
1322: m.set_number = set_num AND