197: AND RACM.PROCESS_FLAG = 'N'
198: AND RACM.REQUEST_ID = req_id
199: AND RACM.SET_NUMBER = set_number ),
200: yt.LAST_UPDATE_DATE = SYSDATE,
201: yt.LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
202: yt.LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,
203: yt.CONCURRENT_REQUEST_ID = req_id
204: WHERE
205: yt.system_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
198: AND RACM.REQUEST_ID = req_id
199: AND RACM.SET_NUMBER = set_number ),
200: yt.LAST_UPDATE_DATE = SYSDATE,
201: yt.LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
202: yt.LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,
203: yt.CONCURRENT_REQUEST_ID = req_id
204: WHERE
205: yt.system_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
206: FROM RA_CUSTOMER_MERGES RACM
291: AND RACM.PROCESS_FLAG = 'N'
292: AND RACM.REQUEST_ID = req_id
293: AND RACM.SET_NUMBER = set_number ),
294: LAST_UPDATE_DATE = SYSDATE,
295: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
296: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,
297: CONCURRENT_REQUEST_ID = req_id
298: WHERE
299: yt.system_install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
292: AND RACM.REQUEST_ID = req_id
293: AND RACM.SET_NUMBER = set_number ),
294: LAST_UPDATE_DATE = SYSDATE,
295: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
296: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,
297: CONCURRENT_REQUEST_ID = req_id
298: WHERE
299: yt.system_install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
300: FROM RA_CUSTOMER_MERGES RACM
384: AND RACM.PROCESS_FLAG = 'N'
385: AND RACM.REQUEST_ID = req_id
386: AND RACM.SET_NUMBER = set_number ),
387: LAST_UPDATE_DATE = SYSDATE,
388: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
389: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,
390: CONCURRENT_REQUEST_ID = req_id
391: WHERE
392: yt.cp_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
385: AND RACM.REQUEST_ID = req_id
386: AND RACM.SET_NUMBER = set_number ),
387: LAST_UPDATE_DATE = SYSDATE,
388: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
389: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,
390: CONCURRENT_REQUEST_ID = req_id
391: WHERE
392: yt.cp_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
393: FROM RA_CUSTOMER_MERGES RACM
477: AND RACM.PROCESS_FLAG = 'N'
478: AND RACM.REQUEST_ID = req_id
479: AND RACM.SET_NUMBER = set_number ),
480: LAST_UPDATE_DATE = SYSDATE,
481: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
482: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,
483: CONCURRENT_REQUEST_ID = req_id
484: WHERE
485: yt.cp_install_site_use_Id IN ( SELECT RACM.DUPLICATE_SITE_ID
478: AND RACM.REQUEST_ID = req_id
479: AND RACM.SET_NUMBER = set_number ),
480: LAST_UPDATE_DATE = SYSDATE,
481: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
482: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,
483: CONCURRENT_REQUEST_ID = req_id
484: WHERE
485: yt.cp_install_site_use_Id IN ( SELECT RACM.DUPLICATE_SITE_ID
486: FROM RA_CUSTOMER_MERGES RACM
566: AND RACM.PROCESS_FLAG = 'N'
567: AND RACM.REQUEST_ID = req_id
568: AND RACM.SET_NUMBER = set_number ),
569: LAST_UPDATE_DATE = SYSDATE,
570: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
571: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,
572: CONCURRENT_REQUEST_ID = req_id
573: WHERE
574: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
567: AND RACM.REQUEST_ID = req_id
568: AND RACM.SET_NUMBER = set_number ),
569: LAST_UPDATE_DATE = SYSDATE,
570: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
571: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,
572: CONCURRENT_REQUEST_ID = req_id
573: WHERE
574: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
575: FROM RA_CUSTOMER_MERGES RACM