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 113: FROM ra_customer_merges cme

109: WHERE ojt.object_code = oue.object_code
110: AND oue.object_user_code = b_object_use
111: )
112: AND kpr.object1_id1 IN (SELECT to_char(cme.duplicate_id)
113: FROM ra_customer_merges cme
114: WHERE cme.process_flag = 'N'
115: AND cme.request_id = req_id
116: AND cme.set_number = set_number
117: )

Line 133: FROM ra_customer_merges cme

129: WHERE ojt.object_code = oue.object_code
130: AND oue.object_user_code = b_object_use
131: )
132: AND rle.object1_id1 IN (SELECT to_char(cme.duplicate_id)
133: FROM ra_customer_merges cme
134: WHERE cme.process_flag = 'N'
135: AND cme.request_id = req_id
136: AND cme.set_number = set_number
137: )

Line 150: FROM ra_customer_merges cme

146: WHERE ojt.object_code = oue.object_code
147: AND oue.object_user_code = b_object_use
148: )
149: AND rle.object2_id1 IN (SELECT to_char(cme.duplicate_id)
150: FROM ra_customer_merges cme
151: WHERE cme.process_flag = 'N'
152: AND cme.request_id = req_id
153: AND cme.set_number = set_number
154: )

Line 167: FROM ra_customer_merges cme

163: WHERE ojt.object_code = oue.object_code
164: AND oue.object_user_code = b_object_use
165: )
166: AND rle.object3_id1 IN (SELECT to_char(cme.duplicate_id)
167: FROM ra_customer_merges cme
168: WHERE cme.process_flag = 'N'
169: AND cme.request_id = req_id
170: AND cme.set_number = set_number
171: )

Line 184: FROM ra_customer_merges cme

180: WHERE ojt.object_code = oue.object_code
181: AND oue.object_user_code = b_object_use
182: )
183: AND cim.object1_id1 IN (SELECT to_char(cme.duplicate_id)
184: FROM ra_customer_merges cme
185: WHERE cme.process_flag = 'N'
186: AND cme.request_id = req_id
187: AND cme.set_number = set_number
188: )

Line 501: FROM ra_customer_merges rcm

497: FROM DUAL;
498:
499: UPDATE HZ_CUSTOMER_MERGE_LOG hz
500: SET hz.MERGE_HEADER_ID = (SELECT distinct CUSTOMER_MERGE_HEADER_ID
501: FROM ra_customer_merges rcm
502: WHERE rcm.request_id = req_id
503: and rcm.set_number = set_number
504: and rcm.process_flag = 'N')
505: ,hz.VCHAR_COL1_ORIG = l_source_party_id

Line 591: FROM ra_customer_merges rcm

587: CURSOR contract_id IS
588: SELECT distinct(okl.chr_id)
589: FROM okc_k_lines_b okl
590: WHERE okl.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
591: FROM ra_customer_merges rcm
592: WHERE rcm.process_flag = 'N'
593: AND rcm.request_id = req_id
594: AND rcm.set_number = set_number);
595: TYPE chr_id_typ IS TABLE OF NUMBER INDEX BY PLS_INTEGER;

Line 634: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm

630: hz_utility_pub.CREATION_DATE,
631: hz_utility_pub.LAST_UPDATE_LOGIN,
632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY
634: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm
635: WHERE (
636: kpr.object1_id1 = to_char(rcm.duplicate_id)
637: ) AND rcm.process_flag = 'N'
638: AND rcm.request_id = req_id

Line 641: FROM ra_customer_merges rcm

637: ) AND rcm.process_flag = 'N'
638: AND rcm.request_id = req_id
639: AND rcm.set_number = set_number
640: AND kpr.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
641: FROM ra_customer_merges rcm
642: WHERE rcm.process_flag = 'N'
643: AND rcm.request_id = req_id
644: AND rcm.set_number = set_number)
645: AND kpr.jtot_object1_code IN (SELECT ojt.object_code

Line 656: FROM ra_customer_merges rcm

652: arp_message.set_name('AR','AR_UPDATING_TABLE');
653: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES',FALSE);
654: UPDATE okc_k_party_roles_b kpr
655: SET kpr.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
656: FROM ra_customer_merges rcm
657: WHERE kpr.object1_id1 = rcm.duplicate_id
658: AND rcm.process_flag = 'N'
659: AND rcm.request_id = req_id
660: AND rcm.set_number = set_number)

Line 666: FROM ra_customer_merges rcm

662: ,kpr.last_update_date = SYSDATE
663: ,kpr.last_updated_by = arp_standard.profile.user_id
664: ,kpr.last_update_login = arp_standard.profile.last_update_login
665: WHERE kpr.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
666: FROM ra_customer_merges rcm
667: WHERE rcm.process_flag = 'N'
668: AND rcm.request_id = req_id
669: AND rcm.set_number = set_number)
670: AND kpr.jtot_object1_code IN (SELECT ojt.object_code

Line 711: FROM OKC_RULES_B rle, ra_customer_merges rcm

707: hz_utility_pub.CREATION_DATE,
708: hz_utility_pub.LAST_UPDATE_LOGIN,
709: hz_utility_pub.LAST_UPDATE_DATE,
710: hz_utility_pub.LAST_UPDATED_BY
711: FROM OKC_RULES_B rle, ra_customer_merges rcm
712: WHERE (
713: rle.object1_id1 = to_char(rcm.duplicate_id)
714: ) AND rcm.process_flag = 'N'
715: AND rcm.request_id = req_id

Line 718: FROM ra_customer_merges rcm

714: ) AND rcm.process_flag = 'N'
715: AND rcm.request_id = req_id
716: AND rcm.set_number = set_number
717: AND rle.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
718: FROM ra_customer_merges rcm
719: WHERE rcm.process_flag = 'N'
720: AND rcm.request_id = req_id
721: AND rcm.set_number = set_number)
722: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 733: FROM ra_customer_merges rcm

