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 RA_CUSTOMER_MERGES

Line 23: from ra_customer_merges m

19: select HEADER_ID
20: from oe_order_headers_all
21: where ship_to_org_id in
22: (select m.duplicate_site_id
23: from ra_customer_merges m
24: where m.process_flag = 'Y'
25: and m.request_id = req_id
26: and m.set_number = set_num)
27: for update nowait;

Line 35: from ra_customer_merges m

31: select HEADER_ID
32: from oe_order_headers_all
33: where invoice_to_org_id in
34: (select m.duplicate_site_id
35: from ra_customer_merges m
36: where m.process_flag = 'Y'
37: and m.request_id = req_id
38: and m.set_number = set_num)
39: for update nowait;

Line 47: from ra_customer_merges m

43: select HEADER_ID
44: from oe_order_headers_all
45: where deliver_to_org_id in
46: (select m.duplicate_site_id
47: from ra_customer_merges m
48: where m.process_flag = 'Y'
49: and m.request_id = req_id
50: and m.set_number = set_num)
51: for update nowait;

Line 58: from ra_customer_merges m

54: select HEADER_ID
55: from oe_order_headers_all
56: where sold_to_org_id in
57: (select m.duplicate_id
58: from ra_customer_merges m
59: where m.process_flag = 'Y'
60: and m.request_id = req_id
61: and m.set_number = set_num)
62: for update nowait;

Line 113: from ra_customer_merges m

109: END IF;
110:
111: UPDATE oe_order_headers_all a
112: set ship_to_org_id = (select distinct m.customer_site_id
113: from ra_customer_merges m
114: where a.ship_to_org_id = m.duplicate_site_id
115: and m.request_id = req_id
116: and m.process_flag = 'Y'
117: and m.set_number = set_num),

Line 126: from ra_customer_merges m

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'
128: and m.request_id = req_id
129: and m.set_number = set_num);
130: g_count := sql%rowcount;

Line 146: from ra_customer_merges m

142: END IF;
143:
144: UPDATE oe_order_headers_all a
145: set invoice_to_org_id = (select distinct m.customer_site_id
146: from ra_customer_merges m
147: where a.invoice_to_org_id = m.duplicate_site_id
148: and m.request_id = req_id
149: and m.process_flag = 'Y'
150: and m.set_number = set_num),

Line 159: from ra_customer_merges m

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'
161: and m.request_id = req_id
162: and m.set_number = set_num);
163: g_count := sql%rowcount;

Line 179: from ra_customer_merges m

175: END IF;
176:
177: UPDATE oe_order_headers_all a
178: set deliver_to_org_id = (select distinct m.customer_site_id
179: from ra_customer_merges m
180: where a.deliver_to_org_id = m.duplicate_site_id
181: and m.request_id = req_id
182: and m.process_flag = 'Y'
183: and m.set_number = set_num),

Line 192: from ra_customer_merges m

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'
194: and m.request_id = req_id
195: and m.set_number = set_num);
196: g_count := sql%rowcount;

Line 218: from ra_customer_merges m

214: END IF;
215:
216: UPDATE oe_order_headers_all a
217: set sold_to_org_id = (select distinct m.customer_id
218: from ra_customer_merges m
219: where a.sold_to_org_id = m.duplicate_id
220: and m.process_flag = 'Y'
221: and m.request_id = req_id
222: and m.set_number = set_num),

Line 231: from ra_customer_merges m

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'
233: and m.request_id = req_id
234: and m.set_number = set_num);
235:

Line 280: from ra_customer_merges m

276: select HEADER_ID
277: from oe_order_header_history
278: where ship_to_org_id in
279: (select m.duplicate_site_id
280: from ra_customer_merges m
281: where m.process_flag = 'Y'
282: and m.request_id = req_id
283: and m.set_number = set_num)
284: for update nowait;

Line 292: from ra_customer_merges m

288: select HEADER_ID
289: from oe_order_header_history
290: where invoice_to_org_id in
291: (select m.duplicate_site_id
292: from ra_customer_merges m
293: where m.process_flag = 'Y'
294: and m.request_id = req_id
295: and m.set_number = set_num)
296: for update nowait;

Line 304: from ra_customer_merges m

300: select HEADER_ID
301: from oe_order_header_history
302: where deliver_to_org_id in
303: (select m.duplicate_site_id
304: from ra_customer_merges m
305: where m.process_flag = 'Y'
306: and m.request_id = req_id
307: and m.set_number = set_num)
308: for update nowait;

Line 315: from ra_customer_merges m

311: select HEADER_ID
312: from oe_order_header_history
313: where sold_to_org_id in
314: (select m.duplicate_id
315: from ra_customer_merges m
316: where m.process_flag = 'Y'
317: and m.request_id = req_id
318: and m.set_number = set_num)
319: for update nowait;

Line 355: from ra_customer_merges m

351: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
352:
353: UPDATE oe_order_header_history a
354: set ship_to_org_id = (select distinct m.customer_site_id
355: from ra_customer_merges m
356: where a.ship_to_org_id = m.duplicate_site_id
357: and m.request_id = req_id
358: and m.process_flag = 'Y'
359: and m.set_number = set_num),

Line 368: from ra_customer_merges m

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'
370: and m.request_id = req_id
371: and m.set_number = set_num);
372: g_count := sql%rowcount;

Line 381: from ra_customer_merges m

377: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
378:
379: UPDATE oe_order_header_history a
380: set invoice_to_org_id = (select distinct m.customer_site_id
381: from ra_customer_merges m
382: where a.invoice_to_org_id = m.duplicate_site_id
383: and m.request_id = req_id
384: and m.process_flag = 'Y'
385: and m.set_number = set_num),

Line 394: from ra_customer_merges m

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'
396: and m.request_id = req_id
397: and m.set_number = set_num);
398: g_count := sql%rowcount;

Line 407: from ra_customer_merges m

403: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
404:
405: UPDATE oe_order_header_history a
406: set deliver_to_org_id = (select distinct m.customer_site_id
407: from ra_customer_merges m
408: where a.deliver_to_org_id = m.duplicate_site_id
409: and m.request_id = req_id
410: and m.process_flag = 'Y'
411: and m.set_number = set_num),

Line 420: from ra_customer_merges m

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'
422: and m.request_id = req_id
423: and m.set_number = set_num);
424: g_count := sql%rowcount;

Line 439: from ra_customer_merges m

435: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
436:
437: UPDATE oe_order_header_history a
438: set sold_to_org_id = (select distinct m.customer_id
439: from ra_customer_merges m
440: where a.sold_to_org_id = m.duplicate_id
441: and m.process_flag = 'Y'
442: and m.request_id = req_id
443: and m.set_number = set_num),

