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

Line 45: from ra_customer_merges m

41: IS
42:
43: CURSOR MERGE_SITES IS
44: select duplicate_id, customer_id, duplicate_site_id, customer_site_id
45: from ra_customer_merges m
46: where m.process_flag = 'N'
47: and m.request_id = req_id
48: and m.set_number = set_num;
49:

Line 62: FROM RA_CUSTOMER_MERGES M1,

58: H.END_CUSTOMER_ID,
59: NVL(M1.CUSTOMER_MERGE_ID,NVL(M2.CUSTOMER_MERGE_ID,NVL(M3.CUSTOMER_MERGE_ID,
60: NVL(M4.CUSTOMER_MERGE_ID,nvl(M5.CUSTOMER_MERGE_ID,
61: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
62: FROM RA_CUSTOMER_MERGES M1,
63: RA_CUSTOMER_MERGES M2,
64: RA_CUSTOMER_MERGES M3,
65: RA_CUSTOMER_MERGES M4,
66: RA_CUSTOMER_MERGES M5,

Line 63: RA_CUSTOMER_MERGES M2,

59: NVL(M1.CUSTOMER_MERGE_ID,NVL(M2.CUSTOMER_MERGE_ID,NVL(M3.CUSTOMER_MERGE_ID,
60: NVL(M4.CUSTOMER_MERGE_ID,nvl(M5.CUSTOMER_MERGE_ID,
61: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
62: FROM RA_CUSTOMER_MERGES M1,
63: RA_CUSTOMER_MERGES M2,
64: RA_CUSTOMER_MERGES M3,
65: RA_CUSTOMER_MERGES M4,
66: RA_CUSTOMER_MERGES M5,
67: RA_CUSTOMER_MERGES M6,

Line 64: RA_CUSTOMER_MERGES M3,

60: NVL(M4.CUSTOMER_MERGE_ID,nvl(M5.CUSTOMER_MERGE_ID,
61: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
62: FROM RA_CUSTOMER_MERGES M1,
63: RA_CUSTOMER_MERGES M2,
64: RA_CUSTOMER_MERGES M3,
65: RA_CUSTOMER_MERGES M4,
66: RA_CUSTOMER_MERGES M5,
67: RA_CUSTOMER_MERGES M6,
68: RA_CUSTOMER_MERGES M7,

Line 65: RA_CUSTOMER_MERGES M4,

61: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
62: FROM RA_CUSTOMER_MERGES M1,
63: RA_CUSTOMER_MERGES M2,
64: RA_CUSTOMER_MERGES M3,
65: RA_CUSTOMER_MERGES M4,
66: RA_CUSTOMER_MERGES M5,
67: RA_CUSTOMER_MERGES M6,
68: RA_CUSTOMER_MERGES M7,
69: OE_ORDER_HEADERS H

Line 66: RA_CUSTOMER_MERGES M5,

62: FROM RA_CUSTOMER_MERGES M1,
63: RA_CUSTOMER_MERGES M2,
64: RA_CUSTOMER_MERGES M3,
65: RA_CUSTOMER_MERGES M4,
66: RA_CUSTOMER_MERGES M5,
67: RA_CUSTOMER_MERGES M6,
68: RA_CUSTOMER_MERGES M7,
69: OE_ORDER_HEADERS H
70: WHERE ( H.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)

Line 67: RA_CUSTOMER_MERGES M6,

63: RA_CUSTOMER_MERGES M2,
64: RA_CUSTOMER_MERGES M3,
65: RA_CUSTOMER_MERGES M4,
66: RA_CUSTOMER_MERGES M5,
67: RA_CUSTOMER_MERGES M6,
68: RA_CUSTOMER_MERGES M7,
69: OE_ORDER_HEADERS H
70: WHERE ( H.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)
71: AND H.INVOICE_TO_ORG_ID = M2.DUPLICATE_SITE_ID(+)

Line 68: RA_CUSTOMER_MERGES M7,

64: RA_CUSTOMER_MERGES M3,
65: RA_CUSTOMER_MERGES M4,
66: RA_CUSTOMER_MERGES M5,
67: RA_CUSTOMER_MERGES M6,
68: RA_CUSTOMER_MERGES M7,
69: OE_ORDER_HEADERS H
70: WHERE ( H.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)
71: AND H.INVOICE_TO_ORG_ID = M2.DUPLICATE_SITE_ID(+)
72: AND H.SHIP_TO_ORG_ID = M3.DUPLICATE_SITE_ID(+)

Line 119: FROM RA_CUSTOMER_MERGES M1,

115: H.END_CUSTOMER_ID,
116: NVL(M1.CUSTOMER_MERGE_ID,NVL(M2.CUSTOMER_MERGE_ID,NVL(M3.CUSTOMER_MERGE_ID,
117: NVL(M4.CUSTOMER_MERGE_ID,nvl(M5.CUSTOMER_MERGE_ID,
118: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
119: FROM RA_CUSTOMER_MERGES M1,
120: RA_CUSTOMER_MERGES M2,
121: RA_CUSTOMER_MERGES M3,
122: RA_CUSTOMER_MERGES M4,
123: RA_CUSTOMER_MERGES M5,

Line 120: RA_CUSTOMER_MERGES M2,

116: NVL(M1.CUSTOMER_MERGE_ID,NVL(M2.CUSTOMER_MERGE_ID,NVL(M3.CUSTOMER_MERGE_ID,
117: NVL(M4.CUSTOMER_MERGE_ID,nvl(M5.CUSTOMER_MERGE_ID,
118: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
119: FROM RA_CUSTOMER_MERGES M1,
120: RA_CUSTOMER_MERGES M2,
121: RA_CUSTOMER_MERGES M3,
122: RA_CUSTOMER_MERGES M4,
123: RA_CUSTOMER_MERGES M5,
124: RA_CUSTOMER_MERGES M6,

Line 121: RA_CUSTOMER_MERGES M3,

117: NVL(M4.CUSTOMER_MERGE_ID,nvl(M5.CUSTOMER_MERGE_ID,
118: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
119: FROM RA_CUSTOMER_MERGES M1,
120: RA_CUSTOMER_MERGES M2,
121: RA_CUSTOMER_MERGES M3,
122: RA_CUSTOMER_MERGES M4,
123: RA_CUSTOMER_MERGES M5,
124: RA_CUSTOMER_MERGES M6,
125: RA_CUSTOMER_MERGES M7,

Line 122: RA_CUSTOMER_MERGES M4,

118: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
119: FROM RA_CUSTOMER_MERGES M1,
120: RA_CUSTOMER_MERGES M2,
121: RA_CUSTOMER_MERGES M3,
122: RA_CUSTOMER_MERGES M4,
123: RA_CUSTOMER_MERGES M5,
124: RA_CUSTOMER_MERGES M6,
125: RA_CUSTOMER_MERGES M7,
126: OE_ORDER_HEADERS H

Line 123: RA_CUSTOMER_MERGES M5,

119: FROM RA_CUSTOMER_MERGES M1,
120: RA_CUSTOMER_MERGES M2,
121: RA_CUSTOMER_MERGES M3,
122: RA_CUSTOMER_MERGES M4,
123: RA_CUSTOMER_MERGES M5,
124: RA_CUSTOMER_MERGES M6,
125: RA_CUSTOMER_MERGES M7,
126: OE_ORDER_HEADERS H
127: WHERE ( H.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)

Line 124: RA_CUSTOMER_MERGES M6,

120: RA_CUSTOMER_MERGES M2,
121: RA_CUSTOMER_MERGES M3,
122: RA_CUSTOMER_MERGES M4,
123: RA_CUSTOMER_MERGES M5,
124: RA_CUSTOMER_MERGES M6,
125: RA_CUSTOMER_MERGES M7,
126: OE_ORDER_HEADERS H
127: WHERE ( H.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)
128: AND H.INVOICE_TO_ORG_ID = M2.DUPLICATE_SITE_ID(+)

Line 125: RA_CUSTOMER_MERGES M7,

121: RA_CUSTOMER_MERGES M3,
122: RA_CUSTOMER_MERGES M4,
123: RA_CUSTOMER_MERGES M5,
124: RA_CUSTOMER_MERGES M6,
125: RA_CUSTOMER_MERGES M7,
126: OE_ORDER_HEADERS H
127: WHERE ( H.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)
128: AND H.INVOICE_TO_ORG_ID = M2.DUPLICATE_SITE_ID(+)
129: AND H.SHIP_TO_ORG_ID = M3.DUPLICATE_SITE_ID(+)

Line 456: from ra_customer_merges m

452: IS
453: --3196900
454: CURSOR MERGE_SITES IS
455: select duplicate_id, customer_id, duplicate_site_id, customer_site_id
456: from ra_customer_merges m
457: where m.process_flag = 'N'
458: and m.request_id = req_id
459: and m.set_number = set_num;
460: /* MOAC_SQL_CHANGE */

Line 478: FROM RA_CUSTOMER_MERGES M1,

474: hist.sold_to_site_use_id,
475: hist.deliver_to_org_id,
476: hist.end_customer_site_use_id,
477: hist.end_customer_id
478: FROM RA_CUSTOMER_MERGES M1,
479: RA_CUSTOMER_MERGES M2,
480: RA_CUSTOMER_MERGES M3,
481: RA_CUSTOMER_MERGES M4,
482: RA_CUSTOMER_MERGES M5,

Line 479: RA_CUSTOMER_MERGES M2,

475: hist.deliver_to_org_id,
476: hist.end_customer_site_use_id,
477: hist.end_customer_id
478: FROM RA_CUSTOMER_MERGES M1,
479: RA_CUSTOMER_MERGES M2,
480: RA_CUSTOMER_MERGES M3,
481: RA_CUSTOMER_MERGES M4,
482: RA_CUSTOMER_MERGES M5,
483: RA_CUSTOMER_MERGES M6,

Line 480: RA_CUSTOMER_MERGES M3,

476: hist.end_customer_site_use_id,
477: hist.end_customer_id
478: FROM RA_CUSTOMER_MERGES M1,
479: RA_CUSTOMER_MERGES M2,
480: RA_CUSTOMER_MERGES M3,
481: RA_CUSTOMER_MERGES M4,
482: RA_CUSTOMER_MERGES M5,
483: RA_CUSTOMER_MERGES M6,
484: RA_CUSTOMER_MERGES M7,

Line 481: RA_CUSTOMER_MERGES M4,

477: hist.end_customer_id
478: FROM RA_CUSTOMER_MERGES M1,
479: RA_CUSTOMER_MERGES M2,
480: RA_CUSTOMER_MERGES M3,
481: RA_CUSTOMER_MERGES M4,
482: RA_CUSTOMER_MERGES M5,
483: RA_CUSTOMER_MERGES M6,
484: RA_CUSTOMER_MERGES M7,
485: OE_ORDER_HEADER_HISTORY HIST,

Line 482: RA_CUSTOMER_MERGES M5,

478: FROM RA_CUSTOMER_MERGES M1,
479: RA_CUSTOMER_MERGES M2,
480: RA_CUSTOMER_MERGES M3,
481: RA_CUSTOMER_MERGES M4,
482: RA_CUSTOMER_MERGES M5,
483: RA_CUSTOMER_MERGES M6,
484: RA_CUSTOMER_MERGES M7,
485: OE_ORDER_HEADER_HISTORY HIST,
486: -- Changed by Srini for MOAC

Line 483: RA_CUSTOMER_MERGES M6,

479: RA_CUSTOMER_MERGES M2,
480: RA_CUSTOMER_MERGES M3,
481: RA_CUSTOMER_MERGES M4,
482: RA_CUSTOMER_MERGES M5,
483: RA_CUSTOMER_MERGES M6,
484: RA_CUSTOMER_MERGES M7,
485: OE_ORDER_HEADER_HISTORY HIST,
486: -- Changed by Srini for MOAC
487: -- This MOAC change has been reverted.

Line 484: RA_CUSTOMER_MERGES M7,

480: RA_CUSTOMER_MERGES M3,
481: RA_CUSTOMER_MERGES M4,
482: RA_CUSTOMER_MERGES M5,
483: RA_CUSTOMER_MERGES M6,
484: RA_CUSTOMER_MERGES M7,
485: OE_ORDER_HEADER_HISTORY HIST,
486: -- Changed by Srini for MOAC
487: -- This MOAC change has been reverted.
488: -- For more information please

Line 550: FROM RA_CUSTOMER_MERGES M1,

546: hist.sold_to_site_use_id,
547: hist.deliver_to_org_id,
548: hist.end_customer_site_use_id,
549: hist.end_customer_id
550: FROM RA_CUSTOMER_MERGES M1,
551: RA_CUSTOMER_MERGES M2,
552: RA_CUSTOMER_MERGES M3,
553: RA_CUSTOMER_MERGES M4,
554: RA_CUSTOMER_MERGES M5,

Line 551: RA_CUSTOMER_MERGES M2,

547: hist.deliver_to_org_id,
548: hist.end_customer_site_use_id,
549: hist.end_customer_id
550: FROM RA_CUSTOMER_MERGES M1,
551: RA_CUSTOMER_MERGES M2,
552: RA_CUSTOMER_MERGES M3,
553: RA_CUSTOMER_MERGES M4,
554: RA_CUSTOMER_MERGES M5,
555: RA_CUSTOMER_MERGES M6,

Line 552: RA_CUSTOMER_MERGES M3,

548: hist.end_customer_site_use_id,
549: hist.end_customer_id
550: FROM RA_CUSTOMER_MERGES M1,
551: RA_CUSTOMER_MERGES M2,
552: RA_CUSTOMER_MERGES M3,
553: RA_CUSTOMER_MERGES M4,
554: RA_CUSTOMER_MERGES M5,
555: RA_CUSTOMER_MERGES M6,
556: RA_CUSTOMER_MERGES M7,

Line 553: RA_CUSTOMER_MERGES M4,

549: hist.end_customer_id
550: FROM RA_CUSTOMER_MERGES M1,
551: RA_CUSTOMER_MERGES M2,
552: RA_CUSTOMER_MERGES M3,
553: RA_CUSTOMER_MERGES M4,
554: RA_CUSTOMER_MERGES M5,
555: RA_CUSTOMER_MERGES M6,
556: RA_CUSTOMER_MERGES M7,
557: OE_ORDER_HEADER_HISTORY HIST,

Line 554: RA_CUSTOMER_MERGES M5,

550: FROM RA_CUSTOMER_MERGES M1,
551: RA_CUSTOMER_MERGES M2,
552: RA_CUSTOMER_MERGES M3,
553: RA_CUSTOMER_MERGES M4,
554: RA_CUSTOMER_MERGES M5,
555: RA_CUSTOMER_MERGES M6,
556: RA_CUSTOMER_MERGES M7,
557: OE_ORDER_HEADER_HISTORY HIST,
558: --Changed for MOAC

Line 555: RA_CUSTOMER_MERGES M6,

551: RA_CUSTOMER_MERGES M2,
552: RA_CUSTOMER_MERGES M3,
553: RA_CUSTOMER_MERGES M4,
554: RA_CUSTOMER_MERGES M5,
555: RA_CUSTOMER_MERGES M6,
556: RA_CUSTOMER_MERGES M7,
557: OE_ORDER_HEADER_HISTORY HIST,
558: --Changed for MOAC
559: OE_ORDER_HEADERS_ALL H

Line 556: RA_CUSTOMER_MERGES M7,

552: RA_CUSTOMER_MERGES M3,
553: RA_CUSTOMER_MERGES M4,
554: RA_CUSTOMER_MERGES M5,
555: RA_CUSTOMER_MERGES M6,
556: RA_CUSTOMER_MERGES M7,
557: OE_ORDER_HEADER_HISTORY HIST,
558: --Changed for MOAC
559: OE_ORDER_HEADERS_ALL H
560: WHERE

Line 754: from ra_customer_merges m

750: select HEADER_ID
751: from oe_order_header_history
752: where ship_to_org_id in
753: (select m.duplicate_site_id
754: from ra_customer_merges m
755: where m.process_flag = 'N'
756: and m.request_id = req_id
757: and m.set_number = set_num)
758: for update nowait;

Line 766: from ra_customer_merges m

762: select HEADER_ID
763: from oe_order_header_history
764: where invoice_to_org_id in
765: (select m.duplicate_site_id
766: from ra_customer_merges m
767: where m.process_flag = 'N'
768: and m.request_id = req_id
769: and m.set_number = set_num)
770: for update nowait;

Line 778: from ra_customer_merges m

774: select HEADER_ID
775: from oe_order_header_history
776: where deliver_to_org_id in
777: (select m.duplicate_site_id
778: from ra_customer_merges m
779: where m.process_flag = 'N'
780: and m.request_id = req_id
781: and m.set_number = set_num)
782: for update nowait;

Line 790: from ra_customer_merges m

786: select HEADER_ID
787: from oe_order_header_history
788: where sold_to_org_id in
789: (select m.duplicate_id
790: from ra_customer_merges m
791: where m.process_flag = 'N'
792: and m.request_id = req_id
793: and m.set_number = set_num)
794: for update nowait;

Line 801: from ra_customer_merges m

797: select HEADER_ID
798: from oe_order_header_history
799: where sold_to_site_use_id in
800: (select m.duplicate_id
801: from ra_customer_merges m
802: where m.process_flag = 'N'
803: and m.request_id = req_id
804: and m.set_number = set_num)
805: for update nowait;

Line 812: from ra_customer_merges m

808: select HEADER_ID
809: from oe_order_header_history
810: where end_customer_site_use_id in
811: (select m.duplicate_id
812: from ra_customer_merges m
813: where m.process_flag = 'N'
814: and m.request_id = req_id
815: and m.set_number = set_num)
816: for update nowait;

Line 823: from ra_customer_merges m

819: select HEADER_ID
820: from oe_order_header_history
821: where end_customer_id in
822: (select m.duplicate_id
823: from ra_customer_merges m
824: where m.process_flag = 'N'
825: and m.request_id = req_id
826: and m.set_number = set_num)
827: for update nowait;

Line 869: from ra_customer_merges m

865: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
866:
867: UPDATE oe_order_header_history a
868: set ship_to_org_id = (select distinct m.customer_site_id
869: from ra_customer_merges m
870: where a.ship_to_org_id = m.duplicate_site_id
871: and m.request_id = req_id
872: and m.process_flag = 'N'
873: and m.set_number = set_num),

Line 882: from ra_customer_merges m

878: program_application_id =arp_standard.profile.program_application_id,
879: program_id = arp_standard.profile.program_id,
880: program_update_date = sysdate
881: where ship_to_org_id in (select m.duplicate_site_id
882: from ra_customer_merges m
883: where m.process_flag = 'N'
884: and m.request_id = req_id
885: and m.set_number = set_num);
886: g_count := sql%rowcount;

Line 896: from ra_customer_merges m

892: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
893:
894: UPDATE oe_order_header_history a
895: set invoice_to_org_id = (select distinct m.customer_site_id
896: from ra_customer_merges m
897: where a.invoice_to_org_id = m.duplicate_site_id
898: and m.request_id = req_id
899: and m.process_flag = 'N'
900: and m.set_number = set_num),

Line 909: from ra_customer_merges m

905: program_application_id =arp_standard.profile.program_application_id,
906: program_id = arp_standard.profile.program_id,
907: program_update_date = sysdate
908: where invoice_to_org_id in (select m.duplicate_site_id
909: from ra_customer_merges m
910: where m.process_flag = 'N'
911: and m.request_id = req_id
912: and m.set_number = set_num);
913: g_count := sql%rowcount;

Line 922: from ra_customer_merges m

918: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
919:
920: UPDATE oe_order_header_history a
921: set deliver_to_org_id = (select distinct m.customer_site_id
922: from ra_customer_merges m
923: where a.deliver_to_org_id = m.duplicate_site_id
924: and m.request_id = req_id
925: and m.process_flag = 'N'
926: and m.set_number = set_num),

Line 935: from ra_customer_merges m

931: program_application_id =arp_standard.profile.program_application_id,
932: program_id = arp_standard.profile.program_id,
933: program_update_date = sysdate
934: where deliver_to_org_id in (select m.duplicate_site_id
935: from ra_customer_merges m
936: where m.process_flag = 'N'
937: and m.request_id = req_id
938: and m.set_number = set_num);
939: g_count := sql%rowcount;

Line 954: from ra_customer_merges m

950: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
951:
952: UPDATE oe_order_header_history a
953: set sold_to_org_id = (select distinct m.customer_id
954: from ra_customer_merges m
955: where a.sold_to_org_id = m.duplicate_id
956: and m.process_flag = 'N'
957: and m.request_id = req_id
958: and m.set_number = set_num),

Line 967: from ra_customer_merges m

963: program_application_id =arp_standard.profile.program_application_id,
964: program_id = arp_standard.profile.program_id,
965: program_update_date = sysdate
966: where sold_to_org_id in (select m.duplicate_id
967: from ra_customer_merges m
968: where m.process_flag = 'N'
969: and m.request_id = req_id
970: and m.set_number = set_num);
971:

Line 982: from ra_customer_merges m

978: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
979:
980: UPDATE oe_order_header_history a
981: set sold_to_site_use_id = (select distinct m.customer_id
982: from ra_customer_merges m
983: where a.sold_to_site_use_id = m.duplicate_id
984: and m.process_flag = 'N'
985: and m.request_id = req_id
986: and m.set_number = set_num),

Line 995: from ra_customer_merges m

991: program_application_id =arp_standard.profile.program_application_id,
992: program_id = arp_standard.profile.program_id,
993: program_update_date = sysdate
994: where sold_to_site_use_id in (select m.duplicate_id
995: from ra_customer_merges m
996: where m.process_flag = 'N'
997: and m.request_id = req_id
998: and m.set_number = set_num);
999:

Line 1010: from ra_customer_merges m

1006: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1007:
1008: UPDATE oe_order_header_history a
1009: set end_customer_site_use_id = (select distinct m.customer_id
1010: from ra_customer_merges m
1011: where a.end_customer_site_use_id = m.duplicate_id
1012: and m.process_flag = 'N'
1013: and m.request_id = req_id
1014: and m.set_number = set_num),

Line 1023: from ra_customer_merges m

1019: program_application_id =arp_standard.profile.program_application_id,
1020: program_id = arp_standard.profile.program_id,
1021: program_update_date = sysdate
1022: where end_customer_site_use_id in (select m.duplicate_id
1023: from ra_customer_merges m
1024: where m.process_flag = 'N'
1025: and m.request_id = req_id
1026: and m.set_number = set_num);
1027:

Line 1040: from ra_customer_merges m

1036: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
1037:
1038: UPDATE oe_order_header_history a
1039: set end_customer_id = (select distinct m.customer_id
1040: from ra_customer_merges m
1041: where a.end_customer_id = m.duplicate_id
1042: and m.process_flag = 'N'
1043: and m.request_id = req_id
1044: and m.set_number = set_num),

Line 1053: from ra_customer_merges m

1049: program_application_id =arp_standard.profile.program_application_id,
1050: program_id = arp_standard.profile.program_id,
1051: program_update_date = sysdate
1052: where end_customer_id in (select m.duplicate_id
1053: from ra_customer_merges m
1054: where m.process_flag = 'N'
1055: and m.request_id = req_id
1056: and m.set_number = set_num);
1057:

Line 1090: from ra_customer_merges m

1086: select HEADER_ID
1087: from oe_headers_iface_all
1088: where ship_to_org_id in
1089: (select m.duplicate_site_id
1090: from ra_customer_merges m
1091: where m.process_flag = 'N'
1092: and m.request_id = req_id
1093: and m.set_number = set_num)
1094: for update nowait;

Line 1102: from ra_customer_merges m

1098: select HEADER_ID
1099: from oe_headers_iface_all
1100: where invoice_to_org_id in
1101: (select m.duplicate_site_id
1102: from ra_customer_merges m
1103: where m.process_flag = 'N'
1104: and m.request_id = req_id
1105: and m.set_number = set_num)
1106: for update nowait;

Line 1114: from ra_customer_merges m

1110: select HEADER_ID
1111: from oe_headers_iface_all
1112: where deliver_to_org_id in
1113: (select m.duplicate_site_id
1114: from ra_customer_merges m
1115: where m.process_flag = 'N'
1116: and m.request_id = req_id
1117: and m.set_number = set_num)
1118: for update nowait;

Line 1125: from ra_customer_merges m

1121: select HEADER_ID
1122: from oe_headers_iface_all
1123: where sold_to_org_id in
1124: (select m.duplicate_id
1125: from ra_customer_merges m
1126: where m.process_flag = 'N'
1127: and m.request_id = req_id
1128: and m.set_number = set_num)
1129: for update nowait;

Line 1165: from ra_customer_merges m

1161: arp_message.set_token( 'TABLE_NAME', 'oe_headers_iface_all', FALSE );
1162:
1163: UPDATE oe_headers_iface_all a
1164: set ship_to_org_id = (select distinct m.customer_site_id
1165: from ra_customer_merges m
1166: where a.ship_to_org_id = m.duplicate_site_id
1167: and m.request_id = req_id
1168: and m.process_flag = 'N'
1169: and m.set_number = set_num),

Line 1178: from ra_customer_merges m

1174: program_application_id =arp_standard.profile.program_application_id,
1175: program_id = arp_standard.profile.program_id,
1176: program_update_date = sysdate
1177: where ship_to_org_id in (select m.duplicate_site_id
1178: from ra_customer_merges m
1179: where m.process_flag = 'N'
1180: and m.request_id = req_id
1181: and m.set_number = set_num);
1182: g_count := sql%rowcount;

Line 1191: from ra_customer_merges m

1187: arp_message.set_token( 'TABLE_NAME', 'oe_headers_iface_all', FALSE );
1188:
1189: UPDATE oe_headers_iface_all a
1190: set invoice_to_org_id = (select distinct m.customer_site_id
1191: from ra_customer_merges m
1192: where a.invoice_to_org_id = m.duplicate_site_id
1193: and m.request_id = req_id
1194: and m.process_flag = 'N'
1195: and m.set_number = set_num),

Line 1204: from ra_customer_merges m

1200: program_application_id =arp_standard.profile.program_application_id,
1201: program_id = arp_standard.profile.program_id,
1202: program_update_date = sysdate
1203: where invoice_to_org_id in (select m.duplicate_site_id
1204: from ra_customer_merges m
1205: where m.process_flag = 'N'
1206: and m.request_id = req_id
1207: and m.set_number = set_num);
1208: g_count := sql%rowcount;

Line 1217: from ra_customer_merges m

1213: arp_message.set_token( 'TABLE_NAME', 'oe_headers_iface_all', FALSE );
1214:
1215: UPDATE oe_headers_iface_all a
1216: set deliver_to_org_id = (select distinct m.customer_site_id
1217: from ra_customer_merges m
1218: where a.deliver_to_org_id = m.duplicate_site_id
1219: and m.request_id = req_id
1220: and m.process_flag = 'N'
1221: and m.set_number = set_num),

Line 1230: from ra_customer_merges m

1226: program_application_id =arp_standard.profile.program_application_id,
1227: program_id = arp_standard.profile.program_id,
1228: program_update_date = sysdate
1229: where deliver_to_org_id in (select m.duplicate_site_id
1230: from ra_customer_merges m
1231: where m.process_flag = 'N'
1232: and m.request_id = req_id
1233: and m.set_number = set_num);
1234: g_count := sql%rowcount;

Line 1248: from ra_customer_merges m

1244: arp_message.set_token( 'TABLE_NAME', 'oe_headers_iface_all', FALSE );
1245:
1246: UPDATE oe_headers_iface_all a
1247: set sold_to_org_id = (select distinct m.customer_id
1248: from ra_customer_merges m
1249: where a.sold_to_org_id = m.duplicate_id
1250: and m.process_flag = 'N'
1251: and m.request_id = req_id
1252: and m.set_number = set_num),

Line 1261: from ra_customer_merges m

1257: program_application_id =arp_standard.profile.program_application_id,
1258: program_id = arp_standard.profile.program_id,
1259: program_update_date = sysdate
1260: where sold_to_org_id in (select m.duplicate_id
1261: from ra_customer_merges m
1262: where m.process_flag = 'N'
1263: and m.request_id = req_id
1264: and m.set_number = set_num);
1265:

Line 1298: from ra_customer_merges m

1294: select HEADER_ID
1295: from OE_HEADER_ACKS
1296: where ship_to_org_id in
1297: (select m.duplicate_site_id
1298: from ra_customer_merges m
1299: where m.process_flag = 'N'
1300: and m.request_id = req_id
1301: and m.set_number = set_num)
1302: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1311: from ra_customer_merges m

1307: select HEADER_ID
1308: from OE_HEADER_ACKS
1309: where invoice_to_org_id in
1310: (select m.duplicate_site_id
1311: from ra_customer_merges m
1312: where m.process_flag = 'N'
1313: and m.request_id = req_id
1314: and m.set_number = set_num)
1315: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1324: from ra_customer_merges m

1320: select HEADER_ID
1321: from OE_HEADER_ACKS
1322: where deliver_to_org_id in
1323: (select m.duplicate_site_id
1324: from ra_customer_merges m
1325: where m.process_flag = 'N'
1326: and m.request_id = req_id
1327: and m.set_number = set_num)
1328: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1337: from ra_customer_merges m

1333: select /* MOAC_SQL_CHANGE */ a.HEADER_ID
1334: from OE_HEADER_ACKS a, OE_ORDER_HEADERS_all h
1335: where a.sold_to_org_id in
1336: (select m.duplicate_id
1337: from ra_customer_merges m
1338: where m.process_flag = 'N'
1339: and m.request_id = req_id
1340: and m.set_number = set_num)
1341: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1351: from ra_customer_merges m

1347: select HEADER_ID
1348: from OE_HEADER_ACKS
1349: where sold_to_site_use_id in
1350: (select m.duplicate_id
1351: from ra_customer_merges m
1352: where m.process_flag = 'N'
1353: and m.request_id = req_id
1354: and m.set_number = set_num)
1355: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1363: from ra_customer_merges m

1359: select HEADER_ID
1360: from OE_HEADER_ACKS
1361: where end_customer_site_use_id in
1362: (select m.duplicate_id
1363: from ra_customer_merges m
1364: where m.process_flag = 'N'
1365: and m.request_id = req_id
1366: and m.set_number = set_num)
1367: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1376: from ra_customer_merges m

1372: select a.HEADER_ID
1373: from OE_HEADER_ACKS a,OE_ORDER_HEADERS h
1374: where a.end_customer_id in
1375: (select m.duplicate_id
1376: from ra_customer_merges m
1377: where m.process_flag = 'N'
1378: and m.request_id = req_id
1379: and m.set_number = set_num)
1380: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1454: ra_customer_merges m

1450: hz_utility_pub.LAST_UPDATE_LOGIN,
1451: hz_utility_pub.LAST_UPDATE_DATE,
1452: hz_utility_pub.LAST_UPDATED_BY
1453: from oe_header_acks h,
1454: ra_customer_merges m
1455: where h.ship_to_org_id=m.duplicate_site_id
1456: and m.process_flag = 'N'
1457: and m.request_id = req_id
1458: and m.set_number = set_num

Line 1468: from ra_customer_merges m

1464: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1465:
1466: UPDATE OE_HEADER_ACKS a
1467: set ship_to_org_id = (select distinct m.customer_site_id
1468: from ra_customer_merges m
1469: where a.ship_to_org_id = m.duplicate_site_id
1470: and m.request_id = req_id
1471: and m.process_flag = 'N'
1472: and m.set_number = set_num),

Line 1481: from ra_customer_merges m

1477: program_application_id =arp_standard.profile.program_application_id,
1478: program_id = arp_standard.profile.program_id,
1479: program_update_date = sysdate
1480: where ship_to_org_id in (select m.duplicate_site_id
1481: from ra_customer_merges m
1482: where m.process_flag = 'N'
1483: and m.request_id = req_id
1484: and m.set_number = set_num)
1485: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 1521: ra_customer_merges m

1517: hz_utility_pub.LAST_UPDATE_LOGIN,
1518: hz_utility_pub.LAST_UPDATE_DATE,
1519: hz_utility_pub.LAST_UPDATED_BY
1520: from oe_header_acks h,
1521: ra_customer_merges m
1522: where h.invoice_to_org_id=m.duplicate_site_id
1523: and m.process_flag = 'N'
1524: and m.request_id = req_id
1525: and m.set_number = set_num

Line 1534: from ra_customer_merges m

1530: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1531:
1532: UPDATE OE_HEADER_ACKS a
1533: set invoice_to_org_id = (select distinct m.customer_site_id
1534: from ra_customer_merges m
1535: where a.invoice_to_org_id = m.duplicate_site_id
1536: and m.request_id = req_id
1537: and m.process_flag = 'N'
1538: and m.set_number = set_num),

Line 1547: from ra_customer_merges m

1543: program_application_id =arp_standard.profile.program_application_id,
1544: program_id = arp_standard.profile.program_id,
1545: program_update_date = sysdate
1546: where invoice_to_org_id in (select m.duplicate_site_id
1547: from ra_customer_merges m
1548: where m.process_flag = 'N'
1549: and m.request_id = req_id
1550: and m.set_number = set_num)
1551: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 1590: ra_customer_merges m

1586: hz_utility_pub.LAST_UPDATE_LOGIN,
1587: hz_utility_pub.LAST_UPDATE_DATE,
1588: hz_utility_pub.LAST_UPDATED_BY
1589: from oe_header_acks h,
1590: ra_customer_merges m
1591: where h.deliver_to_org_id=m.duplicate_site_id
1592: and m.process_flag = 'N'
1593: and m.request_id = req_id
1594: and m.set_number = set_num

Line 1600: from ra_customer_merges m

1596: end if;
1597:
1598: UPDATE OE_HEADER_ACKS a
1599: set deliver_to_org_id = (select distinct m.customer_site_id
1600: from ra_customer_merges m
1601: where a.deliver_to_org_id = m.duplicate_site_id
1602: and m.request_id = req_id
1603: and m.process_flag = 'N'
1604: and m.set_number = set_num),

Line 1613: from ra_customer_merges m

1609: program_application_id =arp_standard.profile.program_application_id,
1610: program_id = arp_standard.profile.program_id,
1611: program_update_date = sysdate
1612: where deliver_to_org_id in (select m.duplicate_site_id
1613: from ra_customer_merges m
1614: where m.process_flag = 'N'
1615: and m.request_id = req_id
1616: and m.set_number = set_num)
1617: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 1661: ra_customer_merges m

1657: hz_utility_pub.LAST_UPDATE_LOGIN,
1658: hz_utility_pub.LAST_UPDATE_DATE,
1659: hz_utility_pub.LAST_UPDATED_BY
1660: from oe_header_acks h,
1661: ra_customer_merges m
1662: where h.sold_to_org_id=m.duplicate_site_id
1663: and m.process_flag = 'N'
1664: and m.request_id = req_id
1665: and m.set_number = set_num

Line 1671: from ra_customer_merges m

1667: end if;
1668:
1669: UPDATE OE_HEADER_ACKS a
1670: set sold_to_org_id = (select distinct m.customer_id
1671: from ra_customer_merges m
1672: where a.sold_to_org_id = m.duplicate_id
1673: and m.process_flag = 'N'
1674: and m.request_id = req_id
1675: and m.set_number = set_num),

Line 1684: from ra_customer_merges m

1680: program_application_id =arp_standard.profile.program_application_id,
1681: program_id = arp_standard.profile.program_id,
1682: program_update_date = sysdate
1683: where sold_to_org_id in (select m.duplicate_id
1684: from ra_customer_merges m
1685: where m.process_flag = 'N'
1686: and m.request_id = req_id
1687: and m.set_number = set_num)
1688: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1733: ra_customer_merges m

1729: hz_utility_pub.LAST_UPDATE_LOGIN,
1730: hz_utility_pub.LAST_UPDATE_DATE,
1731: hz_utility_pub.LAST_UPDATED_BY
1732: from oe_header_acks h,
1733: ra_customer_merges m
1734: where
1735: h.sold_to_site_use_id=m.duplicate_site_id
1736: and
1737: m.process_flag = 'N'

Line 1745: from ra_customer_merges m

1741: end if;
1742:
1743: UPDATE OE_HEADER_ACKS a
1744: set sold_to_site_use_id = (select distinct m.customer_id
1745: from ra_customer_merges m
1746: where a.sold_to_site_use_id = m.duplicate_id
1747: and m.process_flag = 'N'
1748: and m.request_id = req_id
1749: and m.set_number = set_num),

Line 1758: from ra_customer_merges m

1754: program_application_id =arp_standard.profile.program_application_id,
1755: program_id = arp_standard.profile.program_id,
1756: program_update_date = sysdate
1757: where sold_to_site_use_id in (select m.duplicate_id
1758: from ra_customer_merges m
1759: where m.process_flag = 'N'
1760: and m.request_id = req_id
1761: and m.set_number = set_num)
1762: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 1806: ra_customer_merges m

1802: hz_utility_pub.LAST_UPDATE_LOGIN,
1803: hz_utility_pub.LAST_UPDATE_DATE,
1804: hz_utility_pub.LAST_UPDATED_BY
1805: from oe_header_acks h,
1806: ra_customer_merges m
1807: where
1808: h.end_customer_site_use_id=m.duplicate_site_id
1809: and
1810: m.process_flag = 'N'

Line 1818: from ra_customer_merges m

1814: end if;
1815:
1816: UPDATE OE_HEADER_ACKS a
1817: set end_customer_site_use_id = (select distinct m.customer_id
1818: from ra_customer_merges m
1819: where a.end_customer_site_use_id = m.duplicate_id
1820: and m.process_flag = 'N'
1821: and m.request_id = req_id
1822: and m.set_number = set_num),

Line 1832: from ra_customer_merges m

1828: program_id = arp_standard.profile.program_id,
1829: program_update_date = sysdate
1830: where
1831: end_customer_site_use_id in (select m.duplicate_id
1832: from ra_customer_merges m
1833: where m.process_flag = 'N'
1834: and m.request_id = req_id
1835: and m.set_number = set_num)
1836: and

Line 1879: ra_customer_merges m

1875: hz_utility_pub.LAST_UPDATE_LOGIN,
1876: hz_utility_pub.LAST_UPDATE_DATE,
1877: hz_utility_pub.LAST_UPDATED_BY
1878: from oe_header_acks h,
1879: ra_customer_merges m
1880: where
1881: h.end_customer_id=m.duplicate_site_id
1882: and
1883: m.process_flag = 'N'

Line 1891: from ra_customer_merges m

1887: end if;
1888:
1889: UPDATE OE_HEADER_ACKS a
1890: set end_customer_id = (select distinct m.customer_id
1891: from ra_customer_merges m
1892: where a.end_customer_id = m.duplicate_id
1893: and m.process_flag = 'N'
1894: and m.request_id = req_id
1895: and m.set_number = set_num),

Line 1904: from ra_customer_merges m

1900: program_application_id =arp_standard.profile.program_application_id,
1901: program_id = arp_standard.profile.program_id,
1902: program_update_date = sysdate
1903: where end_customer_id in (select m.duplicate_id
1904: from ra_customer_merges m
1905: where m.process_flag = 'N'
1906: and m.request_id = req_id
1907: and m.set_number = set_num)
1908: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 1939: from ra_customer_merges m

1935: IS
1936:
1937: CURSOR MERGE_SITES IS
1938: select duplicate_id, customer_id, duplicate_site_id, customer_site_id
1939: from ra_customer_merges m
1940: where m.process_flag = 'N'
1941: and m.request_id = req_id
1942: and m.set_number = set_num;
1943:

Line 1961: FROM RA_CUSTOMER_MERGES M,

1957: deliver_to_org_id,
1958: end_customer_site_use_id,
1959: end_customer_id,
1960: m.customer_merge_id
1961: FROM RA_CUSTOMER_MERGES M,
1962: -- change for bug 3196900
1963: -- OE_ORDER_LINES_ALL L
1964: OE_ORDER_LINES L
1965: WHERE

Line 1990: FROM RA_CUSTOMER_MERGES M1,

1986: END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_ID,
1987: NVL(M1.CUSTOMER_MERGE_ID,NVL(M2.CUSTOMER_MERGE_ID,NVL(M3.CUSTOMER_MERGE_ID,
1988: NVL(M4.CUSTOMER_MERGE_ID,NVL(M5.CUSTOMER_MERGE_ID,
1989: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
1990: FROM RA_CUSTOMER_MERGES M1,
1991: RA_CUSTOMER_MERGES M2,
1992: RA_CUSTOMER_MERGES M3,
1993: RA_CUSTOMER_MERGES M4,
1994: RA_CUSTOMER_MERGES M5,

Line 1991: RA_CUSTOMER_MERGES M2,

1987: NVL(M1.CUSTOMER_MERGE_ID,NVL(M2.CUSTOMER_MERGE_ID,NVL(M3.CUSTOMER_MERGE_ID,
1988: NVL(M4.CUSTOMER_MERGE_ID,NVL(M5.CUSTOMER_MERGE_ID,
1989: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
1990: FROM RA_CUSTOMER_MERGES M1,
1991: RA_CUSTOMER_MERGES M2,
1992: RA_CUSTOMER_MERGES M3,
1993: RA_CUSTOMER_MERGES M4,
1994: RA_CUSTOMER_MERGES M5,
1995: RA_CUSTOMER_MERGES M6,

Line 1992: RA_CUSTOMER_MERGES M3,

1988: NVL(M4.CUSTOMER_MERGE_ID,NVL(M5.CUSTOMER_MERGE_ID,
1989: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
1990: FROM RA_CUSTOMER_MERGES M1,
1991: RA_CUSTOMER_MERGES M2,
1992: RA_CUSTOMER_MERGES M3,
1993: RA_CUSTOMER_MERGES M4,
1994: RA_CUSTOMER_MERGES M5,
1995: RA_CUSTOMER_MERGES M6,
1996: RA_CUSTOMER_MERGES M7,

Line 1993: RA_CUSTOMER_MERGES M4,

1989: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
1990: FROM RA_CUSTOMER_MERGES M1,
1991: RA_CUSTOMER_MERGES M2,
1992: RA_CUSTOMER_MERGES M3,
1993: RA_CUSTOMER_MERGES M4,
1994: RA_CUSTOMER_MERGES M5,
1995: RA_CUSTOMER_MERGES M6,
1996: RA_CUSTOMER_MERGES M7,
1997: OE_ORDER_LINES L

Line 1994: RA_CUSTOMER_MERGES M5,

1990: FROM RA_CUSTOMER_MERGES M1,
1991: RA_CUSTOMER_MERGES M2,
1992: RA_CUSTOMER_MERGES M3,
1993: RA_CUSTOMER_MERGES M4,
1994: RA_CUSTOMER_MERGES M5,
1995: RA_CUSTOMER_MERGES M6,
1996: RA_CUSTOMER_MERGES M7,
1997: OE_ORDER_LINES L
1998: WHERE ( L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)

Line 1995: RA_CUSTOMER_MERGES M6,

1991: RA_CUSTOMER_MERGES M2,
1992: RA_CUSTOMER_MERGES M3,
1993: RA_CUSTOMER_MERGES M4,
1994: RA_CUSTOMER_MERGES M5,
1995: RA_CUSTOMER_MERGES M6,
1996: RA_CUSTOMER_MERGES M7,
1997: OE_ORDER_LINES L
1998: WHERE ( L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)
1999: AND L.INVOICE_TO_ORG_ID = M2.DUPLICATE_SITE_ID(+)

Line 1996: RA_CUSTOMER_MERGES M7,

1992: RA_CUSTOMER_MERGES M3,
1993: RA_CUSTOMER_MERGES M4,
1994: RA_CUSTOMER_MERGES M5,
1995: RA_CUSTOMER_MERGES M6,
1996: RA_CUSTOMER_MERGES M7,
1997: OE_ORDER_LINES L
1998: WHERE ( L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)
1999: AND L.INVOICE_TO_ORG_ID = M2.DUPLICATE_SITE_ID(+)
2000: AND L.SHIP_TO_ORG_ID = M3.DUPLICATE_SITE_ID(+)

Line 2052: FROM RA_CUSTOMER_MERGES M,

2048: deliver_to_org_id,
2049: end_customer_site_use_id,
2050: end_customer_id,
2051: m.customer_merge_id
2052: FROM RA_CUSTOMER_MERGES M,
2053: -- changed for bug 3196900
2054: -- OE_ORDER_LINES_ALL L
2055: OE_ORDER_LINES L
2056: WHERE

Line 2080: FROM RA_CUSTOMER_MERGES M1,

2076: END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_ID,
2077: NVL(M1.CUSTOMER_MERGE_ID,NVL(M2.CUSTOMER_MERGE_ID,NVL(M3.CUSTOMER_MERGE_ID,
2078: NVL(M4.CUSTOMER_MERGE_ID,NVL(M5.CUSTOMER_MERGE_ID,
2079: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
2080: FROM RA_CUSTOMER_MERGES M1,
2081: RA_CUSTOMER_MERGES M2,
2082: RA_CUSTOMER_MERGES M3,
2083: RA_CUSTOMER_MERGES M4,
2084: RA_CUSTOMER_MERGES M5,

Line 2081: RA_CUSTOMER_MERGES M2,

2077: NVL(M1.CUSTOMER_MERGE_ID,NVL(M2.CUSTOMER_MERGE_ID,NVL(M3.CUSTOMER_MERGE_ID,
2078: NVL(M4.CUSTOMER_MERGE_ID,NVL(M5.CUSTOMER_MERGE_ID,
2079: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
2080: FROM RA_CUSTOMER_MERGES M1,
2081: RA_CUSTOMER_MERGES M2,
2082: RA_CUSTOMER_MERGES M3,
2083: RA_CUSTOMER_MERGES M4,
2084: RA_CUSTOMER_MERGES M5,
2085: RA_CUSTOMER_MERGES M6,

Line 2082: RA_CUSTOMER_MERGES M3,

2078: NVL(M4.CUSTOMER_MERGE_ID,NVL(M5.CUSTOMER_MERGE_ID,
2079: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
2080: FROM RA_CUSTOMER_MERGES M1,
2081: RA_CUSTOMER_MERGES M2,
2082: RA_CUSTOMER_MERGES M3,
2083: RA_CUSTOMER_MERGES M4,
2084: RA_CUSTOMER_MERGES M5,
2085: RA_CUSTOMER_MERGES M6,
2086: RA_CUSTOMER_MERGES M7,

Line 2083: RA_CUSTOMER_MERGES M4,

2079: NVL(M6.CUSTOMER_MERGE_ID,M7.CUSTOMER_MERGE_ID))))))
2080: FROM RA_CUSTOMER_MERGES M1,
2081: RA_CUSTOMER_MERGES M2,
2082: RA_CUSTOMER_MERGES M3,
2083: RA_CUSTOMER_MERGES M4,
2084: RA_CUSTOMER_MERGES M5,
2085: RA_CUSTOMER_MERGES M6,
2086: RA_CUSTOMER_MERGES M7,
2087: OE_ORDER_LINES L

Line 2084: RA_CUSTOMER_MERGES M5,

2080: FROM RA_CUSTOMER_MERGES M1,
2081: RA_CUSTOMER_MERGES M2,
2082: RA_CUSTOMER_MERGES M3,
2083: RA_CUSTOMER_MERGES M4,
2084: RA_CUSTOMER_MERGES M5,
2085: RA_CUSTOMER_MERGES M6,
2086: RA_CUSTOMER_MERGES M7,
2087: OE_ORDER_LINES L
2088: WHERE ( L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)

Line 2085: RA_CUSTOMER_MERGES M6,

2081: RA_CUSTOMER_MERGES M2,
2082: RA_CUSTOMER_MERGES M3,
2083: RA_CUSTOMER_MERGES M4,
2084: RA_CUSTOMER_MERGES M5,
2085: RA_CUSTOMER_MERGES M6,
2086: RA_CUSTOMER_MERGES M7,
2087: OE_ORDER_LINES L
2088: WHERE ( L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)
2089: AND L.INVOICE_TO_ORG_ID = M2.DUPLICATE_SITE_ID(+)

Line 2086: RA_CUSTOMER_MERGES M7,

2082: RA_CUSTOMER_MERGES M3,
2083: RA_CUSTOMER_MERGES M4,
2084: RA_CUSTOMER_MERGES M5,
2085: RA_CUSTOMER_MERGES M6,
2086: RA_CUSTOMER_MERGES M7,
2087: OE_ORDER_LINES L
2088: WHERE ( L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)
2089: AND L.INVOICE_TO_ORG_ID = M2.DUPLICATE_SITE_ID(+)
2090: AND L.SHIP_TO_ORG_ID = M3.DUPLICATE_SITE_ID(+)

Line 2419: from ra_customer_merges m

2415: IS
2416:
2417: CURSOR MERGE_SITES IS
2418: select duplicate_id, customer_id, duplicate_site_id, customer_site_id
2419: from ra_customer_merges m
2420: where m.process_flag = 'N'
2421: and m.request_id = req_id
2422: and m.set_number = set_num;
2423: /* MOAC_SQL_CHANGE */

Line 2440: RA_CUSTOMER_MERGES M1,

2436: l.deliver_to_org_id,
2437: l.end_customer_site_use_id,
2438: l.end_customer_id
2439: FROM OE_ORDER_LINES_HISTORY L,
2440: RA_CUSTOMER_MERGES M1,
2441: RA_CUSTOMER_MERGES M2,
2442: RA_CUSTOMER_MERGES M3,
2443: RA_CUSTOMER_MERGES M4,
2444: RA_CUSTOMER_MERGES M5,

Line 2441: RA_CUSTOMER_MERGES M2,

2437: l.end_customer_site_use_id,
2438: l.end_customer_id
2439: FROM OE_ORDER_LINES_HISTORY L,
2440: RA_CUSTOMER_MERGES M1,
2441: RA_CUSTOMER_MERGES M2,
2442: RA_CUSTOMER_MERGES M3,
2443: RA_CUSTOMER_MERGES M4,
2444: RA_CUSTOMER_MERGES M5,
2445: RA_CUSTOMER_MERGES M6,

Line 2442: RA_CUSTOMER_MERGES M3,

2438: l.end_customer_id
2439: FROM OE_ORDER_LINES_HISTORY L,
2440: RA_CUSTOMER_MERGES M1,
2441: RA_CUSTOMER_MERGES M2,
2442: RA_CUSTOMER_MERGES M3,
2443: RA_CUSTOMER_MERGES M4,
2444: RA_CUSTOMER_MERGES M5,
2445: RA_CUSTOMER_MERGES M6,
2446: RA_CUSTOMER_MERGES M7,

Line 2443: RA_CUSTOMER_MERGES M4,

2439: FROM OE_ORDER_LINES_HISTORY L,
2440: RA_CUSTOMER_MERGES M1,
2441: RA_CUSTOMER_MERGES M2,
2442: RA_CUSTOMER_MERGES M3,
2443: RA_CUSTOMER_MERGES M4,
2444: RA_CUSTOMER_MERGES M5,
2445: RA_CUSTOMER_MERGES M6,
2446: RA_CUSTOMER_MERGES M7,
2447: -- changed for bug 3196900

Line 2444: RA_CUSTOMER_MERGES M5,

2440: RA_CUSTOMER_MERGES M1,
2441: RA_CUSTOMER_MERGES M2,
2442: RA_CUSTOMER_MERGES M3,
2443: RA_CUSTOMER_MERGES M4,
2444: RA_CUSTOMER_MERGES M5,
2445: RA_CUSTOMER_MERGES M6,
2446: RA_CUSTOMER_MERGES M7,
2447: -- changed for bug 3196900
2448: -- OE_ORDER_LINES_HISTORY L

Line 2445: RA_CUSTOMER_MERGES M6,

2441: RA_CUSTOMER_MERGES M2,
2442: RA_CUSTOMER_MERGES M3,
2443: RA_CUSTOMER_MERGES M4,
2444: RA_CUSTOMER_MERGES M5,
2445: RA_CUSTOMER_MERGES M6,
2446: RA_CUSTOMER_MERGES M7,
2447: -- changed for bug 3196900
2448: -- OE_ORDER_LINES_HISTORY L
2449: OE_ORDER_LINES_ALL LN

Line 2446: RA_CUSTOMER_MERGES M7,

2442: RA_CUSTOMER_MERGES M3,
2443: RA_CUSTOMER_MERGES M4,
2444: RA_CUSTOMER_MERGES M5,
2445: RA_CUSTOMER_MERGES M6,
2446: RA_CUSTOMER_MERGES M7,
2447: -- changed for bug 3196900
2448: -- OE_ORDER_LINES_HISTORY L
2449: OE_ORDER_LINES_ALL LN
2450: -- Changed for MOAC

Line 2509: RA_CUSTOMER_MERGES M1,

2505: l.deliver_to_org_id,
2506: l.end_customer_site_use_id,
2507: l.end_customer_id
2508: FROM OE_ORDER_LINES_HISTORY L ,
2509: RA_CUSTOMER_MERGES M1,
2510: RA_CUSTOMER_MERGES M2,
2511: RA_CUSTOMER_MERGES M3,
2512: RA_CUSTOMER_MERGES M4,
2513: RA_CUSTOMER_MERGES M5,

Line 2510: RA_CUSTOMER_MERGES M2,

2506: l.end_customer_site_use_id,
2507: l.end_customer_id
2508: FROM OE_ORDER_LINES_HISTORY L ,
2509: RA_CUSTOMER_MERGES M1,
2510: RA_CUSTOMER_MERGES M2,
2511: RA_CUSTOMER_MERGES M3,
2512: RA_CUSTOMER_MERGES M4,
2513: RA_CUSTOMER_MERGES M5,
2514: RA_CUSTOMER_MERGES M6,

Line 2511: RA_CUSTOMER_MERGES M3,

2507: l.end_customer_id
2508: FROM OE_ORDER_LINES_HISTORY L ,
2509: RA_CUSTOMER_MERGES M1,
2510: RA_CUSTOMER_MERGES M2,
2511: RA_CUSTOMER_MERGES M3,
2512: RA_CUSTOMER_MERGES M4,
2513: RA_CUSTOMER_MERGES M5,
2514: RA_CUSTOMER_MERGES M6,
2515: RA_CUSTOMER_MERGES M7,

Line 2512: RA_CUSTOMER_MERGES M4,

2508: FROM OE_ORDER_LINES_HISTORY L ,
2509: RA_CUSTOMER_MERGES M1,
2510: RA_CUSTOMER_MERGES M2,
2511: RA_CUSTOMER_MERGES M3,
2512: RA_CUSTOMER_MERGES M4,
2513: RA_CUSTOMER_MERGES M5,
2514: RA_CUSTOMER_MERGES M6,
2515: RA_CUSTOMER_MERGES M7,
2516: --changed for bug 3196900

Line 2513: RA_CUSTOMER_MERGES M5,

2509: RA_CUSTOMER_MERGES M1,
2510: RA_CUSTOMER_MERGES M2,
2511: RA_CUSTOMER_MERGES M3,
2512: RA_CUSTOMER_MERGES M4,
2513: RA_CUSTOMER_MERGES M5,
2514: RA_CUSTOMER_MERGES M6,
2515: RA_CUSTOMER_MERGES M7,
2516: --changed for bug 3196900
2517: -- OE_ORDER_LINES_HISTORY L

Line 2514: RA_CUSTOMER_MERGES M6,

2510: RA_CUSTOMER_MERGES M2,
2511: RA_CUSTOMER_MERGES M3,
2512: RA_CUSTOMER_MERGES M4,
2513: RA_CUSTOMER_MERGES M5,
2514: RA_CUSTOMER_MERGES M6,
2515: RA_CUSTOMER_MERGES M7,
2516: --changed for bug 3196900
2517: -- OE_ORDER_LINES_HISTORY L
2518: OE_ORDER_LINES_ALL LN

Line 2515: RA_CUSTOMER_MERGES M7,

2511: RA_CUSTOMER_MERGES M3,
2512: RA_CUSTOMER_MERGES M4,
2513: RA_CUSTOMER_MERGES M5,
2514: RA_CUSTOMER_MERGES M6,
2515: RA_CUSTOMER_MERGES M7,
2516: --changed for bug 3196900
2517: -- OE_ORDER_LINES_HISTORY L
2518: OE_ORDER_LINES_ALL LN
2519: --Changed for MOAC

Line 2724: from ra_customer_merges m

2720: select line_id
2721: from oe_lines_iface_all
2722: where ship_to_org_id in
2723: (select m.duplicate_site_id
2724: from ra_customer_merges m
2725: where m.process_flag = 'N'
2726: and m.request_id = req_id
2727: and m.set_number = set_num)
2728: for update nowait;

Line 2736: from ra_customer_merges m

2732: select line_id
2733: from oe_lines_iface_all
2734: where invoice_to_org_id in
2735: (select m.duplicate_site_id
2736: from ra_customer_merges m
2737: where m.process_flag = 'N'
2738: and m.request_id = req_id
2739: and m.set_number = set_num)
2740: for update nowait;

Line 2748: from ra_customer_merges m

2744: select line_id
2745: from oe_lines_iface_all
2746: where deliver_to_org_id in
2747: (select m.duplicate_site_id
2748: from ra_customer_merges m
2749: where m.process_flag = 'N'
2750: and m.request_id = req_id
2751: and m.set_number = set_num)
2752: for update nowait;

Line 2760: from ra_customer_merges m

2756: select line_id
2757: from oe_lines_iface_all
2758: where sold_to_org_id in
2759: (select m.duplicate_id
2760: from ra_customer_merges m
2761: where m.process_flag = 'N'
2762: and m.request_id = req_id
2763: and m.set_number = set_num)
2764: for update nowait;

Line 2795: from ra_customer_merges m

2791: arp_message.set_token( 'TABLE_NAME', 'oe_lines_iface_all', FALSE );
2792:
2793: UPDATE oe_lines_iface_all a
2794: set ship_to_org_id = (select distinct m.customer_site_id
2795: from ra_customer_merges m
2796: where a.ship_to_org_id = m.duplicate_site_id
2797: and m.request_id = req_id
2798: and m.process_flag = 'N'
2799: and m.set_number = set_num),

Line 2808: from ra_customer_merges m

2804: program_application_id =arp_standard.profile.program_application_id,
2805: program_id = arp_standard.profile.program_id,
2806: program_update_date = sysdate
2807: where ship_to_org_id in (select m.duplicate_site_id
2808: from ra_customer_merges m
2809: where m.process_flag = 'N'
2810: and m.request_id = req_id
2811: and m.set_number = set_num);
2812: g_count := sql%rowcount;

Line 2821: from ra_customer_merges m

2817: arp_message.set_token( 'TABLE_NAME', 'oe_lines_iface_all', FALSE );
2818:
2819: UPDATE oe_lines_iface_all a
2820: set invoice_to_org_id = (select distinct m.customer_site_id
2821: from ra_customer_merges m
2822: where a.invoice_to_org_id = m.duplicate_site_id
2823: and m.request_id = req_id
2824: and m.process_flag = 'N'
2825: and m.set_number = set_num),

Line 2834: from ra_customer_merges m

2830: program_application_id =arp_standard.profile.program_application_id,
2831: program_id = arp_standard.profile.program_id,
2832: program_update_date = sysdate
2833: where invoice_to_org_id in (select m.duplicate_site_id
2834: from ra_customer_merges m
2835: where m.process_flag = 'N'
2836: and m.request_id = req_id
2837: and m.set_number = set_num);
2838: g_count := sql%rowcount;

Line 2847: from ra_customer_merges m

2843: arp_message.set_token( 'TABLE_NAME', 'oe_lines_iface_all', FALSE );
2844:
2845: UPDATE oe_lines_iface_all a
2846: set deliver_to_org_id = (select distinct m.customer_site_id
2847: from ra_customer_merges m
2848: where a.deliver_to_org_id = m.duplicate_site_id
2849: and m.request_id = req_id
2850: and m.process_flag = 'N'
2851: and m.set_number = set_num),

Line 2860: from ra_customer_merges m

2856: program_application_id =arp_standard.profile.program_application_id,
2857: program_id = arp_standard.profile.program_id,
2858: program_update_date = sysdate
2859: where deliver_to_org_id in (select m.duplicate_site_id
2860: from ra_customer_merges m
2861: where m.process_flag = 'N'
2862: and m.request_id = req_id
2863: and m.set_number = set_num);
2864: g_count := sql%rowcount;

Line 2877: from ra_customer_merges m

2873: arp_message.set_token( 'TABLE_NAME', 'oe_lines_iface_all', FALSE );
2874:
2875: UPDATE oe_lines_iface_all a
2876: set sold_to_org_id = (select distinct m.customer_id
2877: from ra_customer_merges m
2878: where a.sold_to_org_id = m.duplicate_id
2879: and m.process_flag = 'N'
2880: and m.request_id = req_id
2881: and m.set_number = set_num),

Line 2890: from ra_customer_merges m

2886: program_application_id =arp_standard.profile.program_application_id,
2887: program_id = arp_standard.profile.program_id,
2888: program_update_date = sysdate
2889: where sold_to_org_id in (select m.duplicate_id
2890: from ra_customer_merges m
2891: where m.process_flag = 'N'
2892: and m.request_id = req_id
2893: and m.set_number = set_num);
2894:

Line 2925: from ra_customer_merges m

2921: select line_id
2922: from oe_line_acks
2923: where ship_to_org_id in
2924: (select m.duplicate_site_id
2925: from ra_customer_merges m
2926: where m.process_flag = 'N'
2927: and m.request_id = req_id
2928: and m.set_number = set_num)
2929: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 2938: from ra_customer_merges m

2934: select line_id
2935: from oe_line_acks
2936: where invoice_to_org_id in
2937: (select m.duplicate_site_id
2938: from ra_customer_merges m
2939: where m.process_flag = 'N'
2940: and m.request_id = req_id
2941: and m.set_number = set_num)
2942: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 2951: from ra_customer_merges m

2947: select line_id
2948: from oe_line_acks
2949: where deliver_to_org_id in
2950: (select m.duplicate_site_id
2951: from ra_customer_merges m
2952: where m.process_flag = 'N'
2953: and m.request_id = req_id
2954: and m.set_number = set_num)
2955: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 2964: from ra_customer_merges m

2960: select line_id
2961: from oe_line_acks
2962: where intmed_ship_to_org_id in
2963: (select m.duplicate_site_id
2964: from ra_customer_merges m
2965: where m.process_flag = 'N'
2966: and m.request_id = req_id
2967: and m.set_number = set_num)
2968: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 2977: from ra_customer_merges m

2973: select a.line_id
2974: from oe_line_acks a, oe_order_lines l
2975: where a.sold_to_org_id in
2976: (select m.duplicate_id
2977: from ra_customer_merges m
2978: where m.process_flag = 'N'
2979: and m.request_id = req_id
2980: and m.set_number = set_num)
2981: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 2991: from ra_customer_merges m

2987: select line_id
2988: from oe_line_acks
2989: where end_customer_site_use_id in
2990: (select m.duplicate_id
2991: from ra_customer_merges m
2992: where m.process_flag = 'N'
2993: and m.request_id = req_id
2994: and m.set_number = set_num)
2995: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 3004: from ra_customer_merges m

3000: select a.line_id
3001: from oe_line_acks a,oe_order_lines l
3002: where a.end_customer_id in
3003: (select m.duplicate_id
3004: from ra_customer_merges m
3005: where m.process_flag = 'N'
3006: and m.request_id = req_id
3007: and m.set_number = set_num)
3008: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 3084: ra_customer_merges m

3080: hz_utility_pub.LAST_UPDATE_LOGIN,
3081: hz_utility_pub.LAST_UPDATE_DATE,
3082: hz_utility_pub.LAST_UPDATED_BY
3083: from oe_line_acks a,
3084: ra_customer_merges m
3085: where m.process_flag = 'N'
3086: and a.ship_to_org_id = m.duplicate_site_id
3087: and m.request_id = req_id
3088: and m.set_number = set_num

Line 3098: from ra_customer_merges m

3094: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3095:
3096: UPDATE oe_line_acks a
3097: set ship_to_org_id = (select distinct m.customer_site_id
3098: from ra_customer_merges m
3099: where a.ship_to_org_id = m.duplicate_site_id
3100: and m.request_id = req_id
3101: and m.process_flag = 'N'
3102: and m.set_number = set_num),

Line 3111: from ra_customer_merges m

3107: program_application_id =arp_standard.profile.program_application_id,
3108: program_id = arp_standard.profile.program_id,
3109: program_update_date = sysdate
3110: where ship_to_org_id in (select m.duplicate_site_id
3111: from ra_customer_merges m
3112: where m.process_flag = 'N'
3113: and m.request_id = req_id
3114: and m.set_number = set_num)
3115: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 3153: ra_customer_merges m

3149: hz_utility_pub.LAST_UPDATE_LOGIN,
3150: hz_utility_pub.LAST_UPDATE_DATE,
3151: hz_utility_pub.LAST_UPDATED_BY
3152: from oe_line_acks a,
3153: ra_customer_merges m
3154: where m.process_flag = 'N'
3155: and a.invoice_to_org_id = m.duplicate_site_id
3156: and m.request_id = req_id
3157: and m.set_number = set_num

Line 3166: from ra_customer_merges m

3162: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3163:
3164: UPDATE oe_line_acks a
3165: set invoice_to_org_id = (select distinct m.customer_site_id
3166: from ra_customer_merges m
3167: where a.invoice_to_org_id = m.duplicate_site_id
3168: and m.request_id = req_id
3169: and m.process_flag = 'N'
3170: and m.set_number = set_num),

Line 3179: from ra_customer_merges m

3175: program_application_id =arp_standard.profile.program_application_id,
3176: program_id = arp_standard.profile.program_id,
3177: program_update_date = sysdate
3178: where invoice_to_org_id in (select m.duplicate_site_id
3179: from ra_customer_merges m
3180: where m.process_flag = 'N'
3181: and m.request_id = req_id
3182: and m.set_number = set_num)
3183: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 3221: ra_customer_merges m

3217: hz_utility_pub.LAST_UPDATE_LOGIN,
3218: hz_utility_pub.LAST_UPDATE_DATE,
3219: hz_utility_pub.LAST_UPDATED_BY
3220: from oe_line_acks a,
3221: ra_customer_merges m
3222: where m.process_flag = 'N'
3223: and a.deliver_to_org_id = m.duplicate_site_id
3224: and m.request_id = req_id
3225: and m.set_number = set_num

Line 3234: from ra_customer_merges m

3230: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3231:
3232: UPDATE oe_line_acks a
3233: set deliver_to_org_id = (select distinct m.customer_site_id
3234: from ra_customer_merges m
3235: where a.deliver_to_org_id = m.duplicate_site_id
3236: and m.request_id = req_id
3237: and m.process_flag = 'N'
3238: and m.set_number = set_num),

Line 3247: from ra_customer_merges m

3243: program_application_id =arp_standard.profile.program_application_id,
3244: program_id = arp_standard.profile.program_id,
3245: program_update_date = sysdate
3246: where deliver_to_org_id in (select m.duplicate_site_id
3247: from ra_customer_merges m
3248: where m.process_flag = 'N'
3249: and m.request_id = req_id
3250: and m.set_number = set_num)
3251: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 3289: ra_customer_merges m

3285: hz_utility_pub.LAST_UPDATE_LOGIN,
3286: hz_utility_pub.LAST_UPDATE_DATE,
3287: hz_utility_pub.LAST_UPDATED_BY
3288: from oe_line_acks a,
3289: ra_customer_merges m
3290: where m.process_flag = 'N'
3291: and a.intmed_ship_to_org_id = m.duplicate_site_id
3292: and m.request_id = req_id
3293: and m.set_number = set_num

Line 3303: from ra_customer_merges m

3299:
3300:
3301: UPDATE oe_line_acks a
3302: set intmed_ship_to_org_id = (select distinct m.customer_site_id
3303: from ra_customer_merges m
3304: where a.intmed_ship_to_org_id = m.duplicate_site_id
3305: and m.request_id = req_id
3306: and m.process_flag = 'N'
3307: and m.set_number = set_num),

Line 3316: from ra_customer_merges m

3312: program_application_id =arp_standard.profile.program_application_id,
3313: program_id = arp_standard.profile.program_id,
3314: program_update_date = sysdate
3315: where intmed_ship_to_org_id in (select m.duplicate_site_id
3316: from ra_customer_merges m
3317: where m.process_flag = 'N'
3318: and m.request_id = req_id
3319: and m.set_number = set_num)
3320: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 3363: ra_customer_merges m

3359: hz_utility_pub.LAST_UPDATE_LOGIN,
3360: hz_utility_pub.LAST_UPDATE_DATE,
3361: hz_utility_pub.LAST_UPDATED_BY
3362: from oe_line_acks a,
3363: ra_customer_merges m
3364: where m.process_flag = 'N'
3365: and a.sold_to_org_id = m.duplicate_site_id
3366: and m.request_id = req_id
3367: and m.set_number = set_num

Line 3377: from ra_customer_merges m

3373: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3374:
3375: UPDATE oe_line_acks a
3376: set sold_to_org_id = (select distinct m.customer_id
3377: from ra_customer_merges m
3378: where a.sold_to_org_id = m.duplicate_id
3379: and m.process_flag = 'N'
3380: and m.request_id = req_id
3381: and m.set_number = set_num),

Line 3390: from ra_customer_merges m

3386: program_application_id =arp_standard.profile.program_application_id,
3387: program_id = arp_standard.profile.program_id,
3388: program_update_date = sysdate
3389: where sold_to_org_id in (select m.duplicate_id
3390: from ra_customer_merges m
3391: where m.process_flag = 'N'
3392: and m.request_id = req_id
3393: and m.set_number = set_num)
3394: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 3440: ra_customer_merges m

3436: hz_utility_pub.LAST_UPDATE_LOGIN,
3437: hz_utility_pub.LAST_UPDATE_DATE,
3438: hz_utility_pub.LAST_UPDATED_BY
3439: from oe_line_acks a,
3440: ra_customer_merges m
3441: where m.process_flag = 'N'
3442: and a.sold_to_org_id = m.duplicate_site_id
3443: and m.request_id = req_id
3444: and m.set_number = set_num

Line 3454: from ra_customer_merges m

3450: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3451:
3452: UPDATE oe_line_acks a
3453: set end_customer_site_use_id = (select distinct m.customer_id
3454: from ra_customer_merges m
3455: where a.end_customer_site_use_id = m.duplicate_id
3456: and m.process_flag = 'N'
3457: and m.request_id = req_id
3458: and m.set_number = set_num),

Line 3467: from ra_customer_merges m

3463: program_application_id =arp_standard.profile.program_application_id,
3464: program_id = arp_standard.profile.program_id,
3465: program_update_date = sysdate
3466: where end_customer_site_use_id in (select m.duplicate_id
3467: from ra_customer_merges m
3468: where m.process_flag = 'N'
3469: and m.request_id = req_id
3470: and m.set_number = set_num)
3471: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';

Line 3515: ra_customer_merges m

3511: hz_utility_pub.LAST_UPDATE_LOGIN,
3512: hz_utility_pub.LAST_UPDATE_DATE,
3513: hz_utility_pub.LAST_UPDATED_BY
3514: from oe_line_acks a,
3515: ra_customer_merges m
3516: where m.process_flag = 'N'
3517: and a.end_customer_id = m.duplicate_site_id
3518: and m.request_id = req_id
3519: and m.set_number = set_num

Line 3529: from ra_customer_merges m

3525: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3526:
3527: UPDATE oe_line_acks a
3528: set end_customer_id = (select distinct m.customer_id
3529: from ra_customer_merges m
3530: where a.end_customer_id = m.duplicate_id
3531: and m.process_flag = 'N'
3532: and m.request_id = req_id
3533: and m.set_number = set_num),

Line 3542: from ra_customer_merges m

3538: program_application_id =arp_standard.profile.program_application_id,
3539: program_id = arp_standard.profile.program_id,
3540: program_update_date = sysdate
3541: where end_customer_id in (select m.duplicate_id
3542: from ra_customer_merges m
3543: where m.process_flag = 'N'
3544: and m.request_id = req_id
3545: and m.set_number = set_num)
3546: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'

Line 3623: from ra_customer_merges m

3619: CURSOR c1 is
3620: select RULE_ELEMENT_ID
3621: from oe_attachment_rule_elements
3622: where attribute_value in (select to_char(m.duplicate_site_id)
3623: from ra_customer_merges m
3624: where m.process_flag = 'N'
3625: and m.request_id = req_id
3626: and m.set_number = set_num)
3627: and attribute_code = 'SHIP_TO_ORG_ID'

Line 3634: from ra_customer_merges m

3630: CURSOR c2 is
3631: select RULE_ELEMENT_ID
3632: from oe_attachment_rule_elements
3633: where attribute_value in (select to_char(m.duplicate_site_id)
3634: from ra_customer_merges m
3635: where m.process_flag = 'N'
3636: and m.request_id = req_id
3637: and m.set_number = set_num)
3638: and attribute_code = 'INVOICE_TO_ORG_ID'

Line 3645: from ra_customer_merges m

3641: CURSOR c3 is
3642: select RULE_ELEMENT_ID
3643: from oe_attachment_rule_elements
3644: where attribute_value in (select to_char(m.duplicate_id)
3645: from ra_customer_merges m
3646: where m.process_flag = 'N'
3647: and m.request_id = req_id
3648: and m.set_number = set_num)
3649: and attribute_code = 'SOLD_TO_ORG_ID'

Line 3713: ra_customer_merges m

3709: hz_utility_pub.LAST_UPDATE_LOGIN,
3710: hz_utility_pub.LAST_UPDATE_DATE,
3711: hz_utility_pub.LAST_UPDATED_BY
3712: from OE_ATTACHMENT_RULE_ELEMENTS a,
3713: ra_customer_merges m
3714: where a.attribute_value = to_char(m.duplicate_site_id)
3715: and m.process_flag = 'N'
3716: and m.request_id = req_id
3717: and m.set_number = set_num

Line 3728: from ra_customer_merges m

3724: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
3725:
3726: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
3727: set (attribute_value) = (select distinct to_char(m.customer_site_id)
3728: from ra_customer_merges m
3729: where a.attribute_value =
3730: to_char(m.duplicate_site_id)
3731: and m.request_id = req_id
3732: and m.process_flag = 'N'

Line 3738: from ra_customer_merges m

3734: last_update_date = sysdate,
3735: last_updated_by = arp_standard.profile.user_id,
3736: last_update_login = arp_standard.profile.last_update_login
3737: where attribute_value in (select to_char(m.duplicate_site_id)
3738: from ra_customer_merges m
3739: where m.process_flag = 'N'
3740: and m.request_id = req_id
3741: and m.set_number = set_num)
3742: and attribute_code = 'SHIP_TO_ORG_ID';

Line 3781: ra_customer_merges m

3777: hz_utility_pub.LAST_UPDATE_LOGIN,
3778: hz_utility_pub.LAST_UPDATE_DATE,
3779: hz_utility_pub.LAST_UPDATED_BY
3780: from OE_ATTACHMENT_RULE_ELEMENTS a,
3781: ra_customer_merges m
3782: where a.attribute_value = to_char(m.duplicate_site_id)
3783: and m.process_flag = 'N'
3784: and m.request_id = req_id
3785: and m.set_number = set_num

Line 3796: from ra_customer_merges m

3792: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
3793:
3794: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
3795: set (attribute_value) = (select distinct to_char(m.customer_site_id)
3796: from ra_customer_merges m
3797: where a.attribute_value =
3798: to_char(m.duplicate_site_id)
3799: and m.request_id = req_id
3800: and m.process_flag = 'N'

Line 3806: from ra_customer_merges m

3802: last_update_date = sysdate,
3803: last_updated_by = arp_standard.profile.user_id,
3804: last_update_login = arp_standard.profile.last_update_login
3805: where attribute_value in (select to_char(m.duplicate_site_id)
3806: from ra_customer_merges m
3807: where m.process_flag = 'N'
3808: and m.request_id = req_id
3809: and m.set_number = set_num)
3810: and attribute_code = 'INVOICE_TO_ORG_ID';

Line 3850: ra_customer_merges m

3846: hz_utility_pub.LAST_UPDATE_LOGIN,
3847: hz_utility_pub.LAST_UPDATE_DATE,
3848: hz_utility_pub.LAST_UPDATED_BY
3849: from OE_ATTACHMENT_RULE_ELEMENTS a,
3850: ra_customer_merges m
3851: where a.attribute_value = to_char(m.duplicate_site_id)
3852: and m.process_flag = 'N'
3853: and m.request_id = req_id
3854: and m.set_number = set_num

Line 3865: from ra_customer_merges m

3861: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
3862:
3863: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
3864: set (attribute_value) = (select distinct to_char(m.customer_id)
3865: from ra_customer_merges m
3866: where a.attribute_value =
3867: to_char(m.duplicate_id)
3868: and m.request_id = req_id
3869: and m.process_flag = 'N'

Line 3875: from ra_customer_merges m

3871: last_update_date = sysdate,
3872: last_updated_by = arp_standard.profile.user_id,
3873: last_update_login = arp_standard.profile.last_update_login
3874: where attribute_value in (select to_char(m.duplicate_id)
3875: from ra_customer_merges m
3876: where m.process_flag = 'N'
3877: and m.request_id = req_id
3878: and m.set_number = set_num)
3879: and attribute_code = 'SOLD_TO_ORG_ID';

Line 3910: from ra_customer_merges m

3906: CURSOR c1 is
3907: select CONDITION_ELEMENT_ID
3908: from oe_def_condn_elems
3909: where value_string in (select to_char(m.duplicate_site_id)
3910: from ra_customer_merges m
3911: where m.process_flag = 'N'
3912: and m.request_id = req_id
3913: and m.set_number = set_num)
3914: and attribute_code = 'SHIP_TO_ORG_ID'

Line 3921: from ra_customer_merges m

3917: CURSOR c2 is
3918: select CONDITION_ELEMENT_ID
3919: from oe_def_condn_elems
3920: where value_string in (select to_char(m.duplicate_site_id)
3921: from ra_customer_merges m
3922: where m.process_flag = 'N'
3923: and m.request_id = req_id
3924: and m.set_number = set_num)
3925: and attribute_code = 'INVOICE_TO_ORG_ID'

Line 3932: from ra_customer_merges m

3928: CURSOR c4 is
3929: select CONDITION_ELEMENT_ID
3930: from oe_def_condn_elems
3931: where value_string in (select to_char(m.duplicate_site_id)
3932: from ra_customer_merges m
3933: where m.process_flag = 'N'
3934: and m.request_id = req_id
3935: and m.set_number = set_num)
3936: and attribute_code = 'INTMED_SHIP_TO_ORG_ID'

Line 3943: from ra_customer_merges m

3939: CURSOR c3 is
3940: select CONDITION_ELEMENT_ID
3941: from oe_def_condn_elems
3942: where value_string in (select to_char(m.duplicate_id)
3943: from ra_customer_merges m
3944: where m.process_flag = 'N'
3945: and m.request_id = req_id
3946: and m.set_number = set_num)
3947: and attribute_code = 'SOLD_TO_ORG_ID'

Line 3954: from ra_customer_merges m

3950: CURSOR c5 is
3951: select ATTR_DEF_RULE_ID
3952: from oe_def_attr_def_rules
3953: where src_constant_value in (select to_char(m.duplicate_site_id)
3954: from ra_customer_merges m
3955: where m.process_flag = 'N'
3956: and m.request_id = req_id
3957: and m.set_number = set_num)
3958: and attribute_code = 'SHIP_TO_ORG_ID'

Line 3965: from ra_customer_merges m

3961: CURSOR c6 is
3962: select ATTR_DEF_RULE_ID
3963: from oe_def_attr_def_rules
3964: where src_constant_value in (select to_char(m.duplicate_site_id)
3965: from ra_customer_merges m
3966: where m.process_flag = 'N'
3967: and m.request_id = req_id
3968: and m.set_number = set_num)
3969: and attribute_code = 'INVOICE_TO_ORG_ID'

Line 3976: from ra_customer_merges m

3972: CURSOR c7 is
3973: select ATTR_DEF_RULE_ID
3974: from oe_def_attr_def_rules
3975: where src_constant_value in (select to_char(m.duplicate_site_id)
3976: from ra_customer_merges m
3977: where m.process_flag = 'N'
3978: and m.request_id = req_id
3979: and m.set_number = set_num)
3980: and attribute_code = 'INTMED_SHIP_TO_ORG_ID'

Line 3987: from ra_customer_merges m

3983: CURSOR c8 is
3984: select ATTR_DEF_RULE_ID
3985: from oe_def_attr_def_rules
3986: where src_constant_value in (select to_char(m.duplicate_id)
3987: from ra_customer_merges m
3988: where m.process_flag = 'N'
3989: and m.request_id = req_id
3990: and m.set_number = set_num)
3991: and attribute_code = 'SOLD_TO_ORG_ID'

Line 4070: ra_customer_merges m

4066: hz_utility_pub.LAST_UPDATE_LOGIN,
4067: hz_utility_pub.LAST_UPDATE_DATE,
4068: hz_utility_pub.LAST_UPDATED_BY
4069: from OE_DEF_CONDN_ELEMS a,
4070: ra_customer_merges m
4071: where a.value_string = to_char(m.duplicate_site_id)
4072: and m.process_flag = 'N'
4073: and m.request_id = req_id
4074: and m.set_number = set_num

Line 4085: from ra_customer_merges m

4081: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4082:
4083: UPDATE OE_DEF_CONDN_ELEMS a
4084: set value_string = (select distinct to_char(m.customer_site_id)
4085: from ra_customer_merges m
4086: where a.value_string =
4087: to_char(m.duplicate_site_id)
4088:
4089: and m.request_id = req_id

Line 4096: from ra_customer_merges m

4092: last_update_date = sysdate,
4093: last_updated_by = arp_standard.profile.user_id,
4094: last_update_login = arp_standard.profile.last_update_login
4095: where value_string in (select to_char(m.duplicate_site_id)
4096: from ra_customer_merges m
4097: where m.process_flag = 'N'
4098: and m.request_id = req_id
4099: and m.set_number = set_num)
4100: and attribute_code = 'SHIP_TO_ORG_ID';

Line 4137: ra_customer_merges m

4133: hz_utility_pub.LAST_UPDATE_LOGIN,
4134: hz_utility_pub.LAST_UPDATE_DATE,
4135: hz_utility_pub.LAST_UPDATED_BY
4136: from OE_DEF_CONDN_ELEMS a,
4137: ra_customer_merges m
4138: where a.value_string = to_char(m.duplicate_site_id)
4139: and m.process_flag = 'N'
4140: and m.request_id = req_id
4141: and m.set_number = set_num

Line 4153: from ra_customer_merges m

4149: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4150:
4151: UPDATE OE_DEF_CONDN_ELEMS a
4152: set value_string = (select distinct to_char(m.customer_site_id)
4153: from ra_customer_merges m
4154: where a.value_string =
4155: to_char(m.duplicate_site_id)
4156:
4157: and m.request_id = req_id

Line 4164: from ra_customer_merges m

4160: last_update_date = sysdate,
4161: last_updated_by = arp_standard.profile.user_id,
4162: last_update_login = arp_standard.profile.last_update_login
4163: where value_string in (select to_char(m.duplicate_site_id)
4164: from ra_customer_merges m
4165: where m.process_flag = 'N'
4166: and m.request_id = req_id
4167: and m.set_number = set_num)
4168: and attribute_code = 'INVOICE_TO_ORG_ID';

Line 4206: ra_customer_merges m

4202: hz_utility_pub.LAST_UPDATE_LOGIN,
4203: hz_utility_pub.LAST_UPDATE_DATE,
4204: hz_utility_pub.LAST_UPDATED_BY
4205: from OE_DEF_CONDN_ELEMS a,
4206: ra_customer_merges m
4207: where a.value_string = to_char(m.duplicate_site_id)
4208: and m.process_flag = 'N'
4209: and m.request_id = req_id
4210: and m.set_number = set_num

Line 4221: from ra_customer_merges m

4217: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4218:
4219: UPDATE OE_DEF_CONDN_ELEMS a
4220: set value_string = (select distinct to_char(m.customer_site_id)
4221: from ra_customer_merges m
4222: where a.value_string =
4223: to_char(m.duplicate_site_id)
4224:
4225: and m.request_id = req_id

Line 4232: from ra_customer_merges m

4228: last_update_date = sysdate,
4229: last_updated_by = arp_standard.profile.user_id,
4230: last_update_login = arp_standard.profile.last_update_login
4231: where value_string in (select to_char(m.duplicate_site_id)
4232: from ra_customer_merges m
4233: where m.process_flag = 'N'
4234: and m.request_id = req_id
4235: and m.set_number = set_num)
4236: and attribute_code = 'INTMED_SHIP_TO_ORG_ID';

Line 4274: ra_customer_merges m

4270: hz_utility_pub.LAST_UPDATE_LOGIN,
4271: hz_utility_pub.LAST_UPDATE_DATE,
4272: hz_utility_pub.LAST_UPDATED_BY
4273: from OE_DEF_CONDN_ELEMS a,
4274: ra_customer_merges m
4275: where a.value_string = to_char(m.duplicate_id)
4276: and m.process_flag = 'N'
4277: and m.request_id = req_id
4278: and m.set_number = set_num

Line 4289: from ra_customer_merges m

4285: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4286:
4287: UPDATE OE_DEF_CONDN_ELEMS a
4288: set value_string = (select distinct to_char(m.customer_id)
4289: from ra_customer_merges m
4290: where a.value_string =
4291: to_char(m.duplicate_id)
4292:
4293: and m.request_id = req_id

Line 4300: from ra_customer_merges m

4296: last_update_date = sysdate,
4297: last_updated_by = arp_standard.profile.user_id,
4298: last_update_login = arp_standard.profile.last_update_login
4299: where value_string in (select to_char(m.duplicate_id)
4300: from ra_customer_merges m
4301: where m.process_flag = 'N'
4302: and m.request_id = req_id
4303: and m.set_number = set_num)
4304: and attribute_code = 'SOLD_TO_ORG_ID';

Line 4344: ra_customer_merges m

4340: hz_utility_pub.LAST_UPDATE_LOGIN,
4341: hz_utility_pub.LAST_UPDATE_DATE,
4342: hz_utility_pub.LAST_UPDATED_BY
4343: from OE_DEF_ATTR_DEF_RULES a,
4344: ra_customer_merges m
4345: where a.src_constant_value = to_char(m.duplicate_site_id)
4346: and m.process_flag = 'N'
4347: and m.request_id = req_id
4348: and m.set_number = set_num

Line 4361: from ra_customer_merges m

4357:
4358:
4359: UPDATE OE_DEF_ATTR_DEF_RULES a
4360: set src_constant_value = (select distinct to_char(m.customer_site_id)
4361: from ra_customer_merges m
4362: where a.src_constant_value =
4363: to_char(m.duplicate_site_id)
4364:
4365: and m.request_id = req_id

Line 4372: from ra_customer_merges m

4368: last_update_date = sysdate,
4369: last_updated_by = arp_standard.profile.user_id,
4370: last_update_login = arp_standard.profile.last_update_login
4371: where src_constant_value in (select to_char(m.duplicate_site_id)
4372: from ra_customer_merges m
4373: where m.process_flag = 'N'
4374: and m.request_id = req_id
4375: and m.set_number = set_num)
4376: and attribute_code = 'SHIP_TO_ORG_ID';

Line 4414: ra_customer_merges m

4410: hz_utility_pub.LAST_UPDATE_LOGIN,
4411: hz_utility_pub.LAST_UPDATE_DATE,
4412: hz_utility_pub.LAST_UPDATED_BY
4413: from OE_DEF_ATTR_DEF_RULES a,
4414: ra_customer_merges m
4415: where a.src_constant_value = to_char(m.duplicate_site_id)
4416: and m.process_flag = 'N'
4417: and m.request_id = req_id
4418: and m.set_number = set_num

Line 4429: from ra_customer_merges m

4425: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4426:
4427: UPDATE OE_DEF_ATTR_DEF_RULES a
4428: set src_constant_value = (select distinct to_char(m.customer_site_id)
4429: from ra_customer_merges m
4430: where a.src_constant_value =
4431: to_char(m.duplicate_site_id)
4432:
4433: and m.request_id = req_id

Line 4440: from ra_customer_merges m

4436: last_update_date = sysdate,
4437: last_updated_by = arp_standard.profile.user_id,
4438: last_update_login = arp_standard.profile.last_update_login
4439: where src_constant_value in (select to_char(m.duplicate_site_id)
4440: from ra_customer_merges m
4441: where m.process_flag = 'N'
4442: and m.request_id = req_id
4443: and m.set_number = set_num)
4444: and attribute_code = 'INVOICE_TO_ORG_ID';

Line 4482: ra_customer_merges m

4478: hz_utility_pub.LAST_UPDATE_LOGIN,
4479: hz_utility_pub.LAST_UPDATE_DATE,
4480: hz_utility_pub.LAST_UPDATED_BY
4481: from OE_DEF_ATTR_DEF_RULES a,
4482: ra_customer_merges m
4483: where a.src_constant_value = to_char(m.duplicate_site_id)
4484: and m.process_flag = 'N'
4485: and m.request_id = req_id
4486: and m.set_number = set_num

Line 4497: from ra_customer_merges m

4493: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4494:
4495: UPDATE OE_DEF_ATTR_DEF_RULES a
4496: set src_constant_value = (select distinct to_char(m.customer_site_id)
4497: from ra_customer_merges m
4498: where a.src_constant_value =
4499: to_char(m.duplicate_site_id)
4500:
4501: and m.request_id = req_id

Line 4508: from ra_customer_merges m

4504: last_update_date = sysdate,
4505: last_updated_by = arp_standard.profile.user_id,
4506: last_update_login = arp_standard.profile.last_update_login
4507: where src_constant_value in (select to_char(m.duplicate_site_id)
4508: from ra_customer_merges m
4509: where m.process_flag = 'N'
4510: and m.request_id = req_id
4511: and m.set_number = set_num)
4512: and attribute_code = 'INTMED_SHIP_TO_ORG_ID';

Line 4551: ra_customer_merges m

4547: hz_utility_pub.LAST_UPDATE_LOGIN,
4548: hz_utility_pub.LAST_UPDATE_DATE,
4549: hz_utility_pub.LAST_UPDATED_BY
4550: from OE_DEF_ATTR_DEF_RULES a,
4551: ra_customer_merges m
4552: where a.src_constant_value = to_char(m.duplicate_site_id)
4553: and m.process_flag = 'N'
4554: and m.request_id = req_id
4555: and m.set_number = set_num

Line 4566: from ra_customer_merges m

4562: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4563:
4564: UPDATE OE_DEF_ATTR_DEF_RULES a
4565: set src_constant_value = (select distinct to_char(m.customer_id)
4566: from ra_customer_merges m
4567: where a.src_constant_value =
4568: to_char(m.duplicate_id)
4569:
4570: and m.request_id = req_id

Line 4577: from ra_customer_merges m

4573: last_update_date = sysdate,
4574: last_updated_by = arp_standard.profile.user_id,
4575: last_update_login = arp_standard.profile.last_update_login
4576: where src_constant_value in (select to_char(m.duplicate_id)
4577: from ra_customer_merges m
4578: where m.process_flag = 'N'
4579: and m.request_id = req_id
4580: and m.set_number = set_num)
4581: and attribute_code = 'SOLD_TO_ORG_ID';

Line 4614: from ra_customer_merges m

4610: CURSOR c1 is
4611: select VALIDATION_TMPLT_ID
4612: from oe_pc_vtmplt_cols
4613: where value_string in (select to_char(m.duplicate_site_id)
4614: from ra_customer_merges m
4615: where m.process_flag = 'N'
4616: and m.request_id = req_id
4617: and m.set_number = set_num)
4618: and column_name = 'SHIP_TO_ORG_ID'

Line 4625: from ra_customer_merges m

4621: CURSOR c2 is
4622: select VALIDATION_TMPLT_ID
4623: from oe_pc_vtmplt_cols
4624: where value_string in (select to_char(m.duplicate_site_id)
4625: from ra_customer_merges m
4626: where m.process_flag = 'N'
4627: and m.request_id = req_id
4628: and m.set_number = set_num)
4629: and column_name = 'INVOICE_TO_ORG_ID'

Line 4636: from ra_customer_merges m

4632: CURSOR c4 is
4633: select VALIDATION_TMPLT_ID
4634: from oe_pc_vtmplt_cols
4635: where value_string in (select to_char(m.duplicate_site_id)
4636: from ra_customer_merges m
4637: where m.process_flag = 'N'
4638: and m.request_id = req_id
4639: and m.set_number = set_num)
4640: and column_name = 'INTMED_SHIP_TO_ORG_ID'

Line 4647: from ra_customer_merges m

4643: CURSOR c3 is
4644: select VALIDATION_TMPLT_ID
4645: from oe_pc_vtmplt_cols
4646: where value_string in (select to_char(m.duplicate_id)
4647: from ra_customer_merges m
4648: where m.process_flag = 'N'
4649: and m.request_id = req_id
4650: and m.set_number = set_num)
4651: and column_name = 'SOLD_TO_ORG_ID'

Line 4719: ra_customer_merges m

4715: hz_utility_pub.LAST_UPDATE_LOGIN,
4716: hz_utility_pub.LAST_UPDATE_DATE,
4717: hz_utility_pub.LAST_UPDATED_BY
4718: from OE_PC_VTMPLT_COLS a,
4719: ra_customer_merges m
4720: where a.value_string = to_char(m.duplicate_site_id)
4721: and m.process_flag = 'N'
4722: and m.request_id = req_id
4723: and m.set_number = set_num

Line 4734: from ra_customer_merges m

4730: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
4731:
4732: UPDATE OE_PC_VTMPLT_COLS a
4733: set value_string = (select distinct to_char(m.customer_site_id)
4734: from ra_customer_merges m
4735: where a.value_string =
4736: to_char(m.duplicate_site_id)
4737:
4738: and m.request_id = req_id

Line 4745: from ra_customer_merges m

4741: last_update_date = sysdate,
4742: last_updated_by = arp_standard.profile.user_id,
4743: last_update_login = arp_standard.profile.last_update_login
4744: where value_string in (select to_char(m.duplicate_site_id)
4745: from ra_customer_merges m
4746: where m.process_flag = 'N'
4747: and m.request_id = req_id
4748: and m.set_number = set_num)
4749: and column_name = 'SHIP_TO_ORG_ID';

Line 4787: ra_customer_merges m

4783: hz_utility_pub.LAST_UPDATE_LOGIN,
4784: hz_utility_pub.LAST_UPDATE_DATE,
4785: hz_utility_pub.LAST_UPDATED_BY
4786: from OE_PC_VTMPLT_COLS a,
4787: ra_customer_merges m
4788: where a.value_string = to_char(m.duplicate_site_id)
4789: and m.process_flag = 'N'
4790: and m.request_id = req_id
4791: and m.set_number = set_num

Line 4802: from ra_customer_merges m

4798: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
4799:
4800: UPDATE OE_PC_VTMPLT_COLS a
4801: set value_string = (select distinct to_char(m.customer_site_id)
4802: from ra_customer_merges m
4803: where a.value_string =
4804: to_char(m.duplicate_site_id)
4805:
4806: and m.request_id = req_id

Line 4813: from ra_customer_merges m

4809: last_update_date = sysdate,
4810: last_updated_by = arp_standard.profile.user_id,
4811: last_update_login = arp_standard.profile.last_update_login
4812: where value_string in (select to_char(m.duplicate_site_id)
4813: from ra_customer_merges m
4814: where m.process_flag = 'N'
4815: and m.request_id = req_id
4816: and m.set_number = set_num)
4817: and column_name = 'INVOICE_TO_ORG_ID';

Line 4855: ra_customer_merges m

4851: hz_utility_pub.LAST_UPDATE_LOGIN,
4852: hz_utility_pub.LAST_UPDATE_DATE,
4853: hz_utility_pub.LAST_UPDATED_BY
4854: from OE_PC_VTMPLT_COLS a,
4855: ra_customer_merges m
4856: where a.value_string = to_char(m.duplicate_site_id)
4857: and m.process_flag = 'N'
4858: and m.request_id = req_id
4859: and m.set_number = set_num

Line 4870: from ra_customer_merges m

4866: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
4867:
4868: UPDATE OE_PC_VTMPLT_COLS a
4869: set value_string = (select distinct to_char(m.customer_site_id)
4870: from ra_customer_merges m
4871: where a.value_string =
4872: to_char(m.duplicate_site_id)
4873:
4874: and m.request_id = req_id

Line 4881: from ra_customer_merges m

4877: last_update_date = sysdate,
4878: last_updated_by = arp_standard.profile.user_id,
4879: last_update_login = arp_standard.profile.last_update_login
4880: where value_string in (select to_char(m.duplicate_site_id)
4881: from ra_customer_merges m
4882: where m.process_flag = 'N'
4883: and m.request_id = req_id
4884: and m.set_number = set_num)
4885: and column_name = 'INTMED_SHIP_TO_ORG_ID';

Line 4924: ra_customer_merges m

4920: hz_utility_pub.LAST_UPDATE_LOGIN,
4921: hz_utility_pub.LAST_UPDATE_DATE,
4922: hz_utility_pub.LAST_UPDATED_BY
4923: from OE_PC_VTMPLT_COLS a,
4924: ra_customer_merges m
4925: where a.value_string = to_char(m.duplicate_id)
4926: and m.process_flag = 'N'
4927: and m.request_id = req_id
4928: and m.set_number = set_num

Line 4939: from ra_customer_merges m

4935: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
4936:
4937: UPDATE OE_PC_VTMPLT_COLS a
4938: set value_string = (select distinct to_char(m.customer_id)
4939: from ra_customer_merges m
4940: where a.value_string =
4941: to_char(m.duplicate_id)
4942:
4943: and m.request_id = req_id

Line 4950: from ra_customer_merges m

4946: last_update_date = sysdate,
4947: last_updated_by = arp_standard.profile.user_id,
4948: last_update_login = arp_standard.profile.last_update_login
4949: where value_string in (select to_char(m.duplicate_id)
4950: from ra_customer_merges m
4951: where m.process_flag = 'N'
4952: and m.request_id = req_id
4953: and m.set_number = set_num)
4954: and column_name = 'SOLD_TO_ORG_ID';

Line 4986: from ra_customer_merges m

4982: CURSOR c1 is
4983: select hold_source_id
4984: from oe_hold_sources
4985: where hold_entity_id in (select m.duplicate_site_id
4986: from ra_customer_merges m
4987: where m.process_flag = 'N'
4988: and m.request_id = req_id
4989: and m.set_number = set_num)
4990: and hold_entity_code = 'S'

Line 4997: from ra_customer_merges m

4993: CURSOR c2 is
4994: select hold_source_id
4995: from oe_hold_sources
4996: where hold_entity_id in (select m.duplicate_site_id
4997: from ra_customer_merges m
4998: where m.process_flag = 'N'
4999: and m.request_id = req_id
5000: and m.set_number = set_num)
5001: and hold_entity_code = 'B'

Line 5009: from ra_customer_merges m

5005: CURSOR c3 is
5006: select hold_source_id
5007: from oe_hold_sources
5008: where hold_entity_id in (select m.duplicate_id
5009: from ra_customer_merges m
5010: where m.process_flag = 'N'
5011: and m.request_id = req_id
5012: and m.set_number = set_num)
5013: and hold_entity_code = 'C'

Line 5076: ra_customer_merges m

5072: hz_utility_pub.LAST_UPDATE_LOGIN,
5073: hz_utility_pub.LAST_UPDATE_DATE,
5074: hz_utility_pub.LAST_UPDATED_BY
5075: from OE_HOLD_SOURCES a,
5076: ra_customer_merges m
5077: where a.hold_entity_id = to_char(m.duplicate_site_id)
5078: and m.process_flag = 'N'
5079: and m.request_id = req_id
5080: and m.set_number = set_num

Line 5091: from ra_customer_merges m

5087: arp_message.set_token( 'TABLE_NAME', 'OE_HOLD_SOURCES', FALSE );
5088:
5089: UPDATE OE_HOLD_SOURCES a
5090: set (hold_entity_id) = (select distinct m.customer_site_id
5091: from ra_customer_merges m
5092: where a.hold_entity_id =
5093: m.duplicate_site_id
5094: and m.request_id = req_id
5095: and m.process_flag = 'N'

Line 5102: from ra_customer_merges m

5098:
5099: last_updated_by = arp_standard.profile.user_id,
5100: last_update_login = arp_standard.profile.last_update_login
5101: where hold_entity_id in (select m.duplicate_site_id
5102: from ra_customer_merges m
5103: where m.process_flag = 'N'
5104: and m.request_id = req_id
5105: and m.set_number = set_num)
5106: and hold_entity_code = 'S';

Line 5144: ra_customer_merges m

5140: hz_utility_pub.LAST_UPDATE_LOGIN,
5141: hz_utility_pub.LAST_UPDATE_DATE,
5142: hz_utility_pub.LAST_UPDATED_BY
5143: from OE_HOLD_SOURCES a,
5144: ra_customer_merges m
5145: where a.hold_entity_id = to_char(m.duplicate_site_id)
5146: and m.process_flag = 'N'
5147: and m.request_id = req_id
5148: and m.set_number = set_num

Line 5159: from ra_customer_merges m

5155: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
5156:
5157: UPDATE OE_HOLD_SOURCES a
5158: set (hold_entity_id) = (select distinct m.customer_site_id
5159: from ra_customer_merges m
5160: where a.hold_entity_id =
5161:
5162: m.duplicate_site_id
5163: and m.request_id = req_id

Line 5170: from ra_customer_merges m

5166: last_update_date = sysdate,
5167: last_updated_by = arp_standard.profile.user_id,
5168: last_update_login = arp_standard.profile.last_update_login
5169: where hold_entity_id in (select m.duplicate_site_id
5170: from ra_customer_merges m
5171: where m.process_flag = 'N'
5172: and m.request_id = req_id
5173: and m.set_number = set_num)
5174: and hold_entity_code = 'B';

Line 5213: ra_customer_merges m

5209: hz_utility_pub.LAST_UPDATE_LOGIN,
5210: hz_utility_pub.LAST_UPDATE_DATE,
5211: hz_utility_pub.LAST_UPDATED_BY
5212: from OE_HOLD_SOURCES a,
5213: ra_customer_merges m
5214: where a.hold_entity_id = to_char(m.duplicate_id)
5215: and m.process_flag = 'N'
5216: and m.request_id = req_id
5217: and m.set_number = set_num

Line 5228: from ra_customer_merges m

5224: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
5225:
5226: UPDATE OE_HOLD_SOURCES a
5227: set hold_entity_id = (select distinct m.customer_id
5228: from ra_customer_merges m
5229: where a.hold_entity_id =
5230: m.duplicate_id
5231: and m.process_flag = 'N'
5232: and m.request_id = req_id

Line 5238: from ra_customer_merges m

5234: last_update_date = sysdate,
5235: last_updated_by = arp_standard.profile.user_id,
5236: last_update_login = arp_standard.profile.last_update_login
5237: where hold_entity_id in (select m.duplicate_id
5238: from ra_customer_merges m
5239: where m.process_flag = 'N'
5240: and m.request_id = req_id
5241: and m.set_number = set_num)
5242: and hold_entity_code = 'C';

Line 5270: from ra_customer_merges m

5266: select DROP_SHIP_SOURCE_ID
5267: from oe_drop_ship_sources
5268: where LINE_LOCATION_ID in
5269: (select m.duplicate_site_id
5270: from ra_customer_merges m
5271: where m.process_flag = 'N'
5272: and m.request_id = req_id
5273: and m.set_number = set_num)
5274: for update nowait;

Line 5327: ra_customer_merges m

5323: hz_utility_pub.LAST_UPDATE_LOGIN,
5324: hz_utility_pub.LAST_UPDATE_DATE,
5325: hz_utility_pub.LAST_UPDATED_BY
5326: from OE_DROP_SHIP_SOURCES a,
5327: ra_customer_merges m
5328: where a.line_location_id = to_char(m.duplicate_site_id)
5329: and m.process_flag = 'N'
5330: and m.request_id = req_id
5331: and m.set_number = set_num;

Line 5341: from ra_customer_merges m

5337: arp_message.set_token( 'TABLE_NAME', 'OE_DROP_SHIP_SOURCES', FALSE );
5338:
5339: UPDATE OE_DROP_SHIP_SOURCES a
5340: set line_location_id = (select distinct m.customer_site_id
5341: from ra_customer_merges m
5342: where a.line_location_id = m.duplicate_site_id
5343: and m.request_id = req_id
5344: and m.process_flag = 'N'
5345: and m.set_number = set_num),

Line 5350: from ra_customer_merges m

5346: last_update_date = sysdate,
5347: last_updated_by = arp_standard.profile.user_id,
5348: last_update_login = arp_standard.profile.last_update_login
5349: where line_location_id in (select m.duplicate_site_id
5350: from ra_customer_merges m
5351: where m.process_flag = 'N'
5352: and m.request_id = req_id
5353: and m.set_number = set_num);
5354: g_count := sql%rowcount;

Line 5378: from ra_customer_merges m

5374: select CUST_ITEM_SETTING_ID
5375: from oe_cust_item_settings
5376: where site_use_id in
5377: (select m.duplicate_site_id
5378: from ra_customer_merges m
5379: where m.process_flag = 'N'
5380: and m.request_id = req_id
5381: and m.set_number = set_num)
5382: for update nowait;

Line 5389: from ra_customer_merges m

5385: select CUST_ITEM_SETTING_ID
5386: from oe_cust_item_settings
5387: where customer_id in
5388: (select m.duplicate_id
5389: from ra_customer_merges m
5390: where m.process_flag = 'N'
5391: and m.request_id = req_id
5392: and m.set_number = set_num)
5393: for update nowait;

Line 5451: ra_customer_merges m

5447: hz_utility_pub.LAST_UPDATE_LOGIN,
5448: hz_utility_pub.LAST_UPDATE_DATE,
5449: hz_utility_pub.LAST_UPDATED_BY
5450: from OE_CUST_ITEM_SETTINGS a,
5451: ra_customer_merges m
5452: where a.site_use_id = m.duplicate_site_id
5453: and m.process_flag = 'N'
5454: and m.request_id = req_id
5455: and m.set_number = set_num;

Line 5465: from ra_customer_merges m

5461: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
5462:
5463: UPDATE OE_CUST_ITEM_SETTINGS a
5464: set site_use_id = (select distinct m.customer_site_id
5465: from ra_customer_merges m
5466: where a.site_use_id = m.duplicate_site_id
5467: and m.request_id = req_id
5468: and m.process_flag = 'N'
5469: and m.set_number = set_num),

Line 5474: from ra_customer_merges m

5470: last_update_date = sysdate,
5471: last_updated_by = arp_standard.profile.user_id,
5472: last_update_login = arp_standard.profile.last_update_login
5473: where site_use_id in (select m.duplicate_site_id
5474: from ra_customer_merges m
5475: where m.process_flag = 'N'
5476: and m.request_id = req_id
5477: and m.set_number = set_num);
5478: g_count := sql%rowcount;

Line 5513: ra_customer_merges m

5509: hz_utility_pub.LAST_UPDATE_LOGIN,
5510: hz_utility_pub.LAST_UPDATE_DATE,
5511: hz_utility_pub.LAST_UPDATED_BY
5512: from OE_CUST_ITEM_SETTINGS a,
5513: ra_customer_merges m
5514: where a.customer_id = m.duplicate_id
5515: and m.process_flag = 'N'
5516: and m.request_id = req_id
5517: and m.set_number = set_num;

Line 5527: from ra_customer_merges m

5523: arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
5524:
5525: UPDATE OE_CUST_ITEM_SETTINGS a
5526: set customer_id = (select distinct m.customer_id
5527: from ra_customer_merges m
5528: where a.customer_id = m.duplicate_id
5529: and m.request_id = req_id
5530: and m.process_flag = 'N'
5531: and m.set_number = set_num),

Line 5536: from ra_customer_merges m

5532: last_update_date = sysdate,
5533: last_updated_by = arp_standard.profile.user_id,
5534: last_update_login = arp_standard.profile.last_update_login
5535: where customer_id in (select m.duplicate_id
5536: from ra_customer_merges m
5537: where m.process_flag = 'N'
5538: and m.request_id = req_id
5539: and m.set_number = set_num);
5540: g_count := sql%rowcount;

Line 5567: FROM RA_CUSTOMER_MERGES M, OE_SETS S

5563: PARALLEL(S,30)
5564: PARALLEL(M,30)
5565: USE_HASH(M,S) */
5566: s.set_id , s.ship_to_org_id , m.customer_merge_id
5567: FROM RA_CUSTOMER_MERGES M, OE_SETS S
5568: WHERE
5569: s.ship_to_org_id = m.duplicate_site_id
5570: and m.process_flag = 'N'
5571: and m.request_id = req_id

Line 5582: FROM RA_CUSTOMER_MERGES M, OE_SETS S

5578: PARALLEL(S,30)
5579: PARALLEL(M,30)
5580: USE_HASH(M,S) */
5581: s.set_id , s.ship_to_org_id ,m.customer_merge_id
5582: FROM RA_CUSTOMER_MERGES M, OE_SETS S
5583: WHERE
5584: s.ship_to_org_id = m.duplicate_site_id
5585: and m.process_flag = 'N'
5586: and m.request_id = req_id

Line 5711: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A

5707: decode(a.pricing_attribute, 'QUALIFIER_ATTRIBUTE2',
5708: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
5709: m.customer_merge_id
5710: --changed for bug 3196900
5711: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
5712: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A,OE_PRICE_ADJUSTMENTS P,OE_ORDER_HEADERS H
5713: WHERE
5714: a.pricing_context = 'CUSTOMER'
5715: and ((a.pricing_attribute in ('QUALIFIER_ATTRIBUTE11',

Line 5712: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A,OE_PRICE_ADJUSTMENTS P,OE_ORDER_HEADERS H

5708: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
5709: m.customer_merge_id
5710: --changed for bug 3196900
5711: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
5712: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A,OE_PRICE_ADJUSTMENTS P,OE_ORDER_HEADERS H
5713: WHERE
5714: a.pricing_context = 'CUSTOMER'
5715: and ((a.pricing_attribute in ('QUALIFIER_ATTRIBUTE11',
5716: 'QUALIFIER_ATTRIBUTE5',

Line 5738: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A

5734: decode(a.pricing_attribute, 'QUALIFIER_ATTRIBUTE2',
5735: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
5736: m.customer_merge_id
5737: --changed for bug 3196900
5738: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
5739: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A , OE_PRICE_ADJUSTMENTS P,
5740: OE_ORDER_HEADERS H
5741: WHERE
5742: a.pricing_context = 'CUSTOMER'

Line 5739: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A , OE_PRICE_ADJUSTMENTS P,

5735: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
5736: m.customer_merge_id
5737: --changed for bug 3196900
5738: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
5739: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A , OE_PRICE_ADJUSTMENTS P,
5740: OE_ORDER_HEADERS H
5741: WHERE
5742: a.pricing_context = 'CUSTOMER'
5743: and ((a.pricing_attribute in ('QUALIFIER_ATTRIBUTE11',

Line 5877: from ra_customer_merges m

5873: IS
5874:
5875: CURSOR MERGE_SITES IS
5876: select duplicate_id, customer_id, duplicate_site_id, customer_site_id
5877: from ra_customer_merges m
5878: where m.process_flag = 'N'
5879: and m.request_id = req_id
5880: and m.set_number = set_num;
5881:

Line 5897: FROM RA_CUSTOMER_MERGES M1,

5893: h.ship_to_org_id,
5894: h.deliver_to_org_id,
5895: h.sold_to_site_use_id,
5896: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
5897: FROM RA_CUSTOMER_MERGES M1,
5898: RA_CUSTOMER_MERGES M2,
5899: RA_CUSTOMER_MERGES M3,
5900: RA_CUSTOMER_MERGES M4,
5901: RA_CUSTOMER_MERGES M5,

Line 5898: RA_CUSTOMER_MERGES M2,

5894: h.deliver_to_org_id,
5895: h.sold_to_site_use_id,
5896: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
5897: FROM RA_CUSTOMER_MERGES M1,
5898: RA_CUSTOMER_MERGES M2,
5899: RA_CUSTOMER_MERGES M3,
5900: RA_CUSTOMER_MERGES M4,
5901: RA_CUSTOMER_MERGES M5,
5902: -- changed for bug 3196900

Line 5899: RA_CUSTOMER_MERGES M3,

5895: h.sold_to_site_use_id,
5896: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
5897: FROM RA_CUSTOMER_MERGES M1,
5898: RA_CUSTOMER_MERGES M2,
5899: RA_CUSTOMER_MERGES M3,
5900: RA_CUSTOMER_MERGES M4,
5901: RA_CUSTOMER_MERGES M5,
5902: -- changed for bug 3196900
5903: -- OE_BLANKET_HEADERS_ALL H

Line 5900: RA_CUSTOMER_MERGES M4,

5896: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
5897: FROM RA_CUSTOMER_MERGES M1,
5898: RA_CUSTOMER_MERGES M2,
5899: RA_CUSTOMER_MERGES M3,
5900: RA_CUSTOMER_MERGES M4,
5901: RA_CUSTOMER_MERGES M5,
5902: -- changed for bug 3196900
5903: -- OE_BLANKET_HEADERS_ALL H
5904: OE_BLANKET_HEADERS H

Line 5901: RA_CUSTOMER_MERGES M5,

5897: FROM RA_CUSTOMER_MERGES M1,
5898: RA_CUSTOMER_MERGES M2,
5899: RA_CUSTOMER_MERGES M3,
5900: RA_CUSTOMER_MERGES M4,
5901: RA_CUSTOMER_MERGES M5,
5902: -- changed for bug 3196900
5903: -- OE_BLANKET_HEADERS_ALL H
5904: OE_BLANKET_HEADERS H
5905: WHERE

Line 5949: FROM RA_CUSTOMER_MERGES M1,

5945: h.ship_to_org_id,
5946: h.deliver_to_org_id,
5947: h.sold_to_site_use_id,
5948: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
5949: FROM RA_CUSTOMER_MERGES M1,
5950: RA_CUSTOMER_MERGES M2,
5951: RA_CUSTOMER_MERGES M3,
5952: RA_CUSTOMER_MERGES M4,
5953: RA_CUSTOMER_MERGES M5,

Line 5950: RA_CUSTOMER_MERGES M2,

5946: h.deliver_to_org_id,
5947: h.sold_to_site_use_id,
5948: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
5949: FROM RA_CUSTOMER_MERGES M1,
5950: RA_CUSTOMER_MERGES M2,
5951: RA_CUSTOMER_MERGES M3,
5952: RA_CUSTOMER_MERGES M4,
5953: RA_CUSTOMER_MERGES M5,
5954: -- changed for bug 3196900

Line 5951: RA_CUSTOMER_MERGES M3,

5947: h.sold_to_site_use_id,
5948: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
5949: FROM RA_CUSTOMER_MERGES M1,
5950: RA_CUSTOMER_MERGES M2,
5951: RA_CUSTOMER_MERGES M3,
5952: RA_CUSTOMER_MERGES M4,
5953: RA_CUSTOMER_MERGES M5,
5954: -- changed for bug 3196900
5955: -- OE_BLANKET_HEADERS_ALL H

Line 5952: RA_CUSTOMER_MERGES M4,

5948: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
5949: FROM RA_CUSTOMER_MERGES M1,
5950: RA_CUSTOMER_MERGES M2,
5951: RA_CUSTOMER_MERGES M3,
5952: RA_CUSTOMER_MERGES M4,
5953: RA_CUSTOMER_MERGES M5,
5954: -- changed for bug 3196900
5955: -- OE_BLANKET_HEADERS_ALL H
5956: OE_BLANKET_HEADERS H

Line 5953: RA_CUSTOMER_MERGES M5,

5949: FROM RA_CUSTOMER_MERGES M1,
5950: RA_CUSTOMER_MERGES M2,
5951: RA_CUSTOMER_MERGES M3,
5952: RA_CUSTOMER_MERGES M4,
5953: RA_CUSTOMER_MERGES M5,
5954: -- changed for bug 3196900
5955: -- OE_BLANKET_HEADERS_ALL H
5956: OE_BLANKET_HEADERS H
5957: WHERE

Line 6211: from ra_customer_merges m

6207: select hist.HEADER_ID
6208: from oe_blanket_headers_hist hist,oe_blanket_headers h
6209: where hist.ship_to_org_id in
6210: (select m.duplicate_site_id
6211: from ra_customer_merges m
6212: where m.process_flag = 'N'
6213: and m.request_id = req_id
6214: and m.set_number = set_num)
6215: --added for bug 3196900

Line 6226: from ra_customer_merges m

6222: select hist.HEADER_ID
6223: from oe_blanket_headers_hist hist,oe_blanket_headers h
6224: where hist.invoice_to_org_id in
6225: (select m.duplicate_site_id
6226: from ra_customer_merges m
6227: where m.process_flag = 'N'
6228: and m.request_id = req_id
6229: and m.set_number = set_num)
6230: --changed for bug 3196900

Line 6241: from ra_customer_merges m

6237: select hist.HEADER_ID
6238: from oe_blanket_headers_hist hist, oe_blanket_headers h
6239: where hist.deliver_to_org_id in
6240: (select m.duplicate_site_id
6241: from ra_customer_merges m
6242: where m.process_flag = 'N'
6243: and m.request_id = req_id
6244: and m.set_number = set_num)
6245: --added for bug 3196900

Line 6256: from ra_customer_merges m

6252: select hist.HEADER_ID
6253: from oe_blanket_headers_hist hist, oe_blanket_headers h
6254: where hist.sold_to_org_id in
6255: (select m.duplicate_id
6256: from ra_customer_merges m
6257: where m.process_flag = 'N'
6258: and m.request_id = req_id
6259: and m.set_number = set_num)
6260: --added for bug 3196900

Line 6270: from ra_customer_merges m

6266: select hist.HEADER_ID
6267: from oe_blanket_headers_hist hist,oe_blanket_headers h
6268: where hist.sold_to_site_use_id in
6269: (select m.duplicate_id
6270: from ra_customer_merges m
6271: where m.process_flag = 'N'
6272: and m.request_id = req_id
6273: and m.set_number = set_num)
6274: --added for bug 3196900

Line 6343: ra_customer_merges m

6339: hz_utility_pub.LAST_UPDATE_LOGIN,
6340: hz_utility_pub.LAST_UPDATE_DATE,
6341: hz_utility_pub.LAST_UPDATED_BY
6342: from oe_blanket_headers_hist h,
6343: ra_customer_merges m
6344: where h.ship_to_org_id=m.duplicate_site_id
6345: and m.process_flag = 'N'
6346: and m.request_id = req_id
6347: and m.set_number = set_num;

Line 6356: from ra_customer_merges m

6352: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6353:
6354: UPDATE oe_blanket_headers_hist a
6355: set ship_to_org_id = (select distinct m.customer_site_id
6356: from ra_customer_merges m
6357: where a.ship_to_org_id = m.duplicate_site_id
6358: and m.request_id = req_id
6359: and m.process_flag = 'N'
6360: and m.set_number = set_num),

Line 6369: from ra_customer_merges m

6365: program_application_id =arp_standard.profile.program_application_id,
6366: program_id = arp_standard.profile.program_id,
6367: program_update_date = sysdate
6368: where ship_to_org_id in (select m.duplicate_site_id
6369: from ra_customer_merges m
6370: where m.process_flag = 'N'
6371: and m.request_id = req_id
6372: and m.set_number = set_num);
6373: g_count := sql%rowcount;

Line 6410: ra_customer_merges m

6406: hz_utility_pub.LAST_UPDATE_LOGIN,
6407: hz_utility_pub.LAST_UPDATE_DATE,
6408: hz_utility_pub.LAST_UPDATED_BY
6409: from oe_blanket_headers_hist h,
6410: ra_customer_merges m
6411: where h.invoice_to_org_id=m.duplicate_site_id
6412: and m.process_flag = 'N'
6413: and m.request_id = req_id
6414: and m.set_number = set_num;

Line 6422: from ra_customer_merges m

6418: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6419:
6420: UPDATE oe_blanket_headers_hist a
6421: set invoice_to_org_id = (select distinct m.customer_site_id
6422: from ra_customer_merges m
6423: where a.invoice_to_org_id = m.duplicate_site_id
6424: and m.request_id = req_id
6425: and m.process_flag = 'N'
6426: and m.set_number = set_num),

Line 6435: from ra_customer_merges m

6431: program_application_id =arp_standard.profile.program_application_id,
6432: program_id = arp_standard.profile.program_id,
6433: program_update_date = sysdate
6434: where invoice_to_org_id in (select m.duplicate_site_id
6435: from ra_customer_merges m
6436: where m.process_flag = 'N'
6437: and m.request_id = req_id
6438: and m.set_number = set_num);
6439: g_count := sql%rowcount;

Line 6477: ra_customer_merges m

6473: hz_utility_pub.LAST_UPDATE_LOGIN,
6474: hz_utility_pub.LAST_UPDATE_DATE,
6475: hz_utility_pub.LAST_UPDATED_BY
6476: from oe_blanket_headers_hist h,
6477: ra_customer_merges m
6478: where h.deliver_to_org_id=m.duplicate_site_id
6479: and m.process_flag = 'N'
6480: and m.request_id = req_id
6481: and m.set_number = set_num;

Line 6488: from ra_customer_merges m

6484: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6485:
6486: UPDATE oe_blanket_headers_hist a
6487: set deliver_to_org_id = (select distinct m.customer_site_id
6488: from ra_customer_merges m
6489: where a.deliver_to_org_id = m.duplicate_site_id
6490: and m.request_id = req_id
6491: and m.process_flag = 'N'
6492: and m.set_number = set_num),

Line 6501: from ra_customer_merges m

6497: program_application_id =arp_standard.profile.program_application_id,
6498: program_id = arp_standard.profile.program_id,
6499: program_update_date = sysdate
6500: where deliver_to_org_id in (select m.duplicate_site_id
6501: from ra_customer_merges m
6502: where m.process_flag = 'N'
6503: and m.request_id = req_id
6504: and m.set_number = set_num);
6505: g_count := sql%rowcount;

Line 6546: ra_customer_merges m

6542: hz_utility_pub.LAST_UPDATE_LOGIN,
6543: hz_utility_pub.LAST_UPDATE_DATE,
6544: hz_utility_pub.LAST_UPDATED_BY
6545: from oe_blanket_headers_hist h,
6546: ra_customer_merges m
6547: where h.sold_to_org_id=m.duplicate_site_id
6548: and m.process_flag = 'N'
6549: and m.request_id = req_id
6550: and m.set_number = set_num;

Line 6559: from ra_customer_merges m

6555: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6556:
6557: UPDATE oe_blanket_headers_hist a
6558: set sold_to_org_id = (select distinct m.customer_id
6559: from ra_customer_merges m
6560: where a.sold_to_org_id = m.duplicate_id
6561: and m.process_flag = 'N'
6562: and m.request_id = req_id
6563: and m.set_number = set_num),

Line 6572: from ra_customer_merges m

6568: program_application_id =arp_standard.profile.program_application_id,
6569: program_id = arp_standard.profile.program_id,
6570: program_update_date = sysdate
6571: where sold_to_org_id in (select m.duplicate_id
6572: from ra_customer_merges m
6573: where m.process_flag = 'N'
6574: and m.request_id = req_id
6575: and m.set_number = set_num);
6576:

Line 6619: ra_customer_merges m

6615: hz_utility_pub.LAST_UPDATE_LOGIN,
6616: hz_utility_pub.LAST_UPDATE_DATE,
6617: hz_utility_pub.LAST_UPDATED_BY
6618: from oe_blanket_headers_hist h,
6619: ra_customer_merges m
6620: where h.sold_to_org_id=m.duplicate_site_id
6621: and m.process_flag = 'N'
6622: and m.request_id = req_id
6623: and m.set_number = set_num;

Line 6632: from ra_customer_merges m

6628: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_HIST', FALSE );
6629:
6630: UPDATE oe_blanket_headers_hist a
6631: set sold_to_site_use_id = (select distinct m.customer_id
6632: from ra_customer_merges m
6633: where a.sold_to_site_use_id = m.duplicate_id
6634: and m.process_flag = 'N'
6635: and m.request_id = req_id
6636: and m.set_number = set_num),

Line 6645: from ra_customer_merges m

6641: program_application_id =arp_standard.profile.program_application_id,
6642: program_id = arp_standard.profile.program_id,
6643: program_update_date = sysdate
6644: where sold_to_site_use_id in (select m.duplicate_id
6645: from ra_customer_merges m
6646: where m.process_flag = 'N'
6647: and m.request_id = req_id
6648: and m.set_number = set_num);
6649:

Line 6677: from ra_customer_merges m

6673: IS
6674:
6675: CURSOR MERGE_SITES IS
6676: select duplicate_id, customer_id, duplicate_site_id, customer_site_id
6677: from ra_customer_merges m
6678: where m.process_flag = 'N'
6679: and m.request_id = req_id
6680: and m.set_number = set_num;
6681:

Line 6696: FROM RA_CUSTOMER_MERGES M1,

6692: ship_to_org_id,
6693: intmed_ship_to_org_id,
6694: deliver_to_org_id,
6695: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
6696: FROM RA_CUSTOMER_MERGES M1,
6697: RA_CUSTOMER_MERGES M2,
6698: RA_CUSTOMER_MERGES M3,
6699: RA_CUSTOMER_MERGES M4,
6700: RA_CUSTOMER_MERGES M5,

Line 6697: RA_CUSTOMER_MERGES M2,

6693: intmed_ship_to_org_id,
6694: deliver_to_org_id,
6695: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
6696: FROM RA_CUSTOMER_MERGES M1,
6697: RA_CUSTOMER_MERGES M2,
6698: RA_CUSTOMER_MERGES M3,
6699: RA_CUSTOMER_MERGES M4,
6700: RA_CUSTOMER_MERGES M5,
6701: -- changed for bug 3196900

Line 6698: RA_CUSTOMER_MERGES M3,

6694: deliver_to_org_id,
6695: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
6696: FROM RA_CUSTOMER_MERGES M1,
6697: RA_CUSTOMER_MERGES M2,
6698: RA_CUSTOMER_MERGES M3,
6699: RA_CUSTOMER_MERGES M4,
6700: RA_CUSTOMER_MERGES M5,
6701: -- changed for bug 3196900
6702: -- OE_BLANKET_LINES_ALL L

Line 6699: RA_CUSTOMER_MERGES M4,

6695: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
6696: FROM RA_CUSTOMER_MERGES M1,
6697: RA_CUSTOMER_MERGES M2,
6698: RA_CUSTOMER_MERGES M3,
6699: RA_CUSTOMER_MERGES M4,
6700: RA_CUSTOMER_MERGES M5,
6701: -- changed for bug 3196900
6702: -- OE_BLANKET_LINES_ALL L
6703: OE_BLANKET_LINES L

Line 6700: RA_CUSTOMER_MERGES M5,

6696: FROM RA_CUSTOMER_MERGES M1,
6697: RA_CUSTOMER_MERGES M2,
6698: RA_CUSTOMER_MERGES M3,
6699: RA_CUSTOMER_MERGES M4,
6700: RA_CUSTOMER_MERGES M5,
6701: -- changed for bug 3196900
6702: -- OE_BLANKET_LINES_ALL L
6703: OE_BLANKET_LINES L
6704: WHERE

Line 6748: FROM RA_CUSTOMER_MERGES M1,

6744: ship_to_org_id,
6745: intmed_ship_to_org_id,
6746: deliver_to_org_id,
6747: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
6748: FROM RA_CUSTOMER_MERGES M1,
6749: RA_CUSTOMER_MERGES M2,
6750: RA_CUSTOMER_MERGES M3,
6751: RA_CUSTOMER_MERGES M4,
6752: RA_CUSTOMER_MERGES M5,

Line 6749: RA_CUSTOMER_MERGES M2,

6745: intmed_ship_to_org_id,
6746: deliver_to_org_id,
6747: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
6748: FROM RA_CUSTOMER_MERGES M1,
6749: RA_CUSTOMER_MERGES M2,
6750: RA_CUSTOMER_MERGES M3,
6751: RA_CUSTOMER_MERGES M4,
6752: RA_CUSTOMER_MERGES M5,
6753: --changed for bug 3196900

Line 6750: RA_CUSTOMER_MERGES M3,

6746: deliver_to_org_id,
6747: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
6748: FROM RA_CUSTOMER_MERGES M1,
6749: RA_CUSTOMER_MERGES M2,
6750: RA_CUSTOMER_MERGES M3,
6751: RA_CUSTOMER_MERGES M4,
6752: RA_CUSTOMER_MERGES M5,
6753: --changed for bug 3196900
6754: -- OE_BLANKET_LINES_ALL L

Line 6751: RA_CUSTOMER_MERGES M4,

6747: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
6748: FROM RA_CUSTOMER_MERGES M1,
6749: RA_CUSTOMER_MERGES M2,
6750: RA_CUSTOMER_MERGES M3,
6751: RA_CUSTOMER_MERGES M4,
6752: RA_CUSTOMER_MERGES M5,
6753: --changed for bug 3196900
6754: -- OE_BLANKET_LINES_ALL L
6755: OE_BLANKET_LINES L

Line 6752: RA_CUSTOMER_MERGES M5,

6748: FROM RA_CUSTOMER_MERGES M1,
6749: RA_CUSTOMER_MERGES M2,
6750: RA_CUSTOMER_MERGES M3,
6751: RA_CUSTOMER_MERGES M4,
6752: RA_CUSTOMER_MERGES M5,
6753: --changed for bug 3196900
6754: -- OE_BLANKET_LINES_ALL L
6755: OE_BLANKET_LINES L
6756: WHERE

Line 7002: from ra_customer_merges m

6998: IS
6999:
7000: CURSOR MERGE_SITES IS
7001: select duplicate_id, customer_id, duplicate_site_id, customer_site_id
7002: from ra_customer_merges m
7003: where m.process_flag = 'N'
7004: and m.request_id = req_id
7005: and m.set_number = set_num;
7006: /* MOAC_SQL_CHANGE */

Line 7023: FROM RA_CUSTOMER_MERGES M1,

7019: l.intmed_ship_to_org_id,
7020: l.deliver_to_org_id,
7021: l.version_number,
7022: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
7023: FROM RA_CUSTOMER_MERGES M1,
7024: RA_CUSTOMER_MERGES M2,
7025: RA_CUSTOMER_MERGES M3,
7026: RA_CUSTOMER_MERGES M4,
7027: RA_CUSTOMER_MERGES M5,

Line 7024: RA_CUSTOMER_MERGES M2,

7020: l.deliver_to_org_id,
7021: l.version_number,
7022: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
7023: FROM RA_CUSTOMER_MERGES M1,
7024: RA_CUSTOMER_MERGES M2,
7025: RA_CUSTOMER_MERGES M3,
7026: RA_CUSTOMER_MERGES M4,
7027: RA_CUSTOMER_MERGES M5,
7028: --changed for bug 3196900

Line 7025: RA_CUSTOMER_MERGES M3,

7021: l.version_number,
7022: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
7023: FROM RA_CUSTOMER_MERGES M1,
7024: RA_CUSTOMER_MERGES M2,
7025: RA_CUSTOMER_MERGES M3,
7026: RA_CUSTOMER_MERGES M4,
7027: RA_CUSTOMER_MERGES M5,
7028: --changed for bug 3196900
7029: -- OE_BLANKET_LINES_HIST L

Line 7026: RA_CUSTOMER_MERGES M4,

7022: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
7023: FROM RA_CUSTOMER_MERGES M1,
7024: RA_CUSTOMER_MERGES M2,
7025: RA_CUSTOMER_MERGES M3,
7026: RA_CUSTOMER_MERGES M4,
7027: RA_CUSTOMER_MERGES M5,
7028: --changed for bug 3196900
7029: -- OE_BLANKET_LINES_HIST L
7030: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_ALL LN

Line 7027: RA_CUSTOMER_MERGES M5,

7023: FROM RA_CUSTOMER_MERGES M1,
7024: RA_CUSTOMER_MERGES M2,
7025: RA_CUSTOMER_MERGES M3,
7026: RA_CUSTOMER_MERGES M4,
7027: RA_CUSTOMER_MERGES M5,
7028: --changed for bug 3196900
7029: -- OE_BLANKET_LINES_HIST L
7030: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_ALL LN
7031: -- Changed for MOAC

Line 7080: FROM RA_CUSTOMER_MERGES M1,

7076: l.intmed_ship_to_org_id,
7077: l.deliver_to_org_id,
7078: l.version_number,
7079: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
7080: FROM RA_CUSTOMER_MERGES M1,
7081: RA_CUSTOMER_MERGES M2,
7082: RA_CUSTOMER_MERGES M3,
7083: RA_CUSTOMER_MERGES M4,
7084: RA_CUSTOMER_MERGES M5,

Line 7081: RA_CUSTOMER_MERGES M2,

7077: l.deliver_to_org_id,
7078: l.version_number,
7079: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
7080: FROM RA_CUSTOMER_MERGES M1,
7081: RA_CUSTOMER_MERGES M2,
7082: RA_CUSTOMER_MERGES M3,
7083: RA_CUSTOMER_MERGES M4,
7084: RA_CUSTOMER_MERGES M5,
7085: --changed for bug 3196900

Line 7082: RA_CUSTOMER_MERGES M3,

7078: l.version_number,
7079: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
7080: FROM RA_CUSTOMER_MERGES M1,
7081: RA_CUSTOMER_MERGES M2,
7082: RA_CUSTOMER_MERGES M3,
7083: RA_CUSTOMER_MERGES M4,
7084: RA_CUSTOMER_MERGES M5,
7085: --changed for bug 3196900
7086: -- OE_BLANKET_LINES_HIST L

Line 7083: RA_CUSTOMER_MERGES M4,

7079: nvl(m1.customer_merge_id,nvl(m2.customer_merge_id,nvl(m3.customer_merge_id,nvl(m4.customer_merge_id,m5.customer_merge_id))))
7080: FROM RA_CUSTOMER_MERGES M1,
7081: RA_CUSTOMER_MERGES M2,
7082: RA_CUSTOMER_MERGES M3,
7083: RA_CUSTOMER_MERGES M4,
7084: RA_CUSTOMER_MERGES M5,
7085: --changed for bug 3196900
7086: -- OE_BLANKET_LINES_HIST L
7087: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN

Line 7084: RA_CUSTOMER_MERGES M5,

7080: FROM RA_CUSTOMER_MERGES M1,
7081: RA_CUSTOMER_MERGES M2,
7082: RA_CUSTOMER_MERGES M3,
7083: RA_CUSTOMER_MERGES M4,
7084: RA_CUSTOMER_MERGES M5,
7085: --changed for bug 3196900
7086: -- OE_BLANKET_LINES_HIST L
7087: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN
7088: -- Changed for MOAC

Line 7347: from ra_customer_merges m

7343: -- from OE_EM_INFORMATION_ALL
7344: from OE_EM_INFORMATION
7345: where sold_to_org_id in
7346: (select m.duplicate_id
7347: from ra_customer_merges m
7348: where m.process_flag = 'N'
7349: and m.request_id = req_id
7350: and m.set_number = set_num)
7351: for update nowait;

Line 7415: ra_customer_merges m

7411: hz_utility_pub.LAST_UPDATE_LOGIN,
7412: hz_utility_pub.LAST_UPDATE_DATE,
7413: hz_utility_pub.LAST_UPDATED_BY
7414: from oe_em_information_All h,
7415: ra_customer_merges m
7416: where h.sold_to_org_id=m.duplicate_site_id
7417: and m.process_flag = 'N'
7418: and m.request_id = req_id
7419: and m.set_number = set_num;

Line 7425: from ra_customer_merges m

7421: end if;
7422:
7423: UPDATE OE_EM_INFORMATION_ALL a
7424: set sold_to_org_id = (select distinct m.customer_id
7425: from ra_customer_merges m
7426: where a.sold_to_org_id = m.duplicate_id
7427: and m.process_flag = 'N'
7428: and m.request_id = req_id
7429: and m.set_number = set_num),

Line 7438: from ra_customer_merges m

7434: program_application_id =arp_standard.profile.program_application_id,
7435: program_id = arp_standard.profile.program_id,
7436: program_update_date = sysdate
7437: where sold_to_org_id in (select m.duplicate_id
7438: from ra_customer_merges m
7439: where m.process_flag = 'N'
7440: and m.request_id = req_id
7441: and m.set_number = set_num)
7442: --added for bug3196900