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

Line 106: FROM ra_customer_merges cme

102: WHERE ojt.object_code = oue.object_code
103: AND oue.object_user_code = b_object_use
104: )
105: AND kpr.object1_id1 IN (SELECT to_char(cme.duplicate_id)
106: FROM ra_customer_merges cme
107: WHERE cme.process_flag = 'N'
108: AND cme.request_id = req_id
109: AND cme.set_number = set_number
110: )

Line 126: FROM ra_customer_merges cme

122: WHERE ojt.object_code = oue.object_code
123: AND oue.object_user_code = b_object_use
124: )
125: AND rle.object1_id1 IN (SELECT to_char(cme.duplicate_id)
126: FROM ra_customer_merges cme
127: WHERE cme.process_flag = 'N'
128: AND cme.request_id = req_id
129: AND cme.set_number = set_number
130: )

Line 143: FROM ra_customer_merges cme

139: WHERE ojt.object_code = oue.object_code
140: AND oue.object_user_code = b_object_use
141: )
142: AND rle.object2_id1 IN (SELECT to_char(cme.duplicate_id)
143: FROM ra_customer_merges cme
144: WHERE cme.process_flag = 'N'
145: AND cme.request_id = req_id
146: AND cme.set_number = set_number
147: )

Line 160: FROM ra_customer_merges cme

156: WHERE ojt.object_code = oue.object_code
157: AND oue.object_user_code = b_object_use
158: )
159: AND rle.object3_id1 IN (SELECT to_char(cme.duplicate_id)
160: FROM ra_customer_merges cme
161: WHERE cme.process_flag = 'N'
162: AND cme.request_id = req_id
163: AND cme.set_number = set_number
164: )

Line 177: FROM ra_customer_merges cme

173: WHERE ojt.object_code = oue.object_code
174: AND oue.object_user_code = b_object_use
175: )
176: AND cim.object1_id1 IN (SELECT to_char(cme.duplicate_id)
177: FROM ra_customer_merges cme
178: WHERE cme.process_flag = 'N'
179: AND cme.request_id = req_id
180: AND cme.set_number = set_number
181: )

Line 494: FROM ra_customer_merges rcm

490: FROM DUAL;
491:
492: UPDATE HZ_CUSTOMER_MERGE_LOG hz
493: SET hz.MERGE_HEADER_ID = (SELECT distinct CUSTOMER_MERGE_HEADER_ID
494: FROM ra_customer_merges rcm
495: WHERE rcm.request_id = req_id
496: and rcm.set_number = set_number
497: and rcm.process_flag = 'N')
498: ,hz.VCHAR_COL1_ORIG = l_source_party_id

Line 613: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm

609: hz_utility_pub.CREATION_DATE,
610: hz_utility_pub.LAST_UPDATE_LOGIN,
611: hz_utility_pub.LAST_UPDATE_DATE,
612: hz_utility_pub.LAST_UPDATED_BY
613: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm
614: WHERE (
615: kpr.object1_id1 = to_char(rcm.duplicate_id)
616: ) AND rcm.process_flag = 'N'
617: AND rcm.request_id = req_id

Line 620: FROM ra_customer_merges rcm

616: ) AND rcm.process_flag = 'N'
617: AND rcm.request_id = req_id
618: AND rcm.set_number = set_number
619: AND kpr.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
620: FROM ra_customer_merges rcm
621: WHERE rcm.process_flag = 'N'
622: AND rcm.request_id = req_id
623: AND rcm.set_number = set_number)
624: AND kpr.jtot_object1_code IN (SELECT ojt.object_code

Line 635: FROM ra_customer_merges rcm

631: arp_message.set_name('AR','AR_UPDATING_TABLE');
632: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES',FALSE);
633: UPDATE okc_k_party_roles_b kpr
634: SET kpr.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
635: FROM ra_customer_merges rcm
636: WHERE kpr.object1_id1 = rcm.duplicate_id
637: AND rcm.process_flag = 'N'
638: AND rcm.request_id = req_id
639: AND rcm.set_number = set_number)

Line 645: FROM ra_customer_merges rcm

641: ,kpr.last_update_date = SYSDATE
642: ,kpr.last_updated_by = arp_standard.profile.user_id
643: ,kpr.last_update_login = arp_standard.profile.last_update_login
644: WHERE kpr.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
645: FROM ra_customer_merges rcm
646: WHERE rcm.process_flag = 'N'
647: AND rcm.request_id = req_id
648: AND rcm.set_number = set_number)
649: AND kpr.jtot_object1_code IN (SELECT ojt.object_code

Line 689: FROM OKC_RULES_B rle, ra_customer_merges rcm

685: hz_utility_pub.CREATION_DATE,
686: hz_utility_pub.LAST_UPDATE_LOGIN,
687: hz_utility_pub.LAST_UPDATE_DATE,
688: hz_utility_pub.LAST_UPDATED_BY
689: FROM OKC_RULES_B rle, ra_customer_merges rcm
690: WHERE (
691: rle.object1_id1 = to_char(rcm.duplicate_id)
692: ) AND rcm.process_flag = 'N'
693: AND rcm.request_id = req_id

Line 696: FROM ra_customer_merges rcm

692: ) AND rcm.process_flag = 'N'
693: AND rcm.request_id = req_id
694: AND rcm.set_number = set_number
695: AND rle.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
696: FROM ra_customer_merges rcm
697: WHERE rcm.process_flag = 'N'
698: AND rcm.request_id = req_id
699: AND rcm.set_number = set_number)
700: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 711: FROM ra_customer_merges rcm

