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.OE_CUST_MERGE_DATA_FIX dependencies on FND_GLOBAL

Line 119: last_updated_by = fnd_global.user_id,

115: and m.request_id = req_id
116: and m.process_flag = 'Y'
117: and m.set_number = set_num),
118: last_update_date = sysdate,
119: last_updated_by = fnd_global.user_id,
120: last_update_login = fnd_global.login_id,
121: request_id = req_id,
122: program_application_id =fnd_global.prog_appl_id,
123: program_id = fnd_global.conc_program_id,

Line 120: last_update_login = fnd_global.login_id,

116: and m.process_flag = 'Y'
117: and m.set_number = set_num),
118: last_update_date = sysdate,
119: last_updated_by = fnd_global.user_id,
120: last_update_login = fnd_global.login_id,
121: request_id = req_id,
122: program_application_id =fnd_global.prog_appl_id,
123: program_id = fnd_global.conc_program_id,
124: program_update_date = sysdate

Line 122: program_application_id =fnd_global.prog_appl_id,

118: last_update_date = sysdate,
119: last_updated_by = fnd_global.user_id,
120: last_update_login = fnd_global.login_id,
121: request_id = req_id,
122: program_application_id =fnd_global.prog_appl_id,
123: program_id = fnd_global.conc_program_id,
124: program_update_date = sysdate
125: where ship_to_org_id in (select m.duplicate_site_id
126: from ra_customer_merges m

Line 123: program_id = fnd_global.conc_program_id,

119: last_updated_by = fnd_global.user_id,
120: last_update_login = fnd_global.login_id,
121: request_id = req_id,
122: program_application_id =fnd_global.prog_appl_id,
123: program_id = fnd_global.conc_program_id,
124: program_update_date = sysdate
125: where ship_to_org_id in (select m.duplicate_site_id
126: from ra_customer_merges m
127: where m.process_flag = 'Y'

Line 152: last_updated_by = fnd_global.user_id,

148: and m.request_id = req_id
149: and m.process_flag = 'Y'
150: and m.set_number = set_num),
151: last_update_date = sysdate,
152: last_updated_by = fnd_global.user_id,
153: last_update_login = fnd_global.login_id,
154: request_id = req_id,
155: program_application_id =fnd_global.prog_appl_id,
156: program_id = fnd_global.conc_program_id,

Line 153: last_update_login = fnd_global.login_id,

149: and m.process_flag = 'Y'
150: and m.set_number = set_num),
151: last_update_date = sysdate,
152: last_updated_by = fnd_global.user_id,
153: last_update_login = fnd_global.login_id,
154: request_id = req_id,
155: program_application_id =fnd_global.prog_appl_id,
156: program_id = fnd_global.conc_program_id,
157: program_update_date = sysdate

Line 155: program_application_id =fnd_global.prog_appl_id,

151: last_update_date = sysdate,
152: last_updated_by = fnd_global.user_id,
153: last_update_login = fnd_global.login_id,
154: request_id = req_id,
155: program_application_id =fnd_global.prog_appl_id,
156: program_id = fnd_global.conc_program_id,
157: program_update_date = sysdate
158: where invoice_to_org_id in (select m.duplicate_site_id
159: from ra_customer_merges m

Line 156: program_id = fnd_global.conc_program_id,

152: last_updated_by = fnd_global.user_id,
153: last_update_login = fnd_global.login_id,
154: request_id = req_id,
155: program_application_id =fnd_global.prog_appl_id,
156: program_id = fnd_global.conc_program_id,
157: program_update_date = sysdate
158: where invoice_to_org_id in (select m.duplicate_site_id
159: from ra_customer_merges m
160: where m.process_flag = 'Y'

Line 185: last_updated_by = fnd_global.user_id,

181: and m.request_id = req_id
182: and m.process_flag = 'Y'
183: and m.set_number = set_num),
184: last_update_date = sysdate,
185: last_updated_by = fnd_global.user_id,
186: last_update_login = fnd_global.login_id,
187: request_id = req_id,
188: program_application_id =fnd_global.prog_appl_id,
189: program_id = fnd_global.conc_program_id,

Line 186: last_update_login = fnd_global.login_id,

182: and m.process_flag = 'Y'
183: and m.set_number = set_num),
184: last_update_date = sysdate,
185: last_updated_by = fnd_global.user_id,
186: last_update_login = fnd_global.login_id,
187: request_id = req_id,
188: program_application_id =fnd_global.prog_appl_id,
189: program_id = fnd_global.conc_program_id,
190: program_update_date = sysdate

Line 188: program_application_id =fnd_global.prog_appl_id,

184: last_update_date = sysdate,
185: last_updated_by = fnd_global.user_id,
186: last_update_login = fnd_global.login_id,
187: request_id = req_id,
188: program_application_id =fnd_global.prog_appl_id,
189: program_id = fnd_global.conc_program_id,
190: program_update_date = sysdate
191: where deliver_to_org_id in (select m.duplicate_site_id
192: from ra_customer_merges m

Line 189: program_id = fnd_global.conc_program_id,

185: last_updated_by = fnd_global.user_id,
186: last_update_login = fnd_global.login_id,
187: request_id = req_id,
188: program_application_id =fnd_global.prog_appl_id,
189: program_id = fnd_global.conc_program_id,
190: program_update_date = sysdate
191: where deliver_to_org_id in (select m.duplicate_site_id
192: from ra_customer_merges m
193: where m.process_flag = 'Y'

Line 224: last_updated_by = fnd_global.user_id,

220: and m.process_flag = 'Y'
221: and m.request_id = req_id
222: and m.set_number = set_num),
223: last_update_date = sysdate,
224: last_updated_by = fnd_global.user_id,
225: last_update_login = fnd_global.login_id,
226: request_id = req_id,
227: program_application_id =fnd_global.prog_appl_id,
228: program_id = fnd_global.conc_program_id,

Line 225: last_update_login = fnd_global.login_id,

221: and m.request_id = req_id
222: and m.set_number = set_num),
223: last_update_date = sysdate,
224: last_updated_by = fnd_global.user_id,
225: last_update_login = fnd_global.login_id,
226: request_id = req_id,
227: program_application_id =fnd_global.prog_appl_id,
228: program_id = fnd_global.conc_program_id,
229: program_update_date = sysdate

Line 227: program_application_id =fnd_global.prog_appl_id,

223: last_update_date = sysdate,
224: last_updated_by = fnd_global.user_id,
225: last_update_login = fnd_global.login_id,
226: request_id = req_id,
227: program_application_id =fnd_global.prog_appl_id,
228: program_id = fnd_global.conc_program_id,
229: program_update_date = sysdate
230: where sold_to_org_id in (select m.duplicate_id
231: from ra_customer_merges m

Line 228: program_id = fnd_global.conc_program_id,

224: last_updated_by = fnd_global.user_id,
225: last_update_login = fnd_global.login_id,
226: request_id = req_id,
227: program_application_id =fnd_global.prog_appl_id,
228: program_id = fnd_global.conc_program_id,
229: program_update_date = sysdate
230: where sold_to_org_id in (select m.duplicate_id
231: from ra_customer_merges m
232: where m.process_flag = 'Y'

Line 361: last_updated_by = fnd_global.user_id,

357: and m.request_id = req_id
358: and m.process_flag = 'Y'
359: and m.set_number = set_num),
360: last_update_date = sysdate,
361: last_updated_by = fnd_global.user_id,
362: last_update_login = fnd_global.login_id,
363: request_id = req_id,
364: program_application_id =fnd_global.prog_appl_id,
365: program_id = fnd_global.conc_program_id,

Line 362: last_update_login = fnd_global.login_id,

358: and m.process_flag = 'Y'
359: and m.set_number = set_num),
360: last_update_date = sysdate,
361: last_updated_by = fnd_global.user_id,
362: last_update_login = fnd_global.login_id,
363: request_id = req_id,
364: program_application_id =fnd_global.prog_appl_id,
365: program_id = fnd_global.conc_program_id,
366: program_update_date = sysdate

Line 364: program_application_id =fnd_global.prog_appl_id,

360: last_update_date = sysdate,
361: last_updated_by = fnd_global.user_id,
362: last_update_login = fnd_global.login_id,
363: request_id = req_id,
364: program_application_id =fnd_global.prog_appl_id,
365: program_id = fnd_global.conc_program_id,
366: program_update_date = sysdate
367: where ship_to_org_id in (select m.duplicate_site_id
368: from ra_customer_merges m

Line 365: program_id = fnd_global.conc_program_id,

361: last_updated_by = fnd_global.user_id,
362: last_update_login = fnd_global.login_id,
363: request_id = req_id,
364: program_application_id =fnd_global.prog_appl_id,
365: program_id = fnd_global.conc_program_id,
366: program_update_date = sysdate
367: where ship_to_org_id in (select m.duplicate_site_id
368: from ra_customer_merges m
369: where m.process_flag = 'Y'

Line 387: last_updated_by = fnd_global.user_id,

383: and m.request_id = req_id
384: and m.process_flag = 'Y'
385: and m.set_number = set_num),
386: last_update_date = sysdate,
387: last_updated_by = fnd_global.user_id,
388: last_update_login = fnd_global.login_id,
389: request_id = req_id,
390: program_application_id =fnd_global.prog_appl_id,
391: program_id = fnd_global.conc_program_id,

Line 388: last_update_login = fnd_global.login_id,

384: and m.process_flag = 'Y'
385: and m.set_number = set_num),
386: last_update_date = sysdate,
387: last_updated_by = fnd_global.user_id,
388: last_update_login = fnd_global.login_id,
389: request_id = req_id,
390: program_application_id =fnd_global.prog_appl_id,
391: program_id = fnd_global.conc_program_id,
392: program_update_date = sysdate

Line 390: program_application_id =fnd_global.prog_appl_id,

