67: and racm.process_flag = 'N'
68: and racm.request_id = req_id
69: and racm.set_number = set_num),
70: last_update_date = sysdate,
71: last_updated_by = arp_standard.profile.user_id,
72: last_update_login = arp_standard.profile.last_update_login
73: where customer_id in (select racm.duplicate_id
74: from ra_customer_merges racm
75: where racm.process_flag = 'N'
68: and racm.request_id = req_id
69: and racm.set_number = set_num),
70: last_update_date = sysdate,
71: last_updated_by = arp_standard.profile.user_id,
72: last_update_login = arp_standard.profile.last_update_login
73: where customer_id in (select racm.duplicate_id
74: from ra_customer_merges racm
75: where racm.process_flag = 'N'
76: and racm.request_id = req_id
176: FROM ra_customer_merges rcm
177: WHERE mtl.ship_to_customer_id = rcm.duplicate_id
178: OR mtl.bill_to_customer_id = rcm.duplicate_id),
179: last_update_date = sysdate,
180: last_updated_by = arp_standard.profile.user_id,
181: last_update_login = arp_standard.profile.last_update_login
182: WHERE ship_to_customer_id IN (
183: SELECT rcm.duplicate_id
184: FROM ra_customer_merges rcm
177: WHERE mtl.ship_to_customer_id = rcm.duplicate_id
178: OR mtl.bill_to_customer_id = rcm.duplicate_id),
179: last_update_date = sysdate,
180: last_updated_by = arp_standard.profile.user_id,
181: last_update_login = arp_standard.profile.last_update_login
182: WHERE ship_to_customer_id IN (
183: SELECT rcm.duplicate_id
184: FROM ra_customer_merges rcm
185: WHERE rcm.process_flag = 'N'
214: FROM ra_customer_merges rcm
215: WHERE mtl.ship_to_site_use_id = rcm.duplicate_site_id
216: OR mtl.bill_to_site_use_id = rcm.duplicate_site_id),
217: last_update_date = sysdate,
218: last_updated_by = arp_standard.profile.user_id,
219: last_update_login = arp_standard.profile.last_update_login
220: WHERE ship_to_site_use_id IN (
221: SELECT rcm.duplicate_site_id
222: FROM ra_customer_merges rcm
215: WHERE mtl.ship_to_site_use_id = rcm.duplicate_site_id
216: OR mtl.bill_to_site_use_id = rcm.duplicate_site_id),
217: last_update_date = sysdate,
218: last_updated_by = arp_standard.profile.user_id,
219: last_update_login = arp_standard.profile.last_update_login
220: WHERE ship_to_site_use_id IN (
221: SELECT rcm.duplicate_site_id
222: FROM ra_customer_merges rcm
223: WHERE rcm.process_flag = 'N'