707: arp_message.set_name('AR','AR_UPDATING_TABLE');
708: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);
709: UPDATE okc_rules_b rle
710: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
711: FROM ra_customer_merges rcm
712: WHERE rle.object1_id1 = rcm.duplicate_id
713: AND rcm.process_flag = 'N'
714: AND rcm.request_id = req_id
715: AND rcm.set_number = set_number)

Line 721: FROM ra_customer_merges rcm

717: ,rle.last_update_date = SYSDATE
718: ,rle.last_updated_by = arp_standard.profile.user_id
719: ,rle.last_update_login = arp_standard.profile.last_update_login
720: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
721: FROM ra_customer_merges rcm
722: WHERE rcm.process_flag = 'N'
723: AND rcm.request_id = req_id
724: AND rcm.set_number = set_number)
725: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 766: FROM OKC_RULES_B rle, ra_customer_merges rcm

762: hz_utility_pub.CREATION_DATE,
763: hz_utility_pub.LAST_UPDATE_LOGIN,
764: hz_utility_pub.LAST_UPDATE_DATE,
765: hz_utility_pub.LAST_UPDATED_BY
766: FROM OKC_RULES_B rle, ra_customer_merges rcm
767: WHERE (
768: rle.object2_id1 = to_char(rcm.duplicate_id)
769: ) AND rcm.process_flag = 'N'
770: AND rcm.request_id = req_id

Line 773: FROM ra_customer_merges rcm

769: ) AND rcm.process_flag = 'N'
770: AND rcm.request_id = req_id
771: AND rcm.set_number = set_number
772: AND rle.object2_id1 IN (SELECT to_char(rcm.duplicate_id)
773: FROM ra_customer_merges rcm
774: WHERE rcm.process_flag = 'N'
775: AND rcm.request_id = req_id
776: AND rcm.set_number = set_number)
777: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 788: FROM ra_customer_merges rcm

784: arp_message.set_name('AR','AR_UPDATING_TABLE');
785: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);
786: UPDATE okc_rules_b rle
787: SET rle.object2_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
788: FROM ra_customer_merges rcm
789: WHERE rle.object2_id1 = rcm.duplicate_id
790: AND rcm.process_flag = 'N'
791: AND rcm.request_id = req_id
792: AND rcm.set_number = set_number)

Line 798: FROM ra_customer_merges rcm

794: ,rle.last_update_date = SYSDATE
795: ,rle.last_updated_by = arp_standard.profile.user_id
796: ,rle.last_update_login = arp_standard.profile.last_update_login
797: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_id)
798: FROM ra_customer_merges rcm
799: WHERE rcm.process_flag = 'N'
800: AND rcm.request_id = req_id
801: AND rcm.set_number = set_number)
802: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 843: FROM OKC_RULES_B rle, ra_customer_merges rcm

839: hz_utility_pub.CREATION_DATE,
840: hz_utility_pub.LAST_UPDATE_LOGIN,
841: hz_utility_pub.LAST_UPDATE_DATE,
842: hz_utility_pub.LAST_UPDATED_BY
843: FROM OKC_RULES_B rle, ra_customer_merges rcm
844: WHERE (
845: rle.object3_id1 = to_char(rcm.duplicate_id)
846: ) AND rcm.process_flag = 'N'
847: AND rcm.request_id = req_id

Line 850: FROM ra_customer_merges rcm

846: ) AND rcm.process_flag = 'N'
847: AND rcm.request_id = req_id
848: AND rcm.set_number = set_number
849: AND rle.object3_id1 IN (SELECT to_char(rcm.duplicate_id)
850: FROM ra_customer_merges rcm
851: WHERE rcm.process_flag = 'N'
852: AND rcm.request_id = req_id
853: AND rcm.set_number = set_number)
854: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 865: FROM ra_customer_merges rcm

861: arp_message.set_name('AR','AR_UPDATING_TABLE');
862: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
863: UPDATE okc_rules_b rle
864: SET rle.object3_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
865: FROM ra_customer_merges rcm
866: WHERE rle.object3_id1 = rcm.duplicate_id
867: AND rcm.process_flag = 'N'
868: AND rcm.request_id = req_id
869: AND rcm.set_number = set_number)

Line 875: FROM ra_customer_merges rcm

871: ,rle.last_update_date = SYSDATE
872: ,rle.last_updated_by = arp_standard.profile.user_id
873: ,rle.last_update_login = arp_standard.profile.last_update_login
874: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_id)
875: FROM ra_customer_merges rcm
876: WHERE rcm.process_flag = 'N'
877: AND rcm.request_id = req_id
878: AND rcm.set_number = set_number)
879: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 921: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

917: hz_utility_pub.CREATION_DATE,
918: hz_utility_pub.LAST_UPDATE_LOGIN,
919: hz_utility_pub.LAST_UPDATE_DATE,
920: hz_utility_pub.LAST_UPDATED_BY
921: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
922: WHERE (
923: okh.cust_acct_id = rcm.duplicate_id
924: ) AND rcm.process_flag = 'N'
925: AND rcm.request_id = req_id

Line 928: FROM ra_customer_merges rcm

924: ) AND rcm.process_flag = 'N'
925: AND rcm.request_id = req_id
926: AND rcm.set_number = set_number
927: AND okh.cust_acct_id IN (SELECT rcm.duplicate_id
928: FROM ra_customer_merges rcm
929: WHERE rcm.process_flag = 'N'
930: AND rcm.request_id = req_id
931: AND rcm.set_number = set_number);
932:

Line 940: FROM ra_customer_merges rcm

936: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.CUST_ACCT_ID',FALSE);
937:
938: UPDATE okc_k_headers_b okh
939: SET okh.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
940: FROM ra_customer_merges rcm
941: WHERE okh.cust_acct_id = rcm.duplicate_id
942: AND rcm.process_flag = 'N'
943: AND rcm.request_id = req_id
944: AND rcm.set_number = set_number)

