eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_CMERGE_BB1 dependencies on RA_CUSTOMER_MERGES

Line 161: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM

157: number_of_rows NUMBER;
158:
159: Cursor LOCK_SYS_SHIP_USE_ID ( req_id NUMBER, set_number NUMBER ) IS
160: SELECT system_ship_to_site_use_id
161: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM
162: WHERE
163: yt.system_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
164: FROM RA_CUSTOMER_MERGES RACM
165: WHERE RACM.PROCESS_FLAG = 'N'

Line 164: FROM RA_CUSTOMER_MERGES RACM

160: SELECT system_ship_to_site_use_id
161: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM
162: WHERE
163: yt.system_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
164: FROM RA_CUSTOMER_MERGES RACM
165: WHERE RACM.PROCESS_FLAG = 'N'
166: AND RACM.REQUEST_ID = req_id
167: AND RACM.SET_NUMBER = set_number )
168: AND yt.customer_id <> RACM.DUPLICATE_ID

Line 194: FROM RA_CUSTOMER_MERGES RACM

190: UPDATE CS_ACCESS_CONTROL_TEMPLATES yt
191: SET
192: yt.system_ship_to_site_use_id =
193: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
194: FROM RA_CUSTOMER_MERGES RACM
195: WHERE yt.system_ship_to_site_use_id
196: = RACM.DUPLICATE_SITE_ID
197: AND RACM.PROCESS_FLAG = 'N'
198: AND RACM.REQUEST_ID = req_id

Line 206: FROM RA_CUSTOMER_MERGES RACM

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
207: WHERE RACM.PROCESS_FLAG = 'N'
208: AND RACM.REQUEST_ID = req_id
209: AND RACM.SET_NUMBER = set_number );
210:

Line 256: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM

252: number_of_rows NUMBER;
253:
254: Cursor LOCK_SYS_INSTALL_SITE_ID ( req_id NUMBER, set_number NUMBER ) IS
255: SELECT system_install_site_use_id
256: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM
257: WHERE
258: yt.system_install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
259: FROM RA_CUSTOMER_MERGES RACM
260: WHERE RACM.PROCESS_FLAG = 'N'

Line 259: FROM RA_CUSTOMER_MERGES RACM

255: SELECT system_install_site_use_id
256: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM
257: WHERE
258: yt.system_install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
259: FROM RA_CUSTOMER_MERGES RACM
260: WHERE RACM.PROCESS_FLAG = 'N'
261: AND RACM.REQUEST_ID = req_id
262: AND RACM.SET_NUMBER = set_number )
263: AND yt.customer_id <> RACM.DUPLICATE_ID

Line 288: FROM RA_CUSTOMER_MERGES RACM

284: UPDATE CS_ACCESS_CONTROL_TEMPLATES yt
285: SET
286: yt.system_install_site_use_id =
287: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
288: FROM RA_CUSTOMER_MERGES RACM
289: WHERE yt.system_install_site_use_id
290: = DUPLICATE_SITE_ID
291: AND RACM.PROCESS_FLAG = 'N'
292: AND RACM.REQUEST_ID = req_id

Line 300: FROM RA_CUSTOMER_MERGES RACM

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
301: WHERE RACM.PROCESS_FLAG = 'N'
302: AND RACM.REQUEST_ID = req_id
303: AND RACM.SET_NUMBER = set_number );
304:

Line 350: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM

346: number_of_rows NUMBER;
347:
348: Cursor LOCK_CP_SHIP_SITE_ID ( req_id NUMBER, set_number NUMBER ) IS
349: SELECT cp_ship_to_site_use_id
350: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM
351: WHERE
352: yt.cp_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
353: FROM RA_CUSTOMER_MERGES RACM
354: WHERE RACM.PROCESS_FLAG = 'N'

Line 353: FROM RA_CUSTOMER_MERGES RACM

349: SELECT cp_ship_to_site_use_id
350: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM
351: WHERE
352: yt.cp_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
353: FROM RA_CUSTOMER_MERGES RACM
354: WHERE RACM.PROCESS_FLAG = 'N'
355: AND RACM.REQUEST_ID = req_id
356: AND RACM.SET_NUMBER = set_number )
357: AND yt.customer_id <> RACM.DUPLICATE_ID

Line 381: FROM RA_CUSTOMER_MERGES RACM

377: UPDATE CS_ACCESS_CONTROL_TEMPLATES yt
378: SET
379: yt.cp_ship_to_site_use_id =
380: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
381: FROM RA_CUSTOMER_MERGES RACM
382: WHERE yt.cp_ship_to_site_use_id
383: = DUPLICATE_SITE_ID
384: AND RACM.PROCESS_FLAG = 'N'
385: AND RACM.REQUEST_ID = req_id

Line 393: FROM RA_CUSTOMER_MERGES RACM

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
394: WHERE RACM.PROCESS_FLAG = 'N'
395: AND RACM.REQUEST_ID = req_id
396: AND RACM.SET_NUMBER = set_number );
397:

Line 442: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM

438: number_of_rows NUMBER;
439:
440: Cursor LOCK_CP_INSTALL_SITE_ID ( req_id NUMBER, set_number NUMBER ) IS
441: SELECT cp_install_site_use_id
442: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM
443: WHERE
444: yt.cp_install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
445: FROM RA_CUSTOMER_MERGES RACM
446: WHERE RACM.PROCESS_FLAG = 'N'

Line 445: FROM RA_CUSTOMER_MERGES RACM

441: SELECT cp_install_site_use_id
442: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM
443: WHERE
444: yt.cp_install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
445: FROM RA_CUSTOMER_MERGES RACM
446: WHERE RACM.PROCESS_FLAG = 'N'
447: AND RACM.REQUEST_ID = req_id
448: AND RACM.SET_NUMBER = set_number )
449: AND yt.customer_id <> RACM.DUPLICATE_ID

