96: and racm.process_flag = 'N'
97: and racm.request_id = req_id
98: and racm.set_number = set_num),
99: last_update_date = sysdate,
100: last_updated_by = arp_standard.profile.user_id,
101: last_update_login = arp_standard.profile.last_update_login,
102: request_id = req_id,
103: program_application_id = arp_standard.profile.program_application_id,
104: program_id = arp_standard.profile.program_id,
97: and racm.request_id = req_id
98: and racm.set_number = set_num),
99: last_update_date = sysdate,
100: last_updated_by = arp_standard.profile.user_id,
101: last_update_login = arp_standard.profile.last_update_login,
102: request_id = req_id,
103: program_application_id = arp_standard.profile.program_application_id,
104: program_id = arp_standard.profile.program_id,
105: program_update_date = sysdate
99: last_update_date = sysdate,
100: last_updated_by = arp_standard.profile.user_id,
101: last_update_login = arp_standard.profile.last_update_login,
102: request_id = req_id,
103: program_application_id = arp_standard.profile.program_application_id,
104: program_id = arp_standard.profile.program_id,
105: program_update_date = sysdate
106: where ship_to_site_use_id in (select racm.duplicate_site_id
107: from ra_customer_merges racm
100: last_updated_by = arp_standard.profile.user_id,
101: last_update_login = arp_standard.profile.last_update_login,
102: request_id = req_id,
103: program_application_id = arp_standard.profile.program_application_id,
104: program_id = arp_standard.profile.program_id,
105: program_update_date = sysdate
106: where ship_to_site_use_id in (select racm.duplicate_site_id
107: from ra_customer_merges racm
108: where racm.process_flag = 'N'
137: and racm.process_flag = 'N'
138: and racm.request_id = req_id
139: and racm.set_number = set_num),
140: last_update_date = sysdate,
141: last_updated_by = arp_standard.profile.user_id,
142: last_update_login = arp_standard.profile.last_update_login,
143: request_id = req_id,
144: program_application_id =arp_standard.profile.program_application_id,
145: program_id = arp_standard.profile.program_id,
138: and racm.request_id = req_id
139: and racm.set_number = set_num),
140: last_update_date = sysdate,
141: last_updated_by = arp_standard.profile.user_id,
142: last_update_login = arp_standard.profile.last_update_login,
143: request_id = req_id,
144: program_application_id =arp_standard.profile.program_application_id,
145: program_id = arp_standard.profile.program_id,
146: program_update_date = sysdate
140: last_update_date = sysdate,
141: last_updated_by = arp_standard.profile.user_id,
142: last_update_login = arp_standard.profile.last_update_login,
143: request_id = req_id,
144: program_application_id =arp_standard.profile.program_application_id,
145: program_id = arp_standard.profile.program_id,
146: program_update_date = sysdate
147: where bill_to_site_use_id in (select racm.duplicate_site_id
148: from ra_customer_merges racm
141: last_updated_by = arp_standard.profile.user_id,
142: last_update_login = arp_standard.profile.last_update_login,
143: request_id = req_id,
144: program_application_id =arp_standard.profile.program_application_id,
145: program_id = arp_standard.profile.program_id,
146: program_update_date = sysdate
147: where bill_to_site_use_id in (select racm.duplicate_site_id
148: from ra_customer_merges racm
149: where racm.process_flag = 'N'
180: and racm.process_flag = 'N'
181: and racm.request_id = req_id
182: and racm.set_number = set_num),
183: last_update_date = sysdate,
184: last_updated_by = arp_standard.profile.user_id,
185: last_update_login = arp_standard.profile.last_update_login,
186: request_id = req_id,
187: program_application_id =arp_standard.profile.program_application_id,
188: program_id = arp_standard.profile.program_id,
181: and racm.request_id = req_id
182: and racm.set_number = set_num),
183: last_update_date = sysdate,
184: last_updated_by = arp_standard.profile.user_id,
185: last_update_login = arp_standard.profile.last_update_login,
186: request_id = req_id,
187: program_application_id =arp_standard.profile.program_application_id,
188: program_id = arp_standard.profile.program_id,
189: program_update_date = sysdate
183: last_update_date = sysdate,
184: last_updated_by = arp_standard.profile.user_id,
185: last_update_login = arp_standard.profile.last_update_login,
186: request_id = req_id,
187: program_application_id =arp_standard.profile.program_application_id,
188: program_id = arp_standard.profile.program_id,
189: program_update_date = sysdate
190: where ship_to_site_use_id in (select racm.duplicate_site_id
191: from ra_customer_merges racm
184: last_updated_by = arp_standard.profile.user_id,
185: last_update_login = arp_standard.profile.last_update_login,
186: request_id = req_id,
187: program_application_id =arp_standard.profile.program_application_id,
188: program_id = arp_standard.profile.program_id,
189: program_update_date = sysdate
190: where ship_to_site_use_id in (select racm.duplicate_site_id
191: from ra_customer_merges racm
192: where racm.process_flag = 'N'
219: and racm.process_flag = 'N'
220: and racm.request_id = req_id
221: and racm.set_number = set_num),
222: last_update_date = sysdate,
223: last_updated_by = arp_standard.profile.user_id,
224: last_update_login = arp_standard.profile.last_update_login,
225: request_id = req_id,
226: program_application_id =arp_standard.profile.program_application_id,
227: program_id = arp_standard.profile.program_id,
220: and racm.request_id = req_id
221: and racm.set_number = set_num),
222: last_update_date = sysdate,
223: last_updated_by = arp_standard.profile.user_id,
224: last_update_login = arp_standard.profile.last_update_login,
225: request_id = req_id,
226: program_application_id =arp_standard.profile.program_application_id,
227: program_id = arp_standard.profile.program_id,
228: program_update_date = sysdate
222: last_update_date = sysdate,
223: last_updated_by = arp_standard.profile.user_id,
224: last_update_login = arp_standard.profile.last_update_login,
225: request_id = req_id,
226: program_application_id =arp_standard.profile.program_application_id,
227: program_id = arp_standard.profile.program_id,
228: program_update_date = sysdate
229: where customer_id in (select racm.duplicate_id
230: from ra_customer_merges racm
223: last_updated_by = arp_standard.profile.user_id,
224: last_update_login = arp_standard.profile.last_update_login,
225: request_id = req_id,
226: program_application_id =arp_standard.profile.program_application_id,
227: program_id = arp_standard.profile.program_id,
228: program_update_date = sysdate
229: where customer_id in (select racm.duplicate_id
230: from ra_customer_merges racm
231: where racm.process_flag = 'N'