729: arp_message.set_name('AR','AR_UPDATING_TABLE');
730: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);
731: UPDATE okc_rules_b rle
732: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
733: FROM ra_customer_merges rcm
734: WHERE rle.object1_id1 = rcm.duplicate_id
735: AND rcm.process_flag = 'N'
736: AND rcm.request_id = req_id
737: AND rcm.set_number = set_number)

Line 743: FROM ra_customer_merges rcm

739: ,rle.last_update_date = SYSDATE
740: ,rle.last_updated_by = arp_standard.profile.user_id
741: ,rle.last_update_login = arp_standard.profile.last_update_login
742: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
743: FROM ra_customer_merges rcm
744: WHERE rcm.process_flag = 'N'
745: AND rcm.request_id = req_id
746: AND rcm.set_number = set_number)
747: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 788: FROM OKC_RULES_B rle, ra_customer_merges rcm

784: hz_utility_pub.CREATION_DATE,
785: hz_utility_pub.LAST_UPDATE_LOGIN,
786: hz_utility_pub.LAST_UPDATE_DATE,
787: hz_utility_pub.LAST_UPDATED_BY
788: FROM OKC_RULES_B rle, ra_customer_merges rcm
789: WHERE (
790: rle.object2_id1 = to_char(rcm.duplicate_id)
791: ) AND rcm.process_flag = 'N'
792: AND rcm.request_id = req_id

Line 795: FROM ra_customer_merges rcm

791: ) AND rcm.process_flag = 'N'
792: AND rcm.request_id = req_id
793: AND rcm.set_number = set_number
794: AND rle.object2_id1 IN (SELECT to_char(rcm.duplicate_id)
795: FROM ra_customer_merges rcm
796: WHERE rcm.process_flag = 'N'
797: AND rcm.request_id = req_id
798: AND rcm.set_number = set_number)
799: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 810: FROM ra_customer_merges rcm

806: arp_message.set_name('AR','AR_UPDATING_TABLE');
807: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);
808: UPDATE okc_rules_b rle
809: SET rle.object2_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
810: FROM ra_customer_merges rcm
811: WHERE rle.object2_id1 = rcm.duplicate_id
812: AND rcm.process_flag = 'N'
813: AND rcm.request_id = req_id
814: AND rcm.set_number = set_number)

Line 820: FROM ra_customer_merges rcm

816: ,rle.last_update_date = SYSDATE
817: ,rle.last_updated_by = arp_standard.profile.user_id
818: ,rle.last_update_login = arp_standard.profile.last_update_login
819: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_id)
820: FROM ra_customer_merges rcm
821: WHERE rcm.process_flag = 'N'
822: AND rcm.request_id = req_id
823: AND rcm.set_number = set_number)
824: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 865: FROM OKC_RULES_B rle, ra_customer_merges rcm

861: hz_utility_pub.CREATION_DATE,
862: hz_utility_pub.LAST_UPDATE_LOGIN,
863: hz_utility_pub.LAST_UPDATE_DATE,
864: hz_utility_pub.LAST_UPDATED_BY
865: FROM OKC_RULES_B rle, ra_customer_merges rcm
866: WHERE (
867: rle.object3_id1 = to_char(rcm.duplicate_id)
868: ) AND rcm.process_flag = 'N'
869: AND rcm.request_id = req_id

Line 872: FROM ra_customer_merges rcm

868: ) AND rcm.process_flag = 'N'
869: AND rcm.request_id = req_id
870: AND rcm.set_number = set_number
871: AND rle.object3_id1 IN (SELECT to_char(rcm.duplicate_id)
872: FROM ra_customer_merges rcm
873: WHERE rcm.process_flag = 'N'
874: AND rcm.request_id = req_id
875: AND rcm.set_number = set_number)
876: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 887: FROM ra_customer_merges rcm

883: arp_message.set_name('AR','AR_UPDATING_TABLE');
884: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
885: UPDATE okc_rules_b rle
886: SET rle.object3_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
887: FROM ra_customer_merges rcm
888: WHERE rle.object3_id1 = rcm.duplicate_id
889: AND rcm.process_flag = 'N'
890: AND rcm.request_id = req_id
891: AND rcm.set_number = set_number)

Line 897: FROM ra_customer_merges rcm

893: ,rle.last_update_date = SYSDATE
894: ,rle.last_updated_by = arp_standard.profile.user_id
895: ,rle.last_update_login = arp_standard.profile.last_update_login
896: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_id)
897: FROM ra_customer_merges rcm
898: WHERE rcm.process_flag = 'N'
899: AND rcm.request_id = req_id
900: AND rcm.set_number = set_number)
901: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 943: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

939: hz_utility_pub.CREATION_DATE,
940: hz_utility_pub.LAST_UPDATE_LOGIN,
941: hz_utility_pub.LAST_UPDATE_DATE,
942: hz_utility_pub.LAST_UPDATED_BY
943: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
944: WHERE (
945: okh.cust_acct_id = rcm.duplicate_id
946: ) AND rcm.process_flag = 'N'
947: AND rcm.request_id = req_id

Line 950: FROM ra_customer_merges rcm

946: ) AND rcm.process_flag = 'N'
947: AND rcm.request_id = req_id
948: AND rcm.set_number = set_number
949: AND okh.cust_acct_id IN (SELECT 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 962: FROM ra_customer_merges rcm

958: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.CUST_ACCT_ID',FALSE);
959:
960: UPDATE okc_k_headers_b okh
961: SET okh.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
962: FROM ra_customer_merges rcm
963: WHERE okh.cust_acct_id = rcm.duplicate_id
964: AND rcm.process_flag = 'N'
965: AND rcm.request_id = req_id
966: AND rcm.set_number = set_number)

Line 972: FROM ra_customer_merges rcm

968: ,okh.last_update_date = SYSDATE
969: ,okh.last_updated_by = arp_standard.profile.user_id
970: ,okh.last_update_login = arp_standard.profile.last_update_login
971: WHERE okh.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
972: FROM ra_customer_merges rcm
973: WHERE rcm.process_flag = 'N'
974: AND rcm.request_id = req_id
975: AND rcm.set_number = set_number);
976:

Line 1015: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

1011: hz_utility_pub.CREATION_DATE,
1012: hz_utility_pub.LAST_UPDATE_LOGIN,
1013: hz_utility_pub.LAST_UPDATE_DATE,
1014: hz_utility_pub.LAST_UPDATED_BY
1015: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
1016: WHERE (
1017: okl.cust_acct_id = rcm.duplicate_id
1018: ) AND rcm.process_flag = 'N'
1019: AND rcm.request_id = req_id

Line 1022: FROM ra_customer_merges rcm

1018: ) AND rcm.process_flag = 'N'
1019: AND rcm.request_id = req_id
1020: AND rcm.set_number = set_number
1021: AND okl.cust_acct_id IN (SELECT rcm.duplicate_id
1022: FROM ra_customer_merges rcm
1023: WHERE rcm.process_flag = 'N'
1024: AND rcm.request_id = req_id
1025: AND rcm.set_number = set_number);
1026:

Line 1042: FROM ra_customer_merges rcm

1038: /*bug9077092*/
1039:
1040: UPDATE okc_k_lines_b okl
1041: SET okl.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
1042: FROM ra_customer_merges rcm
1043: WHERE okl.cust_acct_id = rcm.duplicate_id
1044: AND rcm.process_flag = 'N'
1045: AND rcm.request_id = req_id
1046: AND rcm.set_number = set_number)

Line 1052: FROM ra_customer_merges rcm

1048: ,okl.last_update_date = SYSDATE
1049: ,okl.last_updated_by = arp_standard.profile.user_id
1050: ,okl.last_update_login = arp_standard.profile.last_update_login
1051: WHERE okl.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
1052: FROM ra_customer_merges rcm
1053: WHERE rcm.process_flag = 'N'
1054: AND rcm.request_id = req_id
1055: AND rcm.set_number = set_number);
1056:

Line 1093: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm

1089: hz_utility_pub.CREATION_DATE,
1090: hz_utility_pub.LAST_UPDATE_LOGIN,
1091: hz_utility_pub.LAST_UPDATE_DATE,
1092: hz_utility_pub.LAST_UPDATED_BY
1093: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
1094: WHERE (
1095: okpr.cust_acct_id = rcm.duplicate_id
1096: ) AND rcm.process_flag = 'N'
1097: AND rcm.request_id = req_id

Line 1100: FROM ra_customer_merges rcm

1096: ) AND rcm.process_flag = 'N'
1097: AND rcm.request_id = req_id
1098: AND rcm.set_number = set_number
1099: AND okpr.cust_acct_id IN (SELECT rcm.duplicate_id
1100: FROM ra_customer_merges rcm
1101: WHERE rcm.process_flag = 'N'
1102: AND rcm.request_id = req_id
1103: AND rcm.set_number = set_number);
1104:

Line 1112: FROM ra_customer_merges rcm

1108: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.CUST_ACCT_ID',FALSE);
1109:
1110: UPDATE okc_k_party_roles_b okpr
1111: SET okpr.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
1112: FROM ra_customer_merges rcm
1113: WHERE okpr.cust_acct_id = rcm.duplicate_id
1114: AND rcm.process_flag = 'N'
1115: AND rcm.request_id = req_id
1116: AND rcm.set_number = set_number)

Line 1122: FROM ra_customer_merges rcm

1118: ,okpr.last_update_date = SYSDATE
1119: ,okpr.last_updated_by = arp_standard.profile.user_id
1120: ,okpr.last_update_login = arp_standard.profile.last_update_login
1121: WHERE okpr.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
1122: FROM ra_customer_merges rcm
1123: WHERE rcm.process_flag = 'N'
1124: AND rcm.request_id = req_id
1125: AND rcm.set_number = set_number);
1126:

Line 1164: FROM OKC_K_ITEMS cim, ra_customer_merges rcm

1160: hz_utility_pub.CREATION_DATE,
1161: hz_utility_pub.LAST_UPDATE_LOGIN,
1162: hz_utility_pub.LAST_UPDATE_DATE,
1163: hz_utility_pub.LAST_UPDATED_BY
1164: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1165: WHERE (
1166: cim.object1_id1 = to_char(rcm.duplicate_id)
1167: ) AND rcm.process_flag = 'N'
1168: AND rcm.request_id = req_id

Line 1171: FROM ra_customer_merges rcm

1167: ) AND rcm.process_flag = 'N'
1168: AND rcm.request_id = req_id
1169: AND rcm.set_number = set_number
1170: AND cim.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
1171: FROM ra_customer_merges rcm
1172: WHERE rcm.process_flag = 'N'
1173: AND rcm.request_id = req_id
1174: AND rcm.set_number = set_number)
1175: AND cim.jtot_object1_code IN (SELECT ojt.object_code

Line 1186: FROM ra_customer_merges rcm

1182: arp_message.set_name('AR','AR_UPDATING_TABLE');
1183: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
1184: UPDATE okc_k_items cim
1185: SET cim.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
1186: FROM ra_customer_merges rcm
1187: WHERE cim.object1_id1 = rcm.duplicate_id
1188: AND rcm.process_flag = 'N'
1189: AND rcm.request_id = req_id
1190: AND rcm.set_number = set_number)

Line 1196: FROM ra_customer_merges rcm

