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_HEADERS_B

Line 299: -- okc_k_headers_b also

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
303: from okc_rules_b

Line 308: from okc_k_headers_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)
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

Line 319: -- okc_k_headers_b also

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
323: where okr1.object1_id1 in (

Line 342: from okc_k_headers_b where id = b_chr_id)

338: and okr3.rule_information_category IN ('BTO', 'STO')
339: union
340: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V
341: where id1 IN (select bill_to_site_use_id
342: from okc_k_headers_b where id = b_chr_id)
343: and party_id = l_source_party_id
344: and SITE_USE_CODE = 'BILL_TO')
345: union
346: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

Line 348: from okc_k_headers_b where id = b_chr_id )

344: and SITE_USE_CODE = 'BILL_TO')
345: union
346: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V
347: where id1 IN (select ship_to_site_use_id
348: from okc_k_headers_b where id = b_chr_id )
349: and party_id =l_source_party_id
350: and SITE_USE_CODE = 'SHIP_TO')
351: union
352: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

Line 372: from okc_k_headers_b where id = b_chr_id )

368: and party_id =l_source_party_id)
369: union
370: (select to_char(cust_account_id) from hz_cust_accounts
371: where cust_account_id IN (select cust_acct_id
372: from okc_k_headers_b where id = b_chr_id )
373: -- Changes for Bug# 6861077 Ends
374: and party_id =l_source_party_id));
375:
376: --

Line 381: FROM okc_k_headers_b

377: -- cursor to get the contract number and modifier for log purpose
378: --
379: CURSOR c_header_info (b_chr_id NUMBER) IS
380: SELECT contract_number, contract_number_modifier
381: FROM okc_k_headers_b
382: WHERE id=b_chr_id;
383:
384: CURSOR c_party_id_log(b_chr_id NUMBER) IS
385: SELECT kpr.id

Line 397: l_contract_number okc_k_headers_b.contract_number%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);
400: l_error_msg VARCHAR2(2000);
401: l_log_party_id NUMBER;

Line 398: l_contract_number_modifier okc_k_headers_b.contract_number_modifier%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);
400: l_error_msg VARCHAR2(2000);
401: l_log_party_id NUMBER;
402:

Line 912: -- Updating okc_k_headers_b

908: arp_message.set_name('AR','AR_ROWS_UPDATED');
909: arp_message.set_token('NUM_ROWS',to_char(l_count));
910:
911: -- Start:Code added for Bug 3555739
912: -- Updating okc_k_headers_b
913: -- Cust_Acct_Id
914: -- Insert into log table
915: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
916: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 931: 'OKC_K_HEADERS_B',

927: LAST_UPDATE_LOGIN,
928: LAST_UPDATE_DATE,
929: LAST_UPDATED_BY
930: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
931: 'OKC_K_HEADERS_B',
932: CUSTOMER_MERGE_HEADER_ID,
933: okh.ID,
934: to_char(okh.cust_acct_id),
935: to_char(rcm.customer_id),

Line 943: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

939: hz_utility_pub.CREATION_DATE,
940: hz_utility_pub.LAST_UPDATE_LOGIN,
941: hz_utility_pub.LAST_UPDATE_DATE,
942: hz_utility_pub.LAST_UPDATED_BY
943: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
944: WHERE (
945: okh.cust_acct_id = rcm.duplicate_id
946: ) AND rcm.process_flag = 'N'
947: AND rcm.request_id = req_id

Line 958: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.CUST_ACCT_ID',FALSE);

954:
955: End If;
956:
957: arp_message.set_name('AR','AR_UPDATING_TABLE');
958: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.CUST_ACCT_ID',FALSE);
959:
960: UPDATE okc_k_headers_b okh
961: SET okh.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
962: FROM ra_customer_merges rcm

Line 960: UPDATE okc_k_headers_b okh

