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 OKC_RULES_B

Line 118: FROM okc_rules_b rle

114:
115:
116: CURSOR c_lock_rle1(b_object_use VARCHAR2) IS
117: SELECT 1
118: FROM okc_rules_b rle
119: WHERE rle.jtot_object1_code IN (SELECT ojt.object_code
120: FROM jtf_objects_b ojt
121: ,jtf_object_usages oue
122: WHERE ojt.object_code = oue.object_code

Line 135: FROM okc_rules_b rle

131: FOR UPDATE NOWAIT;
132:
133: CURSOR c_lock_rle2(b_object_use VARCHAR2) IS
134: SELECT 1
135: FROM okc_rules_b rle
136: WHERE rle.jtot_object2_code IN (SELECT ojt.object_code
137: FROM jtf_objects_b ojt
138: ,jtf_object_usages oue
139: WHERE ojt.object_code = oue.object_code

Line 152: FROM okc_rules_b rle

148: FOR UPDATE NOWAIT;
149:
150: CURSOR c_lock_rle3(b_object_use VARCHAR2) IS
151: SELECT 1
152: FROM okc_rules_b rle
153: WHERE rle.jtot_object3_code IN (SELECT ojt.object_code
154: FROM jtf_objects_b ojt
155: ,jtf_object_usages oue
156: WHERE ojt.object_code = oue.object_code

Line 200: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);

196: close c_lock_kpr;
197:
198: -- rules for accounts
199: arp_message.set_name('AR','AR_LOCKING_TABLE');
200: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);
201: arp_message.set_line('Locking for accounts');
202: open c_lock_rle1(c_account);
203: close c_lock_rle1;
204: open c_lock_rle2(c_account);

Line 211: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);

207: close c_lock_rle3;
208:
209: -- rules for sites
210: arp_message.set_name('AR','AR_LOCKING_TABLE');
211: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);
212: arp_message.set_line('Locking for sites');
213: open c_lock_rle1(c_c_site);
214: close c_lock_rle1;
215: open c_lock_rle2(c_c_site);

Line 222: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);

218: close c_lock_rle3;
219:
220: -- rules for site uses
221: arp_message.set_name('AR','AR_LOCKING_TABLE');
222: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
223: arp_message.set_line('Locking for site uses');
224: open c_lock_rle1(c_c_site_use);
225: close c_lock_rle1;
226: open c_lock_rle2(c_c_site_use);

Line 296: from okc_rules_b

292: -- okc_k_headers_b also
293:
294: CURSOR c_rules (b_dnz_chr_id NUMBER) IS
295: select object1_id1, object2_id1, object3_id1
296: from okc_rules_b
297: where dnz_chr_id = b_dnz_chr_id
298: and rule_information_category IN ('BTO', 'STO')
299: union
300: select to_char(bill_to_site_use_id), to_char(ship_to_site_use_id), to_char(cust_acct_id)

Line 315: from (select okr1.object1_id1 from okc_rules_b okr1

311: -- Bug 3555739 modified the cursor to check for account info. in okc_k_lines_b and
312: -- okc_k_headers_b also
313: CURSOR c_account_count (b_chr_id NUMBER) IS
314: select count(*)
315: from (select okr1.object1_id1 from okc_rules_b okr1
316: where okr1.object1_id1 in (
317: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id
318: ) and okr1.dnz_chr_id = b_chr_id
319: and okr1.rule_information_category IN ('BTO', 'STO')

Line 321: select okr2.object2_id1 from okc_rules_b okr2

317: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id
318: ) and okr1.dnz_chr_id = b_chr_id
319: and okr1.rule_information_category IN ('BTO', 'STO')
320: union
321: select okr2.object2_id1 from okc_rules_b okr2
322: where okr2.object2_id1 in (
323: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id
324: ) and okr2.dnz_chr_id = b_chr_id
325: and okr2.rule_information_category IN ('BTO', 'STO')

Line 327: select okr3.object3_id1 from okc_rules_b okr3

323: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id
324: ) and okr2.dnz_chr_id = b_chr_id
325: and okr2.rule_information_category IN ('BTO', 'STO')
326: union
327: select okr3.object3_id1 from okc_rules_b okr3
328: where okr3.object3_id1 in (
329: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id
330: ) and okr3.dnz_chr_id = b_chr_id
331: and okr3.rule_information_category IN ('BTO', 'STO')

Line 386: l_object1_id1 okc_rules_b.object1_id1%type;

382:
383: l_count NUMBER(10) := 0;
384: l_object_user_code VARCHAR2(20);
385: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;
386: l_object1_id1 okc_rules_b.object1_id1%type;
387: l_object2_id1 okc_rules_b.object2_id1%type;
388: l_object3_id1 okc_rules_b.object3_id1%type;
389: l_account_count NUMBER(10) := 0;
390: l_contract_number okc_k_headers_b.contract_number%type;

Line 387: l_object2_id1 okc_rules_b.object2_id1%type;

383: l_count NUMBER(10) := 0;
384: l_object_user_code VARCHAR2(20);
385: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;
386: l_object1_id1 okc_rules_b.object1_id1%type;
387: l_object2_id1 okc_rules_b.object2_id1%type;
388: l_object3_id1 okc_rules_b.object3_id1%type;
389: l_account_count NUMBER(10) := 0;
390: l_contract_number okc_k_headers_b.contract_number%type;
391: l_contract_number_modifier okc_k_headers_b.contract_number_modifier%type;

Line 388: l_object3_id1 okc_rules_b.object3_id1%type;