Line 950: FROM ra_customer_merges rcm

946: ,okh.last_update_date = SYSDATE
947: ,okh.last_updated_by = arp_standard.profile.user_id
948: ,okh.last_update_login = arp_standard.profile.last_update_login
949: WHERE okh.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
950: FROM ra_customer_merges rcm
951: WHERE rcm.process_flag = 'N'
952: AND rcm.request_id = req_id
953: AND rcm.set_number = set_number);
954:

Line 992: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

988: hz_utility_pub.CREATION_DATE,
989: hz_utility_pub.LAST_UPDATE_LOGIN,
990: hz_utility_pub.LAST_UPDATE_DATE,
991: hz_utility_pub.LAST_UPDATED_BY
992: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
993: WHERE (
994: okl.cust_acct_id = rcm.duplicate_id
995: ) AND rcm.process_flag = 'N'
996: AND rcm.request_id = req_id

Line 999: FROM ra_customer_merges rcm

995: ) AND rcm.process_flag = 'N'
996: AND rcm.request_id = req_id
997: AND rcm.set_number = set_number
998: AND okl.cust_acct_id IN (SELECT rcm.duplicate_id
999: FROM ra_customer_merges rcm
1000: WHERE rcm.process_flag = 'N'
1001: AND rcm.request_id = req_id
1002: AND rcm.set_number = set_number);
1003:

Line 1011: FROM ra_customer_merges rcm

1007: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.CUST_ACCT_ID',FALSE);
1008:
1009: UPDATE okc_k_lines_b okl
1010: SET okl.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
1011: FROM ra_customer_merges rcm
1012: WHERE okl.cust_acct_id = rcm.duplicate_id
1013: AND rcm.process_flag = 'N'
1014: AND rcm.request_id = req_id
1015: AND rcm.set_number = set_number)

Line 1021: FROM ra_customer_merges rcm

1017: ,okl.last_update_date = SYSDATE
1018: ,okl.last_updated_by = arp_standard.profile.user_id
1019: ,okl.last_update_login = arp_standard.profile.last_update_login
1020: WHERE okl.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
1021: FROM ra_customer_merges rcm
1022: WHERE rcm.process_flag = 'N'
1023: AND rcm.request_id = req_id
1024: AND rcm.set_number = set_number);
1025:

Line 1061: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm

1057: hz_utility_pub.CREATION_DATE,
1058: hz_utility_pub.LAST_UPDATE_LOGIN,
1059: hz_utility_pub.LAST_UPDATE_DATE,
1060: hz_utility_pub.LAST_UPDATED_BY
1061: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
1062: WHERE (
1063: okpr.cust_acct_id = rcm.duplicate_id
1064: ) AND rcm.process_flag = 'N'
1065: AND rcm.request_id = req_id

Line 1068: FROM ra_customer_merges rcm

1064: ) AND rcm.process_flag = 'N'
1065: AND rcm.request_id = req_id
1066: AND rcm.set_number = set_number
1067: AND okpr.cust_acct_id IN (SELECT rcm.duplicate_id
1068: FROM ra_customer_merges rcm
1069: WHERE rcm.process_flag = 'N'
1070: AND rcm.request_id = req_id
1071: AND rcm.set_number = set_number);
1072:

Line 1080: FROM ra_customer_merges rcm

1076: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.CUST_ACCT_ID',FALSE);
1077:
1078: UPDATE okc_k_party_roles_b okpr
1079: SET okpr.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
1080: FROM ra_customer_merges rcm
1081: WHERE okpr.cust_acct_id = rcm.duplicate_id
1082: AND rcm.process_flag = 'N'
1083: AND rcm.request_id = req_id
1084: AND rcm.set_number = set_number)

Line 1090: FROM ra_customer_merges rcm

1086: ,okpr.last_update_date = SYSDATE
1087: ,okpr.last_updated_by = arp_standard.profile.user_id
1088: ,okpr.last_update_login = arp_standard.profile.last_update_login
1089: WHERE okpr.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
1090: FROM ra_customer_merges rcm
1091: WHERE rcm.process_flag = 'N'
1092: AND rcm.request_id = req_id
1093: AND rcm.set_number = set_number);
1094:

Line 1131: FROM OKC_K_ITEMS cim, ra_customer_merges rcm

1127: hz_utility_pub.CREATION_DATE,
1128: hz_utility_pub.LAST_UPDATE_LOGIN,
1129: hz_utility_pub.LAST_UPDATE_DATE,
1130: hz_utility_pub.LAST_UPDATED_BY
1131: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1132: WHERE (
1133: cim.object1_id1 = to_char(rcm.duplicate_id)
1134: ) AND rcm.process_flag = 'N'
1135: AND rcm.request_id = req_id

Line 1138: FROM ra_customer_merges rcm

1134: ) AND rcm.process_flag = 'N'
1135: AND rcm.request_id = req_id
1136: AND rcm.set_number = set_number
1137: AND cim.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
1138: FROM ra_customer_merges rcm
1139: WHERE rcm.process_flag = 'N'
1140: AND rcm.request_id = req_id
1141: AND rcm.set_number = set_number)
1142: AND cim.jtot_object1_code IN (SELECT ojt.object_code

Line 1153: FROM ra_customer_merges rcm

1149: arp_message.set_name('AR','AR_UPDATING_TABLE');
1150: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
1151: UPDATE okc_k_items cim
1152: SET cim.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
1153: FROM ra_customer_merges rcm
1154: WHERE cim.object1_id1 = rcm.duplicate_id
1155: AND rcm.process_flag = 'N'
1156: AND rcm.request_id = req_id
1157: AND rcm.set_number = set_number)

