211: AND RACM.PROCESS_FLAG = 'N'
212: AND RACM.REQUEST_ID = req_id
213: AND RACM.SET_NUMBER = set_number ),
214: yt.LAST_UPDATE_DATE = SYSDATE,
215: yt.LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
216: yt.LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
217: WHERE
218: yt.bill_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
219: FROM RA_CUSTOMER_MERGES RACM
212: AND RACM.REQUEST_ID = req_id
213: AND RACM.SET_NUMBER = set_number ),
214: yt.LAST_UPDATE_DATE = SYSDATE,
215: yt.LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
216: yt.LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
217: WHERE
218: yt.bill_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
219: FROM RA_CUSTOMER_MERGES RACM
220: WHERE RACM.PROCESS_FLAG = 'N'
303: AND RACM.PROCESS_FLAG = 'N'
304: AND RACM.REQUEST_ID = req_id
305: AND RACM.SET_NUMBER = set_number ),
306: LAST_UPDATE_DATE = SYSDATE,
307: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
308: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
309: WHERE
310: yt.install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
311: FROM RA_CUSTOMER_MERGES RACM
304: AND RACM.REQUEST_ID = req_id
305: AND RACM.SET_NUMBER = set_number ),
306: LAST_UPDATE_DATE = SYSDATE,
307: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
308: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
309: WHERE
310: yt.install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
311: FROM RA_CUSTOMER_MERGES RACM
312: WHERE RACM.PROCESS_FLAG = 'N'
394: AND RACM.PROCESS_FLAG = 'N'
395: AND RACM.REQUEST_ID = req_id
396: AND RACM.SET_NUMBER = set_number ),
397: LAST_UPDATE_DATE = SYSDATE,
398: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
399: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
400: WHERE
401: yt.ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
402: FROM RA_CUSTOMER_MERGES RACM
395: AND RACM.REQUEST_ID = req_id
396: AND RACM.SET_NUMBER = set_number ),
397: LAST_UPDATE_DATE = SYSDATE,
398: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
399: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
400: WHERE
401: yt.ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
402: FROM RA_CUSTOMER_MERGES RACM
403: WHERE RACM.PROCESS_FLAG = 'N'
485: AND RACM.PROCESS_FLAG = 'N'
486: AND RACM.REQUEST_ID = req_id
487: AND RACM.SET_NUMBER = set_number ),
488: LAST_UPDATE_DATE = SYSDATE,
489: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
490: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
491: WHERE
492: yt.Order_bill_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
493: FROM RA_CUSTOMER_MERGES RACM
486: AND RACM.REQUEST_ID = req_id
487: AND RACM.SET_NUMBER = set_number ),
488: LAST_UPDATE_DATE = SYSDATE,
489: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
490: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
491: WHERE
492: yt.Order_bill_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
493: FROM RA_CUSTOMER_MERGES RACM
494: WHERE RACM.PROCESS_FLAG = 'N'
576: AND RACM.PROCESS_FLAG = 'N'
577: AND RACM.REQUEST_ID = req_id
578: AND RACM.SET_NUMBER = set_number ),
579: LAST_UPDATE_DATE = SYSDATE,
580: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
581: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
582: WHERE
583: yt.Order_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
584: FROM RA_CUSTOMER_MERGES RACM
577: AND RACM.REQUEST_ID = req_id
578: AND RACM.SET_NUMBER = set_number ),
579: LAST_UPDATE_DATE = SYSDATE,
580: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
581: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
582: WHERE
583: yt.Order_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
584: FROM RA_CUSTOMER_MERGES RACM
585: WHERE RACM.PROCESS_FLAG = 'N'
664: AND RACM.PROCESS_FLAG = 'N'
665: AND RACM.REQUEST_ID = req_id
666: AND RACM.SET_NUMBER = set_number ),
667: LAST_UPDATE_DATE = SYSDATE,
668: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
669: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
670: WHERE
671: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
672: FROM RA_CUSTOMER_MERGES RACM
665: AND RACM.REQUEST_ID = req_id
666: AND RACM.SET_NUMBER = set_number ),
667: LAST_UPDATE_DATE = SYSDATE,
668: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
669: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
670: WHERE
671: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
672: FROM RA_CUSTOMER_MERGES RACM
673: WHERE RACM.PROCESS_FLAG = 'N'