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.OKL_CONTRACT_BOOK_PVT dependencies on OKC_K_LINES_B

Line 1619: FROM okc_k_lines_b cle, okc_line_styles_b ls, okc_statuses_b sts

1615:
1616: CURSOR l_svclne_csr (ltycode VARCHAR2, chrid okl_k_headers.khr_id%TYPE) IS
1617: SELECT cle.ID,
1618: cle.price_negotiated amount
1619: FROM okc_k_lines_b cle, okc_line_styles_b ls, okc_statuses_b sts
1620: WHERE cle.lse_id = ls.ID
1621: AND ls.lty_code = ltycode
1622: AND cle.dnz_chr_id = chrid
1623: AND sts.code = cle.sts_code

Line 1717: p_okl_free_form okc_k_lines_b.ID%TYPE,

1713:
1714: -- nikshah -- Bug # 5484903 Fixed,
1715: -- Changed CURSOR l_check_date_csr SQL definition
1716: CURSOR l_check_date_csr (
1717: p_okl_free_form okc_k_lines_b.ID%TYPE,
1718: p_oks_cov_prod okc_k_lines_b.ID%TYPE
1719: ) IS
1720: SELECT 'Y' y
1721: FROM DUAL

Line 1718: p_oks_cov_prod okc_k_lines_b.ID%TYPE