Line 1163: FROM ra_customer_merges rcm

1159: ,cim.last_update_date = SYSDATE
1160: ,cim.last_updated_by = arp_standard.profile.user_id
1161: ,cim.last_update_login = arp_standard.profile.last_update_login
1162: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
1163: FROM ra_customer_merges rcm
1164: WHERE rcm.process_flag = 'N'
1165: AND rcm.request_id = req_id
1166: AND rcm.set_number = set_number)
1167: AND cim.jtot_object1_code IN (SELECT ojt.object_code

Line 1230: FROM OKC_RULES_B rle, ra_customer_merges rcm

1226: hz_utility_pub.CREATION_DATE,
1227: hz_utility_pub.LAST_UPDATE_LOGIN,
1228: hz_utility_pub.LAST_UPDATE_DATE,
1229: hz_utility_pub.LAST_UPDATED_BY
1230: FROM OKC_RULES_B rle, ra_customer_merges rcm
1231: WHERE (
1232: rle.object1_id1 = to_char(rcm.duplicate_address_id)
1233: ) AND rcm.process_flag = 'N'
1234: AND rcm.request_id = req_id

Line 1237: FROM ra_customer_merges rcm

1233: ) AND rcm.process_flag = 'N'
1234: AND rcm.request_id = req_id
1235: AND rcm.set_number = set_number
1236: AND rle.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1237: FROM ra_customer_merges rcm
1238: WHERE rcm.process_flag = 'N'
1239: AND rcm.request_id = req_id
1240: AND rcm.set_number = set_number)
1241: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 1252: FROM ra_customer_merges rcm

1248: arp_message.set_name('AR','AR_UPDATING_TABLE');
1249: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);
1250: UPDATE okc_rules_b rle
1251: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1252: FROM ra_customer_merges rcm
1253: WHERE rle.object1_id1 = rcm.duplicate_address_id
1254: AND rcm.process_flag = 'N'
1255: AND rcm.request_id = req_id
1256: AND rcm.set_number = set_number

Line 1263: FROM ra_customer_merges rcm

1259: ,rle.last_update_date = SYSDATE
1260: ,rle.last_updated_by = arp_standard.profile.user_id
1261: ,rle.last_update_login = arp_standard.profile.last_update_login
1262: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1263: FROM ra_customer_merges rcm
1264: WHERE rcm.process_flag = 'N'
1265: AND rcm.request_id = req_id
1266: AND rcm.set_number = set_number)
1267: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 1308: FROM OKC_RULES_B rle, ra_customer_merges rcm

1304: hz_utility_pub.CREATION_DATE,
1305: hz_utility_pub.LAST_UPDATE_LOGIN,
1306: hz_utility_pub.LAST_UPDATE_DATE,
1307: hz_utility_pub.LAST_UPDATED_BY
1308: FROM OKC_RULES_B rle, ra_customer_merges rcm
1309: WHERE (
1310: rle.object2_id1 = to_char(rcm.duplicate_address_id)
1311: ) AND rcm.process_flag = 'N'
1312: AND rcm.request_id = req_id

Line 1315: FROM ra_customer_merges rcm

1311: ) AND rcm.process_flag = 'N'
1312: AND rcm.request_id = req_id
1313: AND rcm.set_number = set_number
1314: AND rle.object2_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1315: FROM ra_customer_merges rcm
1316: WHERE rcm.process_flag = 'N'
1317: AND rcm.request_id = req_id
1318: AND rcm.set_number = set_number)
1319: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 1330: FROM ra_customer_merges rcm

1326: arp_message.set_name('AR','AR_UPDATING_TABLE');
1327: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);
1328: UPDATE okc_rules_b rle
1329: SET rle.object2_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1330: FROM ra_customer_merges rcm
1331: WHERE rle.object2_id1 = rcm.duplicate_address_id
1332: AND rcm.process_flag = 'N'
1333: AND rcm.request_id = req_id
1334: AND rcm.set_number = set_number

Line 1341: FROM ra_customer_merges rcm

1337: ,rle.last_update_date = SYSDATE
1338: ,rle.last_updated_by = arp_standard.profile.user_id
1339: ,rle.last_update_login = arp_standard.profile.last_update_login
1340: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1341: FROM ra_customer_merges rcm
1342: WHERE rcm.process_flag = 'N'
1343: AND rcm.request_id = req_id
1344: AND rcm.set_number = set_number)
1345: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 1385: FROM OKC_RULES_B rle, ra_customer_merges rcm

1381: hz_utility_pub.CREATION_DATE,
1382: hz_utility_pub.LAST_UPDATE_LOGIN,
1383: hz_utility_pub.LAST_UPDATE_DATE,
1384: hz_utility_pub.LAST_UPDATED_BY
1385: FROM OKC_RULES_B rle, ra_customer_merges rcm
1386: WHERE (
1387: rle.object3_id1 = to_char(rcm.duplicate_address_id)
1388: ) AND rcm.process_flag = 'N'
1389: AND rcm.request_id = req_id

Line 1392: FROM ra_customer_merges rcm

1388: ) AND rcm.process_flag = 'N'
1389: AND rcm.request_id = req_id
1390: AND rcm.set_number = set_number
1391: AND rle.object3_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1392: FROM ra_customer_merges rcm
1393: WHERE rcm.process_flag = 'N'
1394: AND rcm.request_id = req_id
1395: AND rcm.set_number = set_number)
1396: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 1407: FROM ra_customer_merges rcm

1403: arp_message.set_name('AR','AR_UPDATING_TABLE');
1404: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
1405: UPDATE okc_rules_b rle
1406: SET rle.object3_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1407: FROM ra_customer_merges rcm
1408: WHERE rle.object3_id1 = rcm.duplicate_address_id
1409: AND rcm.process_flag = 'N'
1410: AND rcm.request_id = req_id
1411: AND rcm.set_number = set_number

