65: and m.request_id = req_id
66: and m.process_flag = 'N'
67: and m.set_number = set_num),
68: last_update_date = sysdate,
69: last_updated_by = arp_standard.profile.user_id,
70: last_update_login = arp_standard.profile.last_update_login
71: where site_use_id in (select m.duplicate_site_id
72: from ra_customer_merges m
73: where m.process_flag = 'N'
66: and m.process_flag = 'N'
67: and m.set_number = set_num),
68: last_update_date = sysdate,
69: last_updated_by = arp_standard.profile.user_id,
70: last_update_login = arp_standard.profile.last_update_login
71: where site_use_id in (select m.duplicate_site_id
72: from ra_customer_merges m
73: where m.process_flag = 'N'
74: and m.request_id = req_id
91: and m.process_flag = 'N'
92: and m.request_id = req_id
93: and m.set_number = set_num),
94: last_update_date = sysdate,
95: last_updated_by = arp_standard.profile.user_id,
96: last_update_login = arp_standard.profile.last_update_login
97: where customer_id in (select m.duplicate_id
98: from ra_customer_merges m
99: where m.process_flag = 'N'
92: and m.request_id = req_id
93: and m.set_number = set_num),
94: last_update_date = sysdate,
95: last_updated_by = arp_standard.profile.user_id,
96: last_update_login = arp_standard.profile.last_update_login
97: where customer_id in (select m.duplicate_id
98: from ra_customer_merges m
99: where m.process_flag = 'N'
100: and m.request_id = req_id
175: and m.request_id = req_id
176: and m.process_flag = 'N'
177: and m.set_number = set_num),
178: last_update_date = sysdate,
179: last_updated_by = arp_standard.profile.user_id,
180: last_update_login = arp_standard.profile.last_update_login
181: where site_use_id in (select m.duplicate_site_id
182: from ra_customer_merges m
183: where m.process_flag = 'N'
176: and m.process_flag = 'N'
177: and m.set_number = set_num),
178: last_update_date = sysdate,
179: last_updated_by = arp_standard.profile.user_id,
180: last_update_login = arp_standard.profile.last_update_login
181: where site_use_id in (select m.duplicate_site_id
182: from ra_customer_merges m
183: where m.process_flag = 'N'
184: and m.request_id = req_id
201: and m.process_flag = 'N'
202: and m.request_id = req_id
203: and m.set_number = set_num),
204: last_update_date = sysdate,
205: last_updated_by = arp_standard.profile.user_id,
206: last_update_login = arp_standard.profile.last_update_login
207: where customer_id in (select m.duplicate_id
208: from ra_customer_merges m
209: where m.process_flag = 'N'
202: and m.request_id = req_id
203: and m.set_number = set_num),
204: last_update_date = sysdate,
205: last_updated_by = arp_standard.profile.user_id,
206: last_update_login = arp_standard.profile.last_update_login
207: where customer_id in (select m.duplicate_id
208: from ra_customer_merges m
209: where m.process_flag = 'N'
210: and m.request_id = req_id
273: and m.request_id = req_id
274: and m.process_flag = 'N'
275: and m.set_number = set_num),
276: last_update_date = sysdate,
277: last_updated_by = arp_standard.profile.user_id,
278: last_update_login = arp_standard.profile.last_update_login
279: where ship_to_site_use_id in (select m.duplicate_site_id
280: from ra_customer_merges m
281: where m.process_flag = 'N'
274: and m.process_flag = 'N'
275: and m.set_number = set_num),
276: last_update_date = sysdate,
277: last_updated_by = arp_standard.profile.user_id,
278: last_update_login = arp_standard.profile.last_update_login
279: where ship_to_site_use_id in (select m.duplicate_site_id
280: from ra_customer_merges m
281: where m.process_flag = 'N'
282: and m.request_id = req_id
344: and m.request_id = req_id
345: and m.process_flag = 'N'
346: and m.set_number = set_num),
347: last_update_date = sysdate,
348: last_updated_by = arp_standard.profile.user_id,
349: last_update_login = arp_standard.profile.last_update_login
350: where ship_to_site_use_id in (select m.duplicate_site_id
351: from ra_customer_merges m
352: where m.process_flag = 'N'
345: and m.process_flag = 'N'
346: and m.set_number = set_num),
347: last_update_date = sysdate,
348: last_updated_by = arp_standard.profile.user_id,
349: last_update_login = arp_standard.profile.last_update_login
350: where ship_to_site_use_id in (select m.duplicate_site_id
351: from ra_customer_merges m
352: where m.process_flag = 'N'
353: and m.request_id = req_id