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

Line 148: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM

144: number_of_rows NUMBER;
145:
146: Cursor LOCK_BILL_TO_SITE_ID ( req_id NUMBER, set_number NUMBER ) IS
147: SELECT bill_to_site_use_id
148: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM
149: WHERE
150: yt.bill_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
151: FROM RA_CUSTOMER_MERGES RACM
152: WHERE RACM.PROCESS_FLAG = 'N'

Line 151: FROM RA_CUSTOMER_MERGES RACM

147: SELECT bill_to_site_use_id
148: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM
149: WHERE
150: yt.bill_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
151: FROM RA_CUSTOMER_MERGES RACM
152: WHERE RACM.PROCESS_FLAG = 'N'
153: AND RACM.REQUEST_ID = req_id
154: AND RACM.SET_NUMBER = set_number )
155: AND yt.customer_id <> RACM.DUPLICATE_ID

Line 181: FROM RA_CUSTOMER_MERGES RACM

177: UPDATE CS_INCIDENTS yt
178: SET
179: yt.bill_to_site_use_id =
180: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
181: FROM RA_CUSTOMER_MERGES RACM
182: WHERE yt.bill_to_site_use_id
183: = RACM.DUPLICATE_SITE_ID
184: AND RACM.PROCESS_FLAG = 'N'
185: AND RACM.REQUEST_ID = req_id

Line 192: FROM RA_CUSTOMER_MERGES RACM

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'
194: AND RACM.REQUEST_ID = req_id
195: AND RACM.SET_NUMBER = set_number );
196:

Line 242: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM

238: number_of_rows NUMBER;
239:
240: Cursor LOCK_INSTALL_SITE_ID ( req_id NUMBER, set_number NUMBER ) IS
241: SELECT install_site_use_id
242: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM
243: WHERE
244: yt.install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
245: FROM RA_CUSTOMER_MERGES RACM
246: WHERE RACM.PROCESS_FLAG = 'N'

Line 245: FROM RA_CUSTOMER_MERGES RACM

241: SELECT install_site_use_id
242: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM
243: WHERE
244: yt.install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
245: FROM RA_CUSTOMER_MERGES RACM
246: WHERE RACM.PROCESS_FLAG = 'N'
247: AND RACM.REQUEST_ID = req_id
248: AND RACM.SET_NUMBER = set_number )
249: AND yt.customer_id <> RACM.DUPLICATE_ID

Line 274: FROM RA_CUSTOMER_MERGES RACM

270: UPDATE CS_INCIDENTS yt
271: SET
272: yt.install_site_use_id =
273: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
274: FROM RA_CUSTOMER_MERGES RACM
275: WHERE yt.install_site_use_id
276: = DUPLICATE_SITE_ID
277: AND RACM.PROCESS_FLAG = 'N'
278: AND RACM.REQUEST_ID = req_id

Line 285: FROM RA_CUSTOMER_MERGES RACM

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'
287: AND RACM.REQUEST_ID = req_id
288: AND RACM.SET_NUMBER = set_number );
289:

Line 335: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM

331: number_of_rows NUMBER;
332:
333: Cursor LOCK_SHIP_SITE_ID ( req_id NUMBER, set_number NUMBER ) IS
334: SELECT ship_to_site_use_id
335: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM
336: WHERE
337: yt.ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
338: FROM RA_CUSTOMER_MERGES RACM
339: WHERE RACM.PROCESS_FLAG = 'N'

Line 338: FROM RA_CUSTOMER_MERGES RACM

334: SELECT ship_to_site_use_id
335: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM
336: WHERE
337: yt.ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
338: FROM RA_CUSTOMER_MERGES RACM
339: WHERE RACM.PROCESS_FLAG = 'N'
340: AND RACM.REQUEST_ID = req_id
341: AND RACM.SET_NUMBER = set_number )
342: AND yt.customer_id <> RACM.DUPLICATE_ID

Line 366: FROM RA_CUSTOMER_MERGES RACM

362: UPDATE CS_INCIDENTS yt
363: SET
364: yt.ship_to_site_use_id =
365: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
366: FROM RA_CUSTOMER_MERGES RACM
367: WHERE yt.ship_to_site_use_id
368: = DUPLICATE_SITE_ID
369: AND RACM.PROCESS_FLAG = 'N'
370: AND RACM.REQUEST_ID = req_id