Line 1418: FROM ra_customer_merges rcm

1414: ,rle.last_update_date = SYSDATE
1415: ,rle.last_updated_by = arp_standard.profile.user_id
1416: ,rle.last_update_login = arp_standard.profile.last_update_login
1417: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1418: FROM ra_customer_merges rcm
1419: WHERE rcm.process_flag = 'N'
1420: AND rcm.request_id = req_id
1421: AND rcm.set_number = set_number)
1422: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 1465: FROM OKC_K_ITEMS cim, ra_customer_merges rcm

1461: hz_utility_pub.CREATION_DATE,
1462: hz_utility_pub.LAST_UPDATE_LOGIN,
1463: hz_utility_pub.LAST_UPDATE_DATE,
1464: hz_utility_pub.LAST_UPDATED_BY
1465: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1466: WHERE (
1467: cim.object1_id1 = to_char(rcm.duplicate_address_id)
1468: ) AND rcm.process_flag = 'N'
1469: AND rcm.request_id = req_id

Line 1472: FROM ra_customer_merges rcm

1468: ) AND rcm.process_flag = 'N'
1469: AND rcm.request_id = req_id
1470: AND rcm.set_number = set_number
1471: AND cim.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1472: FROM ra_customer_merges rcm
1473: WHERE rcm.process_flag = 'N'
1474: AND rcm.request_id = req_id
1475: AND rcm.set_number = set_number)
1476: AND cim.jtot_object1_code IN (SELECT ojt.object_code

Line 1487: FROM ra_customer_merges rcm

1483: arp_message.set_name('AR','AR_UPDATING_TABLE');
1484: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
1485: UPDATE okc_k_items cim
1486: SET cim.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1487: FROM ra_customer_merges rcm
1488: WHERE cim.object1_id1 = rcm.duplicate_address_id
1489: AND rcm.process_flag = 'N'
1490: AND rcm.request_id = req_id
1491: AND rcm.set_number = set_number

Line 1498: FROM ra_customer_merges rcm

1494: ,cim.last_update_date = SYSDATE
1495: ,cim.last_updated_by = arp_standard.profile.user_id
1496: ,cim.last_update_login = arp_standard.profile.last_update_login
1497: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1498: FROM ra_customer_merges rcm
1499: WHERE rcm.process_flag = 'N'
1500: AND rcm.request_id = req_id
1501: AND rcm.set_number = set_number)
1502: AND cim.jtot_object1_code IN (SELECT ojt.object_code

Line 1552: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm

1548: hz_utility_pub.CREATION_DATE,
1549: hz_utility_pub.LAST_UPDATE_LOGIN,
1550: hz_utility_pub.LAST_UPDATE_DATE,
1551: hz_utility_pub.LAST_UPDATED_BY
1552: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm
1553: WHERE (
1554: rle.object1_id1 = to_char(rcm.duplicate_site_id)
1555: ) AND rcm.process_flag = 'N'
1556: AND rcm.request_id = req_id

Line 1559: FROM ra_customer_merges rcm

1555: ) AND rcm.process_flag = 'N'
1556: AND rcm.request_id = req_id
1557: AND rcm.set_number = set_number
1558: AND rle.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1559: FROM ra_customer_merges rcm
1560: WHERE rcm.process_flag = 'N'
1561: AND rcm.request_id = req_id
1562: AND rcm.set_number = set_number)
1563: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 1577: FROM ra_customer_merges rcm

1573: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
1574:
1575: UPDATE okc_k_party_roles_b rle
1576: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1577: FROM ra_customer_merges rcm
1578: WHERE rle.object1_id1 = rcm.duplicate_site_id
1579: AND rcm.process_flag = 'N'
1580: AND rcm.request_id = req_id
1581: AND rcm.set_number = set_number)

Line 1587: FROM ra_customer_merges rcm

1583: ,rle.last_update_date = SYSDATE
1584: ,rle.last_updated_by = arp_standard.profile.user_id
1585: ,rle.last_update_login = arp_standard.profile.last_update_login
1586: WHERE rle.object1_id1 IN ( SELECT to_char(rcm.duplicate_site_id)
1587: FROM ra_customer_merges rcm
1588: WHERE rcm.process_flag = 'N'
1589: AND rcm.request_id = req_id
1590: AND rcm.set_number = set_number)
1591: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 1645: FROM OKC_RULES_B rle, ra_customer_merges rcm

1641: hz_utility_pub.CREATION_DATE,
1642: hz_utility_pub.LAST_UPDATE_LOGIN,
1643: hz_utility_pub.LAST_UPDATE_DATE,
1644: hz_utility_pub.LAST_UPDATED_BY
1645: FROM OKC_RULES_B rle, ra_customer_merges rcm
1646: WHERE (
1647: rle.object1_id1 = to_char(rcm.duplicate_site_id)
1648: ) AND rcm.process_flag = 'N'
1649: AND rcm.request_id = req_id

Line 1652: FROM ra_customer_merges rcm

1648: ) AND rcm.process_flag = 'N'
1649: AND rcm.request_id = req_id
1650: AND rcm.set_number = set_number
1651: AND rle.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1652: FROM ra_customer_merges rcm
1653: WHERE rcm.process_flag = 'N'
1654: AND rcm.request_id = req_id
1655: AND rcm.set_number = set_number)
1656: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 1667: FROM ra_customer_merges rcm