Line 474: FROM RA_CUSTOMER_MERGES RACM

470: UPDATE CS_ACCESS_CONTROL_TEMPLATES yt
471: SET
472: yt.cp_install_site_use_id =
473: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
474: FROM RA_CUSTOMER_MERGES RACM
475: WHERE yt.cp_install_site_use_id
476: = DUPLICATE_SITE_ID
477: AND RACM.PROCESS_FLAG = 'N'
478: AND RACM.REQUEST_ID = req_id

Line 486: FROM RA_CUSTOMER_MERGES RACM

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
487: WHERE RACM.PROCESS_FLAG = 'N'
488: AND RACM.REQUEST_ID = req_id
489: AND RACM.SET_NUMBER = set_number );
490:

Line 535: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM

531: number_of_rows NUMBER;
532:
533: Cursor LOCK_CUSTOMER_ID ( req_id NUMBER, set_number NUMBER ) IS
534: SELECT yt.customer_id
535: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM
536: WHERE
537: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
538: FROM RA_CUSTOMER_MERGES RACM
539: WHERE RACM.PROCESS_FLAG = 'N'

Line 538: FROM RA_CUSTOMER_MERGES RACM

534: SELECT yt.customer_id
535: FROM CS_ACCESS_CONTROL_TEMPLATES yt, RA_CUSTOMER_MERGES RACM
536: WHERE
537: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
538: FROM RA_CUSTOMER_MERGES RACM
539: WHERE RACM.PROCESS_FLAG = 'N'
540: AND RACM.REQUEST_ID = req_id
541: AND RACM.SET_NUMBER = set_number )
542: FOR UPDATE NOWAIT;

Line 564: FROM RA_CUSTOMER_MERGES RACM

560:
561: UPDATE CS_ACCESS_CONTROL_TEMPLATES yt
562: SET
563: yt.customer_id = ( SELECT DISTINCT RACM.CUSTOMER_ID
564: FROM RA_CUSTOMER_MERGES RACM
565: WHERE yt.customer_id = DUPLICATE_ID
566: AND RACM.PROCESS_FLAG = 'N'
567: AND RACM.REQUEST_ID = req_id
568: AND RACM.SET_NUMBER = set_number ),

Line 575: FROM RA_CUSTOMER_MERGES RACM

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
576: WHERE RACM.PROCESS_FLAG = 'N'
577: AND RACM.REQUEST_ID = req_id
578: AND RACM.SET_NUMBER = set_number );
579:

Line 634: RA_CUSTOMER_MERGES RACM

630: SELECT
631: DISTINCT
632: cs.access_control_template_id
633: FROM CS_ACCESS_CONTROL_TEMPLATES CS,
634: RA_CUSTOMER_MERGES RACM
635: WHERE
636: RACM.PROCESS_FLAG = 'N' AND
637: RACM.REQUEST_ID = req_id AND
638: RACM.SET_NUMBER = set_number AND

Line 644: RA_CUSTOMER_MERGES RACM

640: cs.system_ship_to_site_use_id <> racm.customer_site_id AND
641: cs.system_ship_to_site_use_id IS NOT NULL ) AND
642: ( cs.customer_id NOT IN ( select racm.customer_id
643: from CS_ACCESS_CONTROL_TEMPLATES CS,
644: RA_CUSTOMER_MERGES RACM
645: where cs.customer_id = RACM.CUSTOMER_ID AND
646: cs.system_ship_to_site_use_id = racm.customer_site_id or
647: cs.system_ship_to_site_use_id IS NULL ))) AND
648: (( cs.customer_id = RACM.CUSTOMER_ID AND

Line 653: RA_CUSTOMER_MERGES RACM

649: cs.system_install_site_use_id <> racm.customer_site_id AND
650: cs.system_install_site_use_id IS NOT NULL ) AND
651: ( cs.customer_id NOT IN ( select racm.customer_id
652: from CS_ACCESS_CONTROL_TEMPLATES CS,
653: RA_CUSTOMER_MERGES RACM
654: where cs.customer_id = RACM.CUSTOMER_ID AND
655: cs.system_install_site_use_id = racm.customer_site_id or
656: cs.system_install_site_use_id IS NULL ))) AND
657: (( cs.customer_id = RACM.CUSTOMER_ID AND

Line 662: RA_CUSTOMER_MERGES RACM

658: cs.cp_install_site_use_id <> racm.customer_site_id AND
659: cs.cp_install_site_use_id IS NOT NULL ) AND
660: ( cs.customer_id NOT IN ( select racm.customer_id
661: from CS_ACCESS_CONTROL_TEMPLATES CS,
662: RA_CUSTOMER_MERGES RACM
663: where cs.customer_id = RACM.CUSTOMER_ID AND
664: cs.cp_install_site_use_id = racm.customer_site_id or
665: cs.cp_install_site_use_id IS NULL ))) AND
666: (( cs.customer_id = RACM.CUSTOMER_ID AND

Line 671: RA_CUSTOMER_MERGES RACM

667: cs.cp_ship_to_site_use_id <> racm.customer_site_id AND
668: cs.cp_ship_to_site_use_id IS NOT NULL ) AND
669: ( cs.customer_id NOT IN ( select racm.customer_id
670: from CS_ACCESS_CONTROL_TEMPLATES CS,
671: RA_CUSTOMER_MERGES RACM
672: where cs.customer_id = RACM.CUSTOMER_ID AND
673: cs.cp_ship_to_site_use_id = racm.customer_site_id or
674: cs.cp_ship_to_site_use_id IS NULL )) ));
675: