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

Line 146: FROM CS_SYSTEMS yt, RA_CUSTOMER_MERGES RACM

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

Line 149: FROM RA_CUSTOMER_MERGES RACM

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

Line 179: FROM RA_CUSTOMER_MERGES RACM

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

Line 190: FROM RA_CUSTOMER_MERGES RACM

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

Line 240: FROM CS_SYSTEMS yt, RA_CUSTOMER_MERGES RACM

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

Line 243: FROM RA_CUSTOMER_MERGES RACM

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

Line 272: FROM RA_CUSTOMER_MERGES RACM

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

Line 283: FROM RA_CUSTOMER_MERGES RACM

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

Line 333: FROM CS_SYSTEMS yt, RA_CUSTOMER_MERGES RACM

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

Line 336: FROM RA_CUSTOMER_MERGES RACM

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

Line 364: FROM RA_CUSTOMER_MERGES RACM

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

Line 375: FROM RA_CUSTOMER_MERGES RACM

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

Line 425: FROM CS_SYSTEMS yt, RA_CUSTOMER_MERGES RACM

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

Line 428: FROM RA_CUSTOMER_MERGES RACM

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

Line 454: FROM RA_CUSTOMER_MERGES RACM

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

Line 464: FROM RA_CUSTOMER_MERGES RACM

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

Line 523: RA_CUSTOMER_MERGES RACM

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

Line 533: RA_CUSTOMER_MERGES RACM

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

Line 542: RA_CUSTOMER_MERGES RACM

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

Line 551: RA_CUSTOMER_MERGES RACM

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