APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKC_K_LINES_V

Line 248: FROM okc_k_lines_v kle

244:
245: -- Get asset number for line id
246: CURSOR get_asset_number_csr (p_line_id IN NUMBER) IS
247: SELECT kle.name asset_number
248: FROM okc_k_lines_v kle
249: WHERE kle.id = p_line_id;
250:
251: l_return_status VARCHAR2(3);
252:

Line 980: OKC_K_LINES_V KLE

976: TQL.id tql_id,
977: TQL.quote_quantity quote_quantity,
978: TQL.asset_quantity asset_quantity
979: FROM OKL_TXL_QUOTE_LINES_V TQL,
980: OKC_K_LINES_V KLE
981: WHERE TQL.qte_id = p_qte_id
982: AND TQL.qlt_code = 'AMCFIA'
983: AND TQL.kle_id = KLE.id;
984:

Line 3942: OKC_K_LINES_V cle,

3938: tql.quote_quantity,
3939: cle.name,
3940: cle.chr_id -- RMUNJULU 24-JAN-03 2759726 Added
3941: FROM OKL_TXL_QUOTE_LINES_B tql,
3942: OKC_K_LINES_V cle,
3943: OKC_LINE_STYLES_B lse
3944: WHERE tql.id = P_tql_id
3945: AND tql.qlt_code = 'AMCFIA'
3946: AND tql.kle_id = cle.id