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 1462: FROM okc_k_headers_all_b k,

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

Line 1823: FROM okc_k_headers_all_b okc,

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

Line 2136: UPDATE okc_k_headers_all_b

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

Line 2160: UPDATE okc_k_headers_all_b

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

Line 2182: UPDATE okc_k_headers_all_b

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

Line 2486: l_curr_instrument okc_k_headers_all_b.payment_instruction_type%TYPE

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

Line 2497: FROM okc_k_headers_all_b ch,

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

Line 3646: FROM okc_k_headers_all_b khr,

3642:
3643: CURSOR csr_k_salesrep IS
3644: SELECT srp.email_address AS email_address,
3645: res.user_name AS username
3646: FROM okc_k_headers_all_b khr,
3647: okc_contacts ct,
3648: jtf_rs_salesreps srp,
3649: jtf_rs_resource_extns res
3650: WHERE khr.ID = ct.dnz_chr_id

Line 3857: FROM okc_k_headers_all_b okc,

3853: CURSOR csr_old_txn_id IS
3854: SELECT oks.trxn_extension_id,
3855: ca.cust_account_id,
3856: ca.party_id
3857: FROM okc_k_headers_all_b okc,
3858: oks_k_headers_b oks,
3859: hz_cust_site_uses_all su,
3860: hz_cust_acct_sites_all sa,
3861: hz_cust_accounts_all ca