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_K_ITEMS

Line 47: -- OKC_K_ITEMS

43: --
44: -- When merging accounts, customer account ids are looked for in:
45: -- OKC_K_PARTY_ROLES
46: -- OKC_RULES
47: -- OKC_K_ITEMS
48: -- For customer site merges, cust_acct_site_ids are looked for in:
49: -- OKC_RULES
50: -- OKC_K_ITEMS
51: -- For customer site use merges, site_use_ids are looked for in:

Line 50: -- OKC_K_ITEMS

46: -- OKC_RULES
47: -- OKC_K_ITEMS
48: -- For customer site merges, cust_acct_site_ids are looked for in:
49: -- OKC_RULES
50: -- OKC_K_ITEMS
51: -- For customer site use merges, site_use_ids are looked for in:
52: -- OKC_RULES
53: -- OKC_K_ITEMS
54: -- OKC_K_PARTY_ROLES (bug 3950642)

Line 53: -- OKC_K_ITEMS

49: -- OKC_RULES
50: -- OKC_K_ITEMS
51: -- For customer site use merges, site_use_ids are looked for in:
52: -- OKC_RULES
53: -- OKC_K_ITEMS
54: -- OKC_K_PARTY_ROLES (bug 3950642)
55: --
56: -- JTF Objects:
57: -- The merge depends upon the proper usages being set for the JTF objects used

Line 169: FROM okc_k_items cim

165: FOR UPDATE NOWAIT;
166:
167: CURSOR c_lock_cim(b_object_use VARCHAR2) IS
168: SELECT 1
169: FROM okc_k_items cim
170: WHERE cim.jtot_object1_code IN (SELECT ojt.object_code
171: FROM jtf_objects_b ojt
172: ,jtf_object_usages oue
173: WHERE ojt.object_code = oue.object_code

Line 233: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);

229: close c_lock_rle3;
230:
231: -- items for accounts (covered level in OKS)
232: arp_message.set_name('AR','AR_LOCKING_TABLE');
233: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
234: arp_message.set_line('Locking for accounts');
235: open c_lock_cim(c_account);
236: close c_lock_cim;
237:

Line 240: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);

236: close c_lock_cim;
237:
238: -- items for sites
239: arp_message.set_name('AR','AR_LOCKING_TABLE');
240: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
241: arp_message.set_line('Locking for sites');
242: open c_lock_cim(c_c_site);
243: close c_lock_cim;
244:

Line 247: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);

243: close c_lock_cim;
244:
245: -- items for site uses
246: arp_message.set_name('AR','AR_LOCKING_TABLE');
247: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
248: arp_message.set_line('Locking for site uses');
249: open c_lock_cim(c_c_site_use);
250: close c_lock_cim;
251:

Line 1119: 'OKC_K_ITEMS',

1115: LAST_UPDATE_LOGIN,
1116: LAST_UPDATE_DATE,
1117: LAST_UPDATED_BY
1118: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1119: 'OKC_K_ITEMS',
1120: CUSTOMER_MERGE_HEADER_ID,
1121: cim.ID,
1122: cim.object1_id1,
1123: to_char(rcm.customer_id),

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 1150: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);

1146: AND oue.object_user_code = c_account);
1147: End If;
1148:
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

Line 1151: UPDATE okc_k_items cim

1147: End If;
1148:
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'

Line 1453: 'OKC_K_ITEMS',

1449: LAST_UPDATE_LOGIN,
1450: LAST_UPDATE_DATE,
1451: LAST_UPDATED_BY
1452: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1453: 'OKC_K_ITEMS',
1454: CUSTOMER_MERGE_HEADER_ID,
1455: cim.ID,
1456: cim.object1_id1,
1457: to_char(rcm.customer_address_id),

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 1484: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);

1480: AND oue.object_user_code = c_c_site);
1481: End If;
1482:
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

Line 1485: UPDATE okc_k_items cim

1481: End If;
1482:
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'

Line 2210: 'OKC_K_ITEMS',

2206: LAST_UPDATE_LOGIN,
2207: LAST_UPDATE_DATE,
2208: LAST_UPDATED_BY
2209: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2210: 'OKC_K_ITEMS',
2211: CUSTOMER_MERGE_HEADER_ID,
2212: cim.ID,
2213: cim.object1_id1,
2214: to_char(rcm.customer_site_id),

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 2241: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);

2237: AND oue.object_user_code = c_c_site_use);
2238: End If;
2239:
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

Line 2242: UPDATE okc_k_items cim

2238: End If;
2239:
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'

Line 2335: FROM okc_k_items cim

2331: -- merged account in a contract line
2332: --
2333: CURSOR c_cim (b_party_id NUMBER) IS
2334: SELECT cim.dnz_chr_id
2335: FROM okc_k_items cim
2336: WHERE cim.jtot_object1_code IN (SELECT ojt.object_code
2337: FROM jtf_objects_b ojt
2338: ,jtf_object_usages oue
2339: WHERE ojt.object_code = oue.object_code