1192: ,cim.last_update_date = SYSDATE
1193: ,cim.last_updated_by = arp_standard.profile.user_id
1194: ,cim.last_update_login = arp_standard.profile.last_update_login
1195: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
1196: FROM ra_customer_merges rcm
1197: WHERE rcm.process_flag = 'N'
1198: AND rcm.request_id = req_id
1199: AND rcm.set_number = set_number)
1200: AND cim.jtot_object1_code IN (SELECT ojt.object_code

Line 1270: FROM ra_customer_merges rcm

1266: CURSOR contract_id IS
1267: SELECT distinct(okl.chr_id)
1268: FROM okc_k_lines_b okl
1269: WHERE (okl.ship_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
1270: FROM ra_customer_merges rcm
1271: WHERE rcm.process_flag = 'N'
1272: AND rcm.request_id = req_id
1273: AND rcm.set_number = set_number))
1274: UNION

Line 1278: FROM ra_customer_merges rcm

1274: UNION
1275: SELECT distinct(okl.chr_id)
1276: FROM okc_k_lines_b okl
1277: WHERE (okl.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
1278: FROM ra_customer_merges rcm
1279: WHERE rcm.process_flag = 'N'
1280: AND rcm.request_id = req_id
1281: AND rcm.set_number = set_number));
1282: TYPE chr_id_typ IS TABLE OF NUMBER INDEX BY PLS_INTEGER;

Line 1327: FROM OKC_RULES_B rle, ra_customer_merges rcm

1323: hz_utility_pub.CREATION_DATE,
1324: hz_utility_pub.LAST_UPDATE_LOGIN,
1325: hz_utility_pub.LAST_UPDATE_DATE,
1326: hz_utility_pub.LAST_UPDATED_BY
1327: FROM OKC_RULES_B rle, ra_customer_merges rcm
1328: WHERE (
1329: rle.object1_id1 = to_char(rcm.duplicate_address_id)
1330: ) AND rcm.process_flag = 'N'
1331: AND rcm.request_id = req_id

Line 1334: FROM ra_customer_merges rcm

1330: ) AND rcm.process_flag = 'N'
1331: AND rcm.request_id = req_id
1332: AND rcm.set_number = set_number
1333: AND rle.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1334: FROM ra_customer_merges rcm
1335: WHERE rcm.process_flag = 'N'
1336: AND rcm.request_id = req_id
1337: AND rcm.set_number = set_number)
1338: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 1349: FROM ra_customer_merges rcm

1345: arp_message.set_name('AR','AR_UPDATING_TABLE');
1346: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);
1347: UPDATE okc_rules_b rle
1348: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1349: FROM ra_customer_merges rcm
1350: WHERE rle.object1_id1 = rcm.duplicate_address_id
1351: AND rcm.process_flag = 'N'
1352: AND rcm.request_id = req_id
1353: AND rcm.set_number = set_number

Line 1360: FROM ra_customer_merges rcm

1356: ,rle.last_update_date = SYSDATE
1357: ,rle.last_updated_by = arp_standard.profile.user_id
1358: ,rle.last_update_login = arp_standard.profile.last_update_login
1359: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1360: FROM ra_customer_merges rcm
1361: WHERE rcm.process_flag = 'N'
1362: AND rcm.request_id = req_id
1363: AND rcm.set_number = set_number)
1364: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 1405: FROM OKC_RULES_B rle, ra_customer_merges rcm

1401: hz_utility_pub.CREATION_DATE,
1402: hz_utility_pub.LAST_UPDATE_LOGIN,
1403: hz_utility_pub.LAST_UPDATE_DATE,
1404: hz_utility_pub.LAST_UPDATED_BY
1405: FROM OKC_RULES_B rle, ra_customer_merges rcm
1406: WHERE (
1407: rle.object2_id1 = to_char(rcm.duplicate_address_id)
1408: ) AND rcm.process_flag = 'N'
1409: AND rcm.request_id = req_id

Line 1412: FROM ra_customer_merges rcm

1408: ) AND rcm.process_flag = 'N'
1409: AND rcm.request_id = req_id
1410: AND rcm.set_number = set_number
1411: AND rle.object2_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1412: FROM ra_customer_merges rcm
1413: WHERE rcm.process_flag = 'N'
1414: AND rcm.request_id = req_id
1415: AND rcm.set_number = set_number)
1416: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 1427: FROM ra_customer_merges rcm

1423: arp_message.set_name('AR','AR_UPDATING_TABLE');
1424: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);
1425: UPDATE okc_rules_b rle
1426: SET rle.object2_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1427: FROM ra_customer_merges rcm
1428: WHERE rle.object2_id1 = rcm.duplicate_address_id
1429: AND rcm.process_flag = 'N'
1430: AND rcm.request_id = req_id
1431: AND rcm.set_number = set_number

Line 1438: FROM ra_customer_merges rcm

1434: ,rle.last_update_date = SYSDATE
1435: ,rle.last_updated_by = arp_standard.profile.user_id
1436: ,rle.last_update_login = arp_standard.profile.last_update_login
1437: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1438: FROM ra_customer_merges rcm
1439: WHERE rcm.process_flag = 'N'
1440: AND rcm.request_id = req_id
1441: AND rcm.set_number = set_number)
1442: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 1482: FROM OKC_RULES_B rle, ra_customer_merges rcm

1478: hz_utility_pub.CREATION_DATE,
1479: hz_utility_pub.LAST_UPDATE_LOGIN,
1480: hz_utility_pub.LAST_UPDATE_DATE,
1481: hz_utility_pub.LAST_UPDATED_BY
1482: FROM OKC_RULES_B rle, ra_customer_merges rcm
1483: WHERE (
1484: rle.object3_id1 = to_char(rcm.duplicate_address_id)
1485: ) AND rcm.process_flag = 'N'
1486: AND rcm.request_id = req_id

Line 1489: FROM ra_customer_merges rcm