386: last_update_date = sysdate,
387: last_updated_by = fnd_global.user_id,
388: last_update_login = fnd_global.login_id,
389: request_id = req_id,
390: program_application_id =fnd_global.prog_appl_id,
391: program_id = fnd_global.conc_program_id,
392: program_update_date = sysdate
393: where invoice_to_org_id in (select m.duplicate_site_id
394: from ra_customer_merges m

Line 391: program_id = fnd_global.conc_program_id,

387: last_updated_by = fnd_global.user_id,
388: last_update_login = fnd_global.login_id,
389: request_id = req_id,
390: program_application_id =fnd_global.prog_appl_id,
391: program_id = fnd_global.conc_program_id,
392: program_update_date = sysdate
393: where invoice_to_org_id in (select m.duplicate_site_id
394: from ra_customer_merges m
395: where m.process_flag = 'Y'

Line 413: last_updated_by = fnd_global.user_id,

409: and m.request_id = req_id
410: and m.process_flag = 'Y'
411: and m.set_number = set_num),
412: last_update_date = sysdate,
413: last_updated_by = fnd_global.user_id,
414: last_update_login = fnd_global.login_id,
415: request_id = req_id,
416: program_application_id =fnd_global.prog_appl_id,
417: program_id = fnd_global.conc_program_id,

Line 414: last_update_login = fnd_global.login_id,

410: and m.process_flag = 'Y'
411: and m.set_number = set_num),
412: last_update_date = sysdate,
413: last_updated_by = fnd_global.user_id,
414: last_update_login = fnd_global.login_id,
415: request_id = req_id,
416: program_application_id =fnd_global.prog_appl_id,
417: program_id = fnd_global.conc_program_id,
418: program_update_date = sysdate

Line 416: program_application_id =fnd_global.prog_appl_id,

412: last_update_date = sysdate,
413: last_updated_by = fnd_global.user_id,
414: last_update_login = fnd_global.login_id,
415: request_id = req_id,
416: program_application_id =fnd_global.prog_appl_id,
417: program_id = fnd_global.conc_program_id,
418: program_update_date = sysdate
419: where deliver_to_org_id in (select m.duplicate_site_id
420: from ra_customer_merges m

Line 417: program_id = fnd_global.conc_program_id,

413: last_updated_by = fnd_global.user_id,
414: last_update_login = fnd_global.login_id,
415: request_id = req_id,
416: program_application_id =fnd_global.prog_appl_id,
417: program_id = fnd_global.conc_program_id,
418: program_update_date = sysdate
419: where deliver_to_org_id in (select m.duplicate_site_id
420: from ra_customer_merges m
421: where m.process_flag = 'Y'

Line 445: last_updated_by = fnd_global.user_id,

441: and m.process_flag = 'Y'
442: and m.request_id = req_id
443: and m.set_number = set_num),
444: last_update_date = sysdate,
445: last_updated_by = fnd_global.user_id,
446: last_update_login = fnd_global.login_id,
447: request_id = req_id,
448: program_application_id =fnd_global.prog_appl_id,
449: program_id = fnd_global.conc_program_id,

Line 446: last_update_login = fnd_global.login_id,

442: and m.request_id = req_id
443: and m.set_number = set_num),
444: last_update_date = sysdate,
445: last_updated_by = fnd_global.user_id,
446: last_update_login = fnd_global.login_id,
447: request_id = req_id,
448: program_application_id =fnd_global.prog_appl_id,
449: program_id = fnd_global.conc_program_id,
450: program_update_date = sysdate

Line 448: program_application_id =fnd_global.prog_appl_id,

444: last_update_date = sysdate,
445: last_updated_by = fnd_global.user_id,
446: last_update_login = fnd_global.login_id,
447: request_id = req_id,
448: program_application_id =fnd_global.prog_appl_id,
449: program_id = fnd_global.conc_program_id,
450: program_update_date = sysdate
451: where sold_to_org_id in (select m.duplicate_id
452: from ra_customer_merges m

Line 449: program_id = fnd_global.conc_program_id,

445: last_updated_by = fnd_global.user_id,
446: last_update_login = fnd_global.login_id,
447: request_id = req_id,
448: program_application_id =fnd_global.prog_appl_id,
449: program_id = fnd_global.conc_program_id,
450: program_update_date = sysdate
451: where sold_to_org_id in (select m.duplicate_id
452: from ra_customer_merges m
453: where m.process_flag = 'Y'

Line 571: last_updated_by = fnd_global.user_id,

567: and m.request_id = req_id
568: and m.process_flag = 'Y'
569: and m.set_number = set_num),
570: last_update_date = sysdate,
571: last_updated_by = fnd_global.user_id,
572: last_update_login = fnd_global.login_id,
573: request_id = req_id,
574: program_application_id =fnd_global.prog_appl_id,
575: program_id = fnd_global.conc_program_id,

Line 572: last_update_login = fnd_global.login_id,

568: and m.process_flag = 'Y'
569: and m.set_number = set_num),
570: last_update_date = sysdate,
571: last_updated_by = fnd_global.user_id,
572: last_update_login = fnd_global.login_id,
573: request_id = req_id,
574: program_application_id =fnd_global.prog_appl_id,
575: program_id = fnd_global.conc_program_id,
576: program_update_date = sysdate

Line 574: program_application_id =fnd_global.prog_appl_id,

570: last_update_date = sysdate,
571: last_updated_by = fnd_global.user_id,
572: last_update_login = fnd_global.login_id,
573: request_id = req_id,
574: program_application_id =fnd_global.prog_appl_id,
575: program_id = fnd_global.conc_program_id,
576: program_update_date = sysdate
577: where ship_to_org_id in (select m.duplicate_site_id
578: from ra_customer_merges m

Line 575: program_id = fnd_global.conc_program_id,

571: last_updated_by = fnd_global.user_id,
572: last_update_login = fnd_global.login_id,
573: request_id = req_id,
574: program_application_id =fnd_global.prog_appl_id,
575: program_id = fnd_global.conc_program_id,
576: program_update_date = sysdate
577: where ship_to_org_id in (select m.duplicate_site_id
578: from ra_customer_merges m
579: where m.process_flag = 'Y'

Line 597: last_updated_by = fnd_global.user_id,

593: and m.request_id = req_id
594: and m.process_flag = 'Y'
595: and m.set_number = set_num),
596: last_update_date = sysdate,
597: last_updated_by = fnd_global.user_id,
598: last_update_login = fnd_global.login_id,
599: request_id = req_id,
600: program_application_id =fnd_global.prog_appl_id,
601: program_id = fnd_global.conc_program_id,

Line 598: last_update_login = fnd_global.login_id,

594: and m.process_flag = 'Y'
595: and m.set_number = set_num),
596: last_update_date = sysdate,
597: last_updated_by = fnd_global.user_id,
598: last_update_login = fnd_global.login_id,
599: request_id = req_id,
600: program_application_id =fnd_global.prog_appl_id,
601: program_id = fnd_global.conc_program_id,
602: program_update_date = sysdate

Line 600: program_application_id =fnd_global.prog_appl_id,

596: last_update_date = sysdate,
597: last_updated_by = fnd_global.user_id,
598: last_update_login = fnd_global.login_id,
599: request_id = req_id,
600: program_application_id =fnd_global.prog_appl_id,
601: program_id = fnd_global.conc_program_id,
602: program_update_date = sysdate
603: where invoice_to_org_id in (select m.duplicate_site_id
604: from ra_customer_merges m

Line 601: program_id = fnd_global.conc_program_id,

597: last_updated_by = fnd_global.user_id,
598: last_update_login = fnd_global.login_id,
599: request_id = req_id,
600: program_application_id =fnd_global.prog_appl_id,
601: program_id = fnd_global.conc_program_id,
602: program_update_date = sysdate
603: where invoice_to_org_id in (select m.duplicate_site_id
604: from ra_customer_merges m
605: where m.process_flag = 'Y'

Line 623: last_updated_by = fnd_global.user_id,

619: and m.request_id = req_id
620: and m.process_flag = 'Y'
621: and m.set_number = set_num),
622: last_update_date = sysdate,
623: last_updated_by = fnd_global.user_id,
624: last_update_login = fnd_global.login_id,
625: request_id = req_id,
626: program_application_id =fnd_global.prog_appl_id,
627: program_id = fnd_global.conc_program_id,

Line 624: last_update_login = fnd_global.login_id,

620: and m.process_flag = 'Y'
621: and m.set_number = set_num),
622: last_update_date = sysdate,
623: last_updated_by = fnd_global.user_id,
624: last_update_login = fnd_global.login_id,
625: request_id = req_id,
626: program_application_id =fnd_global.prog_appl_id,
627: program_id = fnd_global.conc_program_id,
628: program_update_date = sysdate

Line 626: program_application_id =fnd_global.prog_appl_id,

622: last_update_date = sysdate,
623: last_updated_by = fnd_global.user_id,
624: last_update_login = fnd_global.login_id,
625: request_id = req_id,
626: program_application_id =fnd_global.prog_appl_id,
627: program_id = fnd_global.conc_program_id,
628: program_update_date = sysdate
629: where deliver_to_org_id in (select m.duplicate_site_id
630: from ra_customer_merges m

Line 627: program_id = fnd_global.conc_program_id,

623: last_updated_by = fnd_global.user_id,
624: last_update_login = fnd_global.login_id,
625: request_id = req_id,
626: program_application_id =fnd_global.prog_appl_id,
627: program_id = fnd_global.conc_program_id,
628: program_update_date = sysdate
629: where deliver_to_org_id in (select m.duplicate_site_id
630: from ra_customer_merges m
631: where m.process_flag = 'Y'

Line 654: last_updated_by = fnd_global.user_id,

650: and m.process_flag = 'Y'
651: and m.request_id = req_id
652: and m.set_number = set_num),
653: last_update_date = sysdate,
654: last_updated_by = fnd_global.user_id,
655: last_update_login = fnd_global.login_id,
656: request_id = req_id,
657: program_application_id =fnd_global.prog_appl_id,
658: program_id = fnd_global.conc_program_id,

Line 655: last_update_login = fnd_global.login_id,

651: and m.request_id = req_id
652: and m.set_number = set_num),
653: last_update_date = sysdate,
654: last_updated_by = fnd_global.user_id,
655: last_update_login = fnd_global.login_id,
656: request_id = req_id,
657: program_application_id =fnd_global.prog_appl_id,
658: program_id = fnd_global.conc_program_id,
659: program_update_date = sysdate

Line 657: program_application_id =fnd_global.prog_appl_id,

