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_DEAL_CREAT_PVT dependencies on OKL_K_LINES

Line 6684: okl_k_lines kle

6680: FROM okc_k_headers_b CHR
6681: WHERE EXISTS (SELECT 1
6682: FROM okc_line_styles_b lse,
6683: okc_k_lines_b cle,
6684: okl_k_lines kle
6685: WHERE cle.dnz_chr_id = CHR.id
6686: AND cle.lse_id = lse.id
6687: AND cle.id = kle.id
6688: -- START: cklee/mvasudev,10/14/2005,bug#4300891 - (okl.g Bug#4307723)

Line 6712: okl_k_lines kle

6708: CURSOR get_fin_ast_csr IS
6709: SELECT cle.id
6710: FROM okc_line_styles_b lse,
6711: okc_k_lines_b cle,
6712: okl_k_lines kle
6713: WHERE cle.dnz_chr_id = p_durv_rec.chr_id
6714: AND cle.lse_id = lse.id
6715: AND cle.id = kle.id
6716: AND lse.lty_code = 'FREE_FORM1';

Line 9350: FROM okl_k_lines kle,

9346: WHERE ID = p_chr_id;
9347:
9348: CURSOR c_residual_amt(p_chr_id NUMBER) IS
9349: SELECT SUM(kle.residual_value) total_residual_amount
9350: FROM okl_k_lines kle,
9351: okc_k_lines_b cleb
9352: WHERE cleb.dnz_chr_id = p_chr_id
9353: AND cleb.chr_id = p_chr_id
9354: AND kle.id = cleb.id;

Line 9377: okl_k_lines kle,

9373:
9374: CURSOR c_rvi_premium(p_chr_id NUMBER) IS
9375: SELECT kle.amount rvi_premium
9376: FROM okc_k_lines_b cleb,
9377: okl_k_lines kle,
9378: okc_line_styles_b lseb
9379: WHERE cleb.dnz_chr_id = p_chr_id
9380: AND cleb.chr_id = p_chr_id
9381: AND kle.id = cleb.id