956:
957: arp_message.set_name('AR','AR_UPDATING_TABLE');
958: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.CUST_ACCT_ID',FALSE);
959:
960: UPDATE okc_k_headers_b okh
961: SET okh.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
962: FROM ra_customer_merges rcm
963: WHERE okh.cust_acct_id = rcm.duplicate_id
964: AND rcm.process_flag = 'N'

Line 1942: -- Updating okc_k_headers_b

1938: arp_message.set_name('AR','AR_ROWS_UPDATED');
1939: arp_message.set_token('NUM_ROWS',to_char(l_count));
1940:
1941: -- Start:Code added for Bug 3555739
1942: -- Updating okc_k_headers_b
1943: -- Ship_to_site_use_id
1944: -- Insert into log table
1945: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1946: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1961: 'OKC_K_HEADERS_B',

1957: LAST_UPDATE_LOGIN,
1958: LAST_UPDATE_DATE,
1959: LAST_UPDATED_BY
1960: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1961: 'OKC_K_HEADERS_B',
1962: CUSTOMER_MERGE_HEADER_ID,
1963: okh.ID,
1964: to_char(okh.ship_to_site_use_id),
1965: to_char(rcm.customer_site_id),

Line 1973: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

1969: hz_utility_pub.CREATION_DATE,
1970: hz_utility_pub.LAST_UPDATE_LOGIN,
1971: hz_utility_pub.LAST_UPDATE_DATE,
1972: hz_utility_pub.LAST_UPDATED_BY
1973: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1974: WHERE (
1975: okh.ship_to_site_use_id = rcm.duplicate_site_id
1976: ) AND rcm.process_flag = 'N'
1977: AND rcm.request_id = req_id

Line 1988: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.SHIP_TO_SITE_USE_ID',FALSE);

1984:
1985: End If;
1986:
1987: arp_message.set_name('AR','AR_UPDATING_TABLE');
1988: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.SHIP_TO_SITE_USE_ID',FALSE);
1989:
1990: UPDATE okc_k_headers_b okh
1991: SET okh.ship_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
1992: FROM ra_customer_merges rcm

Line 1990: UPDATE okc_k_headers_b okh

1986:
1987: arp_message.set_name('AR','AR_UPDATING_TABLE');
1988: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.SHIP_TO_SITE_USE_ID',FALSE);
1989:
1990: UPDATE okc_k_headers_b okh
1991: SET okh.ship_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
1992: FROM ra_customer_merges rcm
1993: WHERE okh.ship_to_site_use_id = rcm.duplicate_site_id
1994: AND rcm.process_flag = 'N'

Line 2012: -- Updating okc_k_headers_b

2008: arp_message.set_name('AR','AR_ROWS_UPDATED');
2009: arp_message.set_token('NUM_ROWS',to_char(l_count));
2010:
2011:
2012: -- Updating okc_k_headers_b
2013: -- Bill_to_site_use_id
2014: -- Insert into log table
2015: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2016: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 2031: 'OKC_K_HEADERS_B',

2027: LAST_UPDATE_LOGIN,
2028: LAST_UPDATE_DATE,
2029: LAST_UPDATED_BY
2030: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2031: 'OKC_K_HEADERS_B',
2032: CUSTOMER_MERGE_HEADER_ID,
2033: okh.ID,
2034: to_char(okh.bill_to_site_use_id),
2035: to_char(rcm.customer_site_id),

Line 2043: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

2039: hz_utility_pub.CREATION_DATE,
2040: hz_utility_pub.LAST_UPDATE_LOGIN,
2041: hz_utility_pub.LAST_UPDATE_DATE,
2042: hz_utility_pub.LAST_UPDATED_BY
2043: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
2044: WHERE (
2045: okh.bill_to_site_use_id = rcm.duplicate_site_id
2046: ) AND rcm.process_flag = 'N'
2047: AND rcm.request_id = req_id

Line 2060: UPDATE okc_k_headers_b okh

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
2063: WHERE okh.bill_to_site_use_id = rcm.duplicate_site_id
2064: AND rcm.process_flag = 'N'