DBA Data[Home] [Help]

APPS.OKL_AM_RV_WRITEDOWN_PVT dependencies on OKL_TRX_QUOTES_B

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

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