DBA Data[Home] [Help]

APPS.OKL_AM_RV_WRITEDOWN_PVT dependencies on OKL_TRX_QUOTES_B

Line 93: FROM okl_trx_quotes_b qh, okl_txl_quote_lines_b ql, okl_k_lines_full_v l

89:
90: -- This cursor is used to check if an accepted termination quote exists for an asset line.
91: CURSOR l_quotes_csr(p_kle_id NUMBER) IS
92: SELECT l.name
93: FROM okl_trx_quotes_b qh, okl_txl_quote_lines_b ql, okl_k_lines_full_v l
94: WHERE qh.id = ql.qte_id
95: AND qh.qst_code = 'ACCEPTED'
96: AND ql.qlt_code = 'AMCFIA'
97: AND ql.kle_id = l.id