184: AND RACM.PROCESS_FLAG = 'N'
185: AND RACM.REQUEST_ID = req_id
186: AND RACM.SET_NUMBER = set_number ),
187: yt.LAST_UPDATE_DATE = SYSDATE,
188: yt.LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
189: yt.LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
190: WHERE
191: yt.bill_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
192: FROM RA_CUSTOMER_MERGES RACM
185: AND RACM.REQUEST_ID = req_id
186: AND RACM.SET_NUMBER = set_number ),
187: yt.LAST_UPDATE_DATE = SYSDATE,
188: yt.LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
189: yt.LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
190: WHERE
191: yt.bill_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
192: FROM RA_CUSTOMER_MERGES RACM
193: WHERE RACM.PROCESS_FLAG = 'N'
277: AND RACM.PROCESS_FLAG = 'N'
278: AND RACM.REQUEST_ID = req_id
279: AND RACM.SET_NUMBER = set_number ),
280: LAST_UPDATE_DATE = SYSDATE,
281: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
282: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
283: WHERE
284: yt.install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
285: FROM RA_CUSTOMER_MERGES RACM
278: AND RACM.REQUEST_ID = req_id
279: AND RACM.SET_NUMBER = set_number ),
280: LAST_UPDATE_DATE = SYSDATE,
281: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
282: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
283: WHERE
284: yt.install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
285: FROM RA_CUSTOMER_MERGES RACM
286: WHERE RACM.PROCESS_FLAG = 'N'
369: AND RACM.PROCESS_FLAG = 'N'
370: AND RACM.REQUEST_ID = req_id
371: AND RACM.SET_NUMBER = set_number ),
372: LAST_UPDATE_DATE = SYSDATE,
373: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
374: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
375: WHERE
376: yt.ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
377: FROM RA_CUSTOMER_MERGES RACM
370: AND RACM.REQUEST_ID = req_id
371: AND RACM.SET_NUMBER = set_number ),
372: LAST_UPDATE_DATE = SYSDATE,
373: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
374: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
375: WHERE
376: yt.ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
377: FROM RA_CUSTOMER_MERGES RACM
378: WHERE RACM.PROCESS_FLAG = 'N'
457: AND RACM.PROCESS_FLAG = 'N'
458: AND RACM.REQUEST_ID = req_id
459: AND RACM.SET_NUMBER = set_number ),
460: LAST_UPDATE_DATE = SYSDATE,
461: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
462: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
463: WHERE
464: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
465: FROM RA_CUSTOMER_MERGES RACM
458: AND RACM.REQUEST_ID = req_id
459: AND RACM.SET_NUMBER = set_number ),
460: LAST_UPDATE_DATE = SYSDATE,
461: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
462: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
463: WHERE
464: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
465: FROM RA_CUSTOMER_MERGES RACM
466: WHERE RACM.PROCESS_FLAG = 'N'