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

3320: SELECT '!'
3321: FROM okc_k_headers_b CHR
3322: WHERE CHR.ID = chrid AND CHR.orig_system_source_code = 'OKL_REBOOK';
3323:
3324: l_qte_id okl_k_lines.qte_id%TYPE;
3325: l_creditline_id okl_k_lines.qte_id%TYPE;
3326: x_rem_amt NUMBER;
3327: p_term_tbl okl_trx_quotes_pub.qtev_tbl_type;
3328: x_term_tbl okl_trx_quotes_pub.qtev_tbl_type;

Line 3325: l_creditline_id okl_k_lines.qte_id%TYPE;

3321: FROM okc_k_headers_b CHR
3322: WHERE CHR.ID = chrid AND CHR.orig_system_source_code = 'OKL_REBOOK';
3323:
3324: l_qte_id okl_k_lines.qte_id%TYPE;
3325: l_creditline_id okl_k_lines.qte_id%TYPE;
3326: x_rem_amt NUMBER;
3327: p_term_tbl okl_trx_quotes_pub.qtev_tbl_type;
3328: x_term_tbl okl_trx_quotes_pub.qtev_tbl_type;
3329: x_err_msg VARCHAR2 (1000);

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

3340: -- nikshah -- Bug # 5484903 Fixed,
3341: -- Changed CURSOR l_k_std_csr SQL definition
3342: CURSOR l_k_std_csr (chrid okc_k_headers_b.ID%TYPE) IS
3343: SELECT 1
3344: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3345: WHERE khr.ID = chrid
3346: AND cleb.dnz_chr_id = khr.ID
3347: AND kle.ID = cleb.ID
3348: AND kle.fee_type = 'ROLLOVER'

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

3363: -- nikshah -- Bug # 5484903 Fixed,
3364: -- Changed CURSOR l_k_std__4rbk_csr SQL definition
3365: CURSOR l_k_std__4rbk_csr (chrid okc_k_headers_b.ID%TYPE) IS
3366: SELECT 1
3367: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3368: WHERE khr.ID = chrid
3369: AND cleb.dnz_chr_id = khr.ID
3370: AND kle.ID = cleb.ID
3371: 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'