653: last_update_date = sysdate,
654: last_updated_by = fnd_global.user_id,
655: last_update_login = fnd_global.login_id,
656: request_id = req_id,
657: program_application_id =fnd_global.prog_appl_id,
658: program_id = fnd_global.conc_program_id,
659: program_update_date = sysdate
660: where sold_to_org_id in (select m.duplicate_id
661: from ra_customer_merges m

Line 658: program_id = fnd_global.conc_program_id,

654: last_updated_by = fnd_global.user_id,
655: last_update_login = fnd_global.login_id,
656: request_id = req_id,
657: program_application_id =fnd_global.prog_appl_id,
658: program_id = fnd_global.conc_program_id,
659: program_update_date = sysdate
660: where sold_to_org_id in (select m.duplicate_id
661: from ra_customer_merges m
662: where m.process_flag = 'Y'

Line 798: last_updated_by = fnd_global.user_id,

794: and m.request_id = req_id
795: and m.process_flag = 'Y'
796: and m.set_number = set_num),
797: last_update_date = sysdate,
798: last_updated_by = fnd_global.user_id,
799: last_update_login = fnd_global.login_id,
800: request_id = req_id,
801: program_application_id =fnd_global.prog_appl_id,
802: program_id = fnd_global.conc_program_id,

Line 799: last_update_login = fnd_global.login_id,

795: and m.process_flag = 'Y'
796: and m.set_number = set_num),
797: last_update_date = sysdate,
798: last_updated_by = fnd_global.user_id,
799: last_update_login = fnd_global.login_id,
800: request_id = req_id,
801: program_application_id =fnd_global.prog_appl_id,
802: program_id = fnd_global.conc_program_id,
803: program_update_date = sysdate

Line 801: program_application_id =fnd_global.prog_appl_id,

797: last_update_date = sysdate,
798: last_updated_by = fnd_global.user_id,
799: last_update_login = fnd_global.login_id,
800: request_id = req_id,
801: program_application_id =fnd_global.prog_appl_id,
802: program_id = fnd_global.conc_program_id,
803: program_update_date = sysdate
804: where ship_to_org_id in (select m.duplicate_site_id
805: from ra_customer_merges m

Line 802: program_id = fnd_global.conc_program_id,

798: last_updated_by = fnd_global.user_id,
799: last_update_login = fnd_global.login_id,
800: request_id = req_id,
801: program_application_id =fnd_global.prog_appl_id,
802: program_id = fnd_global.conc_program_id,
803: program_update_date = sysdate
804: where ship_to_org_id in (select m.duplicate_site_id
805: from ra_customer_merges m
806: where m.process_flag = 'Y'

Line 831: last_updated_by = fnd_global.user_id,

827: and m.request_id = req_id
828: and m.process_flag = 'Y'
829: and m.set_number = set_num),
830: last_update_date = sysdate,
831: last_updated_by = fnd_global.user_id,
832: last_update_login = fnd_global.login_id,
833: request_id = req_id,
834: program_application_id =fnd_global.prog_appl_id,
835: program_id = fnd_global.conc_program_id,

Line 832: last_update_login = fnd_global.login_id,

828: and m.process_flag = 'Y'
829: and m.set_number = set_num),
830: last_update_date = sysdate,
831: last_updated_by = fnd_global.user_id,
832: last_update_login = fnd_global.login_id,
833: request_id = req_id,
834: program_application_id =fnd_global.prog_appl_id,
835: program_id = fnd_global.conc_program_id,
836: program_update_date = sysdate

Line 834: program_application_id =fnd_global.prog_appl_id,

830: last_update_date = sysdate,
831: last_updated_by = fnd_global.user_id,
832: last_update_login = fnd_global.login_id,
833: request_id = req_id,
834: program_application_id =fnd_global.prog_appl_id,
835: program_id = fnd_global.conc_program_id,
836: program_update_date = sysdate
837: where invoice_to_org_id in (select m.duplicate_site_id
838: from ra_customer_merges m

Line 835: program_id = fnd_global.conc_program_id,

831: last_updated_by = fnd_global.user_id,
832: last_update_login = fnd_global.login_id,
833: request_id = req_id,
834: program_application_id =fnd_global.prog_appl_id,
835: program_id = fnd_global.conc_program_id,
836: program_update_date = sysdate
837: where invoice_to_org_id in (select m.duplicate_site_id
838: from ra_customer_merges m
839: where m.process_flag = 'Y'

Line 864: last_updated_by = fnd_global.user_id,

860: and m.request_id = req_id
861: and m.process_flag = 'Y'
862: and m.set_number = set_num),
863: last_update_date = sysdate,
864: last_updated_by = fnd_global.user_id,
865: last_update_login = fnd_global.login_id,
866: request_id = req_id,
867: program_application_id =fnd_global.prog_appl_id,
868: program_id = fnd_global.conc_program_id,

Line 865: last_update_login = fnd_global.login_id,

861: and m.process_flag = 'Y'
862: and m.set_number = set_num),
863: last_update_date = sysdate,
864: last_updated_by = fnd_global.user_id,
865: last_update_login = fnd_global.login_id,
866: request_id = req_id,
867: program_application_id =fnd_global.prog_appl_id,
868: program_id = fnd_global.conc_program_id,
869: program_update_date = sysdate

Line 867: program_application_id =fnd_global.prog_appl_id,

863: last_update_date = sysdate,
864: last_updated_by = fnd_global.user_id,
865: last_update_login = fnd_global.login_id,
866: request_id = req_id,
867: program_application_id =fnd_global.prog_appl_id,
868: program_id = fnd_global.conc_program_id,
869: program_update_date = sysdate
870: where deliver_to_org_id in (select m.duplicate_site_id
871: from ra_customer_merges m

Line 868: program_id = fnd_global.conc_program_id,

864: last_updated_by = fnd_global.user_id,
865: last_update_login = fnd_global.login_id,
866: request_id = req_id,
867: program_application_id =fnd_global.prog_appl_id,
868: program_id = fnd_global.conc_program_id,
869: program_update_date = sysdate
870: where deliver_to_org_id in (select m.duplicate_site_id
871: from ra_customer_merges m
872: where m.process_flag = 'Y'

Line 906: last_updated_by = fnd_global.user_id,

902: and m.process_flag = 'Y'
903: and m.request_id = req_id
904: and m.set_number = set_num),
905: last_update_date = sysdate,
906: last_updated_by = fnd_global.user_id,
907: last_update_login = fnd_global.login_id,
908: request_id = req_id,
909: program_application_id =fnd_global.prog_appl_id,
910: program_id = fnd_global.conc_program_id,

Line 907: last_update_login = fnd_global.login_id,

903: and m.request_id = req_id
904: and m.set_number = set_num),
905: last_update_date = sysdate,
906: last_updated_by = fnd_global.user_id,
907: last_update_login = fnd_global.login_id,
908: request_id = req_id,
909: program_application_id =fnd_global.prog_appl_id,
910: program_id = fnd_global.conc_program_id,
911: program_update_date = sysdate

Line 909: program_application_id =fnd_global.prog_appl_id,

905: last_update_date = sysdate,
906: last_updated_by = fnd_global.user_id,
907: last_update_login = fnd_global.login_id,
908: request_id = req_id,
909: program_application_id =fnd_global.prog_appl_id,
910: program_id = fnd_global.conc_program_id,
911: program_update_date = sysdate
912: where sold_to_org_id in (select m.duplicate_id
913: from ra_customer_merges m

Line 910: program_id = fnd_global.conc_program_id,

906: last_updated_by = fnd_global.user_id,
907: last_update_login = fnd_global.login_id,
908: request_id = req_id,
909: program_application_id =fnd_global.prog_appl_id,
910: program_id = fnd_global.conc_program_id,
911: program_update_date = sysdate
912: where sold_to_org_id in (select m.duplicate_id
913: from ra_customer_merges m
914: where m.process_flag = 'Y'

Line 1067: last_updated_by = fnd_global.user_id,

1063: and m.request_id = req_id
1064: and m.process_flag = 'Y'
1065: and m.set_number = set_num),
1066: last_update_date = sysdate,
1067: last_updated_by = fnd_global.user_id,
1068: last_update_login = fnd_global.login_id,
1069: request_id = req_id,
1070: program_application_id =fnd_global.prog_appl_id,
1071: program_id = fnd_global.conc_program_id,

Line 1068: last_update_login = fnd_global.login_id,

1064: and m.process_flag = 'Y'
1065: and m.set_number = set_num),
1066: last_update_date = sysdate,
1067: last_updated_by = fnd_global.user_id,
1068: last_update_login = fnd_global.login_id,
1069: request_id = req_id,
1070: program_application_id =fnd_global.prog_appl_id,
1071: program_id = fnd_global.conc_program_id,
1072: program_update_date = sysdate

Line 1070: program_application_id =fnd_global.prog_appl_id,

1066: last_update_date = sysdate,
1067: last_updated_by = fnd_global.user_id,
1068: last_update_login = fnd_global.login_id,
1069: request_id = req_id,
1070: program_application_id =fnd_global.prog_appl_id,
1071: program_id = fnd_global.conc_program_id,
1072: program_update_date = sysdate
1073: where ship_to_org_id in (select m.duplicate_site_id
1074: from ra_customer_merges m

Line 1071: program_id = fnd_global.conc_program_id,

1067: last_updated_by = fnd_global.user_id,
1068: last_update_login = fnd_global.login_id,
1069: request_id = req_id,
1070: program_application_id =fnd_global.prog_appl_id,
1071: program_id = fnd_global.conc_program_id,
1072: program_update_date = sysdate
1073: where ship_to_org_id in (select m.duplicate_site_id
1074: from ra_customer_merges m
1075: where m.process_flag = 'Y'

Line 1098: last_updated_by = fnd_global.user_id,

1094: and m.request_id = req_id
1095: and m.process_flag = 'Y'
1096: and m.set_number = set_num),
1097: last_update_date = sysdate,
1098: last_updated_by = fnd_global.user_id,
1099: last_update_login = fnd_global.login_id,
1100: request_id = req_id,
1101: program_application_id =fnd_global.prog_appl_id,
1102: program_id = fnd_global.conc_program_id,

Line 1099: last_update_login = fnd_global.login_id,

1095: and m.process_flag = 'Y'
1096: and m.set_number = set_num),
1097: last_update_date = sysdate,
1098: last_updated_by = fnd_global.user_id,
1099: last_update_login = fnd_global.login_id,
1100: request_id = req_id,
1101: program_application_id =fnd_global.prog_appl_id,
1102: program_id = fnd_global.conc_program_id,
1103: program_update_date = sysdate

Line 1101: program_application_id =fnd_global.prog_appl_id,

