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 97: FROM okc_k_lines_b cleb,

93: -- cursor : to check whether Contract is having mixed asset or not
94: CURSOR l_chk_con_csr (chrid NUMBER) IS
95: SELECT COUNT (*)
96: FROM (SELECT COUNT(*)
97: FROM okc_k_lines_b cleb,
98: okl_k_lines kle
99: WHERE kle.id = cleb.id
100: AND cleb.chr_id = chrid
101: --ndani - 27-Mar-2013 - Bug# 16552978 - Start

Line 112: FROM okc_k_lines_b cleb,

108:
109: -- cursor : to check whether Contract is having re-lease assets
110: CURSOR l_con_rel_csr (chrid NUMBER) IS
111: SELECT DISTINCT NVL(kle.re_lease_yn,'N')
112: FROM okc_k_lines_b cleb,
113: okl_k_lines kle
114: WHERE kle.id = cleb.id
115: AND cleb.chr_id = chrid
116: --ndani - 27-Mar-2013 - Bug# 16552978 - Start

Line 744: FROM okc_k_lines_b cleb,

740: -- cursor : to check whether Contract is having mixed asset or not
741: CURSOR l_chk_con_csr (chrid NUMBER) IS
742: SELECT COUNT (*)
743: FROM (SELECT COUNT(*)
744: FROM okc_k_lines_b cleb,
745: okl_k_lines kle
746: WHERE kle.id = cleb.id
747: AND cleb.chr_id = chrid
748: --ndani - 27-Mar-2013 - Bug# 16552978 - Start

Line 759: FROM okc_k_lines_b cleb,

755:
756: -- cursor : to check whether Contract is having re-lease assets
757: CURSOR l_con_rel_csr (chrid NUMBER) IS
758: SELECT DISTINCT NVL(kle.re_lease_yn,'N')
759: FROM okc_k_lines_b cleb,
760: okl_k_lines kle
761: WHERE kle.id = cleb.id
762: AND cleb.chr_id = chrid
763: --ndani - 27-Mar-2013 - Bug# 16552978 - Start

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

1919:
1920: CURSOR l_svclne_csr (ltycode VARCHAR2, chrid okl_k_headers.khr_id%TYPE) IS
1921: SELECT cle.ID,
1922: cle.price_negotiated amount
1923: FROM okc_k_lines_b cle, okc_line_styles_b ls, okc_statuses_b sts
1924: WHERE cle.lse_id = ls.ID
1925: AND ls.lty_code = ltycode
1926: AND cle.dnz_chr_id = chrid
1927: AND sts.code = cle.sts_code

Line 2021: p_okl_free_form okc_k_lines_b.ID%TYPE,

2017:
2018: -- nikshah -- Bug # 5484903 Fixed,
2019: -- Changed CURSOR l_check_date_csr SQL definition
2020: CURSOR l_check_date_csr (
2021: p_okl_free_form okc_k_lines_b.ID%TYPE,
2022: p_oks_cov_prod okc_k_lines_b.ID%TYPE
2023: ) IS
2024: SELECT 'Y' y
2025: FROM DUAL

Line 2022: p_oks_cov_prod okc_k_lines_b.ID%TYPE

2018: -- nikshah -- Bug # 5484903 Fixed,
2019: -- Changed CURSOR l_check_date_csr SQL definition
2020: CURSOR l_check_date_csr (
2021: p_okl_free_form okc_k_lines_b.ID%TYPE,
2022: p_oks_cov_prod okc_k_lines_b.ID%TYPE
2023: ) IS
2024: SELECT 'Y' y
2025: FROM DUAL
2026: WHERE EXISTS (

Line 2061: p_okl_free_form okc_k_lines_b.ID%TYPE,

2057: --Bug# 3257597 : 11.5.10 OKS Rules Migration Impact
2058: -- nikshah -- Bug # 5484903 Fixed
2059: -- Changed CURSOR l_check_date_v10_csr SQL definition
2060: CURSOR l_check_date_v10_csr (
2061: p_okl_free_form okc_k_lines_b.ID%TYPE,
2062: p_oks_cov_prod okc_k_lines_b.ID%TYPE
2063: ) IS
2064: SELECT 'Y' y
2065: FROM DUAL

Line 2062: p_oks_cov_prod okc_k_lines_b.ID%TYPE

2058: -- nikshah -- Bug # 5484903 Fixed
2059: -- Changed CURSOR l_check_date_v10_csr SQL definition
2060: CURSOR l_check_date_v10_csr (
2061: p_okl_free_form okc_k_lines_b.ID%TYPE,
2062: p_oks_cov_prod okc_k_lines_b.ID%TYPE
2063: ) IS
2064: SELECT 'Y' y
2065: FROM DUAL
2066: WHERE EXISTS (

Line 2636: okc_k_lines_b fin_ast_cle,

2632: SELECT fin_ast_cle.ID asset_id,
2633: fab.asset_number asset_number,
2634: fab.current_units current_units
2635: FROM okl_txl_cntrct_lns tcl,
2636: okc_k_lines_b fin_ast_cle,
2637: okc_k_lines_b fa_cle,
2638: okc_line_styles_b fa_lse,
2639: okc_k_items cim,
2640: fa_additions_b fab

Line 2637: okc_k_lines_b fa_cle,

2633: fab.asset_number asset_number,
2634: fab.current_units current_units
2635: FROM okl_txl_cntrct_lns tcl,
2636: okc_k_lines_b fin_ast_cle,
2637: okc_k_lines_b fa_cle,
2638: okc_line_styles_b fa_lse,
2639: okc_k_items cim,
2640: fa_additions_b fab
2641: WHERE tcl.tcn_id = p_source_trx_id

Line 2658: FROM okc_k_lines_b fin_ast_cle,

2654: CURSOR chr_term_assets_csr (p_orig_chr_id IN NUMBER) IS
2655: SELECT fin_ast_cle.ID asset_id,
2656: fab.asset_number asset_number,
2657: fab.current_units current_units
2658: FROM okc_k_lines_b fin_ast_cle,
2659: okc_k_lines_b fa_cle,
2660: okc_k_headers_b CHR,
2661: okc_line_styles_b fin_ast_lse,
2662: okc_line_styles_b fa_lse,

Line 2659: okc_k_lines_b fa_cle,

2655: SELECT fin_ast_cle.ID asset_id,
2656: fab.asset_number asset_number,
2657: fab.current_units current_units
2658: FROM okc_k_lines_b fin_ast_cle,
2659: okc_k_lines_b fa_cle,
2660: okc_k_headers_b CHR,
2661: okc_line_styles_b fin_ast_lse,
2662: okc_line_styles_b fa_lse,
2663: okc_k_items cim,

Line 2685: FROM okl_txl_cntrct_lns tcl, okc_k_lines_b fin_ast_cle

2681: p_source_trx_id IN NUMBER
2682: ) IS
2683: SELECT fin_ast_cle.ID,
2684: fin_ast_cle.sts_code
2685: FROM okl_txl_cntrct_lns tcl, okc_k_lines_b fin_ast_cle
2686: WHERE tcl.tcn_id = p_source_trx_id
2687: AND tcl.before_transfer_yn = 'N'
2688: AND fin_ast_cle.chr_id = p_orig_chr_id
2689: AND fin_ast_cle.dnz_chr_id = p_orig_chr_id

Line 2743: FROM okc_k_lines_b fin_ast_cle, okc_line_styles_b fin_ast_lse

2739:
2740: --Bug# 4631549
2741: CURSOR off_lease_ast_csr (p_orig_chr_id IN NUMBER) IS
2742: SELECT fin_ast_cle.ID
2743: FROM okc_k_lines_b fin_ast_cle, okc_line_styles_b fin_ast_lse
2744: WHERE fin_ast_cle.chr_id = p_orig_chr_id
2745: AND fin_ast_cle.dnz_chr_id = p_orig_chr_id
2746: AND fin_ast_cle.lse_id = fin_ast_lse.ID
2747: AND fin_ast_lse.lty_code = 'FREE_FORM1'

Line 2755: FROM okc_k_lines_b fin_ast_cle,

2751: CURSOR chk_off_lease_csr (p_orig_chr_id IN NUMBER) IS
2752: SELECT tas.ID,
2753: tas.tsu_code,
2754: txl.hold_period_days
2755: FROM okc_k_lines_b fin_ast_cle,
2756: okc_line_styles_b fin_ast_lse,
2757: okl_trx_assets tas,
2758: okl_txl_assets_b txl
2759: WHERE fin_ast_cle.chr_id = p_orig_chr_id

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

3570: -- nikshah -- Bug # 5484903 Fixed,
3571: -- Changed l_rq_fee_lns_bkg_csr SQL definition
3572: CURSOR l_rq_fee_lns_bkg_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3573: SELECT kle.qte_id
3574: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
3575: WHERE khr.ID = chrid
3576: AND cleb.dnz_chr_id = khr.ID
3577: AND kle.ID = cleb.ID
3578: AND kle.fee_type = 'ROLLOVER'

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

3596: -- nikshah -- Bug # 5484903 Fixed
3597: -- Changed CURSOR l_rq_fee_lns_rbk_csr SQL definition
3598: CURSOR l_rq_fee_lns_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3599: SELECT kle.qte_id
3600: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
3601: WHERE khr.ID = chrid
3602: AND cleb.dnz_chr_id = khr.ID
3603: AND kle.ID = cleb.ID
3604: AND kle.fee_type = 'ROLLOVER'

Line 5318: FROM okc_k_lines_b cle, okl_k_lines kle

5314: l_upfront_tax_yn VARCHAR2 (1);
5315:
5316: CURSOR check_st_fee_csr (p_chr_id IN NUMBER) IS
5317: SELECT cle.ID
5318: FROM okc_k_lines_b cle, okl_k_lines kle
5319: WHERE cle.ID = kle.ID
5320: AND cle.dnz_chr_id = p_chr_id
5321: AND cle.chr_id = p_chr_id
5322: AND kle.fee_purpose_code = 'SALESTAX'

Line 5325: l_del_fee_line_id okc_k_lines_b.ID%TYPE;

5321: AND cle.chr_id = p_chr_id
5322: AND kle.fee_purpose_code = 'SALESTAX'
5323: AND cle.sts_code <> 'ABANDONED';
5324:
5325: l_del_fee_line_id okc_k_lines_b.ID%TYPE;
5326: l_del_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
5327: --Bug# 6512668
5328: BEGIN
5329: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN