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 125: FROM okc_rules_b rle

121:
122:
123: CURSOR c_lock_rle1(b_object_use VARCHAR2) IS
124: SELECT 1
125: FROM okc_rules_b rle
126: WHERE rle.jtot_object1_code IN (SELECT ojt.object_code
127: FROM jtf_objects_b ojt
128: ,jtf_object_usages oue
129: WHERE ojt.object_code = oue.object_code

Line 142: FROM okc_rules_b rle

138: FOR UPDATE NOWAIT;
139:
140: CURSOR c_lock_rle2(b_object_use VARCHAR2) IS
141: SELECT 1
142: FROM okc_rules_b rle
143: WHERE rle.jtot_object2_code IN (SELECT ojt.object_code
144: FROM jtf_objects_b ojt
145: ,jtf_object_usages oue
146: WHERE ojt.object_code = oue.object_code

Line 159: FROM okc_rules_b rle

155: FOR UPDATE NOWAIT;
156:
157: CURSOR c_lock_rle3(b_object_use VARCHAR2) IS
158: SELECT 1
159: FROM okc_rules_b rle
160: WHERE rle.jtot_object3_code IN (SELECT ojt.object_code
161: FROM jtf_objects_b ojt
162: ,jtf_object_usages oue
163: WHERE ojt.object_code = oue.object_code

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

203: close c_lock_kpr;
204:
205: -- rules for accounts
206: arp_message.set_name('AR','AR_LOCKING_TABLE');
207: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);
208: arp_message.set_line('Locking for accounts');
209: open c_lock_rle1(c_account);
210: close c_lock_rle1;
211: open c_lock_rle2(c_account);

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

214: close c_lock_rle3;
215:
216: -- rules for sites
217: arp_message.set_name('AR','AR_LOCKING_TABLE');
218: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);
219: arp_message.set_line('Locking for sites');
220: open c_lock_rle1(c_c_site);
221: close c_lock_rle1;
222: open c_lock_rle2(c_c_site);

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

225: close c_lock_rle3;
226:
227: -- rules for site uses
228: arp_message.set_name('AR','AR_LOCKING_TABLE');
229: arp_message.set_token('TABLE_NAME','OKC_RULES_B.OBJECT3_ID1',FALSE);
230: arp_message.set_line('Locking for site uses');
231: open c_lock_rle1(c_c_site_use);
232: close c_lock_rle1;
233: open c_lock_rle2(c_c_site_use);

Line 303: from okc_rules_b

299: -- okc_k_headers_b also
300:
301: CURSOR c_rules (b_dnz_chr_id NUMBER) IS
302: select object1_id1, object2_id1, object3_id1
303: from okc_rules_b
304: where dnz_chr_id = b_dnz_chr_id
305: and rule_information_category IN ('BTO', 'STO')
306: union
307: select to_char(bill_to_site_use_id), to_char(ship_to_site_use_id), to_char(cust_acct_id)

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

318: -- Bug 3555739 modified the cursor to check for account info. in okc_k_lines_b and
319: -- okc_k_headers_b also
320: CURSOR c_account_count (b_chr_id NUMBER) IS
321: select count(*)
322: from (select okr1.object1_id1 from okc_rules_b okr1
323: where okr1.object1_id1 in (
324: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id
325: ) and okr1.dnz_chr_id = b_chr_id
326: and okr1.rule_information_category IN ('BTO', 'STO')

Line 328: select okr2.object2_id1 from okc_rules_b okr2

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

Line 334: select okr3.object3_id1 from okc_rules_b okr3

330: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id
331: ) and okr2.dnz_chr_id = b_chr_id
332: and okr2.rule_information_category IN ('BTO', 'STO')
333: union
334: select okr3.object3_id1 from okc_rules_b okr3
335: where okr3.object3_id1 in (
336: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id
337: ) and okr3.dnz_chr_id = b_chr_id
338: and okr3.rule_information_category IN ('BTO', 'STO')

Line 393: l_object1_id1 okc_rules_b.object1_id1%type;

389:
390: l_count NUMBER(10) := 0;
391: l_object_user_code VARCHAR2(20);
392: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;
393: l_object1_id1 okc_rules_b.object1_id1%type;
394: l_object2_id1 okc_rules_b.object2_id1%type;
395: l_object3_id1 okc_rules_b.object3_id1%type;
396: l_account_count NUMBER(10) := 0;
397: l_contract_number okc_k_headers_b.contract_number%type;

Line 394: l_object2_id1 okc_rules_b.object2_id1%type;

390: l_count NUMBER(10) := 0;
391: l_object_user_code VARCHAR2(20);
392: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;
393: l_object1_id1 okc_rules_b.object1_id1%type;
394: l_object2_id1 okc_rules_b.object2_id1%type;
395: l_object3_id1 okc_rules_b.object3_id1%type;
396: l_account_count NUMBER(10) := 0;
397: l_contract_number okc_k_headers_b.contract_number%type;
398: l_contract_number_modifier okc_k_headers_b.contract_number_modifier%type;

Line 395: l_object3_id1 okc_rules_b.object3_id1%type;

391: l_object_user_code VARCHAR2(20);
392: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;
393: l_object1_id1 okc_rules_b.object1_id1%type;
394: l_object2_id1 okc_rules_b.object2_id1%type;
395: l_object3_id1 okc_rules_b.object3_id1%type;
396: l_account_count NUMBER(10) := 0;
397: l_contract_number okc_k_headers_b.contract_number%type;
398: l_contract_number_modifier okc_k_headers_b.contract_number_modifier%type;
399: l_status VARCHAR2(1);

Line 699: 'OKC_RULES_B',

695: LAST_UPDATE_LOGIN,
696: LAST_UPDATE_DATE,
697: LAST_UPDATED_BY
698: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
699: 'OKC_RULES_B',
700: CUSTOMER_MERGE_HEADER_ID,
701: rle.ID,
702: rle.object1_id1,
703: to_char(rcm.customer_id),

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

726: AND oue.object_user_code = c_account);
727: End If;
728:
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

