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 506: FROM okl_k_lines kle, okc_k_lines_b cle

502: -- SECHAWLA 09-AUG-05 4304230 : Modified to get line status
503: -- This cursor is used to get the residual value for an asset
504: CURSOR l_okllines_csr(p_kle_id IN NUMBER) IS
505: SELECT nvl(kle.residual_value,0), cle.sts_code
506: FROM okl_k_lines kle, okc_k_lines_b cle
507: WHERE kle.id = p_kle_id
508: AND kle.id = cle.id;
509:
510: l_asset_status VARCHAR2(30); -- SECHAWLA 09-AUG-05 4304230

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

2765: l_asset_ind NUMBER;
2766: --akrangan Bug 5495474 start
2767: l_orig_kle_id NUMBER;
2768: --cursor to check if financial asset appears as linked asset
2769: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS
2770: SELECT cim.object1_id1 kle_id -- original asset id
2771: FROM okc_k_lines_b lnk,
2772: okc_line_styles_b lnk_lse,
2773: okc_statuses_b sts,

Line 2771: FROM okc_k_lines_b lnk,

2767: l_orig_kle_id NUMBER;
2768: --cursor to check if financial asset appears as linked asset
2769: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS
2770: SELECT cim.object1_id1 kle_id -- original asset id
2771: FROM okc_k_lines_b lnk,
2772: okc_line_styles_b lnk_lse,
2773: okc_statuses_b sts,
2774: okc_k_items cim
2775: WHERE lnk.id = cim.cle_id

Line 3195: FROM okc_k_lines_b cle,

3191: cp_asset_id IN NUMBER,
3192: cp_fee_type IN VARCHAR2)
3193: IS
3194: SELECT '1'
3195: FROM okc_k_lines_b cle,
3196: okc_line_styles_b lse,
3197: okc_k_items cim,
3198: okc_k_lines_v clep,
3199: okc_line_styles_b lsep,

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

5028: --akrangan Bug 5655680 start --
5029: l_orig_kle_id NUMBER;
5030:
5031: --cursor to check if financial asset appears as linked asset
5032: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS
5033: Select cim.object1_id1 kle_id -- original asset id
5034: From okc_k_lines_b lnk,
5035: okc_line_styles_b lnk_lse,
5036: okc_statuses_b sts,

Line 5034: From okc_k_lines_b lnk,

5030:
5031: --cursor to check if financial asset appears as linked asset
5032: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS
5033: Select cim.object1_id1 kle_id -- original asset id
5034: From okc_k_lines_b lnk,
5035: okc_line_styles_b lnk_lse,
5036: okc_statuses_b sts,
5037: okc_k_items cim
5038: Where lnk.id = cim.cle_id

Line 6111: FROM okc_k_lines_b l,

6107: -- cursor to make sure all passed lines exist
6108: -- and have the correct line style
6109: CURSOR l_line_csr (cp_line_id NUMBER) IS
6110: SELECT 'Y'
6111: FROM okc_k_lines_b l,
6112: okc_line_styles_b s
6113: WHERE l.id = cp_line_id
6114: AND s.id = l.lse_id
6115: AND s.lty_code = G_FIN_ASSET_STYLE;