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 OKL_K_LINES

Line 98: okl_k_lines kle

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
102: AND cleb.dnz_chr_id = chrid

Line 113: okl_k_lines kle

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
117: AND cleb.dnz_chr_id = chrid

Line 124: l_con_rel_flag okl_k_lines.re_lease_yn%TYPE;

120: --ndani - 27-Mar-2013 - Bug# 16552978 - End
121:
122:
123: l_chk_contract_count NUMBER := 0;
124: l_con_rel_flag okl_k_lines.re_lease_yn%TYPE;
125:
126:
127: BEGIN
128:

Line 745: okl_k_lines kle

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
749: AND cleb.dnz_chr_id = chrid

Line 760: okl_k_lines kle

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
764: AND cleb.dnz_chr_id = chrid

Line 771: l_con_rel_flag okl_k_lines.re_lease_yn%TYPE;

767: --ndani - 27-Mar-2013 - Bug# 16552978 - End
768:
769:
770: l_chk_contract_count NUMBER := 0;
771: l_con_rel_flag okl_k_lines.re_lease_yn%TYPE;
772: l_acct_trans_type VARCHAR2 (256);
773: l_acc_call_rel_flag VARCHAR2 (1) := 'N';
774:
775: --Bug# 15992711 , End

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 3627: l_qte_id okl_k_lines.qte_id%TYPE;

3623: SELECT '!'
3624: FROM okc_k_headers_b CHR
3625: WHERE CHR.ID = chrid AND CHR.orig_system_source_code = 'OKL_REBOOK';
3626:
3627: l_qte_id okl_k_lines.qte_id%TYPE;
3628: l_creditline_id okl_k_lines.qte_id%TYPE;
3629: x_rem_amt NUMBER;
3630: p_term_tbl okl_trx_quotes_pub.qtev_tbl_type;
3631: x_term_tbl okl_trx_quotes_pub.qtev_tbl_type;

Line 3628: l_creditline_id okl_k_lines.qte_id%TYPE;

3624: FROM okc_k_headers_b CHR
3625: WHERE CHR.ID = chrid AND CHR.orig_system_source_code = 'OKL_REBOOK';
3626:
3627: l_qte_id okl_k_lines.qte_id%TYPE;
3628: l_creditline_id okl_k_lines.qte_id%TYPE;
3629: x_rem_amt NUMBER;
3630: p_term_tbl okl_trx_quotes_pub.qtev_tbl_type;
3631: x_term_tbl okl_trx_quotes_pub.qtev_tbl_type;
3632: x_err_msg VARCHAR2 (1000);

Line 3647: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr

3643: -- nikshah -- Bug # 5484903 Fixed,
3644: -- Changed CURSOR l_k_std_csr SQL definition
3645: CURSOR l_k_std_csr (chrid okc_k_headers_b.ID%TYPE) IS
3646: SELECT 1
3647: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3648: WHERE khr.ID = chrid
3649: AND cleb.dnz_chr_id = khr.ID
3650: AND kle.ID = cleb.ID
3651: AND kle.fee_type = 'ROLLOVER'

Line 3670: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr

3666: -- nikshah -- Bug # 5484903 Fixed,
3667: -- Changed CURSOR l_k_std__4rbk_csr SQL definition
3668: CURSOR l_k_std__4rbk_csr (chrid okc_k_headers_b.ID%TYPE) IS
3669: SELECT 1
3670: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3671: WHERE khr.ID = chrid
3672: AND cleb.dnz_chr_id = khr.ID
3673: AND kle.ID = cleb.ID
3674: 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'