Line 452: from ra_customer_merges m

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'
454: and m.request_id = req_id
455: and m.set_number = set_num);
456:

Line 490: from ra_customer_merges m

486: select HEADER_ID
487: from oe_headers_iface_all
488: where ship_to_org_id in
489: (select m.duplicate_site_id
490: from ra_customer_merges m
491: where m.process_flag = 'Y'
492: and m.request_id = req_id
493: and m.set_number = set_num)
494: for update nowait;

Line 502: from ra_customer_merges m

498: select HEADER_ID
499: from oe_headers_iface_all
500: where invoice_to_org_id in
501: (select m.duplicate_site_id
502: from ra_customer_merges m
503: where m.process_flag = 'Y'
504: and m.request_id = req_id
505: and m.set_number = set_num)
506: for update nowait;

Line 514: from ra_customer_merges m

510: select HEADER_ID
511: from oe_headers_iface_all
512: where deliver_to_org_id in
513: (select m.duplicate_site_id
514: from ra_customer_merges m
515: where m.process_flag = 'Y'
516: and m.request_id = req_id
517: and m.set_number = set_num)
518: for update nowait;

Line 525: from ra_customer_merges m

521: select HEADER_ID
522: from oe_headers_iface_all
523: where sold_to_org_id in
524: (select m.duplicate_id
525: from ra_customer_merges m
526: where m.process_flag = 'Y'
527: and m.request_id = req_id
528: and m.set_number = set_num)
529: for update nowait;

Line 565: from ra_customer_merges m

561: -- arp_message.set_token( 'TABLE_NAME', 'oe_headers_iface_all', FALSE );
562:
563: UPDATE oe_headers_iface_all a
564: set ship_to_org_id = (select distinct m.customer_site_id
565: from ra_customer_merges m
566: where a.ship_to_org_id = m.duplicate_site_id
567: and m.request_id = req_id
568: and m.process_flag = 'Y'
569: and m.set_number = set_num),

Line 578: from ra_customer_merges m

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'
580: and m.request_id = req_id
581: and m.set_number = set_num);
582: g_count := sql%rowcount;

Line 591: from ra_customer_merges m

587: -- arp_message.set_token( 'TABLE_NAME', 'oe_headers_iface_all', FALSE );
588:
589: UPDATE oe_headers_iface_all a
590: set invoice_to_org_id = (select distinct m.customer_site_id
591: from ra_customer_merges m
592: where a.invoice_to_org_id = m.duplicate_site_id
593: and m.request_id = req_id
594: and m.process_flag = 'Y'
595: and m.set_number = set_num),

Line 604: from ra_customer_merges m

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'
606: and m.request_id = req_id
607: and m.set_number = set_num);
608: g_count := sql%rowcount;

Line 617: from ra_customer_merges m

613: -- arp_message.set_token( 'TABLE_NAME', 'oe_headers_iface_all', FALSE );
614:
615: UPDATE oe_headers_iface_all a
616: set deliver_to_org_id = (select distinct m.customer_site_id
617: from ra_customer_merges m
618: where a.deliver_to_org_id = m.duplicate_site_id
619: and m.request_id = req_id
620: and m.process_flag = 'Y'
621: and m.set_number = set_num),

Line 630: from ra_customer_merges m

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'
632: and m.request_id = req_id
633: and m.set_number = set_num);
634: g_count := sql%rowcount;

Line 648: from ra_customer_merges m

644: -- arp_message.set_token( 'TABLE_NAME', 'oe_headers_iface_all', FALSE );
645:
646: UPDATE oe_headers_iface_all a
647: set sold_to_org_id = (select distinct m.customer_id
648: from ra_customer_merges m
649: where a.sold_to_org_id = m.duplicate_id
650: and m.process_flag = 'Y'
651: and m.request_id = req_id
652: and m.set_number = set_num),

Line 661: from ra_customer_merges m

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'
663: and m.request_id = req_id
664: and m.set_number = set_num);
665:

Line 698: from ra_customer_merges m

694: select HEADER_ID
695: from OE_HEADER_ACKS
696: where ship_to_org_id in
697: (select m.duplicate_site_id
698: from ra_customer_merges m
699: where m.process_flag = 'Y'
700: and m.request_id = req_id
701: and m.set_number = set_num)
702: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 711: from ra_customer_merges m

707: select HEADER_ID
708: from OE_HEADER_ACKS
709: where invoice_to_org_id in
710: (select m.duplicate_site_id
711: from ra_customer_merges m
712: where m.process_flag = 'Y'
713: and m.request_id = req_id
714: and m.set_number = set_num)
715: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 724: from ra_customer_merges m

720: select HEADER_ID
721: from OE_HEADER_ACKS
722: where deliver_to_org_id in
723: (select m.duplicate_site_id
724: from ra_customer_merges m
725: where m.process_flag = 'Y'
726: and m.request_id = req_id
727: and m.set_number = set_num)
728: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 736: from ra_customer_merges m

732: select HEADER_ID
733: from OE_HEADER_ACKS
734: where sold_to_org_id in
735: (select m.duplicate_id
736: from ra_customer_merges m
737: where m.process_flag = 'Y'
738: and m.request_id = req_id
739: and m.set_number = set_num)
740: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 792: from ra_customer_merges m

788: END IF;
789:
790: UPDATE OE_HEADER_ACKS a
791: set ship_to_org_id = (select distinct m.customer_site_id
792: from ra_customer_merges m
793: where a.ship_to_org_id = m.duplicate_site_id
794: and m.request_id = req_id
795: and m.process_flag = 'Y'
796: and m.set_number = set_num),

Line 805: from ra_customer_merges m

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'
807: and m.request_id = req_id
808: and m.set_number = set_num)
809: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 825: from ra_customer_merges m

821: END IF;
822:
823: UPDATE OE_HEADER_ACKS a
824: set invoice_to_org_id = (select distinct m.customer_site_id
825: from ra_customer_merges m
826: where a.invoice_to_org_id = m.duplicate_site_id
827: and m.request_id = req_id
828: and m.process_flag = 'Y'
829: and m.set_number = set_num),

Line 838: from ra_customer_merges m

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'
840: and m.request_id = req_id
841: and m.set_number = set_num)
842: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 858: from ra_customer_merges m

854: END IF;
855:
856: UPDATE OE_HEADER_ACKS a
857: set deliver_to_org_id = (select distinct m.customer_site_id
858: from ra_customer_merges m
859: where a.deliver_to_org_id = m.duplicate_site_id
860: and m.request_id = req_id
861: and m.process_flag = 'Y'
862: and m.set_number = set_num),

Line 871: from ra_customer_merges m

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'
873: and m.request_id = req_id
874: and m.set_number = set_num)
875: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 900: from ra_customer_merges m

896: END IF;
897:
898: UPDATE OE_HEADER_ACKS a
899: set sold_to_org_id = (select distinct m.customer_id
900: from ra_customer_merges m
901: where a.sold_to_org_id = m.duplicate_id
902: and m.process_flag = 'Y'
903: and m.request_id = req_id
904: and m.set_number = set_num),

Line 913: from ra_customer_merges m

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'
915: and m.request_id = req_id
916: and m.set_number = set_num)
917: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 960: from ra_customer_merges m

956: select line_id
957: from oe_order_lines_all
958: where ship_to_org_id in
959: (select m.duplicate_site_id
960: from ra_customer_merges m
961: where m.process_flag = 'Y'
962: and m.request_id = req_id
963: and m.set_number = set_num)
964: for update nowait;

Line 972: from ra_customer_merges m

968: select line_id
969: from oe_order_lines_all
970: where invoice_to_org_id in
971: (select m.duplicate_site_id
972: from ra_customer_merges m
973: where m.process_flag = 'Y'
974: and m.request_id = req_id
975: and m.set_number = set_num)
976: for update nowait;

Line 984: from ra_customer_merges m

980: select line_id
981: from oe_order_lines_all
982: where deliver_to_org_id in
983: (select m.duplicate_site_id
984: from ra_customer_merges m
985: where m.process_flag = 'Y'
986: and m.request_id = req_id
987: and m.set_number = set_num)
988: for update nowait;

Line 996: from ra_customer_merges m

992: select line_id
993: from oe_order_lines_all
994: where intmed_ship_to_org_id in
995: (select m.duplicate_site_id
996: from ra_customer_merges m
997: where m.process_flag = 'Y'
998: and m.request_id = req_id
999: and m.set_number = set_num)
1000: for update nowait;

Line 1007: from ra_customer_merges m

1003: select line_id
1004: from oe_order_lines_all
1005: where sold_to_org_id in
1006: (select m.duplicate_id
1007: from ra_customer_merges m
1008: where m.process_flag = 'Y'
1009: and m.request_id = req_id
1010: and m.set_number = set_num)
1011: for update nowait;

Line 1061: from ra_customer_merges m

1057: END IF;
1058:
1059: UPDATE oe_order_lines_all a
1060: set ship_to_org_id = (select distinct m.customer_site_id
1061: from ra_customer_merges m
1062: where a.ship_to_org_id = m.duplicate_site_id
1063: and m.request_id = req_id
1064: and m.process_flag = 'Y'
1065: and m.set_number = set_num),

Line 1074: from ra_customer_merges m

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'
1076: and m.request_id = req_id
1077: and m.set_number = set_num);
1078: g_count := sql%rowcount;

Line 1092: from ra_customer_merges m

1088: END IF;
1089:
1090: UPDATE oe_order_lines_all a
1091: set invoice_to_org_id = (select distinct m.customer_site_id
1092: from ra_customer_merges m
1093: where a.invoice_to_org_id = m.duplicate_site_id
1094: and m.request_id = req_id
1095: and m.process_flag = 'Y'
1096: and m.set_number = set_num),

Line 1105: from ra_customer_merges m

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'
1107: and m.request_id = req_id
1108: and m.set_number = set_num);
1109: g_count := sql%rowcount;

Line 1124: from ra_customer_merges m

1120: END IF;
1121:
1122: UPDATE oe_order_lines_all a
1123: set deliver_to_org_id = (select distinct m.customer_site_id
1124: from ra_customer_merges m
1125: where a.deliver_to_org_id = m.duplicate_site_id
1126: and m.request_id = req_id
1127: and m.process_flag = 'Y'
1128: and m.set_number = set_num),

Line 1137: from ra_customer_merges m

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'
1139: and m.request_id = req_id
1140: and m.set_number = set_num);
1141: g_count := sql%rowcount;

Line 1156: from ra_customer_merges m

1152: END IF;
1153:
1154: UPDATE oe_order_lines_all a
1155: set intmed_ship_to_org_id = (select distinct m.customer_site_id
1156: from ra_customer_merges m
1157: where a.intmed_ship_to_org_id = m.duplicate_site_id
1158: and m.request_id = req_id
1159: and m.process_flag = 'Y'
1160: and m.set_number = set_num),

Line 1169: from ra_customer_merges m

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'
1171: and m.request_id = req_id
1172: and m.set_number = set_num);
1173: g_count := sql%rowcount;

Line 1195: from ra_customer_merges m

1191: END IF;
1192:
1193: UPDATE oe_order_lines_all a
1194: set sold_to_org_id = (select distinct m.customer_id
1195: from ra_customer_merges m
1196: where a.sold_to_org_id = m.duplicate_id
1197: and m.process_flag = 'Y'
1198: and m.request_id = req_id
1199: and m.set_number = set_num),

Line 1208: from ra_customer_merges m

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'
1210: and m.request_id = req_id
1211: and m.set_number = set_num);
1212:

Line 1254: from ra_customer_merges m

1250: select line_id
1251: from oe_order_lines_history
1252: where ship_to_org_id in
1253: (select m.duplicate_site_id
1254: from ra_customer_merges m
1255: where m.process_flag = 'Y'
1256: and m.request_id = req_id
1257: and m.set_number = set_num)
1258: for update nowait;

Line 1266: from ra_customer_merges m

1262: select line_id
1263: from oe_order_lines_history
1264: where invoice_to_org_id in
1265: (select m.duplicate_site_id
1266: from ra_customer_merges m
1267: where m.process_flag = 'Y'
1268: and m.request_id = req_id
1269: and m.set_number = set_num)
1270: for update nowait;

Line 1278: from ra_customer_merges m

1274: select line_id
1275: from oe_order_lines_history
1276: where deliver_to_org_id in
1277: (select m.duplicate_site_id
1278: from ra_customer_merges m
1279: where m.process_flag = 'Y'
1280: and m.request_id = req_id
1281: and m.set_number = set_num)
1282: for update nowait;

Line 1290: from ra_customer_merges m

1286: select line_id
1287: from oe_order_lines_history
1288: where intmed_ship_to_org_id in
1289: (select m.duplicate_site_id
1290: from ra_customer_merges m
1291: where m.process_flag = 'Y'
1292: and m.request_id = req_id
1293: and m.set_number = set_num)
1294: for update nowait;

Line 1301: from ra_customer_merges m

1297: select line_id
1298: from oe_order_lines_history
1299: where sold_to_org_id in
1300: (select m.duplicate_id
1301: from ra_customer_merges m
1302: where m.process_flag = 'Y'
1303: and m.request_id = req_id
1304: and m.set_number = set_num)
1305: for update nowait;

Line 1355: from ra_customer_merges m

1351: END IF;
1352:
1353: UPDATE oe_order_lines_history a
1354: set ship_to_org_id = (select distinct m.customer_site_id
1355: from ra_customer_merges m
1356: where a.ship_to_org_id = m.duplicate_site_id
1357: and m.request_id = req_id
1358: and m.process_flag = 'Y'
1359: and m.set_number = set_num),

Line 1368: from ra_customer_merges m

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'
1370: and m.request_id = req_id
1371: and m.set_number = set_num);
1372: g_count := sql%rowcount;

Line 1387: from ra_customer_merges m

1383: END IF;
1384:
1385: UPDATE oe_order_lines_history a
1386: set invoice_to_org_id = (select distinct m.customer_site_id
1387: from ra_customer_merges m
1388: where a.invoice_to_org_id = m.duplicate_site_id
1389: and m.request_id = req_id
1390: and m.process_flag = 'Y'
1391: and m.set_number = set_num),

Line 1400: from ra_customer_merges m

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'
1402: and m.request_id = req_id
1403: and m.set_number = set_num);
1404: g_count := sql%rowcount;

Line 1419: from ra_customer_merges m

1415: END IF;
1416:
1417: UPDATE oe_order_lines_history a
1418: set deliver_to_org_id = (select distinct m.customer_site_id
1419: from ra_customer_merges m
1420: where a.deliver_to_org_id = m.duplicate_site_id
1421: and m.request_id = req_id
1422: and m.process_flag = 'Y'
1423: and m.set_number = set_num),

Line 1432: from ra_customer_merges m

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'
1434: and m.request_id = req_id
1435: and m.set_number = set_num);
1436: g_count := sql%rowcount;

Line 1452: from ra_customer_merges m

1448:
1449:
1450: UPDATE oe_order_lines_history a
1451: set intmed_ship_to_org_id = (select distinct m.customer_site_id
1452: from ra_customer_merges m
1453: where a.intmed_ship_to_org_id = m.duplicate_site_id
1454: and m.request_id = req_id
1455: and m.process_flag = 'Y'
1456: and m.set_number = set_num),

Line 1465: from ra_customer_merges m

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'
1467: and m.request_id = req_id
1468: and m.set_number = set_num);
1469: g_count := sql%rowcount;

Line 1492: from ra_customer_merges m

1488: END IF;
1489:
1490: UPDATE oe_order_lines_history a
1491: set sold_to_org_id = (select distinct m.customer_id
1492: from ra_customer_merges m
1493: where a.sold_to_org_id = m.duplicate_id
1494: and m.process_flag = 'Y'
1495: and m.request_id = req_id
1496: and m.set_number = set_num),

Line 1505: from ra_customer_merges m

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'
1507: and m.request_id = req_id
1508: and m.set_number = set_num);
1509:

Line 1553: from ra_customer_merges m

1549: select line_id
1550: from oe_lines_iface_all
1551: where ship_to_org_id in
1552: (select m.duplicate_site_id
1553: from ra_customer_merges m
1554: where m.process_flag = 'Y'
1555: and m.request_id = req_id
1556: and m.set_number = set_num)
1557: for update nowait;

Line 1565: from ra_customer_merges m

1561: select line_id
1562: from oe_lines_iface_all
1563: where invoice_to_org_id in
1564: (select m.duplicate_site_id
1565: from ra_customer_merges m
1566: where m.process_flag = 'Y'
1567: and m.request_id = req_id
1568: and m.set_number = set_num)
1569: for update nowait;

Line 1577: from ra_customer_merges m

1573: select line_id
1574: from oe_lines_iface_all
1575: where deliver_to_org_id in
1576: (select m.duplicate_site_id
1577: from ra_customer_merges m
1578: where m.process_flag = 'Y'
1579: and m.request_id = req_id
1580: and m.set_number = set_num)
1581: for update nowait;

Line 1589: from ra_customer_merges m

1585: select line_id
1586: from oe_lines_iface_all
1587: where sold_to_org_id in
1588: (select m.duplicate_id
1589: from ra_customer_merges m
1590: where m.process_flag = 'Y'
1591: and m.request_id = req_id
1592: and m.set_number = set_num)
1593: for update nowait;

Line 1624: from ra_customer_merges m

1620: -- arp_message.set_token( 'TABLE_NAME', 'oe_lines_iface_all', FALSE );
1621:
1622: UPDATE oe_lines_iface_all a
1623: set ship_to_org_id = (select distinct m.customer_site_id
1624: from ra_customer_merges m
1625: where a.ship_to_org_id = m.duplicate_site_id
1626: and m.request_id = req_id
1627: and m.process_flag = 'Y'
1628: and m.set_number = set_num),

Line 1637: from ra_customer_merges m

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'
1639: and m.request_id = req_id
1640: and m.set_number = set_num);
1641: g_count := sql%rowcount;

Line 1650: from ra_customer_merges m

1646: -- arp_message.set_token( 'TABLE_NAME', 'oe_lines_iface_all', FALSE );
1647:
1648: UPDATE oe_lines_iface_all a
1649: set invoice_to_org_id = (select distinct m.customer_site_id
1650: from ra_customer_merges m
1651: where a.invoice_to_org_id = m.duplicate_site_id
1652: and m.request_id = req_id
1653: and m.process_flag = 'Y'
1654: and m.set_number = set_num),

Line 1663: from ra_customer_merges m

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'
1665: and m.request_id = req_id
1666: and m.set_number = set_num);
1667: g_count := sql%rowcount;

Line 1676: from ra_customer_merges m

1672: -- arp_message.set_token( 'TABLE_NAME', 'oe_lines_iface_all', FALSE );
1673:
1674: UPDATE oe_lines_iface_all a
1675: set deliver_to_org_id = (select distinct m.customer_site_id
1676: from ra_customer_merges m
1677: where a.deliver_to_org_id = m.duplicate_site_id
1678: and m.request_id = req_id
1679: and m.process_flag = 'Y'
1680: and m.set_number = set_num),

Line 1689: from ra_customer_merges m

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'
1691: and m.request_id = req_id
1692: and m.set_number = set_num);
1693: g_count := sql%rowcount;

Line 1706: from ra_customer_merges m

1702: -- arp_message.set_token( 'TABLE_NAME', 'oe_lines_iface_all', FALSE );
1703:
1704: UPDATE oe_lines_iface_all a
1705: set sold_to_org_id = (select distinct m.customer_id
1706: from ra_customer_merges m
1707: where a.sold_to_org_id = m.duplicate_id
1708: and m.process_flag = 'Y'
1709: and m.request_id = req_id
1710: and m.set_number = set_num),

Line 1719: from ra_customer_merges m

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'
1721: and m.request_id = req_id
1722: and m.set_number = set_num);
1723:

Line 1754: from ra_customer_merges m

1750: select line_id
1751: from oe_line_acks
1752: where ship_to_org_id in
1753: (select m.duplicate_site_id
1754: from ra_customer_merges m
1755: where m.process_flag = 'Y'
1756: and m.request_id = req_id
1757: and m.set_number = set_num)
1758: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1767: from ra_customer_merges m

1763: select line_id
1764: from oe_line_acks
1765: where invoice_to_org_id in
1766: (select m.duplicate_site_id
1767: from ra_customer_merges m
1768: where m.process_flag = 'Y'
1769: and m.request_id = req_id
1770: and m.set_number = set_num)
1771: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1780: from ra_customer_merges m

1776: select line_id
1777: from oe_line_acks
1778: where deliver_to_org_id in
1779: (select m.duplicate_site_id
1780: from ra_customer_merges m
1781: where m.process_flag = 'Y'
1782: and m.request_id = req_id
1783: and m.set_number = set_num)
1784: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1793: from ra_customer_merges m

1789: select line_id
1790: from oe_line_acks
1791: where intmed_ship_to_org_id in
1792: (select m.duplicate_site_id
1793: from ra_customer_merges m
1794: where m.process_flag = 'Y'
1795: and m.request_id = req_id
1796: and m.set_number = set_num)
1797: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1805: from ra_customer_merges m

1801: select line_id
1802: from oe_line_acks
1803: where sold_to_org_id in
1804: (select m.duplicate_id
1805: from ra_customer_merges m
1806: where m.process_flag = 'Y'
1807: and m.request_id = req_id
1808: and m.set_number = set_num)
1809: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1859: from ra_customer_merges m

1855: END IF;
1856:
1857: UPDATE oe_line_acks a
1858: set ship_to_org_id = (select distinct m.customer_site_id
1859: from ra_customer_merges m
1860: where a.ship_to_org_id = m.duplicate_site_id
1861: and m.request_id = req_id
1862: and m.process_flag = 'Y'
1863: and m.set_number = set_num),

Line 1872: from ra_customer_merges m

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'
1874: and m.request_id = req_id
1875: and m.set_number = set_num)
1876: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 1891: from ra_customer_merges m

1887: END IF;
1888:
1889: UPDATE oe_line_acks a
1890: set invoice_to_org_id = (select distinct m.customer_site_id
1891: from ra_customer_merges m
1892: where a.invoice_to_org_id = m.duplicate_site_id
1893: and m.request_id = req_id
1894: and m.process_flag = 'Y'
1895: and m.set_number = set_num),

Line 1904: from ra_customer_merges m

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'
1906: and m.request_id = req_id
1907: and m.set_number = set_num)
1908: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 1923: from ra_customer_merges m

1919: END IF;
1920:
1921: UPDATE oe_line_acks a
1922: set deliver_to_org_id = (select distinct m.customer_site_id
1923: from ra_customer_merges m
1924: where a.deliver_to_org_id = m.duplicate_site_id
1925: and m.request_id = req_id
1926: and m.process_flag = 'Y'
1927: and m.set_number = set_num),

Line 1936: from ra_customer_merges m

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'
1938: and m.request_id = req_id
1939: and m.set_number = set_num)
1940: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 1955: from ra_customer_merges m

1951: END IF;
1952:
1953: UPDATE oe_line_acks a
1954: set intmed_ship_to_org_id = (select distinct m.customer_site_id
1955: from ra_customer_merges m
1956: where a.intmed_ship_to_org_id = m.duplicate_site_id
1957: and m.request_id = req_id
1958: and m.process_flag = 'Y'
1959: and m.set_number = set_num),

Line 1968: from ra_customer_merges m

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'
1970: and m.request_id = req_id
1971: and m.set_number = set_num)
1972: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 1995: from ra_customer_merges m

1991: END IF;
1992:
1993: UPDATE oe_line_acks a
1994: set sold_to_org_id = (select distinct m.customer_id
1995: from ra_customer_merges m
1996: where a.sold_to_org_id = m.duplicate_id
1997: and m.process_flag = 'Y'
1998: and m.request_id = req_id
1999: and m.set_number = set_num),

Line 2008: from ra_customer_merges m

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'
2010: and m.request_id = req_id
2011: and m.set_number = set_num)
2012: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 2108: from ra_customer_merges m

2104: CURSOR c1 is
2105: select RULE_ELEMENT_ID
2106: from oe_attachment_rule_elements
2107: where attribute_value in (select to_char(m.duplicate_site_id)
2108: from ra_customer_merges m
2109: where m.process_flag = 'Y'
2110: and m.request_id = req_id
2111: and m.set_number = set_num)
2112: and attribute_code = 'SHIP_TO_ORG_ID'

Line 2119: from ra_customer_merges m

2115: CURSOR c2 is
2116: select RULE_ELEMENT_ID
2117: from oe_attachment_rule_elements
2118: where attribute_value in (select to_char(m.duplicate_site_id)
2119: from ra_customer_merges m
2120: where m.process_flag = 'Y'
2121: and m.request_id = req_id
2122: and m.set_number = set_num)
2123: and attribute_code = 'INVOICE_TO_ORG_ID'

Line 2130: from ra_customer_merges m

2126: CURSOR c3 is
2127: select RULE_ELEMENT_ID
2128: from oe_attachment_rule_elements
2129: where attribute_value in (select to_char(m.duplicate_id)
2130: from ra_customer_merges m
2131: where m.process_flag = 'Y'
2132: and m.request_id = req_id
2133: and m.set_number = set_num)
2134: and attribute_code = 'SOLD_TO_ORG_ID'

Line 2184: from ra_customer_merges m

2180: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE SHIP_TO_ORG_ID' ) ;
2181: END IF;
2182: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
2183: set (attribute_value) = (select distinct to_char(m.customer_site_id)
2184: from ra_customer_merges m
2185: where a.attribute_value =
2186: to_char(m.duplicate_site_id)
2187: and m.request_id = req_id
2188: and m.process_flag = 'Y'

Line 2194: from ra_customer_merges m

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
2197: and m.set_number = set_num)
2198: and attribute_code = 'SHIP_TO_ORG_ID';

Line 2220: from ra_customer_merges m

2216: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE INVOICE_TO_ORG_ID' ) ;
2217: END IF;
2218: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
2219: set (attribute_value) = (select distinct to_char(m.customer_site_id)
2220: from ra_customer_merges m
2221: where a.attribute_value =
2222: to_char(m.duplicate_site_id)
2223: and m.request_id = req_id
2224: and m.process_flag = 'Y'

Line 2230: from ra_customer_merges m

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
2233: and m.set_number = set_num)
2234: and attribute_code = 'INVOICE_TO_ORG_ID';

Line 2257: from ra_customer_merges m

2253: END IF;
2254:
2255: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
2256: set (attribute_value) = (select distinct to_char(m.customer_id)
2257: from ra_customer_merges m
2258: where a.attribute_value =
2259: to_char(m.duplicate_id)
2260: and m.request_id = req_id
2261: and m.process_flag = 'Y'

Line 2267: from ra_customer_merges m

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
2270: and m.set_number = set_num)
2271: and attribute_code = 'SOLD_TO_ORG_ID';

Line 2313: from ra_customer_merges m

2309: CURSOR c1 is
2310: select CONDITION_ELEMENT_ID
2311: from oe_def_condn_elems
2312: where value_string in (select to_char(m.duplicate_site_id)
2313: from ra_customer_merges m
2314: where m.process_flag = 'Y'
2315: and m.request_id = req_id
2316: and m.set_number = set_num)
2317: and attribute_code = 'SHIP_TO_ORG_ID'

Line 2324: from ra_customer_merges m

2320: CURSOR c2 is
2321: select CONDITION_ELEMENT_ID
2322: from oe_def_condn_elems
2323: where value_string in (select to_char(m.duplicate_site_id)
2324: from ra_customer_merges m
2325: where m.process_flag = 'Y'
2326: and m.request_id = req_id
2327: and m.set_number = set_num)
2328: and attribute_code = 'INVOICE_TO_ORG_ID'

Line 2335: from ra_customer_merges m

2331: CURSOR c4 is
2332: select CONDITION_ELEMENT_ID
2333: from oe_def_condn_elems
2334: where value_string in (select to_char(m.duplicate_site_id)
2335: from ra_customer_merges m
2336: where m.process_flag = 'Y'
2337: and m.request_id = req_id
2338: and m.set_number = set_num)
2339: and attribute_code = 'INTMED_SHIP_TO_ORG_ID'

Line 2346: from ra_customer_merges m

2342: CURSOR c3 is
2343: select CONDITION_ELEMENT_ID
2344: from oe_def_condn_elems
2345: where value_string in (select to_char(m.duplicate_id)
2346: from ra_customer_merges m
2347: where m.process_flag = 'Y'
2348: and m.request_id = req_id
2349: and m.set_number = set_num)
2350: and attribute_code = 'SOLD_TO_ORG_ID'

Line 2357: from ra_customer_merges m

2353: CURSOR c5 is
2354: select ATTR_DEF_RULE_ID
2355: from oe_def_attr_def_rules
2356: where src_constant_value in (select to_char(m.duplicate_site_id)
2357: from ra_customer_merges m
2358: where m.process_flag = 'Y'
2359: and m.request_id = req_id
2360: and m.set_number = set_num)
2361: and attribute_code = 'SHIP_TO_ORG_ID'

Line 2368: from ra_customer_merges m

2364: CURSOR c6 is
2365: select ATTR_DEF_RULE_ID
2366: from oe_def_attr_def_rules
2367: where src_constant_value in (select to_char(m.duplicate_site_id)
2368: from ra_customer_merges m
2369: where m.process_flag = 'Y'
2370: and m.request_id = req_id
2371: and m.set_number = set_num)
2372: and attribute_code = 'INVOICE_TO_ORG_ID'

Line 2379: from ra_customer_merges m

2375: CURSOR c7 is
2376: select ATTR_DEF_RULE_ID
2377: from oe_def_attr_def_rules
2378: where src_constant_value in (select to_char(m.duplicate_site_id)
2379: from ra_customer_merges m
2380: where m.process_flag = 'Y'
2381: and m.request_id = req_id
2382: and m.set_number = set_num)
2383: and attribute_code = 'INTMED_SHIP_TO_ORG_ID'

Line 2390: from ra_customer_merges m

2386: CURSOR c8 is
2387: select ATTR_DEF_RULE_ID
2388: from oe_def_attr_def_rules
2389: where src_constant_value in (select to_char(m.duplicate_id)
2390: from ra_customer_merges m
2391: where m.process_flag = 'Y'
2392: and m.request_id = req_id
2393: and m.set_number = set_num)
2394: and attribute_code = 'SOLD_TO_ORG_ID'

Line 2459: from ra_customer_merges m

2455: oe_debug_pub.add( 'UPDATING OE_DEF_CONDN_ELEMENTS.VALUE_STRING FOR ATTRIBUTE CODE SHIP_TO_ORG_ID' ) ;
2456: END IF;
2457: UPDATE OE_DEF_CONDN_ELEMS a
2458: set value_string = (select distinct to_char(m.customer_site_id)
2459: from ra_customer_merges m
2460: where a.value_string =
2461: to_char(m.duplicate_site_id)
2462:
2463: and m.request_id = req_id

Line 2470: from ra_customer_merges m

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
2473: and m.set_number = set_num)
2474: and attribute_code = 'SHIP_TO_ORG_ID';

Line 2495: from ra_customer_merges m

2491: oe_debug_pub.add( 'UPDATING OE_DEF_CONDN_ELEMENTS.VALUE_STRING FOR ATTRIBUTE CODE INVOICE_TO_ORG_ID' ) ;
2492: END IF;
2493: UPDATE OE_DEF_CONDN_ELEMS a
2494: set value_string = (select distinct to_char(m.customer_site_id)
2495: from ra_customer_merges m
2496: where a.value_string =
2497: to_char(m.duplicate_site_id)
2498:
2499: and m.request_id = req_id

Line 2506: from ra_customer_merges m

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
2509: and m.set_number = set_num)
2510: and attribute_code = 'INVOICE_TO_ORG_ID';

Line 2531: from ra_customer_merges m

2527: oe_debug_pub.add( 'UPDATING OE_DEF_CONDN_ELEMENTS.VALUE_STRING FOR ATTRIBUTE CODE INTMED_TO_ORG_ID' ) ;
2528: END IF;
2529: UPDATE OE_DEF_CONDN_ELEMS a
2530: set value_string = (select distinct to_char(m.customer_site_id)
2531: from ra_customer_merges m
2532: where a.value_string =
2533: to_char(m.duplicate_site_id)
2534:
2535: and m.request_id = req_id

Line 2542: from ra_customer_merges m

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
2545: and m.set_number = set_num)
2546: and attribute_code = 'INTMED_SHIP_TO_ORG_ID';

Line 2568: from ra_customer_merges m

2564: END IF;
2565:
2566: UPDATE OE_DEF_CONDN_ELEMS a
2567: set value_string = (select distinct to_char(m.customer_id)
2568: from ra_customer_merges m
2569: where a.value_string =
2570: to_char(m.duplicate_id)
2571:
2572: and m.request_id = req_id

Line 2579: from ra_customer_merges m

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
2582: and m.set_number = set_num)
2583: and attribute_code = 'SOLD_TO_ORG_ID';

Line 2607: from ra_customer_merges m

2603: END IF;
2604:
2605: UPDATE OE_DEF_ATTR_DEF_RULES a
2606: set src_constant_value = (select distinct to_char(m.customer_site_id)
2607: from ra_customer_merges m
2608: where a.src_constant_value =
2609: to_char(m.duplicate_site_id)
2610:
2611: and m.request_id = req_id

Line 2618: from ra_customer_merges m

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
2621: and m.set_number = set_num)
2622: and attribute_code = 'SHIP_TO_ORG_ID';

Line 2644: from ra_customer_merges m

2640: END IF;
2641:
2642: UPDATE OE_DEF_ATTR_DEF_RULES a
2643: set src_constant_value = (select distinct to_char(m.customer_site_id)
2644: from ra_customer_merges m
2645: where a.src_constant_value =
2646: to_char(m.duplicate_site_id)
2647:
2648: and m.request_id = req_id

Line 2655: from ra_customer_merges m

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
2658: and m.set_number = set_num)
2659: and attribute_code = 'INVOICE_TO_ORG_ID';

Line 2681: from ra_customer_merges m

2677: END IF;
2678:
2679: UPDATE OE_DEF_ATTR_DEF_RULES a
2680: set src_constant_value = (select distinct to_char(m.customer_site_id)
2681: from ra_customer_merges m
2682: where a.src_constant_value =
2683: to_char(m.duplicate_site_id)
2684:
2685: and m.request_id = req_id

Line 2692: from ra_customer_merges m

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
2695: and m.set_number = set_num)
2696: and attribute_code = 'INTMED_SHIP_TO_ORG_ID';

Line 2718: from ra_customer_merges m

2714: END IF;
2715:
2716: UPDATE OE_DEF_ATTR_DEF_RULES a
2717: set src_constant_value = (select distinct to_char(m.customer_id)
2718: from ra_customer_merges m
2719: where a.src_constant_value =
2720: to_char(m.duplicate_id)
2721:
2722: and m.request_id = req_id

Line 2729: from ra_customer_merges m

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
2732: and m.set_number = set_num)
2733: and attribute_code = 'SOLD_TO_ORG_ID';

Line 2777: from ra_customer_merges m

2773: CURSOR c1 is
2774: select VALIDATION_TMPLT_ID
2775: from oe_pc_vtmplt_cols
2776: where value_string in (select to_char(m.duplicate_site_id)
2777: from ra_customer_merges m
2778: where m.process_flag = 'Y'
2779: and m.request_id = req_id
2780: and m.set_number = set_num)
2781: and column_name = 'SHIP_TO_ORG_ID'

Line 2788: from ra_customer_merges m

2784: CURSOR c2 is
2785: select VALIDATION_TMPLT_ID
2786: from oe_pc_vtmplt_cols
2787: where value_string in (select to_char(m.duplicate_site_id)
2788: from ra_customer_merges m
2789: where m.process_flag = 'Y'
2790: and m.request_id = req_id
2791: and m.set_number = set_num)
2792: and column_name = 'INVOICE_TO_ORG_ID'

Line 2799: from ra_customer_merges m

2795: CURSOR c4 is
2796: select VALIDATION_TMPLT_ID
2797: from oe_pc_vtmplt_cols
2798: where value_string in (select to_char(m.duplicate_site_id)
2799: from ra_customer_merges m
2800: where m.process_flag = 'Y'
2801: and m.request_id = req_id
2802: and m.set_number = set_num)
2803: and column_name = 'INTMED_SHIP_TO_ORG_ID'

Line 2810: from ra_customer_merges m

2806: CURSOR c3 is
2807: select VALIDATION_TMPLT_ID
2808: from oe_pc_vtmplt_cols
2809: where value_string in (select to_char(m.duplicate_id)
2810: from ra_customer_merges m
2811: where m.process_flag = 'Y'
2812: and m.request_id = req_id
2813: and m.set_number = set_num)
2814: and column_name = 'SOLD_TO_ORG_ID'

Line 2868: from ra_customer_merges m

2864: END IF;
2865:
2866: UPDATE OE_PC_VTMPLT_COLS a
2867: set value_string = (select distinct to_char(m.customer_site_id)
2868: from ra_customer_merges m
2869: where a.value_string =
2870: to_char(m.duplicate_site_id)
2871:
2872: and m.request_id = req_id

Line 2879: from ra_customer_merges m

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
2882: and m.set_number = set_num)
2883: and column_name = 'SHIP_TO_ORG_ID';

Line 2905: from ra_customer_merges m

2901: END IF;
2902:
2903: UPDATE OE_PC_VTMPLT_COLS a
2904: set value_string = (select distinct to_char(m.customer_site_id)
2905: from ra_customer_merges m
2906: where a.value_string =
2907: to_char(m.duplicate_site_id)
2908:
2909: and m.request_id = req_id

Line 2916: from ra_customer_merges m

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
2919: and m.set_number = set_num)
2920: and column_name = 'INVOICE_TO_ORG_ID';

Line 2942: from ra_customer_merges m

2938: END IF;
2939:
2940: UPDATE OE_PC_VTMPLT_COLS a
2941: set value_string = (select distinct to_char(m.customer_site_id)
2942: from ra_customer_merges m
2943: where a.value_string =
2944: to_char(m.duplicate_site_id)
2945:
2946: and m.request_id = req_id

Line 2953: from ra_customer_merges m

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
2956: and m.set_number = set_num)
2957: and column_name = 'INTMED_SHIP_TO_ORG_ID';

Line 2980: from ra_customer_merges m

2976: END IF;
2977:
2978: UPDATE OE_PC_VTMPLT_COLS a
2979: set value_string = (select distinct to_char(m.customer_id)
2980: from ra_customer_merges m
2981: where a.value_string =
2982: to_char(m.duplicate_id)
2983:
2984: and m.request_id = req_id

Line 2991: from ra_customer_merges m

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
2994: and m.set_number = set_num)
2995: and column_name = 'SOLD_TO_ORG_ID';

Line 3038: from ra_customer_merges m

3034: CURSOR c1 is
3035: select hold_source_id
3036: from oe_hold_sources
3037: where hold_entity_id in (select m.duplicate_site_id
3038: from ra_customer_merges m
3039: where m.process_flag = 'Y'
3040: and m.request_id = req_id
3041: and m.set_number = set_num)
3042: and hold_entity_code = 'S'

Line 3049: from ra_customer_merges m

3045: CURSOR c2 is
3046: select hold_source_id
3047: from oe_hold_sources
3048: where hold_entity_id in (select m.duplicate_site_id
3049: from ra_customer_merges m
3050: where m.process_flag = 'Y'
3051: and m.request_id = req_id
3052: and m.set_number = set_num)
3053: and hold_entity_code = 'B'

Line 3061: from ra_customer_merges m

3057: CURSOR c3 is
3058: select hold_source_id
3059: from oe_hold_sources
3060: where hold_entity_id in (select m.duplicate_id
3061: from ra_customer_merges m
3062: where m.process_flag = 'Y'
3063: and m.request_id = req_id
3064: and m.set_number = set_num)
3065: and hold_entity_code = 'C'

Line 3115: from ra_customer_merges m

3111: END IF;
3112:
3113: UPDATE OE_HOLD_SOURCES a
3114: set (hold_entity_id) = (select distinct m.customer_site_id
3115: from ra_customer_merges m
3116: where a.hold_entity_id =
3117: m.duplicate_site_id
3118: and m.request_id = req_id
3119: and m.process_flag = 'Y'

Line 3126: from ra_customer_merges m

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
3129: and m.set_number = set_num)
3130: and hold_entity_code = 'S';

Line 3153: from ra_customer_merges m

3149: END IF;
3150:
3151: UPDATE OE_HOLD_SOURCES a
3152: set (hold_entity_id) = (select distinct m.customer_site_id
3153: from ra_customer_merges m
3154: where a.hold_entity_id =
3155:
3156: m.duplicate_site_id
3157: and m.request_id = req_id

Line 3164: from ra_customer_merges m

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
3167: and m.set_number = set_num)
3168: and hold_entity_code = 'B';

Line 3192: from ra_customer_merges m

3188: END IF;
3189:
3190: UPDATE OE_HOLD_SOURCES a
3191: set hold_entity_id = (select distinct m.customer_id
3192: from ra_customer_merges m
3193: where a.hold_entity_id =
3194: m.duplicate_id
3195: and m.process_flag = 'Y'
3196: and m.request_id = req_id

Line 3202: from ra_customer_merges m

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
3205: and m.set_number = set_num)
3206: and hold_entity_code = 'C';

Line 3246: from ra_customer_merges m

3242: select DROP_SHIP_SOURCE_ID
3243: from oe_drop_ship_sources
3244: where LINE_LOCATION_ID in
3245: (select m.duplicate_site_id
3246: from ra_customer_merges m
3247: where m.process_flag = 'Y'
3248: and m.request_id = req_id
3249: and m.set_number = set_num)
3250: for update nowait;

Line 3289: from ra_customer_merges m

3285: END IF;
3286:
3287: UPDATE OE_DROP_SHIP_SOURCES a
3288: set line_location_id = (select distinct m.customer_site_id
3289: from ra_customer_merges m
3290: where a.line_location_id = m.duplicate_site_id
3291: and m.request_id = req_id
3292: and m.process_flag = 'Y'
3293: and m.set_number = set_num),

Line 3298: from ra_customer_merges m

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
3301: and m.set_number = set_num);
3302: g_count := sql%rowcount;

Line 3338: from ra_customer_merges m

3334: select CUST_ITEM_SETTING_ID
3335: from oe_cust_item_settings
3336: where site_use_id in
3337: (select m.duplicate_site_id
3338: from ra_customer_merges m
3339: where m.process_flag = 'Y'
3340: and m.request_id = req_id
3341: and m.set_number = set_num)
3342: for update nowait;

Line 3349: from ra_customer_merges m

3345: select CUST_ITEM_SETTING_ID
3346: from oe_cust_item_settings
3347: where customer_id in
3348: (select m.duplicate_id
3349: from ra_customer_merges m
3350: where m.process_flag = 'Y'
3351: and m.request_id = req_id
3352: and m.set_number = set_num)
3353: for update nowait;

Line 3398: from ra_customer_merges m

3394: END IF;
3395:
3396: UPDATE OE_CUST_ITEM_SETTINGS a
3397: set site_use_id = (select distinct m.customer_site_id
3398: from ra_customer_merges m
3399: where a.site_use_id = m.duplicate_site_id
3400: and m.request_id = req_id
3401: and m.process_flag = 'Y'
3402: and m.set_number = set_num),

Line 3407: from ra_customer_merges m

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
3410: and m.set_number = set_num);
3411: g_count := sql%rowcount;

Line 3430: from ra_customer_merges m

3426: END IF;
3427:
3428: UPDATE OE_CUST_ITEM_SETTINGS a
3429: set customer_id = (select distinct m.customer_id
3430: from ra_customer_merges m
3431: where a.customer_id = m.duplicate_id
3432: and m.request_id = req_id
3433: and m.process_flag = 'Y'
3434: and m.set_number = set_num),

Line 3439: from ra_customer_merges m

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
3442: and m.set_number = set_num);
3443: g_count := sql%rowcount;

Line 3482: from ra_customer_merges m

3478: select Set_Id
3479: from oe_sets
3480: where ship_to_org_id in
3481: (select m.duplicate_site_id
3482: from ra_customer_merges m
3483: where m.process_flag = 'Y'
3484: and m.request_id = req_id
3485: and m.set_number = set_num)
3486: for update nowait;

Line 3525: from ra_customer_merges m

3521: END IF;
3522:
3523: UPDATE oe_sets a
3524: set ship_to_org_id = (select distinct m.customer_site_id
3525: from ra_customer_merges m
3526: where a.ship_to_org_id = m.duplicate_site_id
3527: and m.request_id = req_id
3528: and m.process_flag = 'Y'
3529: and m.set_number = set_num),

Line 3534: from ra_customer_merges m

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
3537: and m.set_number = set_num);
3538: g_count := sql%rowcount;