1097: last_update_date = sysdate,
1098: last_updated_by = fnd_global.user_id,
1099: last_update_login = fnd_global.login_id,
1100: request_id = req_id,
1101: program_application_id =fnd_global.prog_appl_id,
1102: program_id = fnd_global.conc_program_id,
1103: program_update_date = sysdate
1104: where invoice_to_org_id in (select m.duplicate_site_id
1105: from ra_customer_merges m

Line 1102: program_id = fnd_global.conc_program_id,

1098: last_updated_by = fnd_global.user_id,
1099: last_update_login = fnd_global.login_id,
1100: request_id = req_id,
1101: program_application_id =fnd_global.prog_appl_id,
1102: program_id = fnd_global.conc_program_id,
1103: program_update_date = sysdate
1104: where invoice_to_org_id in (select m.duplicate_site_id
1105: from ra_customer_merges m
1106: where m.process_flag = 'Y'

Line 1130: last_updated_by = fnd_global.user_id,

1126: and m.request_id = req_id
1127: and m.process_flag = 'Y'
1128: and m.set_number = set_num),
1129: last_update_date = sysdate,
1130: last_updated_by = fnd_global.user_id,
1131: last_update_login = fnd_global.login_id,
1132: request_id = req_id,
1133: program_application_id =fnd_global.prog_appl_id,
1134: program_id = fnd_global.conc_program_id,

Line 1131: last_update_login = fnd_global.login_id,

1127: and m.process_flag = 'Y'
1128: and m.set_number = set_num),
1129: last_update_date = sysdate,
1130: last_updated_by = fnd_global.user_id,
1131: last_update_login = fnd_global.login_id,
1132: request_id = req_id,
1133: program_application_id =fnd_global.prog_appl_id,
1134: program_id = fnd_global.conc_program_id,
1135: program_update_date = sysdate

Line 1133: program_application_id =fnd_global.prog_appl_id,

1129: last_update_date = sysdate,
1130: last_updated_by = fnd_global.user_id,
1131: last_update_login = fnd_global.login_id,
1132: request_id = req_id,
1133: program_application_id =fnd_global.prog_appl_id,
1134: program_id = fnd_global.conc_program_id,
1135: program_update_date = sysdate
1136: where deliver_to_org_id in (select m.duplicate_site_id
1137: from ra_customer_merges m

Line 1134: program_id = fnd_global.conc_program_id,

1130: last_updated_by = fnd_global.user_id,
1131: last_update_login = fnd_global.login_id,
1132: request_id = req_id,
1133: program_application_id =fnd_global.prog_appl_id,
1134: program_id = fnd_global.conc_program_id,
1135: program_update_date = sysdate
1136: where deliver_to_org_id in (select m.duplicate_site_id
1137: from ra_customer_merges m
1138: where m.process_flag = 'Y'

Line 1162: last_updated_by = fnd_global.user_id,

1158: and m.request_id = req_id
1159: and m.process_flag = 'Y'
1160: and m.set_number = set_num),
1161: last_update_date = sysdate,
1162: last_updated_by = fnd_global.user_id,
1163: last_update_login = fnd_global.login_id,
1164: request_id = req_id,
1165: program_application_id =fnd_global.prog_appl_id,
1166: program_id = fnd_global.conc_program_id,

Line 1163: last_update_login = fnd_global.login_id,

1159: and m.process_flag = 'Y'
1160: and m.set_number = set_num),
1161: last_update_date = sysdate,
1162: last_updated_by = fnd_global.user_id,
1163: last_update_login = fnd_global.login_id,
1164: request_id = req_id,
1165: program_application_id =fnd_global.prog_appl_id,
1166: program_id = fnd_global.conc_program_id,
1167: program_update_date = sysdate

Line 1165: program_application_id =fnd_global.prog_appl_id,

1161: last_update_date = sysdate,
1162: last_updated_by = fnd_global.user_id,
1163: last_update_login = fnd_global.login_id,
1164: request_id = req_id,
1165: program_application_id =fnd_global.prog_appl_id,
1166: program_id = fnd_global.conc_program_id,
1167: program_update_date = sysdate
1168: where intmed_ship_to_org_id in (select m.duplicate_site_id
1169: from ra_customer_merges m

Line 1166: program_id = fnd_global.conc_program_id,

1162: last_updated_by = fnd_global.user_id,
1163: last_update_login = fnd_global.login_id,
1164: request_id = req_id,
1165: program_application_id =fnd_global.prog_appl_id,
1166: program_id = fnd_global.conc_program_id,
1167: program_update_date = sysdate
1168: where intmed_ship_to_org_id in (select m.duplicate_site_id
1169: from ra_customer_merges m
1170: where m.process_flag = 'Y'

Line 1201: last_updated_by = fnd_global.user_id,

1197: and m.process_flag = 'Y'
1198: and m.request_id = req_id
1199: and m.set_number = set_num),
1200: last_update_date = sysdate,
1201: last_updated_by = fnd_global.user_id,
1202: last_update_login = fnd_global.login_id,
1203: request_id = req_id,
1204: program_application_id =fnd_global.prog_appl_id,
1205: program_id = fnd_global.conc_program_id,

Line 1202: last_update_login = fnd_global.login_id,

1198: and m.request_id = req_id
1199: and m.set_number = set_num),
1200: last_update_date = sysdate,
1201: last_updated_by = fnd_global.user_id,
1202: last_update_login = fnd_global.login_id,
1203: request_id = req_id,
1204: program_application_id =fnd_global.prog_appl_id,
1205: program_id = fnd_global.conc_program_id,
1206: program_update_date = sysdate

Line 1204: program_application_id =fnd_global.prog_appl_id,

1200: last_update_date = sysdate,
1201: last_updated_by = fnd_global.user_id,
1202: last_update_login = fnd_global.login_id,
1203: request_id = req_id,
1204: program_application_id =fnd_global.prog_appl_id,
1205: program_id = fnd_global.conc_program_id,
1206: program_update_date = sysdate
1207: where sold_to_org_id in (select m.duplicate_id
1208: from ra_customer_merges m

Line 1205: program_id = fnd_global.conc_program_id,

1201: last_updated_by = fnd_global.user_id,
1202: last_update_login = fnd_global.login_id,
1203: request_id = req_id,
1204: program_application_id =fnd_global.prog_appl_id,
1205: program_id = fnd_global.conc_program_id,
1206: program_update_date = sysdate
1207: where sold_to_org_id in (select m.duplicate_id
1208: from ra_customer_merges m
1209: where m.process_flag = 'Y'

Line 1361: last_updated_by = fnd_global.user_id,

1357: and m.request_id = req_id
1358: and m.process_flag = 'Y'
1359: and m.set_number = set_num),
1360: last_update_date = sysdate,
1361: last_updated_by = fnd_global.user_id,
1362: last_update_login = fnd_global.login_id,
1363: request_id = req_id,
1364: program_application_id =fnd_global.prog_appl_id,
1365: program_id = fnd_global.conc_program_id,

Line 1362: last_update_login = fnd_global.login_id,

1358: and m.process_flag = 'Y'
1359: and m.set_number = set_num),
1360: last_update_date = sysdate,
1361: last_updated_by = fnd_global.user_id,
1362: last_update_login = fnd_global.login_id,
1363: request_id = req_id,
1364: program_application_id =fnd_global.prog_appl_id,
1365: program_id = fnd_global.conc_program_id,
1366: program_update_date = sysdate

Line 1364: program_application_id =fnd_global.prog_appl_id,

1360: last_update_date = sysdate,
1361: last_updated_by = fnd_global.user_id,
1362: last_update_login = fnd_global.login_id,
1363: request_id = req_id,
1364: program_application_id =fnd_global.prog_appl_id,
1365: program_id = fnd_global.conc_program_id,
1366: program_update_date = sysdate
1367: where ship_to_org_id in (select m.duplicate_site_id
1368: from ra_customer_merges m

Line 1365: program_id = fnd_global.conc_program_id,

1361: last_updated_by = fnd_global.user_id,
1362: last_update_login = fnd_global.login_id,
1363: request_id = req_id,
1364: program_application_id =fnd_global.prog_appl_id,
1365: program_id = fnd_global.conc_program_id,
1366: program_update_date = sysdate
1367: where ship_to_org_id in (select m.duplicate_site_id
1368: from ra_customer_merges m
1369: where m.process_flag = 'Y'

Line 1393: last_updated_by = fnd_global.user_id,

1389: and m.request_id = req_id
1390: and m.process_flag = 'Y'
1391: and m.set_number = set_num),
1392: last_update_date = sysdate,
1393: last_updated_by = fnd_global.user_id,
1394: last_update_login = fnd_global.login_id,
1395: request_id = req_id,
1396: program_application_id =fnd_global.prog_appl_id,
1397: program_id = fnd_global.conc_program_id,

Line 1394: last_update_login = fnd_global.login_id,

1390: and m.process_flag = 'Y'
1391: and m.set_number = set_num),
1392: last_update_date = sysdate,
1393: last_updated_by = fnd_global.user_id,
1394: last_update_login = fnd_global.login_id,
1395: request_id = req_id,
1396: program_application_id =fnd_global.prog_appl_id,
1397: program_id = fnd_global.conc_program_id,
1398: program_update_date = sysdate

Line 1396: program_application_id =fnd_global.prog_appl_id,

1392: last_update_date = sysdate,
1393: last_updated_by = fnd_global.user_id,
1394: last_update_login = fnd_global.login_id,
1395: request_id = req_id,
1396: program_application_id =fnd_global.prog_appl_id,
1397: program_id = fnd_global.conc_program_id,
1398: program_update_date = sysdate
1399: where invoice_to_org_id in (select m.duplicate_site_id
1400: from ra_customer_merges m

Line 1397: program_id = fnd_global.conc_program_id,

1393: last_updated_by = fnd_global.user_id,
1394: last_update_login = fnd_global.login_id,
1395: request_id = req_id,
1396: program_application_id =fnd_global.prog_appl_id,
1397: program_id = fnd_global.conc_program_id,
1398: program_update_date = sysdate
1399: where invoice_to_org_id in (select m.duplicate_site_id
1400: from ra_customer_merges m
1401: where m.process_flag = 'Y'

Line 1425: last_updated_by = fnd_global.user_id,

1421: and m.request_id = req_id
1422: and m.process_flag = 'Y'
1423: and m.set_number = set_num),
1424: last_update_date = sysdate,
1425: last_updated_by = fnd_global.user_id,
1426: last_update_login = fnd_global.login_id,
1427: request_id = req_id,
1428: program_application_id =fnd_global.prog_appl_id,
1429: program_id = fnd_global.conc_program_id,

Line 1426: last_update_login = fnd_global.login_id,

1422: and m.process_flag = 'Y'
1423: and m.set_number = set_num),
1424: last_update_date = sysdate,
1425: last_updated_by = fnd_global.user_id,
1426: last_update_login = fnd_global.login_id,
1427: request_id = req_id,
1428: program_application_id =fnd_global.prog_appl_id,
1429: program_id = fnd_global.conc_program_id,
1430: program_update_date = sysdate

