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 992: OKC_K_LINES_V KLE

988: TQL.id tql_id,
989: TQL.quote_quantity quote_quantity,
990: TQL.asset_quantity asset_quantity
991: FROM OKL_TXL_QUOTE_LINES_V TQL,
992: OKC_K_LINES_V KLE
993: WHERE TQL.qte_id = p_qte_id
994: AND TQL.qlt_code = 'AMCFIA'
995: AND TQL.kle_id = KLE.id;
996:

Line 4152: OKC_K_LINES_V cle,

4148: tql.quote_quantity,
4149: cle.name,
4150: cle.chr_id -- RMUNJULU 24-JAN-03 2759726 Added
4151: FROM OKL_TXL_QUOTE_LINES_B tql,
4152: OKC_K_LINES_V cle,
4153: OKC_LINE_STYLES_B lse
4154: WHERE tql.id = P_tql_id
4155: AND tql.qlt_code = 'AMCFIA'
4156: AND tql.kle_id = cle.id