1485: ) AND rcm.process_flag = 'N'
1486: AND rcm.request_id = req_id
1487: AND rcm.set_number = set_number
1488: AND rle.object3_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1489: FROM ra_customer_merges rcm
1490: WHERE rcm.process_flag = 'N'
1491: AND rcm.request_id = req_id
1492: AND rcm.set_number = set_number)
1493: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 1504: FROM ra_customer_merges rcm

1500: arp_message.set_name('AR','AR_UPDATING_TABLE');
1501: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
1502: UPDATE okc_rules_b rle
1503: SET rle.object3_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1504: FROM ra_customer_merges rcm
1505: WHERE rle.object3_id1 = rcm.duplicate_address_id
1506: AND rcm.process_flag = 'N'
1507: AND rcm.request_id = req_id
1508: AND rcm.set_number = set_number

Line 1515: FROM ra_customer_merges rcm

1511: ,rle.last_update_date = SYSDATE
1512: ,rle.last_updated_by = arp_standard.profile.user_id
1513: ,rle.last_update_login = arp_standard.profile.last_update_login
1514: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1515: FROM ra_customer_merges rcm
1516: WHERE rcm.process_flag = 'N'
1517: AND rcm.request_id = req_id
1518: AND rcm.set_number = set_number)
1519: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 1562: FROM OKC_K_ITEMS cim, ra_customer_merges rcm

1558: hz_utility_pub.CREATION_DATE,
1559: hz_utility_pub.LAST_UPDATE_LOGIN,
1560: hz_utility_pub.LAST_UPDATE_DATE,
1561: hz_utility_pub.LAST_UPDATED_BY
1562: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1563: WHERE (
1564: cim.object1_id1 = to_char(rcm.duplicate_address_id)
1565: ) AND rcm.process_flag = 'N'
1566: AND rcm.request_id = req_id

Line 1569: FROM ra_customer_merges rcm

1565: ) AND rcm.process_flag = 'N'
1566: AND rcm.request_id = req_id
1567: AND rcm.set_number = set_number
1568: AND cim.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1569: FROM ra_customer_merges rcm
1570: WHERE rcm.process_flag = 'N'
1571: AND rcm.request_id = req_id
1572: AND rcm.set_number = set_number)
1573: AND cim.jtot_object1_code IN (SELECT ojt.object_code

Line 1584: FROM ra_customer_merges rcm

1580: arp_message.set_name('AR','AR_UPDATING_TABLE');
1581: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
1582: UPDATE okc_k_items cim
1583: SET cim.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_address_id)
1584: FROM ra_customer_merges rcm
1585: WHERE cim.object1_id1 = rcm.duplicate_address_id
1586: AND rcm.process_flag = 'N'
1587: AND rcm.request_id = req_id
1588: AND rcm.set_number = set_number

Line 1595: FROM ra_customer_merges rcm

1591: ,cim.last_update_date = SYSDATE
1592: ,cim.last_updated_by = arp_standard.profile.user_id
1593: ,cim.last_update_login = arp_standard.profile.last_update_login
1594: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1595: FROM ra_customer_merges rcm
1596: WHERE rcm.process_flag = 'N'
1597: AND rcm.request_id = req_id
1598: AND rcm.set_number = set_number)
1599: AND cim.jtot_object1_code IN (SELECT ojt.object_code

Line 1649: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm

1645: hz_utility_pub.CREATION_DATE,
1646: hz_utility_pub.LAST_UPDATE_LOGIN,
1647: hz_utility_pub.LAST_UPDATE_DATE,
1648: hz_utility_pub.LAST_UPDATED_BY
1649: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm
1650: WHERE (
1651: rle.object1_id1 = to_char(rcm.duplicate_site_id)
1652: ) AND rcm.process_flag = 'N'
1653: AND rcm.request_id = req_id

Line 1656: FROM ra_customer_merges rcm

1652: ) AND rcm.process_flag = 'N'
1653: AND rcm.request_id = req_id
1654: AND rcm.set_number = set_number
1655: AND rle.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1656: FROM ra_customer_merges rcm
1657: WHERE rcm.process_flag = 'N'
1658: AND rcm.request_id = req_id
1659: AND rcm.set_number = set_number)
1660: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 1674: FROM ra_customer_merges rcm

1670: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
1671:
1672: UPDATE okc_k_party_roles_b rle
1673: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1674: FROM ra_customer_merges rcm
1675: WHERE rle.object1_id1 = rcm.duplicate_site_id
1676: AND rcm.process_flag = 'N'
1677: AND rcm.request_id = req_id
1678: AND rcm.set_number = set_number)

Line 1684: FROM ra_customer_merges rcm

1680: ,rle.last_update_date = SYSDATE
1681: ,rle.last_updated_by = arp_standard.profile.user_id
1682: ,rle.last_update_login = arp_standard.profile.last_update_login
1683: WHERE rle.object1_id1 IN ( SELECT to_char(rcm.duplicate_site_id)
1684: FROM ra_customer_merges rcm
1685: WHERE rcm.process_flag = 'N'
1686: AND rcm.request_id = req_id
1687: AND rcm.set_number = set_number)
1688: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 1742: FROM OKC_RULES_B rle, ra_customer_merges rcm

1738: hz_utility_pub.CREATION_DATE,
1739: hz_utility_pub.LAST_UPDATE_LOGIN,
1740: hz_utility_pub.LAST_UPDATE_DATE,
1741: hz_utility_pub.LAST_UPDATED_BY
1742: FROM OKC_RULES_B rle, ra_customer_merges rcm
1743: WHERE (
1744: rle.object1_id1 = to_char(rcm.duplicate_site_id)
1745: ) AND rcm.process_flag = 'N'
1746: AND rcm.request_id = req_id

Line 1749: FROM ra_customer_merges rcm