1714: -- nikshah -- Bug # 5484903 Fixed,
1715: -- Changed CURSOR l_check_date_csr SQL definition
1716: CURSOR l_check_date_csr (
1717: p_okl_free_form okc_k_lines_b.ID%TYPE,
1718: p_oks_cov_prod okc_k_lines_b.ID%TYPE
1719: ) IS
1720: SELECT 'Y' y
1721: FROM DUAL
1722: WHERE EXISTS (

Line 1757: p_okl_free_form okc_k_lines_b.ID%TYPE,

1753: --Bug# 3257597 : 11.5.10 OKS Rules Migration Impact
1754: -- nikshah -- Bug # 5484903 Fixed
1755: -- Changed CURSOR l_check_date_v10_csr SQL definition
1756: CURSOR l_check_date_v10_csr (
1757: p_okl_free_form okc_k_lines_b.ID%TYPE,
1758: p_oks_cov_prod okc_k_lines_b.ID%TYPE
1759: ) IS
1760: SELECT 'Y' y
1761: FROM DUAL

Line 1758: p_oks_cov_prod okc_k_lines_b.ID%TYPE

1754: -- nikshah -- Bug # 5484903 Fixed
1755: -- Changed CURSOR l_check_date_v10_csr SQL definition
1756: CURSOR l_check_date_v10_csr (
1757: p_okl_free_form okc_k_lines_b.ID%TYPE,
1758: p_oks_cov_prod okc_k_lines_b.ID%TYPE
1759: ) IS
1760: SELECT 'Y' y
1761: FROM DUAL
1762: WHERE EXISTS (

Line 2333: okc_k_lines_b fin_ast_cle,

2329: SELECT fin_ast_cle.ID asset_id,
2330: fab.asset_number asset_number,
2331: fab.current_units current_units
2332: FROM okl_txl_cntrct_lns tcl,
2333: okc_k_lines_b fin_ast_cle,
2334: okc_k_lines_b fa_cle,
2335: okc_line_styles_b fa_lse,
2336: okc_k_items cim,
2337: fa_additions_b fab

Line 2334: okc_k_lines_b fa_cle,

2330: fab.asset_number asset_number,
2331: fab.current_units current_units
2332: FROM okl_txl_cntrct_lns tcl,
2333: okc_k_lines_b fin_ast_cle,
2334: okc_k_lines_b fa_cle,
2335: okc_line_styles_b fa_lse,
2336: okc_k_items cim,
2337: fa_additions_b fab
2338: WHERE tcl.tcn_id = p_source_trx_id

Line 2355: FROM okc_k_lines_b fin_ast_cle,

2351: CURSOR chr_term_assets_csr (p_orig_chr_id IN NUMBER) IS
2352: SELECT fin_ast_cle.ID asset_id,
2353: fab.asset_number asset_number,
2354: fab.current_units current_units
2355: FROM okc_k_lines_b fin_ast_cle,
2356: okc_k_lines_b fa_cle,
2357: okc_k_headers_b CHR,
2358: okc_line_styles_b fin_ast_lse,
2359: okc_line_styles_b fa_lse,

Line 2356: okc_k_lines_b fa_cle,

2352: SELECT fin_ast_cle.ID asset_id,
2353: fab.asset_number asset_number,
2354: fab.current_units current_units
2355: FROM okc_k_lines_b fin_ast_cle,
2356: okc_k_lines_b fa_cle,
2357: okc_k_headers_b CHR,
2358: okc_line_styles_b fin_ast_lse,
2359: okc_line_styles_b fa_lse,
2360: okc_k_items cim,

Line 2382: FROM okl_txl_cntrct_lns tcl, okc_k_lines_b fin_ast_cle

2378: p_source_trx_id IN NUMBER
2379: ) IS
2380: SELECT fin_ast_cle.ID,
2381: fin_ast_cle.sts_code
2382: FROM okl_txl_cntrct_lns tcl, okc_k_lines_b fin_ast_cle
2383: WHERE tcl.tcn_id = p_source_trx_id
2384: AND tcl.before_transfer_yn = 'N'
2385: AND fin_ast_cle.chr_id = p_orig_chr_id
2386: AND fin_ast_cle.dnz_chr_id = p_orig_chr_id

Line 2440: FROM okc_k_lines_b fin_ast_cle, okc_line_styles_b fin_ast_lse

2436:
2437: --Bug# 4631549
2438: CURSOR off_lease_ast_csr (p_orig_chr_id IN NUMBER) IS
2439: SELECT fin_ast_cle.ID
2440: FROM okc_k_lines_b fin_ast_cle, okc_line_styles_b fin_ast_lse
2441: WHERE fin_ast_cle.chr_id = p_orig_chr_id
2442: AND fin_ast_cle.dnz_chr_id = p_orig_chr_id
2443: AND fin_ast_cle.lse_id = fin_ast_lse.ID
2444: AND fin_ast_lse.lty_code = 'FREE_FORM1'

Line 2452: FROM okc_k_lines_b fin_ast_cle,

2448: CURSOR chk_off_lease_csr (p_orig_chr_id IN NUMBER) IS
2449: SELECT tas.ID,
2450: tas.tsu_code,
2451: txl.hold_period_days
2452: FROM okc_k_lines_b fin_ast_cle,
2453: okc_line_styles_b fin_ast_lse,
2454: okl_trx_assets tas,
2455: okl_txl_assets_b txl
2456: WHERE fin_ast_cle.chr_id = p_orig_chr_id

Line 3271: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle

3267: -- nikshah -- Bug # 5484903 Fixed,
3268: -- Changed l_rq_fee_lns_bkg_csr SQL definition
3269: CURSOR l_rq_fee_lns_bkg_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3270: SELECT kle.qte_id
3271: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
3272: WHERE khr.ID = chrid
3273: AND cleb.dnz_chr_id = khr.ID
3274: AND kle.ID = cleb.ID
3275: AND kle.fee_type = 'ROLLOVER'

Line 3297: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle

3293: -- nikshah -- Bug # 5484903 Fixed
3294: -- Changed CURSOR l_rq_fee_lns_rbk_csr SQL definition
3295: CURSOR l_rq_fee_lns_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3296: SELECT kle.qte_id
3297: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
3298: WHERE khr.ID = chrid
3299: AND cleb.dnz_chr_id = khr.ID
3300: AND kle.ID = cleb.ID
3301: AND kle.fee_type = 'ROLLOVER'

Line 4850: FROM okc_k_lines_b cle, okl_k_lines kle

4846: l_upfront_tax_yn VARCHAR2 (1);
4847:
4848: CURSOR check_st_fee_csr (p_chr_id IN NUMBER) IS
4849: SELECT cle.ID
4850: FROM okc_k_lines_b cle, okl_k_lines kle
4851: WHERE cle.ID = kle.ID
4852: AND cle.dnz_chr_id = p_chr_id
4853: AND cle.chr_id = p_chr_id
4854: AND kle.fee_purpose_code = 'SALESTAX'

Line 4857: l_del_fee_line_id okc_k_lines_b.ID%TYPE;

4853: AND cle.chr_id = p_chr_id
4854: AND kle.fee_purpose_code = 'SALESTAX'
4855: AND cle.sts_code <> 'ABANDONED';
4856:
4857: l_del_fee_line_id okc_k_lines_b.ID%TYPE;
4858: l_del_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
4859: --Bug# 6512668
4860: BEGIN
4861: x_process_status := okl_api.g_ret_sts_success;