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 291: -- Bug 3555739 modified the cursor to check for account info. in okc_k_lines_b and

287:
288: --
289: -- cursor to get all the acounts from rules for a particular
290: -- contract
291: -- Bug 3555739 modified the cursor to check for account info. in okc_k_lines_b and
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

Line 305: from okc_k_lines_b

301: from okc_k_headers_b
302: where id = b_dnz_chr_id
303: union
304: select to_char(bill_to_site_use_id), to_char(ship_to_site_use_id), to_char(cust_acct_id)
305: from okc_k_lines_b
306: where chr_id = b_dnz_chr_id ;
307:
308: --
309: -- cursor to check whether the source party has more than one

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

307:
308: --
309: -- cursor to check whether the source party has more than one
310: -- account in the contract
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

Line 347: from okc_k_lines_b where dnz_chr_id = b_chr_id)

343: and SITE_USE_CODE = 'SHIP_TO')
344: union
345: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V
346: where id1 IN (select bill_to_site_use_id
347: from okc_k_lines_b where dnz_chr_id = b_chr_id)
348: and party_id = l_source_party_id
349: and SITE_USE_CODE = 'BILL_TO')
350: union
351: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

Line 353: from okc_k_lines_b where dnz_chr_id = b_chr_id )

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

Line 359: from okc_k_lines_b where dnz_chr_id = b_chr_id )

355: and SITE_USE_CODE = 'SHIP_TO')
356: union
357: (select to_char(cust_account_id) from hz_cust_accounts
358: where cust_account_id IN (select cust_acct_id
359: from okc_k_lines_b where dnz_chr_id = b_chr_id )
360: -- For Bug# 6861077
361: and party_id =l_source_party_id)
362: union
363: (select to_char(cust_account_id) from hz_cust_accounts

Line 961: -- Updating okc_k_lines_b

957: arp_message.set_token('NUM_ROWS',to_char(l_count));
958:
959:
960:
961: -- Updating okc_k_lines_b
962: -- Cust_Acct_Id
963: -- Insert into log table
964: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
965: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 980: 'OKC_K_LINES_B',

976: LAST_UPDATE_LOGIN,
977: LAST_UPDATE_DATE,
978: LAST_UPDATED_BY
979: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
980: 'OKC_K_LINES_B',
981: CUSTOMER_MERGE_HEADER_ID,
982: okl.ID,
983: to_char(okl.cust_acct_id),
984: to_char(rcm.customer_id),

Line 992: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

988: hz_utility_pub.CREATION_DATE,
989: hz_utility_pub.LAST_UPDATE_LOGIN,
990: hz_utility_pub.LAST_UPDATE_DATE,
991: hz_utility_pub.LAST_UPDATED_BY
992: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
993: WHERE (
994: okl.cust_acct_id = rcm.duplicate_id
995: ) AND rcm.process_flag = 'N'
996: AND rcm.request_id = req_id

Line 1007: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.CUST_ACCT_ID',FALSE);

1003:
1004: End If;
1005:
1006: arp_message.set_name('AR','AR_UPDATING_TABLE');
1007: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.CUST_ACCT_ID',FALSE);
1008:
1009: UPDATE okc_k_lines_b okl
1010: SET okl.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
1011: FROM ra_customer_merges rcm

Line 1009: UPDATE okc_k_lines_b okl

1005:
1006: arp_message.set_name('AR','AR_UPDATING_TABLE');
1007: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.CUST_ACCT_ID',FALSE);
1008:
1009: UPDATE okc_k_lines_b okl
1010: SET okl.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
1011: FROM ra_customer_merges rcm
1012: WHERE okl.cust_acct_id = rcm.duplicate_id
1013: AND rcm.process_flag = 'N'

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

1956:
1957: End If;
1958:
1959: arp_message.set_name('AR','AR_UPDATING_TABLE');
1960: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);
1961:
1962: UPDATE okc_k_headers_b okh
1963: SET okh.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
1964: FROM ra_customer_merges rcm

Line 1982: -- Updating okc_k_lines_b

