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.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 46: FROM okc_k_headers_all_b ch,

42: ch.currency_code),
43: fnd_currency.get_format_mask (ch.currency_code, 50)) ||
44: ' ' ||
45: ch.currency_code AS amount
46: FROM okc_k_headers_all_b ch,
47: oks_k_headers_b sh
48: WHERE ch.ID = sh.chr_id
49: AND ch.ID = p_chr_id;
50: BEGIN

Line 117: FROM okc_k_headers_all_b ch

113: ch.currency_code),
114: fnd_currency.get_format_mask (ch.currency_code, 50)) ||
115: ' ' ||
116: ch.currency_code AS amount
117: FROM okc_k_headers_all_b ch
118: WHERE ch.ID = p_chr_id;
119: BEGIN
120: -- start debug log
121: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 184: FROM okc_k_headers_all_b ch,

180: (NVL (sh.tax_amount, 0), ch.currency_code),
181: fnd_currency.get_format_mask (ch.currency_code, 50)) ||
182: ' ' ||
183: ch.currency_code AS amount
184: FROM okc_k_headers_all_b ch,
185: oks_k_headers_b sh
186: WHERE ch.ID = sh.chr_id
187: AND ch.ID = p_chr_id;
188:

Line 754: FROM okc_k_headers_all_b

750: l_organization_id NUMBER := '';
751:
752: CURSOR csr_k_organization IS
753: SELECT authoring_org_id
754: FROM okc_k_headers_all_b
755: WHERE ID = p_chr_id;
756: BEGIN
757: -- start debug log
758: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 821: FROM okc_k_headers_all_b khr,

817: l_salesrep_email VARCHAR2 (1000) := '';
818:
819: CURSOR csr_k_salesrep IS
820: SELECT res.resource_name AS salesrep_name
821: FROM okc_k_headers_all_b khr,
822: okc_contacts ct,
823: jtf_rs_salesreps srp,
824: jtf_rs_resource_extns_vl res
825: WHERE khr.ID = ct.dnz_chr_id

Line 1105: FROM okc_k_headers_all_b kc

1101: NULL, NULL,
1102: '-'
1103: ) ||
1104: kc.contract_number_modifier AS contract_number
1105: FROM okc_k_headers_all_b kc
1106: WHERE kc.ID = p_chr_id;
1107: BEGIN
1108: -- start debug log
1109: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 1461: FROM okc_k_headers_all_b k,

1457: CURSOR csr_currency_tip IS
1458: SELECT k.currency_code ||
1459: ' = ' ||
1460: f.NAME
1461: FROM okc_k_headers_all_b k,
1462: fnd_currencies_tl f
1463: WHERE k.currency_code = f.currency_code
1464: AND f.LANGUAGE = USERENV ('LANG')
1465: AND k.ID = p_chr_id;

Line 1822: FROM okc_k_headers_all_b okc,

1818: x_rnrl_rec oks_renew_util_pvt.rnrl_rec_type;
1819:
1820: CURSOR csr_billing_address_id IS
1821: SELECT st.party_site_id
1822: FROM okc_k_headers_all_b okc,
1823: hz_cust_site_uses_all su,
1824: hz_cust_acct_sites_all sa,
1825: hz_party_sites st
1826: WHERE okc.bill_to_site_use_id = su.site_use_id

Line 2135: UPDATE okc_k_headers_all_b

2131: last_updated_by = fnd_global.user_id,
2132: last_update_login = fnd_global.login_id
2133: WHERE chr_id = p_chr_id;
2134:
2135: UPDATE okc_k_headers_all_b
2136: SET cust_po_number = NULL,
2137: payment_instruction_type = NULL,
2138: cust_po_number_req_yn = 'N',
2139: payment_term_id =

Line 2159: UPDATE okc_k_headers_all_b

2155: last_updated_by = fnd_global.user_id,
2156: last_update_login = fnd_global.login_id
2157: WHERE chr_id = p_chr_id;
2158:
2159: UPDATE okc_k_headers_all_b
2160: SET cust_po_number = NULL,
2161: payment_instruction_type = NULL,
2162: cust_po_number_req_yn = 'N',
2163: object_version_number = object_version_number +

Line 2181: UPDATE okc_k_headers_all_b

2177: last_updated_by = fnd_global.user_id,
2178: last_update_login = fnd_global.login_id
2179: WHERE chr_id = p_chr_id;
2180:
2181: UPDATE okc_k_headers_all_b
2182: SET cust_po_number = p_payment_details,
2183: payment_instruction_type = p_payment_type,
2184: object_version_number = object_version_number +
2185: 1,

Line 2484: l_curr_instrument okc_k_headers_all_b.payment_instruction_type%TYPE

2480: l_rnrl_rec oks_renew_util_pvt.rnrl_rec_type;
2481: x_rnrl_rec oks_renew_util_pvt.rnrl_rec_type;
2482: l_k_amount NUMBER (15, 2);
2483: l_k_curr VARCHAR2 (100);
2484: l_curr_instrument okc_k_headers_all_b.payment_instruction_type%TYPE
2485: := '';
2486: l_curr_payment oks_k_headers_b.payment_type%TYPE
2487: := '';
2488: l_k_current_payments VARCHAR2 (2000) := '';

Line 2495: FROM okc_k_headers_all_b ch,

2491: SELECT (NVL (ch.estimated_amount, 0) + NVL (sh.tax_amount, 0) ) AS amount,
2492: ch.currency_code AS currency_code,
2493: ch.payment_instruction_type AS instrument_type,
2494: sh.payment_type AS payment_type
2495: FROM okc_k_headers_all_b ch,
2496: oks_k_headers_b sh
2497: WHERE ch.ID = sh.chr_id
2498: AND ch.ID = p_chr_id;
2499:

Line 3598: FROM okc_k_headers_all_b khr,

3594:
3595: CURSOR csr_k_salesrep IS
3596: SELECT srp.email_address AS email_address,
3597: res.user_name AS username
3598: FROM okc_k_headers_all_b khr,
3599: okc_contacts ct,
3600: jtf_rs_salesreps srp,
3601: jtf_rs_resource_extns res
3602: WHERE khr.ID = ct.dnz_chr_id

Line 3809: FROM okc_k_headers_all_b okc,

3805: CURSOR csr_old_txn_id IS
3806: SELECT oks.trxn_extension_id,
3807: ca.cust_account_id,
3808: ca.party_id
3809: FROM okc_k_headers_all_b okc,
3810: oks_k_headers_b oks,
3811: hz_cust_site_uses_all su,
3812: hz_cust_acct_sites_all sa,
3813: hz_cust_accounts_all ca