DBA Data[Home] [Help]

APPS.CSP_CMERGE_BB1 dependencies on STANDARD

Line 201: yt.LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

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

Line 202: yt.LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,

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

Line 295: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

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

Line 296: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,

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

Line 388: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

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

Line 389: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,

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

Line 481: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

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

Line 482: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,

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

Line 570: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

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

Line 571: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN,

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