APPS.OKL_AM_CREATE_QUOTE_PVT dependencies on OKC_K_LINES_V

Line 57: FROM okc_k_lines_v kle,

53: --Updated the sql statement for performance issue #5484903
54: -- by excluding UPPER function to do Index scan
55: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS
56: SELECT 'Y' a
57: FROM okc_k_lines_v kle,
58: okc_line_styles_b lse
59: WHERE kle.lse_id = lse.id
60: AND lse.lty_code = 'FREE_FORM1'
61: AND UPPER(kle.NAME) = p_asset_number -- RMUNJULU 3241502

Line 3079: FROM OKC_K_LINES_V OKLV,

3075: -- GKADARKA 06-JAN-03 2683876 Added code to check for non terminated assets
3076: -- RMUNJULU 18-FEB-03 2804703 Changed cursor to check for active lines only
3077: CURSOR cur_k_assets ( p_chr_id NUMBER ) IS
3078: SELECT COUNT(OKLV.id )
3079: FROM OKC_K_LINES_V OKLV,
3080: OKC_LINE_STYLES_V OLSV,
3081: OKC_K_HEADERS_V KHR
3082: WHERE OKLV.lse_id = OLSV.id
3083: AND OLSV.lty_code = 'FREE_FORM1'