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_LINES_B

Line 298: -- Bug 3555739 modified the cursor to check for account info. in okc_k_lines_b and

294:
295: --
296: -- cursor to get all the acounts from rules for a particular
297: -- contract
298: -- Bug 3555739 modified the cursor to check for account info. in okc_k_lines_b and
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

Line 312: from okc_k_lines_b

308: from okc_k_headers_b
309: where id = b_dnz_chr_id
310: union
311: select to_char(bill_to_site_use_id), to_char(ship_to_site_use_id), to_char(cust_acct_id)
312: from okc_k_lines_b
313: where chr_id = b_dnz_chr_id ;
314:
315: --
316: -- cursor to check whether the source party has more than one

Line 318: -- Bug 3555739 modified the cursor to check for account info. in okc_k_lines_b and

314:
315: --
316: -- cursor to check whether the source party has more than one
317: -- account in the contract
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

Line 354: from okc_k_lines_b where dnz_chr_id = b_chr_id)

350: and SITE_USE_CODE = 'SHIP_TO')
351: union
352: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V
353: where id1 IN (select bill_to_site_use_id
354: from okc_k_lines_b where dnz_chr_id = b_chr_id)
355: and party_id = l_source_party_id
356: and SITE_USE_CODE = 'BILL_TO')
357: union
358: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

Line 360: from okc_k_lines_b where dnz_chr_id = b_chr_id )

356: and SITE_USE_CODE = 'BILL_TO')
357: union
358: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V
359: where id1 IN (select ship_to_site_use_id
360: from okc_k_lines_b where dnz_chr_id = b_chr_id )
361: and party_id =l_source_party_id
362: and SITE_USE_CODE = 'SHIP_TO')
363: union
364: (select to_char(cust_account_id) from hz_cust_accounts

Line 366: from okc_k_lines_b where dnz_chr_id = b_chr_id )

362: and SITE_USE_CODE = 'SHIP_TO')
363: union
364: (select to_char(cust_account_id) from hz_cust_accounts
365: where cust_account_id IN (select cust_acct_id
366: from okc_k_lines_b where dnz_chr_id = b_chr_id )
367: -- For Bug# 6861077
368: and party_id =l_source_party_id)
369: union
370: (select to_char(cust_account_id) from hz_cust_accounts

Line 589: FROM okc_k_lines_b okl

585: l_count NUMBER;
586: /*BUG9077092*/
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

Line 984: -- Updating okc_k_lines_b

980: arp_message.set_token('NUM_ROWS',to_char(l_count));
981:
982:
983:
984: -- Updating okc_k_lines_b
985: -- Cust_Acct_Id
986: -- Insert into log table
987: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
988: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1003: 'OKC_K_LINES_B',

999: LAST_UPDATE_LOGIN,
1000: LAST_UPDATE_DATE,
1001: LAST_UPDATED_BY
1002: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1003: 'OKC_K_LINES_B',
1004: CUSTOMER_MERGE_HEADER_ID,
1005: okl.ID,
1006: to_char(okl.cust_acct_id),
1007: to_char(rcm.customer_id),

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 1030: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.CUST_ACCT_ID',FALSE);

1026:
1027: End If;
1028:
1029: arp_message.set_name('AR','AR_UPDATING_TABLE');
1030: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.CUST_ACCT_ID',FALSE);
1031:
1032: /*bug9077092*/
1033: FOR j IN contract_id LOOP
1034: l_chr_id(i) := j.chr_id;

Line 1040: UPDATE okc_k_lines_b okl

1036: EXIT WHEN contract_id%NOTFOUND;
1037: END LOOP;
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'

Line 1268: FROM okc_k_lines_b okl

1264: /*BUG9077092*/
1265: /*modified below sql query for bug10434787 in order to drive through index*/
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

Line 1276: FROM okc_k_lines_b okl

1272: AND rcm.request_id = req_id
1273: AND rcm.set_number = set_number))
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

Line 2058: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);

2054:
2055: End If;
2056:
2057: arp_message.set_name('AR','AR_UPDATING_TABLE');
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

Line 2081: -- Updating okc_k_lines_b

2077: l_cum_count := l_cum_count + l_count; /*bug9077092*/
2078: arp_message.set_name('AR','AR_ROWS_UPDATED');
2079: arp_message.set_token('NUM_ROWS',to_char(l_count));
2080:
2081: -- Updating okc_k_lines_b
2082: -- Ship_to_site_use_id
2083: -- Insert into log table
2084: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2085: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 2100: 'OKC_K_LINES_B',

2096: LAST_UPDATE_LOGIN,
2097: LAST_UPDATE_DATE,
2098: LAST_UPDATED_BY
2099: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2100: 'OKC_K_LINES_B',
2101: CUSTOMER_MERGE_HEADER_ID,
2102: okl.ID,
2103: to_char(okl.ship_to_site_use_id),
2104: to_char(rcm.customer_site_id),

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 2127: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.SHIP_TO_SITE_USE_ID',FALSE);

2123:
2124: End If;
2125:
2126: arp_message.set_name('AR','AR_UPDATING_TABLE');
2127: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.SHIP_TO_SITE_USE_ID',FALSE);
2128:
2129: /*bug9077092*/
2130: FOR j IN contract_id LOOP
2131: l_chr_id(i) := j.chr_id;

Line 2137: UPDATE okc_k_lines_b okl

2133: EXIT WHEN contract_id%NOTFOUND;
2134: END LOOP;
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'

Line 2159: -- Updating okc_k_lines_b

2155: arp_message.set_name('AR','AR_ROWS_UPDATED');
2156: arp_message.set_token('NUM_ROWS',to_char(l_count));
2157:
2158:
2159: -- Updating okc_k_lines_b
2160: -- Bill_to_site_use_id
2161: -- Insert into log table
2162: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2163: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 2178: 'OKC_K_LINES_B',

2174: LAST_UPDATE_LOGIN,
2175: LAST_UPDATE_DATE,
2176: LAST_UPDATED_BY
2177: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2178: 'OKC_K_LINES_B',
2179: CUSTOMER_MERGE_HEADER_ID,
2180: okl.ID,
2181: to_char(okl.bill_to_site_use_id),
2182: to_char(rcm.customer_site_id),

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 2205: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);

2201:
2202: End If;
2203:
2204: arp_message.set_name('AR','AR_UPDATING_TABLE');
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

Line 2207: UPDATE okc_k_lines_b okl

2203:
2204: arp_message.set_name('AR','AR_UPDATING_TABLE');
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'