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_BB4 dependencies on RA_CUSTOMER_MERGES

Line 161: FROM CS_TEMPLATES_INTERFACE 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_TEMPLATES_INTERFACE 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_TEMPLATES_INTERFACE 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_TEMPLATES_INTERFACE 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 202: FROM RA_CUSTOMER_MERGES RACM

198: AND RACM.REQUEST_ID = req_id
199: AND RACM.SET_NUMBER = set_number )
200: WHERE
201: yt.system_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
202: FROM RA_CUSTOMER_MERGES RACM
203: WHERE RACM.PROCESS_FLAG = 'N'
204: AND RACM.REQUEST_ID = req_id
205: AND RACM.SET_NUMBER = set_number );
206:

Line 252: FROM CS_TEMPLATES_INTERFACE yt, RA_CUSTOMER_MERGES RACM

248: number_of_rows NUMBER;
249:
250: Cursor LOCK_SYS_INSTALL_SITE_ID ( req_id NUMBER, set_number NUMBER ) IS
251: SELECT system_install_site_use_id
252: FROM CS_TEMPLATES_INTERFACE yt, RA_CUSTOMER_MERGES RACM
253: WHERE
254: yt.system_install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
255: FROM RA_CUSTOMER_MERGES RACM
256: WHERE RACM.PROCESS_FLAG = 'N'

Line 255: FROM RA_CUSTOMER_MERGES RACM

251: SELECT system_install_site_use_id
252: FROM CS_TEMPLATES_INTERFACE yt, RA_CUSTOMER_MERGES RACM
253: WHERE
254: yt.system_install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
255: FROM RA_CUSTOMER_MERGES RACM
256: WHERE RACM.PROCESS_FLAG = 'N'
257: AND RACM.REQUEST_ID = req_id
258: AND RACM.SET_NUMBER = set_number )
259: AND yt.customer_id <> RACM.DUPLICATE_ID

Line 284: FROM RA_CUSTOMER_MERGES RACM

280: UPDATE CS_TEMPLATES_INTERFACE yt
281: SET
282: yt.system_install_site_use_id =
283: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
284: FROM RA_CUSTOMER_MERGES RACM
285: WHERE yt.system_install_site_use_id
286: = DUPLICATE_SITE_ID
287: AND RACM.PROCESS_FLAG = 'N'
288: AND RACM.REQUEST_ID = req_id

Line 292: FROM RA_CUSTOMER_MERGES RACM

288: AND RACM.REQUEST_ID = req_id
289: AND RACM.SET_NUMBER = set_number )
290: WHERE
291: yt.system_install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
292: FROM RA_CUSTOMER_MERGES RACM
293: WHERE RACM.PROCESS_FLAG = 'N'
294: AND RACM.REQUEST_ID = req_id
295: AND RACM.SET_NUMBER = set_number );
296:

Line 342: FROM CS_TEMPLATES_INTERFACE yt, RA_CUSTOMER_MERGES RACM

338: number_of_rows NUMBER;
339:
340: Cursor LOCK_CP_SHIP_SITE_ID ( req_id NUMBER, set_number NUMBER ) IS
341: SELECT cp_ship_to_site_use_id
342: FROM CS_TEMPLATES_INTERFACE yt, RA_CUSTOMER_MERGES RACM
343: WHERE
344: yt.cp_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
345: FROM RA_CUSTOMER_MERGES RACM
346: WHERE RACM.PROCESS_FLAG = 'N'

Line 345: FROM RA_CUSTOMER_MERGES RACM

341: SELECT cp_ship_to_site_use_id
342: FROM CS_TEMPLATES_INTERFACE yt, RA_CUSTOMER_MERGES RACM
343: WHERE
344: yt.cp_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
345: FROM RA_CUSTOMER_MERGES RACM
346: WHERE RACM.PROCESS_FLAG = 'N'
347: AND RACM.REQUEST_ID = req_id
348: AND RACM.SET_NUMBER = set_number )
349: AND yt.customer_id <> RACM.DUPLICATE_ID