1978: l_count := sql%rowcount;
1979: arp_message.set_name('AR','AR_ROWS_UPDATED');
1980: arp_message.set_token('NUM_ROWS',to_char(l_count));
1981:
1982: -- Updating okc_k_lines_b
1983: -- Ship_to_site_use_id
1984: -- Insert into log table
1985: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1986: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 2001: 'OKC_K_LINES_B',

1997: LAST_UPDATE_LOGIN,
1998: LAST_UPDATE_DATE,
1999: LAST_UPDATED_BY
2000: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2001: 'OKC_K_LINES_B',
2002: CUSTOMER_MERGE_HEADER_ID,
2003: okl.ID,
2004: to_char(okl.ship_to_site_use_id),
2005: to_char(rcm.customer_site_id),

Line 2013: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

2009: hz_utility_pub.CREATION_DATE,
2010: hz_utility_pub.LAST_UPDATE_LOGIN,
2011: hz_utility_pub.LAST_UPDATE_DATE,
2012: hz_utility_pub.LAST_UPDATED_BY
2013: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2014: WHERE (
2015: okl.ship_to_site_use_id = rcm.duplicate_site_id
2016: ) AND rcm.process_flag = 'N'
2017: AND rcm.request_id = req_id

Line 2028: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.SHIP_TO_SITE_USE_ID',FALSE);

2024:
2025: End If;
2026:
2027: arp_message.set_name('AR','AR_UPDATING_TABLE');
2028: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.SHIP_TO_SITE_USE_ID',FALSE);
2029:
2030: UPDATE okc_k_lines_b okl
2031: SET okl.ship_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2032: FROM ra_customer_merges rcm

Line 2030: UPDATE okc_k_lines_b okl

2026:
2027: arp_message.set_name('AR','AR_UPDATING_TABLE');
2028: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.SHIP_TO_SITE_USE_ID',FALSE);
2029:
2030: UPDATE okc_k_lines_b okl
2031: SET okl.ship_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2032: FROM ra_customer_merges rcm
2033: WHERE okl.ship_to_site_use_id = rcm.duplicate_site_id
2034: AND rcm.process_flag = 'N'

Line 2051: -- Updating okc_k_lines_b

2047: arp_message.set_name('AR','AR_ROWS_UPDATED');
2048: arp_message.set_token('NUM_ROWS',to_char(l_count));
2049:
2050:
2051: -- Updating okc_k_lines_b
2052: -- Bill_to_site_use_id
2053: -- Insert into log table
2054: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2055: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 2070: 'OKC_K_LINES_B',

2066: LAST_UPDATE_LOGIN,
2067: LAST_UPDATE_DATE,
2068: LAST_UPDATED_BY
2069: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2070: 'OKC_K_LINES_B',
2071: CUSTOMER_MERGE_HEADER_ID,
2072: okl.ID,
2073: to_char(okl.bill_to_site_use_id),
2074: to_char(rcm.customer_site_id),

Line 2082: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

2078: hz_utility_pub.CREATION_DATE,
2079: hz_utility_pub.LAST_UPDATE_LOGIN,
2080: hz_utility_pub.LAST_UPDATE_DATE,
2081: hz_utility_pub.LAST_UPDATED_BY
2082: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2083: WHERE (
2084: okl.bill_to_site_use_id = rcm.duplicate_site_id
2085: ) AND rcm.process_flag = 'N'
2086: AND rcm.request_id = req_id

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

2093:
2094: End If;
2095:
2096: arp_message.set_name('AR','AR_UPDATING_TABLE');
2097: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);
2098:
2099: UPDATE okc_k_lines_b okl
2100: SET okl.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2101: FROM ra_customer_merges rcm

Line 2099: UPDATE okc_k_lines_b okl

2095:
2096: arp_message.set_name('AR','AR_UPDATING_TABLE');
2097: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);
2098:
2099: UPDATE okc_k_lines_b okl
2100: SET okl.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2101: FROM ra_customer_merges rcm
2102: WHERE okl.bill_to_site_use_id = rcm.duplicate_site_id
2103: AND rcm.process_flag = 'N'