DBA Data[Home] [Help]

APPS.OKL_AM_SV_WRITEDOWN_PVT dependencies on OKL_TRX_QUOTES_B

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

81:
82: -- This cursor is used to check if an accepted termination quote exists for an asset line.
83: CURSOR l_quotes_csr(p_kle_id NUMBER) IS
84: SELECT l.asset_number
85: FROM okl_trx_quotes_b qh, okl_txl_quote_lines_b ql, okx_asset_lines_v l
86: WHERE qh.id = ql.qte_id
87: AND qh.qst_code = 'ACCEPTED'
88: AND ql.qlt_code = 'AMCFIA'
89: AND ql.kle_id = l.parent_line_id