Line 373: FROM RA_CUSTOMER_MERGES RACM

369: UPDATE CS_TEMPLATES_INTERFACE yt
370: SET
371: yt.cp_ship_to_site_use_id =
372: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
373: FROM RA_CUSTOMER_MERGES RACM
374: WHERE yt.cp_ship_to_site_use_id
375: = DUPLICATE_SITE_ID
376: AND RACM.PROCESS_FLAG = 'N'
377: AND RACM.REQUEST_ID = req_id

Line 381: FROM RA_CUSTOMER_MERGES RACM

377: AND RACM.REQUEST_ID = req_id
378: AND RACM.SET_NUMBER = set_number )
379: WHERE
380: yt.cp_ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
381: FROM RA_CUSTOMER_MERGES RACM
382: WHERE RACM.PROCESS_FLAG = 'N'
383: AND RACM.REQUEST_ID = req_id
384: AND RACM.SET_NUMBER = set_number );
385:

Line 430: FROM CS_TEMPLATES_INTERFACE yt, RA_CUSTOMER_MERGES RACM

426: number_of_rows NUMBER;
427:
428: Cursor LOCK_CP_INSTALL_SITE_ID ( req_id NUMBER, set_number NUMBER ) IS
429: SELECT cp_install_site_use_id
430: FROM CS_TEMPLATES_INTERFACE yt, RA_CUSTOMER_MERGES RACM
431: WHERE
432: yt.cp_install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
433: FROM RA_CUSTOMER_MERGES RACM
434: WHERE RACM.PROCESS_FLAG = 'N'

Line 433: FROM RA_CUSTOMER_MERGES RACM

429: SELECT cp_install_site_use_id
430: FROM CS_TEMPLATES_INTERFACE yt, RA_CUSTOMER_MERGES RACM
431: WHERE
432: yt.cp_install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
433: FROM RA_CUSTOMER_MERGES RACM
434: WHERE RACM.PROCESS_FLAG = 'N'
435: AND RACM.REQUEST_ID = req_id
436: AND RACM.SET_NUMBER = set_number )
437: AND yt.customer_id <> RACM.DUPLICATE_ID

Line 462: FROM RA_CUSTOMER_MERGES RACM

458: UPDATE CS_TEMPLATES_INTERFACE yt
459: SET
460: yt.cp_install_site_use_id =
461: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
462: FROM RA_CUSTOMER_MERGES RACM
463: WHERE yt.cp_install_site_use_id
464: = DUPLICATE_SITE_ID
465: AND RACM.PROCESS_FLAG = 'N'
466: AND RACM.REQUEST_ID = req_id

Line 470: FROM RA_CUSTOMER_MERGES RACM

466: AND RACM.REQUEST_ID = req_id
467: AND RACM.SET_NUMBER = set_number )
468: WHERE
469: yt.cp_install_site_use_Id IN ( SELECT RACM.DUPLICATE_SITE_ID
470: FROM RA_CUSTOMER_MERGES RACM
471: WHERE RACM.PROCESS_FLAG = 'N'
472: AND RACM.REQUEST_ID = req_id
473: AND RACM.SET_NUMBER = set_number );
474:

Line 519: FROM CS_TEMPLATES_INTERFACE yt, RA_CUSTOMER_MERGES RACM

515: number_of_rows NUMBER;
516:
517: Cursor LOCK_CUSTOMER_ID ( req_id NUMBER, set_number NUMBER ) IS
518: SELECT yt.customer_id
519: FROM CS_TEMPLATES_INTERFACE yt, RA_CUSTOMER_MERGES RACM
520: WHERE
521: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
522: FROM RA_CUSTOMER_MERGES RACM
523: WHERE RACM.PROCESS_FLAG = 'N'

Line 522: FROM RA_CUSTOMER_MERGES RACM

