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_ACTIVATE_ASSET_PVT dependencies on OKL_K_LINES

Line 1663: okl_k_lines kle_fin

1659: l_chr_id
1660: From
1661: okc_k_lines_b cleb_fa,
1662: okc_k_lines_b cleb_fin,
1663: okl_k_lines kle_fin
1664: where
1665: cleb_fa.id = p_fa_cle_id
1666: and cleb_fin.id = cleb_fa.cle_id
1667: and cleb_fin.dnz_chr_id = cleb_fa.dnz_chr_id

Line 1778: OKL_K_LINES fee_kle,

1774: Cursor cap_fee_csr(fa_cle_id in number
1775: ,rbk_chr_id in number) IS
1776: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
1777: From
1778: OKL_K_LINES fee_kle,
1779: OKC_K_LINES_B fee_cle,
1780: OKC_STATUSES_B fee_sts,
1781: OKL_K_LINES cov_ast_kle,
1782: OKC_K_LINES_B cov_ast_cle,

Line 1781: OKL_K_LINES cov_ast_kle,

1777: From
1778: OKL_K_LINES fee_kle,
1779: OKC_K_LINES_B fee_cle,
1780: OKC_STATUSES_B fee_sts,
1781: OKL_K_LINES cov_ast_kle,
1782: OKC_K_LINES_B cov_ast_cle,
1783: OKC_LINE_STYLES_B cov_ast_lse,
1784: OKC_STATUSES_B cov_ast_sts,
1785: OKC_K_ITEMS cov_ast_cim,

Line 3028: FROM OKL_K_LINES

3024: --cursor definitions------------------------------------------------------------
3025: --Cursor to fetch residual value from top line for operating leas
3026: CURSOR residual_val_csr(p_fin_ast_line_id IN NUMBER) is
3027: SELECT residual_value
3028: FROM OKL_K_LINES
3029: WHERE id = p_fin_ast_line_id;
3030:
3031: l_residual_value NUMBER default 0;
3032:

Line 5082: OKL_K_LINES kle,

5078: cle.id,
5079: cle.name
5080: FROM OKC_K_LINES_V cle,
5081: OKC_LINE_STYLES_B lse,
5082: OKL_K_LINES kle,
5083: OKC_K_LINES_B fa_cle,
5084: OKC_LINE_STYLES_B fa_cle_lse
5085: WHERE kle.id = cle.id
5086: AND cle.chr_id = p_chr_id

Line 5105: l_oec OKL_K_LINES.OEC%TYPE;

5101: --Bug# 2522268
5102: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'));
5103: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));
5104:
5105: l_oec OKL_K_LINES.OEC%TYPE;
5106: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;
5107: l_cle_id OKC_K_LINES_V.ID%TYPE;
5108: l_asset_number OKC_K_LINES_V.NAME%TYPE;
5109:

Line 5106: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;

5102: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'));
5103: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));
5104:
5105: l_oec OKL_K_LINES.OEC%TYPE;
5106: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;
5107: l_cle_id OKC_K_LINES_V.ID%TYPE;
5108: l_asset_number OKC_K_LINES_V.NAME%TYPE;
5109:
5110:

Line 6367: OKL_K_LINES kle,

6363: cle.id,
6364: cle.name
6365: FROM OKC_K_LINES_V cle,
6366: OKC_LINE_STYLES_B lse,
6367: OKL_K_LINES kle,
6368: OKC_K_LINES_B fa_cle,
6369: OKC_LINE_STYLES_B fa_cle_lse
6370: WHERE kle.id = cle.id
6371: AND cle.chr_id = p_chr_id

Line 6390: l_oec OKL_K_LINES.OEC%TYPE;

6386: --Bug# 2522268
6387: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'));
6388: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));
6389:
6390: l_oec OKL_K_LINES.OEC%TYPE;
6391: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;
6392: l_cle_id OKC_K_LINES_V.ID%TYPE;
6393: l_asset_number OKC_K_LINES_V.NAME%TYPE;
6394:

Line 6391: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;

6387: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'));
6388: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));
6389:
6390: l_oec OKL_K_LINES.OEC%TYPE;
6391: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;
6392: l_cle_id OKC_K_LINES_V.ID%TYPE;
6393: l_asset_number OKC_K_LINES_V.NAME%TYPE;
6394:
6395:

Line 7872: OKL_K_LINES fee_kle,

