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 52: -- OKC_K_ITEMS

48: --
49: -- When merging accounts, customer account ids are looked for in:
50: -- OKC_K_PARTY_ROLES
51: -- OKC_RULES
52: -- OKC_K_ITEMS
53: -- For customer site merges, cust_acct_site_ids are looked for in:
54: -- OKC_RULES
55: -- OKC_K_ITEMS
56: -- For customer site use merges, site_use_ids are looked for in:

Line 55: -- OKC_K_ITEMS

51: -- OKC_RULES
52: -- OKC_K_ITEMS
53: -- For customer site merges, cust_acct_site_ids are looked for in:
54: -- OKC_RULES
55: -- OKC_K_ITEMS
56: -- For customer site use merges, site_use_ids are looked for in:
57: -- OKC_RULES
58: -- OKC_K_ITEMS
59: -- OKC_K_PARTY_ROLES (bug 3950642)

Line 58: -- OKC_K_ITEMS

54: -- OKC_RULES
55: -- OKC_K_ITEMS
56: -- For customer site use merges, site_use_ids are looked for in:
57: -- OKC_RULES
58: -- OKC_K_ITEMS
59: -- OKC_K_PARTY_ROLES (bug 3950642)
60: --
61: -- JTF Objects:
62: -- The merge depends upon the proper usages being set for the JTF objects used

Line 176: FROM okc_k_items cim

172: FOR UPDATE NOWAIT;
173:
174: CURSOR c_lock_cim(b_object_use VARCHAR2) IS
175: SELECT 1
176: FROM okc_k_items cim
177: WHERE cim.jtot_object1_code IN (SELECT ojt.object_code
178: FROM jtf_objects_b ojt
179: ,jtf_object_usages oue
180: WHERE ojt.object_code = oue.object_code

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

236: close c_lock_rle3;
237:
238: -- items for accounts (covered level in OKS)
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 accounts');
242: open c_lock_cim(c_account);
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 sites
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 sites');
249: open c_lock_cim(c_c_site);
250: close c_lock_cim;
251:

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

250: close c_lock_cim;
251:
252: -- items for site uses
253: arp_message.set_name('AR','AR_LOCKING_TABLE');
254: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
255: arp_message.set_line('Locking for site uses');
256: open c_lock_cim(c_c_site_use);
257: close c_lock_cim;
258:

Line 1152: 'OKC_K_ITEMS',

1148: LAST_UPDATE_LOGIN,
1149: LAST_UPDATE_DATE,
1150: LAST_UPDATED_BY
1151: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1152: 'OKC_K_ITEMS',
1153: CUSTOMER_MERGE_HEADER_ID,
1154: cim.ID,
1155: cim.object1_id1,
1156: to_char(rcm.customer_id),

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

1179: AND oue.object_user_code = c_account);
1180: End If;
1181:
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

Line 1184: UPDATE okc_k_items cim

1180: End If;
1181:
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'

Line 1550: 'OKC_K_ITEMS',

1546: LAST_UPDATE_LOGIN,
1547: LAST_UPDATE_DATE,
1548: LAST_UPDATED_BY
1549: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1550: 'OKC_K_ITEMS',
1551: CUSTOMER_MERGE_HEADER_ID,
1552: cim.ID,
1553: cim.object1_id1,
1554: to_char(rcm.customer_address_id),

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

1577: AND oue.object_user_code = c_c_site);
1578: End If;
1579:
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

Line 1582: UPDATE okc_k_items cim

1578: End If;
1579:
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'

Line 2320: 'OKC_K_ITEMS',

2316: LAST_UPDATE_LOGIN,
2317: LAST_UPDATE_DATE,
2318: LAST_UPDATED_BY
2319: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2320: 'OKC_K_ITEMS',
2321: CUSTOMER_MERGE_HEADER_ID,
2322: cim.ID,
2323: cim.object1_id1,
2324: to_char(rcm.customer_site_id),

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

2347: AND oue.object_user_code = c_c_site_use);
2348: End If;
2349:
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

Line 2352: UPDATE okc_k_items cim

2348: End If;
2349:
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'

Line 2486: FROM okc_k_items cim

2482: -- merged account in a contract line
2483: --
2484: CURSOR c_cim (b_party_id NUMBER) IS
2485: SELECT cim.dnz_chr_id
2486: FROM okc_k_items cim
2487: WHERE cim.jtot_object1_code IN (SELECT ojt.object_code
2488: FROM jtf_objects_b ojt
2489: ,jtf_object_usages oue
2490: WHERE ojt.object_code = oue.object_code