518: SELECT yt.customer_id
519: FROM CS_TEMPLATES_INTERFACE yt, RA_CUSTOMER_MERGES RACM
520: WHERE
521: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
522: FROM RA_CUSTOMER_MERGES RACM
523: WHERE RACM.PROCESS_FLAG = 'N'
524: AND RACM.REQUEST_ID = req_id
525: AND RACM.SET_NUMBER = set_number )
526: FOR UPDATE NOWAIT;

Line 548: FROM RA_CUSTOMER_MERGES RACM

544:
545: UPDATE CS_TEMPLATES_INTERFACE yt
546: SET
547: yt.customer_id = ( SELECT DISTINCT RACM.CUSTOMER_ID
548: FROM RA_CUSTOMER_MERGES RACM
549: WHERE yt.customer_id = DUPLICATE_ID
550: AND RACM.PROCESS_FLAG = 'N'
551: AND RACM.REQUEST_ID = req_id
552: AND RACM.SET_NUMBER = set_number )

Line 555: FROM RA_CUSTOMER_MERGES RACM

551: AND RACM.REQUEST_ID = req_id
552: AND RACM.SET_NUMBER = set_number )
553: WHERE
554: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
555: FROM RA_CUSTOMER_MERGES RACM
556: WHERE RACM.PROCESS_FLAG = 'N'
557: AND RACM.REQUEST_ID = req_id
558: AND RACM.SET_NUMBER = set_number );
559:

Line 614: RA_CUSTOMER_MERGES RACM

610: SELECT
611: DISTINCT
612: cs.templates_interface_id
613: FROM CS_TEMPLATES_INTERFACE CS,
614: RA_CUSTOMER_MERGES RACM
615: WHERE
616: RACM.PROCESS_FLAG = 'N' AND
617: RACM.REQUEST_ID = req_id AND
618: RACM.SET_NUMBER = set_number AND

Line 624: RA_CUSTOMER_MERGES RACM

620: cs.system_ship_to_site_use_id <> racm.customer_site_id AND
621: cs.system_ship_to_site_use_id IS NOT NULL ) AND
622: ( cs.customer_id NOT IN ( select racm.customer_id
623: from CS_TEMPLATES_INTERFACE CS,
624: RA_CUSTOMER_MERGES RACM
625: where cs.customer_id = RACM.CUSTOMER_ID AND
626: cs.system_ship_to_site_use_id = racm.customer_site_id or
627: cs.system_ship_to_site_use_id IS NULL ))) AND
628: (( cs.customer_id = RACM.CUSTOMER_ID AND

Line 633: RA_CUSTOMER_MERGES RACM

629: cs.system_install_site_use_id <> racm.customer_site_id AND
630: cs.system_install_site_use_id IS NOT NULL ) AND
631: ( cs.customer_id NOT IN ( select racm.customer_id
632: from CS_TEMPLATES_INTERFACE CS,
633: RA_CUSTOMER_MERGES RACM
634: where cs.customer_id = RACM.CUSTOMER_ID AND
635: cs.system_install_site_use_id = racm.customer_site_id or
636: cs.system_install_site_use_id IS NULL ))) AND
637: (( cs.customer_id = RACM.CUSTOMER_ID AND

Line 642: RA_CUSTOMER_MERGES RACM

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

Line 651: RA_CUSTOMER_MERGES RACM

647: cs.cp_ship_to_site_use_id <> racm.customer_site_id AND
648: cs.cp_ship_to_site_use_id IS NOT NULL ) AND
649: ( cs.customer_id NOT IN ( select racm.customer_id
650: from CS_TEMPLATES_INTERFACE CS,
651: RA_CUSTOMER_MERGES RACM
652: where cs.customer_id = RACM.CUSTOMER_ID AND
653: cs.cp_ship_to_site_use_id = racm.customer_site_id or
654: cs.cp_ship_to_site_use_id IS NULL ))) );
655: BEGIN