7868: Cursor cap_fee_csr(fa_cle_id in number
7869: ,rel_chr_id in number) IS
7870: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
7871: From
7872: OKL_K_LINES fee_kle,
7873: OKC_K_LINES_B fee_cle,
7874: OKC_STATUSES_B fee_sts,
7875: OKL_K_LINES cov_ast_kle,
7876: OKC_K_LINES_B cov_ast_cle,

Line 7875: OKL_K_LINES cov_ast_kle,

7871: From
7872: OKL_K_LINES fee_kle,
7873: OKC_K_LINES_B fee_cle,
7874: OKC_STATUSES_B fee_sts,
7875: OKL_K_LINES cov_ast_kle,
7876: OKC_K_LINES_B cov_ast_cle,
7877: OKC_LINE_STYLES_B cov_ast_lse,
7878: OKC_STATUSES_B cov_ast_sts,
7879: OKC_K_ITEMS cov_ast_cim,

Line 9594: from okl_k_lines_v

9590: -- Bug# 5150150 - start
9591: -- cursor to get expected asset cost
9592: cursor l_exp_asset_cost_csr (p_cle_id in number) is
9593: select id,EXPECTED_ASSET_COST
9594: from okl_k_lines_v
9595: where id = p_cle_id;
9596:
9597: -- cursor to get ORIG_SYSTEM_SOURCE_CODE of the contract
9598:

Line 9606: l_cle_id okl_k_lines_v.id%type;

9602: where id = p_chr_id;
9603:
9604: l_chr_id okc_k_headers_b.id%type;
9605: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
9606: l_cle_id okl_k_lines_v.id%type;
9607: l_exp_asset_cost okl_k_lines_v.expected_asset_cost%type;
9608:
9609: --cursor to get Cap fees added during Re-lease for the asset
9610: Cursor cap_fee_csr(p_fin_ast_cle_id in number

Line 9607: l_exp_asset_cost okl_k_lines_v.expected_asset_cost%type;

9603:
9604: l_chr_id okc_k_headers_b.id%type;
9605: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
9606: l_cle_id okl_k_lines_v.id%type;
9607: l_exp_asset_cost okl_k_lines_v.expected_asset_cost%type;
9608:
9609: --cursor to get Cap fees added during Re-lease for the asset
9610: Cursor cap_fee_csr(p_fin_ast_cle_id in number
9611: ,p_chr_id in number) IS

Line 9614: OKL_K_LINES fee_kle,

9610: Cursor cap_fee_csr(p_fin_ast_cle_id in number
9611: ,p_chr_id in number) IS
9612: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
9613: From
9614: OKL_K_LINES fee_kle,
9615: OKC_K_LINES_B fee_cle,
9616: OKC_STATUSES_B fee_sts,
9617: OKL_K_LINES cov_ast_kle,
9618: OKC_K_LINES_B cov_ast_cle,

Line 9617: OKL_K_LINES cov_ast_kle,

9613: From
9614: OKL_K_LINES fee_kle,
9615: OKC_K_LINES_B fee_cle,
9616: OKC_STATUSES_B fee_sts,
9617: OKL_K_LINES cov_ast_kle,
9618: OKC_K_LINES_B cov_ast_cle,
9619: OKC_STATUSES_B cov_ast_sts,
9620: OKC_K_ITEMS cov_ast_cim
9621: Where fee_kle.id = fee_cle.id

Line 11182: okl_k_lines kle_fin

11178:
11179: cursor l_capital_cost_csr(p_fin_cle_id in number) IS
11180: select kle_fin.capital_amount
11181: from okc_k_lines_b cleb_fin,
11182: okl_k_lines kle_fin
11183: where cleb_fin.id = p_fin_cle_id
11184: and kle_fin.id = cleb_fin.id;
11185:
11186: l_capital_amount okl_k_lines.capital_amount%TYPE;

Line 11186: l_capital_amount okl_k_lines.capital_amount%TYPE;

11182: okl_k_lines kle_fin
11183: where cleb_fin.id = p_fin_cle_id
11184: and kle_fin.id = cleb_fin.id;
11185:
11186: l_capital_amount okl_k_lines.capital_amount%TYPE;
11187:
11188: l_talv_rec okl_txl_assets_pub.tlpv_rec_type;
11189: lx_talv_rec okl_txl_assets_pub.tlpv_rec_type;
11190: l_txdv_rec okl_txd_assets_pub.adpv_rec_type;