APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKX_ASSET_LINES_V

Line 3355: FROM OKX_ASSET_LINES_V

3351: asset_id,
3352: original_cost,
3353: current_units,
3354: in_service_date
3355: FROM OKX_ASSET_LINES_V
3356: WHERE dnz_chr_id = p_term_rec.p_contract_id;
3357:
3358: --This cursor returns the original cost from the original asset creation line
3359: CURSOR l_txlassetsv_csr(p_asset_number okl_txl_assets_v.asset_number%TYPE) IS

Line 3485: -- loop thru all the records from okx_asset_lines_v where

3481: RAISE OKL_API.G_EXCEPTION_ERROR;
3482: END IF;
3483:
3484: -- scenario 8 - Direct Finance Lease expiration with NO hold period
3485: -- loop thru all the records from okx_asset_lines_v where
3486: -- contract id matches p_contract_id, validate the data
3487: -- and then create transaction header and line in okl_trx_assets_v and
3488: -- okl_txl_assets_v
3489: FOR l_lines_rec IN l_linesv_csr LOOP

Line 9058: FROM OKX_ASSET_LINES_V A

9054: -- Cursor to get the asset id for the line
9055: CURSOR line_info_csr (p_l_id IN NUMBER) IS
9056: SELECT asset_id,
9057: line_number
9058: FROM OKX_ASSET_LINES_V A
9059: WHERE parent_line_id = p_l_id;
9060:
9061: -- Cursor to get the purchase amount for the line
9062: -- RMUNJULU 04-FEB-03 2781557 Changed cursor to get proper purchase amount lines