Line 1428: program_application_id =fnd_global.prog_appl_id,

1424: last_update_date = sysdate,
1425: last_updated_by = fnd_global.user_id,
1426: last_update_login = fnd_global.login_id,
1427: request_id = req_id,
1428: program_application_id =fnd_global.prog_appl_id,
1429: program_id = fnd_global.conc_program_id,
1430: program_update_date = sysdate
1431: where deliver_to_org_id in (select m.duplicate_site_id
1432: from ra_customer_merges m

Line 1429: program_id = fnd_global.conc_program_id,

1425: last_updated_by = fnd_global.user_id,
1426: last_update_login = fnd_global.login_id,
1427: request_id = req_id,
1428: program_application_id =fnd_global.prog_appl_id,
1429: program_id = fnd_global.conc_program_id,
1430: program_update_date = sysdate
1431: where deliver_to_org_id in (select m.duplicate_site_id
1432: from ra_customer_merges m
1433: where m.process_flag = 'Y'

Line 1458: last_updated_by = fnd_global.user_id,

1454: and m.request_id = req_id
1455: and m.process_flag = 'Y'
1456: and m.set_number = set_num),
1457: last_update_date = sysdate,
1458: last_updated_by = fnd_global.user_id,
1459: last_update_login = fnd_global.login_id,
1460: request_id = req_id,
1461: program_application_id =fnd_global.prog_appl_id,
1462: program_id = fnd_global.conc_program_id,

Line 1459: last_update_login = fnd_global.login_id,

1455: and m.process_flag = 'Y'
1456: and m.set_number = set_num),
1457: last_update_date = sysdate,
1458: last_updated_by = fnd_global.user_id,
1459: last_update_login = fnd_global.login_id,
1460: request_id = req_id,
1461: program_application_id =fnd_global.prog_appl_id,
1462: program_id = fnd_global.conc_program_id,
1463: program_update_date = sysdate

Line 1461: program_application_id =fnd_global.prog_appl_id,

1457: last_update_date = sysdate,
1458: last_updated_by = fnd_global.user_id,
1459: last_update_login = fnd_global.login_id,
1460: request_id = req_id,
1461: program_application_id =fnd_global.prog_appl_id,
1462: program_id = fnd_global.conc_program_id,
1463: program_update_date = sysdate
1464: where intmed_ship_to_org_id in (select m.duplicate_site_id
1465: from ra_customer_merges m

Line 1462: program_id = fnd_global.conc_program_id,

1458: last_updated_by = fnd_global.user_id,
1459: last_update_login = fnd_global.login_id,
1460: request_id = req_id,
1461: program_application_id =fnd_global.prog_appl_id,
1462: program_id = fnd_global.conc_program_id,
1463: program_update_date = sysdate
1464: where intmed_ship_to_org_id in (select m.duplicate_site_id
1465: from ra_customer_merges m
1466: where m.process_flag = 'Y'

Line 1498: last_updated_by = fnd_global.user_id,

1494: and m.process_flag = 'Y'
1495: and m.request_id = req_id
1496: and m.set_number = set_num),
1497: last_update_date = sysdate,
1498: last_updated_by = fnd_global.user_id,
1499: last_update_login = fnd_global.login_id,
1500: request_id = req_id,
1501: program_application_id =fnd_global.prog_appl_id,
1502: program_id = fnd_global.conc_program_id,

Line 1499: last_update_login = fnd_global.login_id,

1495: and m.request_id = req_id
1496: and m.set_number = set_num),
1497: last_update_date = sysdate,
1498: last_updated_by = fnd_global.user_id,
1499: last_update_login = fnd_global.login_id,
1500: request_id = req_id,
1501: program_application_id =fnd_global.prog_appl_id,
1502: program_id = fnd_global.conc_program_id,
1503: program_update_date = sysdate

Line 1501: program_application_id =fnd_global.prog_appl_id,

1497: last_update_date = sysdate,
1498: last_updated_by = fnd_global.user_id,
1499: last_update_login = fnd_global.login_id,
1500: request_id = req_id,
1501: program_application_id =fnd_global.prog_appl_id,
1502: program_id = fnd_global.conc_program_id,
1503: program_update_date = sysdate
1504: where sold_to_org_id in (select m.duplicate_id
1505: from ra_customer_merges m

Line 1502: program_id = fnd_global.conc_program_id,

1498: last_updated_by = fnd_global.user_id,
1499: last_update_login = fnd_global.login_id,
1500: request_id = req_id,
1501: program_application_id =fnd_global.prog_appl_id,
1502: program_id = fnd_global.conc_program_id,
1503: program_update_date = sysdate
1504: where sold_to_org_id in (select m.duplicate_id
1505: from ra_customer_merges m
1506: where m.process_flag = 'Y'

Line 1630: last_updated_by = fnd_global.user_id,

1626: and m.request_id = req_id
1627: and m.process_flag = 'Y'
1628: and m.set_number = set_num),
1629: last_update_date = sysdate,
1630: last_updated_by = fnd_global.user_id,
1631: last_update_login = fnd_global.login_id,
1632: request_id = req_id,
1633: program_application_id =fnd_global.prog_appl_id,
1634: program_id = fnd_global.conc_program_id,

Line 1631: last_update_login = fnd_global.login_id,

1627: and m.process_flag = 'Y'
1628: and m.set_number = set_num),
1629: last_update_date = sysdate,
1630: last_updated_by = fnd_global.user_id,
1631: last_update_login = fnd_global.login_id,
1632: request_id = req_id,
1633: program_application_id =fnd_global.prog_appl_id,
1634: program_id = fnd_global.conc_program_id,
1635: program_update_date = sysdate

Line 1633: program_application_id =fnd_global.prog_appl_id,

1629: last_update_date = sysdate,
1630: last_updated_by = fnd_global.user_id,
1631: last_update_login = fnd_global.login_id,
1632: request_id = req_id,
1633: program_application_id =fnd_global.prog_appl_id,
1634: program_id = fnd_global.conc_program_id,
1635: program_update_date = sysdate
1636: where ship_to_org_id in (select m.duplicate_site_id
1637: from ra_customer_merges m

Line 1634: program_id = fnd_global.conc_program_id,

1630: last_updated_by = fnd_global.user_id,
1631: last_update_login = fnd_global.login_id,
1632: request_id = req_id,
1633: program_application_id =fnd_global.prog_appl_id,
1634: program_id = fnd_global.conc_program_id,
1635: program_update_date = sysdate
1636: where ship_to_org_id in (select m.duplicate_site_id
1637: from ra_customer_merges m
1638: where m.process_flag = 'Y'

Line 1656: last_updated_by = fnd_global.user_id,

1652: and m.request_id = req_id
1653: and m.process_flag = 'Y'
1654: and m.set_number = set_num),
1655: last_update_date = sysdate,
1656: last_updated_by = fnd_global.user_id,
1657: last_update_login = fnd_global.login_id,
1658: request_id = req_id,
1659: program_application_id =fnd_global.prog_appl_id,
1660: program_id = fnd_global.conc_program_id,

Line 1657: last_update_login = fnd_global.login_id,

1653: and m.process_flag = 'Y'
1654: and m.set_number = set_num),
1655: last_update_date = sysdate,
1656: last_updated_by = fnd_global.user_id,
1657: last_update_login = fnd_global.login_id,
1658: request_id = req_id,
1659: program_application_id =fnd_global.prog_appl_id,
1660: program_id = fnd_global.conc_program_id,
1661: program_update_date = sysdate

Line 1659: program_application_id =fnd_global.prog_appl_id,

1655: last_update_date = sysdate,
1656: last_updated_by = fnd_global.user_id,
1657: last_update_login = fnd_global.login_id,
1658: request_id = req_id,
1659: program_application_id =fnd_global.prog_appl_id,
1660: program_id = fnd_global.conc_program_id,
1661: program_update_date = sysdate
1662: where invoice_to_org_id in (select m.duplicate_site_id
1663: from ra_customer_merges m

Line 1660: program_id = fnd_global.conc_program_id,

1656: last_updated_by = fnd_global.user_id,
1657: last_update_login = fnd_global.login_id,
1658: request_id = req_id,
1659: program_application_id =fnd_global.prog_appl_id,
1660: program_id = fnd_global.conc_program_id,
1661: program_update_date = sysdate
1662: where invoice_to_org_id in (select m.duplicate_site_id
1663: from ra_customer_merges m
1664: where m.process_flag = 'Y'

Line 1682: last_updated_by = fnd_global.user_id,

1678: and m.request_id = req_id
1679: and m.process_flag = 'Y'
1680: and m.set_number = set_num),
1681: last_update_date = sysdate,
1682: last_updated_by = fnd_global.user_id,
1683: last_update_login = fnd_global.login_id,
1684: request_id = req_id,
1685: program_application_id =fnd_global.prog_appl_id,
1686: program_id = fnd_global.conc_program_id,

Line 1683: last_update_login = fnd_global.login_id,

1679: and m.process_flag = 'Y'
1680: and m.set_number = set_num),
1681: last_update_date = sysdate,
1682: last_updated_by = fnd_global.user_id,
1683: last_update_login = fnd_global.login_id,
1684: request_id = req_id,
1685: program_application_id =fnd_global.prog_appl_id,
1686: program_id = fnd_global.conc_program_id,
1687: program_update_date = sysdate

Line 1685: program_application_id =fnd_global.prog_appl_id,

