DBA Data[Home] [Help]

APPS.CSP_CMERGE_BB2 dependencies on STANDARD

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

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

Line 216: yt.LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

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'

Line 307: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

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

Line 308: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

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'

Line 398: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

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

Line 399: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

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'

Line 489: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

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

Line 490: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

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'

Line 580: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

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

Line 581: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

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'

Line 668: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

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

Line 669: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

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'