1745: ) AND rcm.process_flag = 'N'
1746: AND rcm.request_id = req_id
1747: AND rcm.set_number = set_number
1748: AND rle.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1749: FROM ra_customer_merges rcm
1750: WHERE rcm.process_flag = 'N'
1751: AND rcm.request_id = req_id
1752: AND rcm.set_number = set_number)
1753: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 1764: FROM ra_customer_merges rcm

1760: arp_message.set_name('AR','AR_UPDATING_TABLE');
1761: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);
1762: UPDATE okc_rules_b rle
1763: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1764: FROM ra_customer_merges rcm
1765: WHERE rle.object1_id1 = rcm.duplicate_site_id
1766: AND rcm.process_flag = 'N'
1767: AND rcm.request_id = req_id
1768: AND rcm.set_number = set_number)

Line 1774: FROM ra_customer_merges rcm

1770: ,rle.last_update_date = SYSDATE
1771: ,rle.last_updated_by = arp_standard.profile.user_id
1772: ,rle.last_update_login = arp_standard.profile.last_update_login
1773: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1774: FROM ra_customer_merges rcm
1775: WHERE rcm.process_flag = 'N'
1776: AND rcm.request_id = req_id
1777: AND rcm.set_number = set_number)
1778: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 1818: FROM OKC_RULES_B rle, ra_customer_merges rcm

1814: hz_utility_pub.CREATION_DATE,
1815: hz_utility_pub.LAST_UPDATE_LOGIN,
1816: hz_utility_pub.LAST_UPDATE_DATE,
1817: hz_utility_pub.LAST_UPDATED_BY
1818: FROM OKC_RULES_B rle, ra_customer_merges rcm
1819: WHERE (
1820: rle.object2_id1 = to_char(rcm.duplicate_site_id)
1821: ) AND rcm.process_flag = 'N'
1822: AND rcm.request_id = req_id

Line 1825: FROM ra_customer_merges rcm

1821: ) AND rcm.process_flag = 'N'
1822: AND rcm.request_id = req_id
1823: AND rcm.set_number = set_number
1824: AND rle.object2_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1825: FROM ra_customer_merges rcm
1826: WHERE rcm.process_flag = 'N'
1827: AND rcm.request_id = req_id
1828: AND rcm.set_number = set_number)
1829: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 1840: FROM ra_customer_merges rcm

1836: arp_message.set_name('AR','AR_UPDATING_TABLE');
1837: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);
1838: UPDATE okc_rules_b rle
1839: SET rle.object2_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1840: FROM ra_customer_merges rcm
1841: WHERE rle.object2_id1 = rcm.duplicate_site_id
1842: AND rcm.process_flag = 'N'
1843: AND rcm.request_id = req_id
1844: AND rcm.set_number = set_number)

Line 1850: FROM ra_customer_merges rcm

1846: ,rle.last_update_date = SYSDATE
1847: ,rle.last_updated_by = arp_standard.profile.user_id
1848: ,rle.last_update_login = arp_standard.profile.last_update_login
1849: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1850: FROM ra_customer_merges rcm
1851: WHERE rcm.process_flag = 'N'
1852: AND rcm.request_id = req_id
1853: AND rcm.set_number = set_number)
1854: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 1895: FROM OKC_RULES_B rle, ra_customer_merges rcm

1891: hz_utility_pub.CREATION_DATE,
1892: hz_utility_pub.LAST_UPDATE_LOGIN,
1893: hz_utility_pub.LAST_UPDATE_DATE,
1894: hz_utility_pub.LAST_UPDATED_BY
1895: FROM OKC_RULES_B rle, ra_customer_merges rcm
1896: WHERE (
1897: rle.object3_id1 = to_char(rcm.duplicate_site_id)
1898: ) AND rcm.process_flag = 'N'
1899: AND rcm.request_id = req_id

Line 1902: FROM ra_customer_merges rcm

1898: ) AND rcm.process_flag = 'N'
1899: AND rcm.request_id = req_id
1900: AND rcm.set_number = set_number
1901: AND rle.object3_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1902: FROM ra_customer_merges rcm
1903: WHERE rcm.process_flag = 'N'
1904: AND rcm.request_id = req_id
1905: AND rcm.set_number = set_number)
1906: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 1917: FROM ra_customer_merges rcm

1913: arp_message.set_name('AR','AR_UPDATING_TABLE');
1914: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
1915: UPDATE okc_rules_b rle
1916: SET rle.object3_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1917: FROM ra_customer_merges rcm
1918: WHERE rle.object3_id1 = rcm.duplicate_site_id
1919: AND rcm.process_flag = 'N'
1920: AND rcm.request_id = req_id
1921: AND rcm.set_number = set_number)

Line 1927: FROM ra_customer_merges rcm

1923: ,rle.last_update_date = SYSDATE
1924: ,rle.last_updated_by = arp_standard.profile.user_id
1925: ,rle.last_update_login = arp_standard.profile.last_update_login
1926: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1927: FROM ra_customer_merges rcm
1928: WHERE rcm.process_flag = 'N'
1929: AND rcm.request_id = req_id
1930: AND rcm.set_number = set_number)
1931: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 1973: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

1969: hz_utility_pub.CREATION_DATE,
1970: hz_utility_pub.LAST_UPDATE_LOGIN,
1971: hz_utility_pub.LAST_UPDATE_DATE,
1972: hz_utility_pub.LAST_UPDATED_BY
1973: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1974: WHERE (
1975: okh.ship_to_site_use_id = rcm.duplicate_site_id
1976: ) AND rcm.process_flag = 'N'
1977: AND rcm.request_id = req_id

Line 1980: FROM ra_customer_merges rcm

1976: ) AND rcm.process_flag = 'N'
1977: AND rcm.request_id = req_id
1978: AND rcm.set_number = set_number
1979: AND okh.ship_to_site_use_id IN (SELECT rcm.duplicate_site_id
1980: FROM ra_customer_merges rcm
1981: WHERE rcm.process_flag = 'N'
1982: AND rcm.request_id = req_id
1983: AND rcm.set_number = set_number);
1984:

