DBA Data[Home] [Help]

APPS.OKL_AM_CALCULATE_QUOTE_PVT dependencies on OKL_K_LINES

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 3247: OKL_K_LINES kle

3243: okc_line_styles_b lse,
3244: okc_k_items cim,
3245: okc_k_lines_v clep,
3246: okc_line_styles_b lsep,
3247: OKL_K_LINES kle
3248: WHERE cle.lse_id = lse.id
3249: AND lse.lty_code = 'LINK_FEE_ASSET'
3250: AND cim.cle_id = cle.id
3251: AND cle.cle_id = clep.id