1663: arp_message.set_name('AR','AR_UPDATING_TABLE');
1664: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);
1665: UPDATE okc_rules_b rle
1666: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1667: FROM ra_customer_merges rcm
1668: WHERE rle.object1_id1 = rcm.duplicate_site_id
1669: AND rcm.process_flag = 'N'
1670: AND rcm.request_id = req_id
1671: AND rcm.set_number = set_number)

Line 1677: FROM ra_customer_merges rcm

1673: ,rle.last_update_date = SYSDATE
1674: ,rle.last_updated_by = arp_standard.profile.user_id
1675: ,rle.last_update_login = arp_standard.profile.last_update_login
1676: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1677: FROM ra_customer_merges rcm
1678: WHERE rcm.process_flag = 'N'
1679: AND rcm.request_id = req_id
1680: AND rcm.set_number = set_number)
1681: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 1721: FROM OKC_RULES_B rle, ra_customer_merges rcm

1717: hz_utility_pub.CREATION_DATE,
1718: hz_utility_pub.LAST_UPDATE_LOGIN,
1719: hz_utility_pub.LAST_UPDATE_DATE,
1720: hz_utility_pub.LAST_UPDATED_BY
1721: FROM OKC_RULES_B rle, ra_customer_merges rcm
1722: WHERE (
1723: rle.object2_id1 = to_char(rcm.duplicate_site_id)
1724: ) AND rcm.process_flag = 'N'
1725: AND rcm.request_id = req_id

Line 1728: FROM ra_customer_merges rcm

1724: ) AND rcm.process_flag = 'N'
1725: AND rcm.request_id = req_id
1726: AND rcm.set_number = set_number
1727: AND rle.object2_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1728: FROM ra_customer_merges rcm
1729: WHERE rcm.process_flag = 'N'
1730: AND rcm.request_id = req_id
1731: AND rcm.set_number = set_number)
1732: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 1743: FROM ra_customer_merges rcm

1739: arp_message.set_name('AR','AR_UPDATING_TABLE');
1740: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);
1741: UPDATE okc_rules_b rle
1742: SET rle.object2_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1743: FROM ra_customer_merges rcm
1744: WHERE rle.object2_id1 = rcm.duplicate_site_id
1745: AND rcm.process_flag = 'N'
1746: AND rcm.request_id = req_id
1747: AND rcm.set_number = set_number)

Line 1753: FROM ra_customer_merges rcm

1749: ,rle.last_update_date = SYSDATE
1750: ,rle.last_updated_by = arp_standard.profile.user_id
1751: ,rle.last_update_login = arp_standard.profile.last_update_login
1752: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1753: FROM ra_customer_merges rcm
1754: WHERE rcm.process_flag = 'N'
1755: AND rcm.request_id = req_id
1756: AND rcm.set_number = set_number)
1757: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 1798: FROM OKC_RULES_B rle, ra_customer_merges rcm

1794: hz_utility_pub.CREATION_DATE,
1795: hz_utility_pub.LAST_UPDATE_LOGIN,
1796: hz_utility_pub.LAST_UPDATE_DATE,
1797: hz_utility_pub.LAST_UPDATED_BY
1798: FROM OKC_RULES_B rle, ra_customer_merges rcm
1799: WHERE (
1800: rle.object3_id1 = to_char(rcm.duplicate_site_id)
1801: ) AND rcm.process_flag = 'N'
1802: AND rcm.request_id = req_id

Line 1805: FROM ra_customer_merges rcm

1801: ) AND rcm.process_flag = 'N'
1802: AND rcm.request_id = req_id
1803: AND rcm.set_number = set_number
1804: AND rle.object3_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1805: FROM ra_customer_merges rcm
1806: WHERE rcm.process_flag = 'N'
1807: AND rcm.request_id = req_id
1808: AND rcm.set_number = set_number)
1809: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 1820: FROM ra_customer_merges rcm

1816: arp_message.set_name('AR','AR_UPDATING_TABLE');
1817: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
1818: UPDATE okc_rules_b rle
1819: SET rle.object3_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1820: FROM ra_customer_merges rcm
1821: WHERE rle.object3_id1 = rcm.duplicate_site_id
1822: AND rcm.process_flag = 'N'
1823: AND rcm.request_id = req_id
1824: AND rcm.set_number = set_number)

Line 1830: FROM ra_customer_merges rcm

1826: ,rle.last_update_date = SYSDATE
1827: ,rle.last_updated_by = arp_standard.profile.user_id
1828: ,rle.last_update_login = arp_standard.profile.last_update_login
1829: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1830: FROM ra_customer_merges rcm
1831: WHERE rcm.process_flag = 'N'
1832: AND rcm.request_id = req_id
1833: AND rcm.set_number = set_number)
1834: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 1876: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

1872: hz_utility_pub.CREATION_DATE,
1873: hz_utility_pub.LAST_UPDATE_LOGIN,
1874: hz_utility_pub.LAST_UPDATE_DATE,
1875: hz_utility_pub.LAST_UPDATED_BY
1876: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1877: WHERE (
1878: okh.ship_to_site_use_id = rcm.duplicate_site_id
1879: ) AND rcm.process_flag = 'N'
1880: AND rcm.request_id = req_id

Line 1883: FROM ra_customer_merges rcm

1879: ) AND rcm.process_flag = 'N'
1880: AND rcm.request_id = req_id
1881: AND rcm.set_number = set_number
1882: AND okh.ship_to_site_use_id IN (SELECT rcm.duplicate_site_id
1883: FROM ra_customer_merges rcm
1884: WHERE rcm.process_flag = 'N'
1885: AND rcm.request_id = req_id
1886: AND rcm.set_number = set_number);
1887:

Line 1895: FROM ra_customer_merges rcm

