DBA Data[Home] [Help]

APPS.CSP_CMERGE_BB8 dependencies on STANDARD

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

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

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

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'

Line 281: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

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

Line 282: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

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'

Line 373: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

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

Line 374: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

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'

Line 461: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

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

Line 462: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

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'