1681: last_update_date = sysdate,
1682: last_updated_by = fnd_global.user_id,
1683: last_update_login = fnd_global.login_id,
1684: request_id = req_id,
1685: program_application_id =fnd_global.prog_appl_id,
1686: program_id = fnd_global.conc_program_id,
1687: program_update_date = sysdate
1688: where deliver_to_org_id in (select m.duplicate_site_id
1689: from ra_customer_merges m

Line 1686: program_id = fnd_global.conc_program_id,

1682: last_updated_by = fnd_global.user_id,
1683: last_update_login = fnd_global.login_id,
1684: request_id = req_id,
1685: program_application_id =fnd_global.prog_appl_id,
1686: program_id = fnd_global.conc_program_id,
1687: program_update_date = sysdate
1688: where deliver_to_org_id in (select m.duplicate_site_id
1689: from ra_customer_merges m
1690: where m.process_flag = 'Y'

Line 1712: last_updated_by = fnd_global.user_id,

1708: and m.process_flag = 'Y'
1709: and m.request_id = req_id
1710: and m.set_number = set_num),
1711: last_update_date = sysdate,
1712: last_updated_by = fnd_global.user_id,
1713: last_update_login = fnd_global.login_id,
1714: request_id = req_id,
1715: program_application_id =fnd_global.prog_appl_id,
1716: program_id = fnd_global.conc_program_id,

Line 1713: last_update_login = fnd_global.login_id,

1709: and m.request_id = req_id
1710: and m.set_number = set_num),
1711: last_update_date = sysdate,
1712: last_updated_by = fnd_global.user_id,
1713: last_update_login = fnd_global.login_id,
1714: request_id = req_id,
1715: program_application_id =fnd_global.prog_appl_id,
1716: program_id = fnd_global.conc_program_id,
1717: program_update_date = sysdate

Line 1715: program_application_id =fnd_global.prog_appl_id,

1711: last_update_date = sysdate,
1712: last_updated_by = fnd_global.user_id,
1713: last_update_login = fnd_global.login_id,
1714: request_id = req_id,
1715: program_application_id =fnd_global.prog_appl_id,
1716: program_id = fnd_global.conc_program_id,
1717: program_update_date = sysdate
1718: where sold_to_org_id in (select m.duplicate_id
1719: from ra_customer_merges m

Line 1716: program_id = fnd_global.conc_program_id,

1712: last_updated_by = fnd_global.user_id,
1713: last_update_login = fnd_global.login_id,
1714: request_id = req_id,
1715: program_application_id =fnd_global.prog_appl_id,
1716: program_id = fnd_global.conc_program_id,
1717: program_update_date = sysdate
1718: where sold_to_org_id in (select m.duplicate_id
1719: from ra_customer_merges m
1720: where m.process_flag = 'Y'

Line 1865: last_updated_by = fnd_global.user_id,

1861: and m.request_id = req_id
1862: and m.process_flag = 'Y'
1863: and m.set_number = set_num),
1864: last_update_date = sysdate,
1865: last_updated_by = fnd_global.user_id,
1866: last_update_login = fnd_global.login_id,
1867: request_id = req_id,
1868: program_application_id =fnd_global.prog_appl_id,
1869: program_id = fnd_global.conc_program_id,

Line 1866: last_update_login = fnd_global.login_id,

1862: and m.process_flag = 'Y'
1863: and m.set_number = set_num),
1864: last_update_date = sysdate,
1865: last_updated_by = fnd_global.user_id,
1866: last_update_login = fnd_global.login_id,
1867: request_id = req_id,
1868: program_application_id =fnd_global.prog_appl_id,
1869: program_id = fnd_global.conc_program_id,
1870: program_update_date = sysdate

Line 1868: program_application_id =fnd_global.prog_appl_id,

1864: last_update_date = sysdate,
1865: last_updated_by = fnd_global.user_id,
1866: last_update_login = fnd_global.login_id,
1867: request_id = req_id,
1868: program_application_id =fnd_global.prog_appl_id,
1869: program_id = fnd_global.conc_program_id,
1870: program_update_date = sysdate
1871: where ship_to_org_id in (select m.duplicate_site_id
1872: from ra_customer_merges m

Line 1869: program_id = fnd_global.conc_program_id,

1865: last_updated_by = fnd_global.user_id,
1866: last_update_login = fnd_global.login_id,
1867: request_id = req_id,
1868: program_application_id =fnd_global.prog_appl_id,
1869: program_id = fnd_global.conc_program_id,
1870: program_update_date = sysdate
1871: where ship_to_org_id in (select m.duplicate_site_id
1872: from ra_customer_merges m
1873: where m.process_flag = 'Y'

Line 1897: last_updated_by = fnd_global.user_id,

1893: and m.request_id = req_id
1894: and m.process_flag = 'Y'
1895: and m.set_number = set_num),
1896: last_update_date = sysdate,
1897: last_updated_by = fnd_global.user_id,
1898: last_update_login = fnd_global.login_id,
1899: request_id = req_id,
1900: program_application_id =fnd_global.prog_appl_id,
1901: program_id = fnd_global.conc_program_id,

Line 1898: last_update_login = fnd_global.login_id,

1894: and m.process_flag = 'Y'
1895: and m.set_number = set_num),
1896: last_update_date = sysdate,
1897: last_updated_by = fnd_global.user_id,
1898: last_update_login = fnd_global.login_id,
1899: request_id = req_id,
1900: program_application_id =fnd_global.prog_appl_id,
1901: program_id = fnd_global.conc_program_id,
1902: program_update_date = sysdate

Line 1900: program_application_id =fnd_global.prog_appl_id,

1896: last_update_date = sysdate,
1897: last_updated_by = fnd_global.user_id,
1898: last_update_login = fnd_global.login_id,
1899: request_id = req_id,
1900: program_application_id =fnd_global.prog_appl_id,
1901: program_id = fnd_global.conc_program_id,
1902: program_update_date = sysdate
1903: where invoice_to_org_id in (select m.duplicate_site_id
1904: from ra_customer_merges m

Line 1901: program_id = fnd_global.conc_program_id,

1897: last_updated_by = fnd_global.user_id,
1898: last_update_login = fnd_global.login_id,
1899: request_id = req_id,
1900: program_application_id =fnd_global.prog_appl_id,
1901: program_id = fnd_global.conc_program_id,
1902: program_update_date = sysdate
1903: where invoice_to_org_id in (select m.duplicate_site_id
1904: from ra_customer_merges m
1905: where m.process_flag = 'Y'

Line 1929: last_updated_by = fnd_global.user_id,

1925: and m.request_id = req_id
1926: and m.process_flag = 'Y'
1927: and m.set_number = set_num),
1928: last_update_date = sysdate,
1929: last_updated_by = fnd_global.user_id,
1930: last_update_login = fnd_global.login_id,
1931: request_id = req_id,
1932: program_application_id =fnd_global.prog_appl_id,
1933: program_id = fnd_global.conc_program_id,

Line 1930: last_update_login = fnd_global.login_id,

1926: and m.process_flag = 'Y'
1927: and m.set_number = set_num),
1928: last_update_date = sysdate,
1929: last_updated_by = fnd_global.user_id,
1930: last_update_login = fnd_global.login_id,
1931: request_id = req_id,
1932: program_application_id =fnd_global.prog_appl_id,
1933: program_id = fnd_global.conc_program_id,
1934: program_update_date = sysdate

Line 1932: program_application_id =fnd_global.prog_appl_id,

1928: last_update_date = sysdate,
1929: last_updated_by = fnd_global.user_id,
1930: last_update_login = fnd_global.login_id,
1931: request_id = req_id,
1932: program_application_id =fnd_global.prog_appl_id,
1933: program_id = fnd_global.conc_program_id,
1934: program_update_date = sysdate
1935: where deliver_to_org_id in (select m.duplicate_site_id
1936: from ra_customer_merges m

Line 1933: program_id = fnd_global.conc_program_id,

1929: last_updated_by = fnd_global.user_id,
1930: last_update_login = fnd_global.login_id,
1931: request_id = req_id,
1932: program_application_id =fnd_global.prog_appl_id,
1933: program_id = fnd_global.conc_program_id,
1934: program_update_date = sysdate
1935: where deliver_to_org_id in (select m.duplicate_site_id
1936: from ra_customer_merges m
1937: where m.process_flag = 'Y'

Line 1961: last_updated_by = fnd_global.user_id,

1957: and m.request_id = req_id
1958: and m.process_flag = 'Y'
1959: and m.set_number = set_num),
1960: last_update_date = sysdate,
1961: last_updated_by = fnd_global.user_id,
1962: last_update_login = fnd_global.login_id,
1963: request_id = req_id,
1964: program_application_id =fnd_global.prog_appl_id,
1965: program_id = fnd_global.conc_program_id,

Line 1962: last_update_login = fnd_global.login_id,

1958: and m.process_flag = 'Y'
1959: and m.set_number = set_num),
1960: last_update_date = sysdate,
1961: last_updated_by = fnd_global.user_id,
1962: last_update_login = fnd_global.login_id,
1963: request_id = req_id,
1964: program_application_id =fnd_global.prog_appl_id,
1965: program_id = fnd_global.conc_program_id,
1966: program_update_date = sysdate

Line 1964: program_application_id =fnd_global.prog_appl_id,

1960: last_update_date = sysdate,
1961: last_updated_by = fnd_global.user_id,
1962: last_update_login = fnd_global.login_id,
1963: request_id = req_id,
1964: program_application_id =fnd_global.prog_appl_id,
1965: program_id = fnd_global.conc_program_id,
1966: program_update_date = sysdate
1967: where intmed_ship_to_org_id in (select m.duplicate_site_id
1968: from ra_customer_merges m

Line 1965: program_id = fnd_global.conc_program_id,

1961: last_updated_by = fnd_global.user_id,
1962: last_update_login = fnd_global.login_id,
1963: request_id = req_id,
1964: program_application_id =fnd_global.prog_appl_id,
1965: program_id = fnd_global.conc_program_id,
1966: program_update_date = sysdate
1967: where intmed_ship_to_org_id in (select m.duplicate_site_id
1968: from ra_customer_merges m
1969: where m.process_flag = 'Y'

Line 2001: last_updated_by = fnd_global.user_id,

1997: and m.process_flag = 'Y'
1998: and m.request_id = req_id
1999: and m.set_number = set_num),
2000: last_update_date = sysdate,
2001: last_updated_by = fnd_global.user_id,
2002: last_update_login = fnd_global.login_id,
2003: request_id = req_id,
2004: program_application_id =fnd_global.prog_appl_id,
2005: program_id = fnd_global.conc_program_id,

Line 2002: last_update_login = fnd_global.login_id,

1998: and m.request_id = req_id
1999: and m.set_number = set_num),
2000: last_update_date = sysdate,
2001: last_updated_by = fnd_global.user_id,
2002: last_update_login = fnd_global.login_id,
2003: request_id = req_id,
2004: program_application_id =fnd_global.prog_appl_id,
2005: program_id = fnd_global.conc_program_id,
2006: program_update_date = sysdate

