eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKX_ASSET_LINES_V

Line 3471: FROM OKX_ASSET_LINES_V

3467: asset_id,
3468: original_cost,
3469: current_units,
3470: in_service_date
3471: FROM OKX_ASSET_LINES_V
3472: WHERE dnz_chr_id = p_term_rec.p_contract_id;
3473:
3474: --This cursor returns the original cost from the original asset creation line
3475: CURSOR l_txlassetsv_csr(p_asset_number okl_txl_assets_v.asset_number%TYPE) IS

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

3597: RAISE OKL_API.G_EXCEPTION_ERROR;
3598: END IF;
3599:
3600: -- scenario 8 - Direct Finance Lease expiration with NO hold period
3601: -- loop thru all the records from okx_asset_lines_v where
3602: -- contract id matches p_contract_id, validate the data
3603: -- and then create transaction header and line in okl_trx_assets_v and
3604: -- okl_txl_assets_v
3605: FOR l_lines_rec IN l_linesv_csr LOOP

Line 9257: FROM OKX_ASSET_LINES_V A

9253: -- Cursor to get the asset id for the line
9254: CURSOR line_info_csr (p_l_id IN NUMBER) IS
9255: SELECT asset_id,
9256: line_number
9257: FROM OKX_ASSET_LINES_V A
9258: WHERE parent_line_id = p_l_id;
9259:
9260: -- Cursor to get the purchase amount for the line
9261: -- RMUNJULU 04-FEB-03 2781557 Changed cursor to get proper purchase amount lines