384: l_object_user_code VARCHAR2(20);
385: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;
386: l_object1_id1 okc_rules_b.object1_id1%type;
387: l_object2_id1 okc_rules_b.object2_id1%type;
388: l_object3_id1 okc_rules_b.object3_id1%type;
389: l_account_count NUMBER(10) := 0;
390: l_contract_number okc_k_headers_b.contract_number%type;
391: l_contract_number_modifier okc_k_headers_b.contract_number_modifier%type;
392: l_status VARCHAR2(1);

Line 677: 'OKC_RULES_B',

673: LAST_UPDATE_LOGIN,
674: LAST_UPDATE_DATE,
675: LAST_UPDATED_BY
676: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
677: 'OKC_RULES_B',
678: CUSTOMER_MERGE_HEADER_ID,
679: rle.ID,
680: rle.object1_id1,
681: to_char(rcm.customer_id),

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 708: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);

704: AND oue.object_user_code = c_account);
705: End If;
706:
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

Line 709: UPDATE okc_rules_b rle

705: End If;
706:
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'

Line 754: 'OKC_RULES_B',

750: LAST_UPDATE_LOGIN,
751: LAST_UPDATE_DATE,
752: LAST_UPDATED_BY
753: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
754: 'OKC_RULES_B',
755: CUSTOMER_MERGE_HEADER_ID,
756: rle.ID,
757: rle.object2_id1,
758: to_char(rcm.customer_id),

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 785: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);

781: AND oue.object_user_code = c_account);
782: End If;
783:
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

Line 786: UPDATE okc_rules_b rle

782: End If;
783:
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'

Line 831: 'OKC_RULES_B',

827: LAST_UPDATE_LOGIN,
828: LAST_UPDATE_DATE,
829: LAST_UPDATED_BY
830: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
831: 'OKC_RULES_B',
832: CUSTOMER_MERGE_HEADER_ID,
833: rle.ID,
834: rle.object3_id1,
835: to_char(rcm.customer_id),

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 862: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);

858: AND oue.object_user_code = c_account);
859: End If;
860:
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

Line 863: UPDATE okc_rules_b rle

859: End If;
860:
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'

Line 1218: 'OKC_RULES_B',

1214: LAST_UPDATE_LOGIN,
1215: LAST_UPDATE_DATE,
1216: LAST_UPDATED_BY
1217: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1218: 'OKC_RULES_B',
1219: CUSTOMER_MERGE_HEADER_ID,
1220: rle.ID,
1221: rle.object1_id1,
1222: to_char(customer_address_id),

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 1249: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);

1245: AND oue.object_user_code = c_c_site);
1246: End If;
1247:
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

Line 1250: UPDATE okc_rules_b rle

1246: End If;
1247:
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'

Line 1296: 'OKC_RULES_B',

1292: LAST_UPDATE_LOGIN,
1293: LAST_UPDATE_DATE,
1294: LAST_UPDATED_BY
1295: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1296: 'OKC_RULES_B',
1297: CUSTOMER_MERGE_HEADER_ID,
1298: rle.ID,
1299: rle.object2_id1,
1300: to_char(customer_address_id),

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 1327: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);

1323: AND oue.object_user_code = c_c_site);
1324: End If;
1325:
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

Line 1328: UPDATE okc_rules_b rle

1324: End If;
1325:
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'

Line 1373: 'OKC_RULES_B',

1369: LAST_UPDATE_LOGIN,
1370: LAST_UPDATE_DATE,
1371: LAST_UPDATED_BY
1372: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1373: 'OKC_RULES_B',
1374: CUSTOMER_MERGE_HEADER_ID,
1375: rle.ID,
1376: rle.object3_id1,
1377: to_char(customer_address_id),

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 1404: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);

1400: AND oue.object_user_code = c_c_site);
1401: End If;
1402:
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

Line 1405: UPDATE okc_rules_b rle

1401: End If;
1402:
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'

Line 1633: 'OKC_RULES_B',

1629: LAST_UPDATE_LOGIN,
1630: LAST_UPDATE_DATE,
1631: LAST_UPDATED_BY
1632: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1633: 'OKC_RULES_B',
1634: CUSTOMER_MERGE_HEADER_ID,
1635: rle.ID,
1636: rle.object1_id1,
1637: to_char(rcm.customer_site_id),

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 1664: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT1_ID1',FALSE);

1660: AND oue.object_user_code = c_c_site_use);
1661: End If;
1662:
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

Line 1665: UPDATE okc_rules_b rle

1661: End If;
1662:
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'

Line 1709: 'OKC_RULES_B',

1705: LAST_UPDATE_LOGIN,
1706: LAST_UPDATE_DATE,
1707: LAST_UPDATED_BY
1708: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1709: 'OKC_RULES_B',
1710: CUSTOMER_MERGE_HEADER_ID,
1711: rle.ID,
1712: rle.object2_id1,
1713: to_char(rcm.customer_site_id),

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 1740: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT2_ID1',FALSE);

1736: AND oue.object_user_code = c_c_site_use);
1737: End If;
1738:
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

Line 1741: UPDATE okc_rules_b rle

1737: End If;
1738:
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'

Line 1786: 'OKC_RULES_B',

1782: LAST_UPDATE_LOGIN,
1783: LAST_UPDATE_DATE,
1784: LAST_UPDATED_BY
1785: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1786: 'OKC_RULES_B',
1787: CUSTOMER_MERGE_HEADER_ID,
1788: rle.ID,
1789: rle.object3_id1,
1790: to_char(rcm.customer_site_id),

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 1817: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);

1813: AND oue.object_user_code = c_c_site_use);
1814: End If;
1815:
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

Line 1818: UPDATE okc_rules_b rle

1814: End If;
1815:
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'