APPS.OKL_AM_PROCESS_ASSET_TRX_PVT dependencies on OKX_ASSET_LINES_V

Line 308: FROM okl_trx_quotes_b qh, okl_txl_quote_lines_b ql, okx_asset_lines_v l

304:
305: -- This cursor is used to check if an accepted termination quote exists for an asset line.
306: CURSOR l_quotes_csr(p_kle_id IN NUMBER) IS
307: SELECT l.asset_number
308: FROM okl_trx_quotes_b qh, okl_txl_quote_lines_b ql, okx_asset_lines_v l
309: WHERE qh.id = ql.qte_id
310: AND qh.qst_code = 'ACCEPTED'
311: AND ql.qlt_code = 'AMCFIA'
312: AND ql.kle_id = l.parent_line_id