Line 731: UPDATE okc_rules_b rle

727: End If;
728:
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'

Line 776: 'OKC_RULES_B',

772: LAST_UPDATE_LOGIN,
773: LAST_UPDATE_DATE,
774: LAST_UPDATED_BY
775: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
776: 'OKC_RULES_B',
777: CUSTOMER_MERGE_HEADER_ID,
778: rle.ID,
779: rle.object2_id1,
780: to_char(rcm.customer_id),

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

803: AND oue.object_user_code = c_account);
804: End If;
805:
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

Line 808: UPDATE okc_rules_b rle

804: End If;
805:
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'

Line 853: 'OKC_RULES_B',

849: LAST_UPDATE_LOGIN,
850: LAST_UPDATE_DATE,
851: LAST_UPDATED_BY
852: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
853: 'OKC_RULES_B',
854: CUSTOMER_MERGE_HEADER_ID,
855: rle.ID,
856: rle.object3_id1,
857: to_char(rcm.customer_id),

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

880: AND oue.object_user_code = c_account);
881: End If;
882:
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

Line 885: UPDATE okc_rules_b rle

881: End If;
882:
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'

Line 1315: 'OKC_RULES_B',

1311: LAST_UPDATE_LOGIN,
1312: LAST_UPDATE_DATE,
1313: LAST_UPDATED_BY
1314: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1315: 'OKC_RULES_B',
1316: CUSTOMER_MERGE_HEADER_ID,
1317: rle.ID,
1318: rle.object1_id1,
1319: to_char(customer_address_id),

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

1342: AND oue.object_user_code = c_c_site);
1343: End If;
1344:
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

Line 1347: UPDATE okc_rules_b rle

1343: End If;
1344:
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'

Line 1393: 'OKC_RULES_B',

1389: LAST_UPDATE_LOGIN,
1390: LAST_UPDATE_DATE,
1391: LAST_UPDATED_BY
1392: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1393: 'OKC_RULES_B',
1394: CUSTOMER_MERGE_HEADER_ID,
1395: rle.ID,
1396: rle.object2_id1,
1397: to_char(customer_address_id),

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

1420: AND oue.object_user_code = c_c_site);
1421: End If;
1422:
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

Line 1425: UPDATE okc_rules_b rle

1421: End If;
1422:
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'

Line 1470: 'OKC_RULES_B',

1466: LAST_UPDATE_LOGIN,
1467: LAST_UPDATE_DATE,
1468: LAST_UPDATED_BY
1469: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1470: 'OKC_RULES_B',
1471: CUSTOMER_MERGE_HEADER_ID,
1472: rle.ID,
1473: rle.object3_id1,
1474: to_char(customer_address_id),

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

1497: AND oue.object_user_code = c_c_site);
1498: End If;
1499:
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

Line 1502: UPDATE okc_rules_b rle

1498: End If;
1499:
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'

Line 1730: 'OKC_RULES_B',

1726: LAST_UPDATE_LOGIN,
1727: LAST_UPDATE_DATE,
1728: LAST_UPDATED_BY
1729: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1730: 'OKC_RULES_B',
1731: CUSTOMER_MERGE_HEADER_ID,
1732: rle.ID,
1733: rle.object1_id1,
1734: to_char(rcm.customer_site_id),

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

1757: AND oue.object_user_code = c_c_site_use);
1758: End If;
1759:
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

Line 1762: UPDATE okc_rules_b rle

1758: End If;
1759:
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'

Line 1806: 'OKC_RULES_B',

1802: LAST_UPDATE_LOGIN,
1803: LAST_UPDATE_DATE,
1804: LAST_UPDATED_BY
1805: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1806: 'OKC_RULES_B',
1807: CUSTOMER_MERGE_HEADER_ID,
1808: rle.ID,
1809: rle.object2_id1,
1810: to_char(rcm.customer_site_id),

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

1833: AND oue.object_user_code = c_c_site_use);
1834: End If;
1835:
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

Line 1838: UPDATE okc_rules_b rle

1834: End If;
1835:
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'

Line 1883: 'OKC_RULES_B',

1879: LAST_UPDATE_LOGIN,
1880: LAST_UPDATE_DATE,
1881: LAST_UPDATED_BY
1882: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1883: 'OKC_RULES_B',
1884: CUSTOMER_MERGE_HEADER_ID,
1885: rle.ID,
1886: rle.object3_id1,
1887: to_char(rcm.customer_site_id),

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

1910: AND oue.object_user_code = c_c_site_use);
1911: End If;
1912:
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

Line 1915: UPDATE okc_rules_b rle

1911: End If;
1912:
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'