1891: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.SHIP_TO_SITE_USE_ID',FALSE);
1892:
1893: UPDATE okc_k_headers_b okh
1894: SET okh.ship_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
1895: FROM ra_customer_merges rcm
1896: WHERE okh.ship_to_site_use_id = rcm.duplicate_site_id
1897: AND rcm.process_flag = 'N'
1898: AND rcm.request_id = req_id
1899: AND rcm.set_number = set_number)

Line 1905: FROM ra_customer_merges rcm

1901: ,okh.last_update_date = SYSDATE
1902: ,okh.last_updated_by = arp_standard.profile.user_id
1903: ,okh.last_update_login = arp_standard.profile.last_update_login
1904: WHERE okh.ship_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
1905: FROM ra_customer_merges rcm
1906: WHERE rcm.process_flag = 'N'
1907: AND rcm.request_id = req_id
1908: AND rcm.set_number = set_number);
1909: l_count := sql%rowcount;

Line 1945: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

1941: hz_utility_pub.CREATION_DATE,
1942: hz_utility_pub.LAST_UPDATE_LOGIN,
1943: hz_utility_pub.LAST_UPDATE_DATE,
1944: hz_utility_pub.LAST_UPDATED_BY
1945: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1946: WHERE (
1947: okh.bill_to_site_use_id = rcm.duplicate_site_id
1948: ) AND rcm.process_flag = 'N'
1949: AND rcm.request_id = req_id

Line 1952: FROM ra_customer_merges rcm

1948: ) AND rcm.process_flag = 'N'
1949: AND rcm.request_id = req_id
1950: AND rcm.set_number = set_number
1951: AND okh.bill_to_site_use_id IN (SELECT rcm.duplicate_site_id
1952: FROM ra_customer_merges rcm
1953: WHERE rcm.process_flag = 'N'
1954: AND rcm.request_id = req_id
1955: AND rcm.set_number = set_number);
1956:

Line 1964: FROM ra_customer_merges rcm

1960: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);
1961:
1962: UPDATE okc_k_headers_b okh
1963: SET okh.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
1964: FROM ra_customer_merges rcm
1965: WHERE okh.bill_to_site_use_id = rcm.duplicate_site_id
1966: AND rcm.process_flag = 'N'
1967: AND rcm.request_id = req_id
1968: AND rcm.set_number = set_number)

Line 1974: FROM ra_customer_merges rcm

1970: ,okh.last_update_date = SYSDATE
1971: ,okh.last_updated_by = arp_standard.profile.user_id
1972: ,okh.last_update_login = arp_standard.profile.last_update_login
1973: WHERE okh.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
1974: FROM ra_customer_merges rcm
1975: WHERE rcm.process_flag = 'N'
1976: AND rcm.request_id = req_id
1977: AND rcm.set_number = set_number);
1978: l_count := sql%rowcount;

Line 2013: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

2009: hz_utility_pub.CREATION_DATE,
2010: hz_utility_pub.LAST_UPDATE_LOGIN,
2011: hz_utility_pub.LAST_UPDATE_DATE,
2012: hz_utility_pub.LAST_UPDATED_BY
2013: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2014: WHERE (
2015: okl.ship_to_site_use_id = rcm.duplicate_site_id
2016: ) AND rcm.process_flag = 'N'
2017: AND rcm.request_id = req_id

Line 2020: FROM ra_customer_merges rcm

2016: ) AND rcm.process_flag = 'N'
2017: AND rcm.request_id = req_id
2018: AND rcm.set_number = set_number
2019: AND okl.ship_to_site_use_id IN (SELECT rcm.duplicate_site_id
2020: FROM ra_customer_merges rcm
2021: WHERE rcm.process_flag = 'N'
2022: AND rcm.request_id = req_id
2023: AND rcm.set_number = set_number);
2024:

Line 2032: FROM ra_customer_merges rcm

2028: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.SHIP_TO_SITE_USE_ID',FALSE);
2029:
2030: UPDATE okc_k_lines_b okl
2031: SET okl.ship_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2032: FROM ra_customer_merges rcm
2033: WHERE okl.ship_to_site_use_id = rcm.duplicate_site_id
2034: AND rcm.process_flag = 'N'
2035: AND rcm.request_id = req_id
2036: AND rcm.set_number = set_number)

Line 2042: FROM ra_customer_merges rcm

2038: ,okl.last_update_date = SYSDATE
2039: ,okl.last_updated_by = arp_standard.profile.user_id
2040: ,okl.last_update_login = arp_standard.profile.last_update_login
2041: WHERE okl.ship_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2042: FROM ra_customer_merges rcm
2043: WHERE rcm.process_flag = 'N'
2044: AND rcm.request_id = req_id
2045: AND rcm.set_number = set_number);
2046: l_count := sql%rowcount;

Line 2082: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

2078: hz_utility_pub.CREATION_DATE,
2079: hz_utility_pub.LAST_UPDATE_LOGIN,
2080: hz_utility_pub.LAST_UPDATE_DATE,
2081: hz_utility_pub.LAST_UPDATED_BY
2082: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2083: WHERE (
2084: okl.bill_to_site_use_id = rcm.duplicate_site_id
2085: ) AND rcm.process_flag = 'N'
2086: AND rcm.request_id = req_id

Line 2089: FROM ra_customer_merges rcm

2085: ) AND rcm.process_flag = 'N'
2086: AND rcm.request_id = req_id
2087: AND rcm.set_number = set_number
2088: AND okl.bill_to_site_use_id IN (SELECT rcm.duplicate_site_id
2089: FROM ra_customer_merges rcm
2090: WHERE rcm.process_flag = 'N'
2091: AND rcm.request_id = req_id
2092: AND rcm.set_number = set_number);
2093:

Line 2101: FROM ra_customer_merges rcm