Line 377: FROM RA_CUSTOMER_MERGES RACM

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'
379: AND RACM.REQUEST_ID = req_id
380: AND RACM.SET_NUMBER = set_number );
381:

Line 426: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM

422: number_of_rows NUMBER;
423:
424: Cursor LOCK_CUSTOMER_ID ( req_id NUMBER, set_number NUMBER ) IS
425: SELECT yt.customer_id
426: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM
427: WHERE
428: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
429: FROM RA_CUSTOMER_MERGES RACM
430: WHERE RACM.PROCESS_FLAG = 'N'

Line 429: FROM RA_CUSTOMER_MERGES RACM

425: SELECT yt.customer_id
426: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM
427: WHERE
428: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
429: FROM RA_CUSTOMER_MERGES RACM
430: WHERE RACM.PROCESS_FLAG = 'N'
431: AND RACM.REQUEST_ID = req_id
432: AND RACM.SET_NUMBER = set_number )
433: FOR UPDATE NOWAIT;

Line 455: FROM RA_CUSTOMER_MERGES RACM

451:
452: UPDATE CS_INCIDENTS yt
453: SET
454: yt.customer_id = ( SELECT DISTINCT RACM.CUSTOMER_ID
455: FROM RA_CUSTOMER_MERGES RACM
456: WHERE yt.customer_id = DUPLICATE_ID
457: AND RACM.PROCESS_FLAG = 'N'
458: AND RACM.REQUEST_ID = req_id
459: AND RACM.SET_NUMBER = set_number ),

Line 465: FROM RA_CUSTOMER_MERGES RACM

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'
467: AND RACM.REQUEST_ID = req_id
468: AND RACM.SET_NUMBER = set_number );
469:

Line 524: RA_CUSTOMER_MERGES RACM

520: SELECT
521: DISTINCT
522: cs.incident_id
523: FROM CS_INCIDENTS CS,
524: RA_CUSTOMER_MERGES RACM
525: WHERE
526: RACM.PROCESS_FLAG = 'N' AND
527: RACM.REQUEST_ID = req_id AND
528: RACM.SET_NUMBER = set_number AND

Line 534: RA_CUSTOMER_MERGES RACM

530: cs.bill_to_site_use_id <> racm.customer_site_id AND
531: cs.bill_to_site_use_id IS NOT NULL ) AND
532: ( cs.customer_id NOT IN ( select racm.customer_id
533: from CS_INCIDENTS CS,
534: RA_CUSTOMER_MERGES RACM
535: where cs.customer_id = RACM.CUSTOMER_ID AND
536: cs.bill_to_site_use_id = racm.customer_site_id OR
537: cs.bill_to_site_use_id IS NULL ))) AND
538: (( cs.customer_id = RACM.CUSTOMER_ID AND

Line 543: RA_CUSTOMER_MERGES RACM

539: cs.install_site_use_id <> racm.customer_site_id AND
540: cs.install_site_use_id IS NOT NULL ) AND
541: ( cs.customer_id NOT IN ( select racm.customer_id
542: from CS_INCIDENTS CS,
543: RA_CUSTOMER_MERGES RACM
544: WHERE cs.customer_id = RACM.CUSTOMER_ID AND
545: cs.install_site_use_id = racm.customer_site_id OR
546: cs.install_site_use_id IS NULL ))) AND
547: (( cs.customer_id = RACM.CUSTOMER_ID AND

Line 552: RA_CUSTOMER_MERGES RACM

548: cs.ship_to_site_use_id <> racm.customer_site_id AND
549: cs.ship_to_site_use_id IS NOT NULL ) AND
550: ( cs.customer_id NOT IN ( select racm.customer_id
551: from CS_INCIDENTS CS,
552: RA_CUSTOMER_MERGES RACM
553: WHERE cs.customer_id = RACM.CUSTOMER_ID AND
554: cs.ship_to_site_use_id = racm.customer_site_id OR
555: cs.ship_to_site_use_id IS NULL ))));
556: