DBA Data[Home] [Help]

APPS.CSP_CMERGE_BB3 dependencies on STANDARD

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

182: AND RACM.PROCESS_FLAG = 'N'
183: AND RACM.REQUEST_ID = req_id
184: AND RACM.SET_NUMBER = set_number ),
185: yt.LAST_UPDATE_DATE = SYSDATE,
186: yt.LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
187: yt.LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
188: WHERE
189: yt.bill_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
190: FROM RA_CUSTOMER_MERGES RACM

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

183: AND RACM.REQUEST_ID = req_id
184: AND RACM.SET_NUMBER = set_number ),
185: yt.LAST_UPDATE_DATE = SYSDATE,
186: yt.LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
187: yt.LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
188: WHERE
189: yt.bill_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
190: FROM RA_CUSTOMER_MERGES RACM
191: WHERE RACM.PROCESS_FLAG = 'N'

Line 279: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

275: AND RACM.PROCESS_FLAG = 'N'
276: AND RACM.REQUEST_ID = req_id
277: AND RACM.SET_NUMBER = set_number ),
278: LAST_UPDATE_DATE = SYSDATE,
279: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
280: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
281: WHERE
282: yt.install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
283: FROM RA_CUSTOMER_MERGES RACM

Line 280: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

276: AND RACM.REQUEST_ID = req_id
277: AND RACM.SET_NUMBER = set_number ),
278: LAST_UPDATE_DATE = SYSDATE,
279: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
280: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
281: WHERE
282: yt.install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
283: FROM RA_CUSTOMER_MERGES RACM
284: WHERE RACM.PROCESS_FLAG = 'N'

Line 371: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

367: AND RACM.PROCESS_FLAG = 'N'
368: AND RACM.REQUEST_ID = req_id
369: AND RACM.SET_NUMBER = set_number ),
370: LAST_UPDATE_DATE = SYSDATE,
371: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
372: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
373: WHERE
374: yt.ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
375: FROM RA_CUSTOMER_MERGES RACM

Line 372: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

368: AND RACM.REQUEST_ID = req_id
369: AND RACM.SET_NUMBER = set_number ),
370: LAST_UPDATE_DATE = SYSDATE,
371: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
372: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
373: WHERE
374: yt.ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
375: FROM RA_CUSTOMER_MERGES RACM
376: WHERE RACM.PROCESS_FLAG = 'N'

Line 460: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

456: AND RACM.PROCESS_FLAG = 'N'
457: AND RACM.REQUEST_ID = req_id
458: AND RACM.SET_NUMBER = set_number ),
459: LAST_UPDATE_DATE = SYSDATE,
460: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
461: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
462: WHERE
463: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
464: FROM RA_CUSTOMER_MERGES RACM

Line 461: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

457: AND RACM.REQUEST_ID = req_id
458: AND RACM.SET_NUMBER = set_number ),
459: LAST_UPDATE_DATE = SYSDATE,
460: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
461: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
462: WHERE
463: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
464: FROM RA_CUSTOMER_MERGES RACM
465: WHERE RACM.PROCESS_FLAG = 'N'