2097: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);
2098:
2099: UPDATE okc_k_lines_b okl
2100: SET okl.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2101: FROM ra_customer_merges rcm
2102: WHERE okl.bill_to_site_use_id = rcm.duplicate_site_id
2103: AND rcm.process_flag = 'N'
2104: AND rcm.request_id = req_id
2105: AND rcm.set_number = set_number)

Line 2111: FROM ra_customer_merges rcm

2107: ,okl.last_update_date = SYSDATE
2108: ,okl.last_updated_by = arp_standard.profile.user_id
2109: ,okl.last_update_login = arp_standard.profile.last_update_login
2110: WHERE okl.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2111: FROM ra_customer_merges rcm
2112: WHERE rcm.process_flag = 'N'
2113: AND rcm.request_id = req_id
2114: AND rcm.set_number = set_number);
2115: l_count := sql%rowcount;

Line 2151: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm

2147: hz_utility_pub.CREATION_DATE,
2148: hz_utility_pub.LAST_UPDATE_LOGIN,
2149: hz_utility_pub.LAST_UPDATE_DATE,
2150: hz_utility_pub.LAST_UPDATED_BY
2151: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
2152: WHERE (
2153: okpr.bill_to_site_use_id = rcm.duplicate_site_id
2154: ) AND rcm.process_flag = 'N'
2155: AND rcm.request_id = req_id

Line 2158: FROM ra_customer_merges rcm

2154: ) AND rcm.process_flag = 'N'
2155: AND rcm.request_id = req_id
2156: AND rcm.set_number = set_number
2157: AND okpr.bill_to_site_use_id IN (SELECT rcm.duplicate_site_id
2158: FROM ra_customer_merges rcm
2159: WHERE rcm.process_flag = 'N'
2160: AND rcm.request_id = req_id
2161: AND rcm.set_number = set_number);
2162:

Line 2170: FROM ra_customer_merges rcm

2166: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.BILL_TO_SITE_USE_ID',FALSE);
2167:
2168: UPDATE okc_k_party_roles_b okpr
2169: SET okpr.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2170: FROM ra_customer_merges rcm
2171: WHERE okpr.bill_to_site_use_id = rcm.duplicate_site_id
2172: AND rcm.process_flag = 'N'
2173: AND rcm.request_id = req_id
2174: AND rcm.set_number = set_number)

Line 2180: FROM ra_customer_merges rcm

2176: ,okpr.last_update_date = SYSDATE
2177: ,okpr.last_updated_by = arp_standard.profile.user_id
2178: ,okpr.last_update_login = arp_standard.profile.last_update_login
2179: WHERE okpr.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2180: FROM ra_customer_merges rcm
2181: WHERE rcm.process_flag = 'N'
2182: AND rcm.request_id = req_id
2183: AND rcm.set_number = set_number);
2184: l_count := sql%rowcount;

Line 2222: FROM OKC_K_ITEMS cim, ra_customer_merges rcm

2218: hz_utility_pub.CREATION_DATE,
2219: hz_utility_pub.LAST_UPDATE_LOGIN,
2220: hz_utility_pub.LAST_UPDATE_DATE,
2221: hz_utility_pub.LAST_UPDATED_BY
2222: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
2223: WHERE (
2224: cim.object1_id1 = to_char(rcm.duplicate_site_id)
2225: ) AND rcm.process_flag = 'N'
2226: AND rcm.request_id = req_id

Line 2229: FROM ra_customer_merges rcm

2225: ) AND rcm.process_flag = 'N'
2226: AND rcm.request_id = req_id
2227: AND rcm.set_number = set_number
2228: AND cim.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
2229: FROM ra_customer_merges rcm
2230: WHERE rcm.process_flag = 'N'
2231: AND rcm.request_id = req_id
2232: AND rcm.set_number = set_number)
2233: AND cim.jtot_object1_code IN (SELECT ojt.object_code

Line 2244: FROM ra_customer_merges rcm

2240: arp_message.set_name('AR','AR_UPDATING_TABLE');
2241: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
2242: UPDATE okc_k_items cim
2243: SET cim.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
2244: FROM ra_customer_merges rcm
2245: WHERE cim.object1_id1 = rcm.duplicate_site_id
2246: AND rcm.process_flag = 'N'
2247: AND rcm.request_id = req_id
2248: AND rcm.set_number = set_number)

Line 2254: FROM ra_customer_merges rcm

2250: ,cim.last_update_date = SYSDATE
2251: ,cim.last_updated_by = arp_standard.profile.user_id
2252: ,cim.last_update_login = arp_standard.profile.last_update_login
2253: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
2254: FROM ra_customer_merges rcm
2255: WHERE rcm.process_flag = 'N'
2256: AND rcm.request_id = req_id
2257: AND rcm.set_number = set_number)
2258: AND cim.jtot_object1_code IN (SELECT ojt.object_code

Line 2287: ,ra_customer_merges cme

2283: --
2284: CURSOR c_reason IS
2285: SELECT cmh.merge_reason_code
2286: FROM ra_customer_merge_headers cmh
2287: ,ra_customer_merges cme
2288: WHERE cmh.customer_merge_header_id = cme.customer_merge_header_id
2289: AND cme.request_id = req_id
2290: AND cme.set_number = set_number
2291: AND cme.process_flag = 'N'

Line 2300: FROM ra_customer_merges cme

2296: -- or a site merge within the same account
2297: --
2298: CURSOR c_site_merge(b_request_id NUMBER, b_set_number NUMBER) IS
2299: SELECT customer_id, duplicate_id
2300: FROM ra_customer_merges cme
2301: WHERE cme.request_id = b_request_id
2302: AND cme.set_number = b_set_number
2303: AND cme.process_flag = 'N'
2304: ;