Line 2004: program_application_id =fnd_global.prog_appl_id,

2000: last_update_date = sysdate,
2001: last_updated_by = fnd_global.user_id,
2002: last_update_login = fnd_global.login_id,
2003: request_id = req_id,
2004: program_application_id =fnd_global.prog_appl_id,
2005: program_id = fnd_global.conc_program_id,
2006: program_update_date = sysdate
2007: where sold_to_org_id in (select m.duplicate_id
2008: from ra_customer_merges m

Line 2005: program_id = fnd_global.conc_program_id,

2001: last_updated_by = fnd_global.user_id,
2002: last_update_login = fnd_global.login_id,
2003: request_id = req_id,
2004: program_application_id =fnd_global.prog_appl_id,
2005: program_id = fnd_global.conc_program_id,
2006: program_update_date = sysdate
2007: where sold_to_org_id in (select m.duplicate_id
2008: from ra_customer_merges m
2009: where m.process_flag = 'Y'

Line 2191: last_updated_by = fnd_global.user_id,

2187: and m.request_id = req_id
2188: and m.process_flag = 'Y'
2189: and m.set_number = set_num),
2190: last_update_date = sysdate,
2191: last_updated_by = fnd_global.user_id,
2192: last_update_login = fnd_global.login_id
2193: where attribute_value in (select to_char(m.duplicate_site_id)
2194: from ra_customer_merges m
2195: where m.process_flag = 'Y'

Line 2192: last_update_login = fnd_global.login_id

2188: and m.process_flag = 'Y'
2189: and m.set_number = set_num),
2190: last_update_date = sysdate,
2191: last_updated_by = fnd_global.user_id,
2192: last_update_login = fnd_global.login_id
2193: where attribute_value in (select to_char(m.duplicate_site_id)
2194: from ra_customer_merges m
2195: where m.process_flag = 'Y'
2196: and m.request_id = req_id

Line 2227: last_updated_by = fnd_global.user_id,

2223: and m.request_id = req_id
2224: and m.process_flag = 'Y'
2225: and m.set_number = set_num),
2226: last_update_date = sysdate,
2227: last_updated_by = fnd_global.user_id,
2228: last_update_login = fnd_global.login_id
2229: where attribute_value in (select to_char(m.duplicate_site_id)
2230: from ra_customer_merges m
2231: where m.process_flag = 'Y'

Line 2228: last_update_login = fnd_global.login_id

2224: and m.process_flag = 'Y'
2225: and m.set_number = set_num),
2226: last_update_date = sysdate,
2227: last_updated_by = fnd_global.user_id,
2228: last_update_login = fnd_global.login_id
2229: where attribute_value in (select to_char(m.duplicate_site_id)
2230: from ra_customer_merges m
2231: where m.process_flag = 'Y'
2232: and m.request_id = req_id

Line 2264: last_updated_by = fnd_global.user_id,

2260: and m.request_id = req_id
2261: and m.process_flag = 'Y'
2262: and m.set_number = set_num),
2263: last_update_date = sysdate,
2264: last_updated_by = fnd_global.user_id,
2265: last_update_login = fnd_global.login_id
2266: where attribute_value in (select to_char(m.duplicate_id)
2267: from ra_customer_merges m
2268: where m.process_flag = 'Y'

Line 2265: last_update_login = fnd_global.login_id

2261: and m.process_flag = 'Y'
2262: and m.set_number = set_num),
2263: last_update_date = sysdate,
2264: last_updated_by = fnd_global.user_id,
2265: last_update_login = fnd_global.login_id
2266: where attribute_value in (select to_char(m.duplicate_id)
2267: from ra_customer_merges m
2268: where m.process_flag = 'Y'
2269: and m.request_id = req_id

Line 2467: last_updated_by = fnd_global.user_id,

2463: and m.request_id = req_id
2464: and m.process_flag = 'Y'
2465: and m.set_number = set_num),
2466: last_update_date = sysdate,
2467: last_updated_by = fnd_global.user_id,
2468: last_update_login = fnd_global.login_id
2469: where value_string in (select to_char(m.duplicate_site_id)
2470: from ra_customer_merges m
2471: where m.process_flag = 'Y'

Line 2468: last_update_login = fnd_global.login_id

2464: and m.process_flag = 'Y'
2465: and m.set_number = set_num),
2466: last_update_date = sysdate,
2467: last_updated_by = fnd_global.user_id,
2468: last_update_login = fnd_global.login_id
2469: where value_string in (select to_char(m.duplicate_site_id)
2470: from ra_customer_merges m
2471: where m.process_flag = 'Y'
2472: and m.request_id = req_id

Line 2503: last_updated_by = fnd_global.user_id,

2499: and m.request_id = req_id
2500: and m.process_flag = 'Y'
2501: and m.set_number = set_num),
2502: last_update_date = sysdate,
2503: last_updated_by = fnd_global.user_id,
2504: last_update_login = fnd_global.login_id
2505: where value_string in (select to_char(m.duplicate_site_id)
2506: from ra_customer_merges m
2507: where m.process_flag = 'Y'

Line 2504: last_update_login = fnd_global.login_id

2500: and m.process_flag = 'Y'
2501: and m.set_number = set_num),
2502: last_update_date = sysdate,
2503: last_updated_by = fnd_global.user_id,
2504: last_update_login = fnd_global.login_id
2505: where value_string in (select to_char(m.duplicate_site_id)
2506: from ra_customer_merges m
2507: where m.process_flag = 'Y'
2508: and m.request_id = req_id

Line 2539: last_updated_by = fnd_global.user_id,

2535: and m.request_id = req_id
2536: and m.process_flag = 'Y'
2537: and m.set_number = set_num),
2538: last_update_date = sysdate,
2539: last_updated_by = fnd_global.user_id,
2540: last_update_login = fnd_global.login_id
2541: where value_string in (select to_char(m.duplicate_site_id)
2542: from ra_customer_merges m
2543: where m.process_flag = 'Y'

Line 2540: last_update_login = fnd_global.login_id

2536: and m.process_flag = 'Y'
2537: and m.set_number = set_num),
2538: last_update_date = sysdate,
2539: last_updated_by = fnd_global.user_id,
2540: last_update_login = fnd_global.login_id
2541: where value_string in (select to_char(m.duplicate_site_id)
2542: from ra_customer_merges m
2543: where m.process_flag = 'Y'
2544: and m.request_id = req_id

Line 2576: last_updated_by = fnd_global.user_id,

2572: and m.request_id = req_id
2573: and m.process_flag = 'Y'
2574: and m.set_number = set_num),
2575: last_update_date = sysdate,
2576: last_updated_by = fnd_global.user_id,
2577: last_update_login = fnd_global.login_id
2578: where value_string in (select to_char(m.duplicate_id)
2579: from ra_customer_merges m
2580: where m.process_flag = 'Y'

Line 2577: last_update_login = fnd_global.login_id

2573: and m.process_flag = 'Y'
2574: and m.set_number = set_num),
2575: last_update_date = sysdate,
2576: last_updated_by = fnd_global.user_id,
2577: last_update_login = fnd_global.login_id
2578: where value_string in (select to_char(m.duplicate_id)
2579: from ra_customer_merges m
2580: where m.process_flag = 'Y'
2581: and m.request_id = req_id

Line 2615: last_updated_by = fnd_global.user_id,

2611: and m.request_id = req_id
2612: and m.process_flag = 'Y'
2613: and m.set_number = set_num),
2614: last_update_date = sysdate,
2615: last_updated_by = fnd_global.user_id,
2616: last_update_login = fnd_global.login_id
2617: where src_constant_value in (select to_char(m.duplicate_site_id)
2618: from ra_customer_merges m
2619: where m.process_flag = 'Y'

Line 2616: last_update_login = fnd_global.login_id

2612: and m.process_flag = 'Y'
2613: and m.set_number = set_num),
2614: last_update_date = sysdate,
2615: last_updated_by = fnd_global.user_id,
2616: last_update_login = fnd_global.login_id
2617: where src_constant_value in (select to_char(m.duplicate_site_id)
2618: from ra_customer_merges m
2619: where m.process_flag = 'Y'
2620: and m.request_id = req_id

Line 2652: last_updated_by = fnd_global.user_id,

2648: and m.request_id = req_id
2649: and m.process_flag = 'Y'
2650: and m.set_number = set_num),
2651: last_update_date = sysdate,
2652: last_updated_by = fnd_global.user_id,
2653: last_update_login = fnd_global.login_id
2654: where src_constant_value in (select to_char(m.duplicate_site_id)
2655: from ra_customer_merges m
2656: where m.process_flag = 'Y'

Line 2653: last_update_login = fnd_global.login_id

2649: and m.process_flag = 'Y'
2650: and m.set_number = set_num),
2651: last_update_date = sysdate,
2652: last_updated_by = fnd_global.user_id,
2653: last_update_login = fnd_global.login_id
2654: where src_constant_value in (select to_char(m.duplicate_site_id)
2655: from ra_customer_merges m
2656: where m.process_flag = 'Y'
2657: and m.request_id = req_id

Line 2689: last_updated_by = fnd_global.user_id,

2685: and m.request_id = req_id
2686: and m.process_flag = 'Y'
2687: and m.set_number = set_num),
2688: last_update_date = sysdate,
2689: last_updated_by = fnd_global.user_id,
2690: last_update_login = fnd_global.login_id
2691: where src_constant_value in (select to_char(m.duplicate_site_id)
2692: from ra_customer_merges m
2693: where m.process_flag = 'Y'

Line 2690: last_update_login = fnd_global.login_id

2686: and m.process_flag = 'Y'
2687: and m.set_number = set_num),
2688: last_update_date = sysdate,
2689: last_updated_by = fnd_global.user_id,
2690: last_update_login = fnd_global.login_id
2691: where src_constant_value in (select to_char(m.duplicate_site_id)
2692: from ra_customer_merges m
2693: where m.process_flag = 'Y'
2694: and m.request_id = req_id

Line 2726: last_updated_by = fnd_global.user_id,

2722: and m.request_id = req_id
2723: and m.process_flag = 'Y'
2724: and m.set_number = set_num),
2725: last_update_date = sysdate,
2726: last_updated_by = fnd_global.user_id,
2727: last_update_login = fnd_global.login_id
2728: where src_constant_value in (select to_char(m.duplicate_id)
2729: from ra_customer_merges m
2730: where m.process_flag = 'Y'

Line 2727: last_update_login = fnd_global.login_id

2723: and m.process_flag = 'Y'
2724: and m.set_number = set_num),
2725: last_update_date = sysdate,
2726: last_updated_by = fnd_global.user_id,
2727: last_update_login = fnd_global.login_id
2728: where src_constant_value in (select to_char(m.duplicate_id)
2729: from ra_customer_merges m
2730: where m.process_flag = 'Y'
2731: and m.request_id = req_id

Line 2876: last_updated_by = fnd_global.user_id,

2872: and m.request_id = req_id
2873: and m.process_flag = 'Y'
2874: and m.set_number = set_num),
2875: last_update_date = sysdate,
2876: last_updated_by = fnd_global.user_id,
2877: last_update_login = fnd_global.login_id
2878: where value_string in (select to_char(m.duplicate_site_id)
2879: from ra_customer_merges m
2880: where m.process_flag = 'Y'

Line 2877: last_update_login = fnd_global.login_id

2873: and m.process_flag = 'Y'
2874: and m.set_number = set_num),
2875: last_update_date = sysdate,
2876: last_updated_by = fnd_global.user_id,
2877: last_update_login = fnd_global.login_id
2878: where value_string in (select to_char(m.duplicate_site_id)
2879: from ra_customer_merges m
2880: where m.process_flag = 'Y'
2881: and m.request_id = req_id

Line 2913: last_updated_by = fnd_global.user_id,

2909: and m.request_id = req_id
2910: and m.process_flag = 'Y'
2911: and m.set_number = set_num),
2912: last_update_date = sysdate,
2913: last_updated_by = fnd_global.user_id,
2914: last_update_login = fnd_global.login_id
2915: where value_string in (select to_char(m.duplicate_site_id)
2916: from ra_customer_merges m
2917: where m.process_flag = 'Y'

Line 2914: last_update_login = fnd_global.login_id

2910: and m.process_flag = 'Y'
2911: and m.set_number = set_num),
2912: last_update_date = sysdate,
2913: last_updated_by = fnd_global.user_id,
2914: last_update_login = fnd_global.login_id
2915: where value_string in (select to_char(m.duplicate_site_id)
2916: from ra_customer_merges m
2917: where m.process_flag = 'Y'
2918: and m.request_id = req_id

Line 2950: last_updated_by = fnd_global.user_id,

2946: and m.request_id = req_id
2947: and m.process_flag = 'Y'
2948: and m.set_number = set_num),
2949: last_update_date = sysdate,
2950: last_updated_by = fnd_global.user_id,
2951: last_update_login = fnd_global.login_id
2952: where value_string in (select to_char(m.duplicate_site_id)
2953: from ra_customer_merges m
2954: where m.process_flag = 'Y'

Line 2951: last_update_login = fnd_global.login_id

2947: and m.process_flag = 'Y'
2948: and m.set_number = set_num),
2949: last_update_date = sysdate,
2950: last_updated_by = fnd_global.user_id,
2951: last_update_login = fnd_global.login_id
2952: where value_string in (select to_char(m.duplicate_site_id)
2953: from ra_customer_merges m
2954: where m.process_flag = 'Y'
2955: and m.request_id = req_id

Line 2988: last_updated_by = fnd_global.user_id,

2984: and m.request_id = req_id
2985: and m.process_flag = 'Y'
2986: and m.set_number = set_num),
2987: last_update_date = sysdate,
2988: last_updated_by = fnd_global.user_id,
2989: last_update_login = fnd_global.login_id
2990: where value_string in (select to_char(m.duplicate_id)
2991: from ra_customer_merges m
2992: where m.process_flag = 'Y'

Line 2989: last_update_login = fnd_global.login_id

2985: and m.process_flag = 'Y'
2986: and m.set_number = set_num),
2987: last_update_date = sysdate,
2988: last_updated_by = fnd_global.user_id,
2989: last_update_login = fnd_global.login_id
2990: where value_string in (select to_char(m.duplicate_id)
2991: from ra_customer_merges m
2992: where m.process_flag = 'Y'
2993: and m.request_id = req_id

Line 3123: last_updated_by = fnd_global.user_id,

3119: and m.process_flag = 'Y'
3120: and m.set_number = set_num),
3121: last_update_date = sysdate,
3122:
3123: last_updated_by = fnd_global.user_id,
3124: last_update_login = fnd_global.login_id
3125: where hold_entity_id in (select m.duplicate_site_id
3126: from ra_customer_merges m
3127: where m.process_flag = 'Y'

Line 3124: last_update_login = fnd_global.login_id

3120: and m.set_number = set_num),
3121: last_update_date = sysdate,
3122:
3123: last_updated_by = fnd_global.user_id,
3124: last_update_login = fnd_global.login_id
3125: where hold_entity_id in (select m.duplicate_site_id
3126: from ra_customer_merges m
3127: where m.process_flag = 'Y'
3128: and m.request_id = req_id

Line 3161: last_updated_by = fnd_global.user_id,

3157: and m.request_id = req_id
3158: and m.process_flag = 'Y'
3159: and m.set_number = set_num),
3160: last_update_date = sysdate,
3161: last_updated_by = fnd_global.user_id,
3162: last_update_login = fnd_global.login_id
3163: where hold_entity_id in (select m.duplicate_site_id
3164: from ra_customer_merges m
3165: where m.process_flag = 'Y'

Line 3162: last_update_login = fnd_global.login_id

3158: and m.process_flag = 'Y'
3159: and m.set_number = set_num),
3160: last_update_date = sysdate,
3161: last_updated_by = fnd_global.user_id,
3162: last_update_login = fnd_global.login_id
3163: where hold_entity_id in (select m.duplicate_site_id
3164: from ra_customer_merges m
3165: where m.process_flag = 'Y'
3166: and m.request_id = req_id

Line 3199: last_updated_by = fnd_global.user_id,

3195: and m.process_flag = 'Y'
3196: and m.request_id = req_id
3197: and m.set_number = set_num),
3198: last_update_date = sysdate,
3199: last_updated_by = fnd_global.user_id,
3200: last_update_login = fnd_global.login_id
3201: where hold_entity_id in (select m.duplicate_id
3202: from ra_customer_merges m
3203: where m.process_flag = 'Y'

Line 3200: last_update_login = fnd_global.login_id

3196: and m.request_id = req_id
3197: and m.set_number = set_num),
3198: last_update_date = sysdate,
3199: last_updated_by = fnd_global.user_id,
3200: last_update_login = fnd_global.login_id
3201: where hold_entity_id in (select m.duplicate_id
3202: from ra_customer_merges m
3203: where m.process_flag = 'Y'
3204: and m.request_id = req_id

Line 3295: last_updated_by = fnd_global.user_id,

3291: and m.request_id = req_id
3292: and m.process_flag = 'Y'
3293: and m.set_number = set_num),
3294: last_update_date = sysdate,
3295: last_updated_by = fnd_global.user_id,
3296: last_update_login = fnd_global.login_id
3297: where line_location_id in (select m.duplicate_site_id
3298: from ra_customer_merges m
3299: where m.process_flag = 'Y'

Line 3296: last_update_login = fnd_global.login_id

3292: and m.process_flag = 'Y'
3293: and m.set_number = set_num),
3294: last_update_date = sysdate,
3295: last_updated_by = fnd_global.user_id,
3296: last_update_login = fnd_global.login_id
3297: where line_location_id in (select m.duplicate_site_id
3298: from ra_customer_merges m
3299: where m.process_flag = 'Y'
3300: and m.request_id = req_id

Line 3404: last_updated_by = fnd_global.user_id,

3400: and m.request_id = req_id
3401: and m.process_flag = 'Y'
3402: and m.set_number = set_num),
3403: last_update_date = sysdate,
3404: last_updated_by = fnd_global.user_id,
3405: last_update_login = fnd_global.login_id
3406: where site_use_id in (select m.duplicate_site_id
3407: from ra_customer_merges m
3408: where m.process_flag = 'Y'

Line 3405: last_update_login = fnd_global.login_id

3401: and m.process_flag = 'Y'
3402: and m.set_number = set_num),
3403: last_update_date = sysdate,
3404: last_updated_by = fnd_global.user_id,
3405: last_update_login = fnd_global.login_id
3406: where site_use_id in (select m.duplicate_site_id
3407: from ra_customer_merges m
3408: where m.process_flag = 'Y'
3409: and m.request_id = req_id

Line 3436: last_updated_by = fnd_global.user_id,

3432: and m.request_id = req_id
3433: and m.process_flag = 'Y'
3434: and m.set_number = set_num),
3435: last_update_date = sysdate,
3436: last_updated_by = fnd_global.user_id,
3437: last_update_login = fnd_global.login_id
3438: where customer_id in (select m.duplicate_id
3439: from ra_customer_merges m
3440: where m.process_flag = 'Y'

Line 3437: last_update_login = fnd_global.login_id

3433: and m.process_flag = 'Y'
3434: and m.set_number = set_num),
3435: last_update_date = sysdate,
3436: last_updated_by = fnd_global.user_id,
3437: last_update_login = fnd_global.login_id
3438: where customer_id in (select m.duplicate_id
3439: from ra_customer_merges m
3440: where m.process_flag = 'Y'
3441: and m.request_id = req_id

Line 3531: updated_by = fnd_global.user_id,

3527: and m.request_id = req_id
3528: and m.process_flag = 'Y'
3529: and m.set_number = set_num),
3530: update_date = sysdate,
3531: updated_by = fnd_global.user_id,
3532: update_login = fnd_global.login_id
3533: where ship_to_org_id in (select m.duplicate_site_id
3534: from ra_customer_merges m
3535: where m.process_flag = 'Y'

Line 3532: update_login = fnd_global.login_id

3528: and m.process_flag = 'Y'
3529: and m.set_number = set_num),
3530: update_date = sysdate,
3531: updated_by = fnd_global.user_id,
3532: update_login = fnd_global.login_id
3533: where ship_to_org_id in (select m.duplicate_site_id
3534: from ra_customer_merges m
3535: where m.process_flag = 'Y'
3536: and m.request_id = req_id