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_AM_CALCULATE_QUOTE_PVT dependencies on OKC_K_LINES_B

Line 547: FROM okl_k_lines kle, okc_k_lines_b cle

543: -- SECHAWLA 09-AUG-05 4304230 : Modified to get line status
544: -- This cursor is used to get the residual value for an asset
545: CURSOR l_okllines_csr(p_kle_id IN NUMBER) IS
546: SELECT nvl(kle.residual_value,0), cle.sts_code
547: FROM okl_k_lines kle, okc_k_lines_b cle
548: WHERE kle.id = p_kle_id
549: AND kle.id = cle.id;
550:
551: l_asset_status VARCHAR2(30); -- SECHAWLA 09-AUG-05 4304230

Line 2816: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS

2812: l_asset_ind NUMBER;
2813: --akrangan Bug 5495474 start
2814: l_orig_kle_id NUMBER;
2815: --cursor to check if financial asset appears as linked asset
2816: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS
2817: SELECT cim.object1_id1 kle_id -- original asset id
2818: FROM okc_k_lines_b lnk,
2819: okc_line_styles_b lnk_lse,
2820: okc_statuses_b sts,

Line 2818: FROM okc_k_lines_b lnk,

2814: l_orig_kle_id NUMBER;
2815: --cursor to check if financial asset appears as linked asset
2816: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS
2817: SELECT cim.object1_id1 kle_id -- original asset id
2818: FROM okc_k_lines_b lnk,
2819: okc_line_styles_b lnk_lse,
2820: okc_statuses_b sts,
2821: okc_k_items cim
2822: WHERE lnk.id = cim.cle_id

Line 3242: FROM okc_k_lines_b cle,

3238: cp_asset_id IN NUMBER,
3239: cp_fee_type IN VARCHAR2)
3240: IS
3241: SELECT '1'
3242: FROM okc_k_lines_b cle,
3243: okc_line_styles_b lse,
3244: okc_k_items cim,
3245: okc_k_lines_v clep,
3246: okc_line_styles_b lsep,

Line 5151: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS

5147: --akrangan Bug 5655680 start --
5148: l_orig_kle_id NUMBER;
5149:
5150: --cursor to check if financial asset appears as linked asset
5151: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS
5152: Select cim.object1_id1 kle_id -- original asset id
5153: From okc_k_lines_b lnk,
5154: okc_line_styles_b lnk_lse,
5155: okc_statuses_b sts,

Line 5153: From okc_k_lines_b lnk,

5149:
5150: --cursor to check if financial asset appears as linked asset
5151: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS
5152: Select cim.object1_id1 kle_id -- original asset id
5153: From okc_k_lines_b lnk,
5154: okc_line_styles_b lnk_lse,
5155: okc_statuses_b sts,
5156: okc_k_items cim
5157: Where lnk.id = cim.cle_id

Line 6230: FROM okc_k_lines_b l,

6226: -- cursor to make sure all passed lines exist
6227: -- and have the correct line style
6228: CURSOR l_line_csr (cp_line_id NUMBER) IS
6229: SELECT 'Y'
6230: FROM okc_k_lines_b l,
6231: okc_line_styles_b s
6232: WHERE l.id = cp_line_id
6233: AND s.id = l.lse_id
6234: AND s.lty_code = G_FIN_ASSET_STYLE;