Line 1992: FROM ra_customer_merges rcm

1988: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.SHIP_TO_SITE_USE_ID',FALSE);
1989:
1990: UPDATE okc_k_headers_b okh
1991: SET okh.ship_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
1992: FROM ra_customer_merges rcm
1993: WHERE okh.ship_to_site_use_id = rcm.duplicate_site_id
1994: AND rcm.process_flag = 'N'
1995: AND rcm.request_id = req_id
1996: AND rcm.set_number = set_number)

Line 2002: FROM ra_customer_merges rcm

1998: ,okh.last_update_date = SYSDATE
1999: ,okh.last_updated_by = arp_standard.profile.user_id
2000: ,okh.last_update_login = arp_standard.profile.last_update_login
2001: WHERE okh.ship_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2002: FROM ra_customer_merges rcm
2003: WHERE rcm.process_flag = 'N'
2004: AND rcm.request_id = req_id
2005: AND rcm.set_number = set_number);
2006: l_count := sql%rowcount;

Line 2043: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

2039: hz_utility_pub.CREATION_DATE,
2040: hz_utility_pub.LAST_UPDATE_LOGIN,
2041: hz_utility_pub.LAST_UPDATE_DATE,
2042: hz_utility_pub.LAST_UPDATED_BY
2043: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
2044: WHERE (
2045: okh.bill_to_site_use_id = rcm.duplicate_site_id
2046: ) AND rcm.process_flag = 'N'
2047: AND rcm.request_id = req_id

Line 2050: FROM ra_customer_merges rcm

2046: ) AND rcm.process_flag = 'N'
2047: AND rcm.request_id = req_id
2048: AND rcm.set_number = set_number
2049: AND okh.bill_to_site_use_id IN (SELECT rcm.duplicate_site_id
2050: FROM ra_customer_merges rcm
2051: WHERE rcm.process_flag = 'N'
2052: AND rcm.request_id = req_id
2053: AND rcm.set_number = set_number);
2054:

Line 2062: FROM ra_customer_merges rcm

2058: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);
2059:
2060: UPDATE okc_k_headers_b okh
2061: SET okh.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2062: FROM ra_customer_merges rcm
2063: WHERE okh.bill_to_site_use_id = rcm.duplicate_site_id
2064: AND rcm.process_flag = 'N'
2065: AND rcm.request_id = req_id
2066: AND rcm.set_number = set_number)

Line 2072: FROM ra_customer_merges rcm

2068: ,okh.last_update_date = SYSDATE
2069: ,okh.last_updated_by = arp_standard.profile.user_id
2070: ,okh.last_update_login = arp_standard.profile.last_update_login
2071: WHERE okh.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2072: FROM ra_customer_merges rcm
2073: WHERE rcm.process_flag = 'N'
2074: AND rcm.request_id = req_id
2075: AND rcm.set_number = set_number);
2076: l_count := sql%rowcount;

Line 2112: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

2108: hz_utility_pub.CREATION_DATE,
2109: hz_utility_pub.LAST_UPDATE_LOGIN,
2110: hz_utility_pub.LAST_UPDATE_DATE,
2111: hz_utility_pub.LAST_UPDATED_BY
2112: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2113: WHERE (
2114: okl.ship_to_site_use_id = rcm.duplicate_site_id
2115: ) AND rcm.process_flag = 'N'
2116: AND rcm.request_id = req_id

Line 2119: FROM ra_customer_merges rcm

2115: ) AND rcm.process_flag = 'N'
2116: AND rcm.request_id = req_id
2117: AND rcm.set_number = set_number
2118: AND okl.ship_to_site_use_id IN (SELECT rcm.duplicate_site_id
2119: FROM ra_customer_merges rcm
2120: WHERE rcm.process_flag = 'N'
2121: AND rcm.request_id = req_id
2122: AND rcm.set_number = set_number);
2123:

Line 2139: FROM ra_customer_merges rcm

2135: /*bug9077092*/
2136:
2137: UPDATE okc_k_lines_b okl
2138: SET okl.ship_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2139: FROM ra_customer_merges rcm
2140: WHERE okl.ship_to_site_use_id = rcm.duplicate_site_id
2141: AND rcm.process_flag = 'N'
2142: AND rcm.request_id = req_id
2143: AND rcm.set_number = set_number)

Line 2149: FROM ra_customer_merges rcm

2145: ,okl.last_update_date = SYSDATE
2146: ,okl.last_updated_by = arp_standard.profile.user_id
2147: ,okl.last_update_login = arp_standard.profile.last_update_login
2148: WHERE okl.ship_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2149: FROM ra_customer_merges rcm
2150: WHERE rcm.process_flag = 'N'
2151: AND rcm.request_id = req_id
2152: AND rcm.set_number = set_number);
2153: l_count := sql%rowcount;

Line 2190: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

2186: hz_utility_pub.CREATION_DATE,
2187: hz_utility_pub.LAST_UPDATE_LOGIN,
2188: hz_utility_pub.LAST_UPDATE_DATE,
2189: hz_utility_pub.LAST_UPDATED_BY
2190: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2191: WHERE (
2192: okl.bill_to_site_use_id = rcm.duplicate_site_id
2193: ) AND rcm.process_flag = 'N'
2194: AND rcm.request_id = req_id

Line 2197: FROM ra_customer_merges rcm

2193: ) AND rcm.process_flag = 'N'
2194: AND rcm.request_id = req_id
2195: AND rcm.set_number = set_number
2196: AND okl.bill_to_site_use_id IN (SELECT rcm.duplicate_site_id
2197: FROM ra_customer_merges rcm
2198: WHERE rcm.process_flag = 'N'
2199: AND rcm.request_id = req_id
2200: AND rcm.set_number = set_number);
2201:

Line 2209: FROM ra_customer_merges rcm

2205: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);
2206:
2207: UPDATE okc_k_lines_b okl
2208: SET okl.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2209: FROM ra_customer_merges rcm
2210: WHERE okl.bill_to_site_use_id = rcm.duplicate_site_id
2211: AND rcm.process_flag = 'N'
2212: AND rcm.request_id = req_id
2213: AND rcm.set_number = set_number)

Line 2219: FROM ra_customer_merges rcm

2215: ,okl.last_update_date = SYSDATE
2216: ,okl.last_updated_by = arp_standard.profile.user_id
2217: ,okl.last_update_login = arp_standard.profile.last_update_login
2218: WHERE okl.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2219: FROM ra_customer_merges rcm
2220: WHERE rcm.process_flag = 'N'
2221: AND rcm.request_id = req_id
2222: AND rcm.set_number = set_number);
2223: l_count := sql%rowcount;

Line 2260: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm

2256: hz_utility_pub.CREATION_DATE,
2257: hz_utility_pub.LAST_UPDATE_LOGIN,
2258: hz_utility_pub.LAST_UPDATE_DATE,
2259: hz_utility_pub.LAST_UPDATED_BY
2260: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
2261: WHERE (
2262: okpr.bill_to_site_use_id = rcm.duplicate_site_id
2263: ) AND rcm.process_flag = 'N'
2264: AND rcm.request_id = req_id

Line 2267: FROM ra_customer_merges rcm

2263: ) AND rcm.process_flag = 'N'
2264: AND rcm.request_id = req_id
2265: AND rcm.set_number = set_number
2266: AND okpr.bill_to_site_use_id IN (SELECT rcm.duplicate_site_id
2267: FROM ra_customer_merges rcm
2268: WHERE rcm.process_flag = 'N'
2269: AND rcm.request_id = req_id
2270: AND rcm.set_number = set_number);
2271:

Line 2279: FROM ra_customer_merges rcm

2275: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.BILL_TO_SITE_USE_ID',FALSE);
2276:
2277: UPDATE okc_k_party_roles_b okpr
2278: SET okpr.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2279: FROM ra_customer_merges rcm
2280: WHERE okpr.bill_to_site_use_id = rcm.duplicate_site_id
2281: AND rcm.process_flag = 'N'
2282: AND rcm.request_id = req_id
2283: AND rcm.set_number = set_number)

Line 2289: FROM ra_customer_merges rcm

2285: ,okpr.last_update_date = SYSDATE
2286: ,okpr.last_updated_by = arp_standard.profile.user_id
2287: ,okpr.last_update_login = arp_standard.profile.last_update_login
2288: WHERE okpr.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2289: FROM ra_customer_merges rcm
2290: WHERE rcm.process_flag = 'N'
2291: AND rcm.request_id = req_id
2292: AND rcm.set_number = set_number);
2293: l_count := sql%rowcount;

Line 2332: FROM OKC_K_ITEMS cim, ra_customer_merges rcm

2328: hz_utility_pub.CREATION_DATE,
2329: hz_utility_pub.LAST_UPDATE_LOGIN,
2330: hz_utility_pub.LAST_UPDATE_DATE,
2331: hz_utility_pub.LAST_UPDATED_BY
2332: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
2333: WHERE (
2334: cim.object1_id1 = to_char(rcm.duplicate_site_id)
2335: ) AND rcm.process_flag = 'N'
2336: AND rcm.request_id = req_id

Line 2339: FROM ra_customer_merges rcm

2335: ) AND rcm.process_flag = 'N'
2336: AND rcm.request_id = req_id
2337: AND rcm.set_number = set_number
2338: AND cim.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
2339: FROM ra_customer_merges rcm
2340: WHERE rcm.process_flag = 'N'
2341: AND rcm.request_id = req_id
2342: AND rcm.set_number = set_number)
2343: AND cim.jtot_object1_code IN (SELECT ojt.object_code

Line 2354: FROM ra_customer_merges rcm

2350: arp_message.set_name('AR','AR_UPDATING_TABLE');
2351: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
2352: UPDATE okc_k_items cim
2353: SET cim.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
2354: FROM ra_customer_merges rcm
2355: WHERE cim.object1_id1 = rcm.duplicate_site_id
2356: AND rcm.process_flag = 'N'
2357: AND rcm.request_id = req_id
2358: AND rcm.set_number = set_number)

Line 2364: FROM ra_customer_merges rcm

2360: ,cim.last_update_date = SYSDATE
2361: ,cim.last_updated_by = arp_standard.profile.user_id
2362: ,cim.last_update_login = arp_standard.profile.last_update_login
2363: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
2364: FROM ra_customer_merges rcm
2365: WHERE rcm.process_flag = 'N'
2366: AND rcm.request_id = req_id
2367: AND rcm.set_number = set_number)
2368: AND cim.jtot_object1_code IN (SELECT ojt.object_code

Line 2438: ,ra_customer_merges cme

2434: --
2435: CURSOR c_reason IS
2436: SELECT cmh.merge_reason_code
2437: FROM ra_customer_merge_headers cmh
2438: ,ra_customer_merges cme
2439: WHERE cmh.customer_merge_header_id = cme.customer_merge_header_id
2440: AND cme.request_id = req_id
2441: AND cme.set_number = set_number
2442: AND cme.process_flag = 'N'

Line 2451: FROM ra_customer_merges cme

2447: -- or a site merge within the same account
2448: --
2449: CURSOR c_site_merge(b_request_id NUMBER, b_set_number NUMBER) IS
2450: SELECT customer_id, duplicate_id
2451: FROM ra_customer_merges cme
2452: WHERE cme.request_id = b_request_id
2453: AND cme.set_number = b_set_number
2454: AND cme.process_flag = 'N'
2455: ;