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 1667: okl_k_lines kle_fin

1663: l_chr_id
1664: From
1665: okc_k_lines_b cleb_fa,
1666: okc_k_lines_b cleb_fin,
1667: okl_k_lines kle_fin
1668: where
1669: cleb_fa.id = p_fa_cle_id
1670: and cleb_fin.id = cleb_fa.cle_id
1671: and cleb_fin.dnz_chr_id = cleb_fa.dnz_chr_id

Line 1782: OKL_K_LINES fee_kle,

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

Line 1785: OKL_K_LINES cov_ast_kle,

1781: From
1782: OKL_K_LINES fee_kle,
1783: OKC_K_LINES_B fee_cle,
1784: OKC_STATUSES_B fee_sts,
1785: OKL_K_LINES cov_ast_kle,
1786: OKC_K_LINES_B cov_ast_cle,
1787: OKC_LINE_STYLES_B cov_ast_lse,
1788: OKC_STATUSES_B cov_ast_sts,
1789: OKC_K_ITEMS cov_ast_cim,

Line 3037: FROM OKL_K_LINES

3033: --cursor definitions------------------------------------------------------------
3034: --Cursor to fetch residual value from top line for operating leas
3035: CURSOR residual_val_csr(p_fin_ast_line_id IN NUMBER) is
3036: SELECT residual_value
3037: FROM OKL_K_LINES
3038: WHERE id = p_fin_ast_line_id;
3039:
3040: l_residual_value NUMBER default 0;
3041:

Line 5346: ,okl_k_lines kle

5342: -- Bug# 15992711 Start of Modifications
5343: CURSOR chk_release_chr_csr(p_cle_id IN NUMBER) IS
5344: SELECT NVL(kle.RE_LEASE_YN,'N')
5345: FROM okc_k_lines_b cleb
5346: ,okl_k_lines kle
5347: WHERE cleb.cle_id = p_cle_id
5348: AND cleb.id = kle.id;
5349: --Bug# 15992711 End of Modifications
5350: l_release_chr_yn VARCHAR2(1);

Line 6301: OKL_K_LINES kle,

6297: cle.id,
6298: cle.name
6299: FROM OKC_K_LINES_V cle,
6300: OKC_LINE_STYLES_B lse,
6301: OKL_K_LINES kle,
6302: OKC_K_LINES_B fa_cle,
6303: OKC_LINE_STYLES_B fa_cle_lse
6304: WHERE kle.id = cle.id
6305: AND cle.chr_id = p_chr_id

Line 6324: l_oec OKL_K_LINES.OEC%TYPE;

6320: --Bug# 2522268
6321: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'));
6322: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));
6323:
6324: l_oec OKL_K_LINES.OEC%TYPE;
6325: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;
6326: l_cle_id OKC_K_LINES_V.ID%TYPE;
6327: l_asset_number OKC_K_LINES_V.NAME%TYPE;
6328: */

Line 6325: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;

6321: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'));
6322: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));
6323:
6324: l_oec OKL_K_LINES.OEC%TYPE;
6325: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;
6326: l_cle_id OKC_K_LINES_V.ID%TYPE;
6327: l_asset_number OKC_K_LINES_V.NAME%TYPE;
6328: */
6329:

Line 6534: ,okl_k_lines kle

6530: -- Bug# 15992711 Start of Modifications
6531: CURSOR chk_release_chr_csr(p_cle_id IN NUMBER) IS
6532: SELECT NVL(kle.RE_LEASE_YN,'N')
6533: FROM okc_k_lines_b cleb
6534: ,okl_k_lines kle
6535: WHERE cleb.cle_id = p_cle_id
6536: AND cleb.id = kle.id;
6537: --Bug# 15992711 End of Modifications
6538:

Line 7136: FROM okl_k_lines kle

7132: --Bug#2522439 */
7133:
7134: -- Bug# 15992711 Start of Modifications
7135: AND exists ( SELECT '1'
7136: FROM okl_k_lines kle
7137: ,okc_k_lines_b cleb
7138: WHERE cleb.dnz_chr_id = chr.id
7139: AND cleb.chr_id = chr.id
7140: AND cleb.id = kle.id

Line 7597: OKL_K_LINES fee_kle,

7593: Cursor cap_fee_csr(fa_cle_id in number
7594: ,rel_chr_id in number) IS
7595: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
7596: From
7597: OKL_K_LINES fee_kle,
7598: OKC_K_LINES_B fee_cle,
7599: OKC_STATUSES_B fee_sts,
7600: OKL_K_LINES cov_ast_kle,
7601: OKC_K_LINES_B cov_ast_cle,

Line 7600: OKL_K_LINES cov_ast_kle,

7596: From
7597: OKL_K_LINES fee_kle,
7598: OKC_K_LINES_B fee_cle,
7599: OKC_STATUSES_B fee_sts,
7600: OKL_K_LINES cov_ast_kle,
7601: OKC_K_LINES_B cov_ast_cle,
7602: OKC_LINE_STYLES_B cov_ast_lse,
7603: OKC_STATUSES_B cov_ast_sts,
7604: OKC_K_ITEMS cov_ast_cim,

Line 9319: from okl_k_lines_v

9315: -- Bug# 5150150 - start
9316: -- cursor to get expected asset cost
9317: cursor l_exp_asset_cost_csr (p_cle_id in number) is
9318: select id,EXPECTED_ASSET_COST
9319: from okl_k_lines_v
9320: where id = p_cle_id;
9321:
9322: -- cursor to get ORIG_SYSTEM_SOURCE_CODE of the contract
9323:

Line 9331: l_cle_id okl_k_lines_v.id%type;

9327: where id = p_chr_id;
9328:
9329: l_chr_id okc_k_headers_b.id%type;
9330: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
9331: l_cle_id okl_k_lines_v.id%type;
9332: l_exp_asset_cost okl_k_lines_v.expected_asset_cost%type;
9333:
9334: --cursor to get Cap fees added during Re-lease for the asset
9335: Cursor cap_fee_csr(p_fin_ast_cle_id in number

Line 9332: l_exp_asset_cost okl_k_lines_v.expected_asset_cost%type;

9328:
9329: l_chr_id okc_k_headers_b.id%type;
9330: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
9331: l_cle_id okl_k_lines_v.id%type;
9332: l_exp_asset_cost okl_k_lines_v.expected_asset_cost%type;
9333:
9334: --cursor to get Cap fees added during Re-lease for the asset
9335: Cursor cap_fee_csr(p_fin_ast_cle_id in number
9336: ,p_chr_id in number) IS

Line 9339: OKL_K_LINES fee_kle,

9335: Cursor cap_fee_csr(p_fin_ast_cle_id in number
9336: ,p_chr_id in number) IS
9337: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
9338: From
9339: OKL_K_LINES fee_kle,
9340: OKC_K_LINES_B fee_cle,
9341: OKC_STATUSES_B fee_sts,
9342: OKL_K_LINES cov_ast_kle,
9343: OKC_K_LINES_B cov_ast_cle,

Line 9342: OKL_K_LINES cov_ast_kle,

9338: From
9339: OKL_K_LINES fee_kle,
9340: OKC_K_LINES_B fee_cle,
9341: OKC_STATUSES_B fee_sts,
9342: OKL_K_LINES cov_ast_kle,
9343: OKC_K_LINES_B cov_ast_cle,
9344: OKC_STATUSES_B cov_ast_sts,
9345: OKC_K_ITEMS cov_ast_cim
9346: Where fee_kle.id = fee_cle.id

Line 10907: okl_k_lines kle_fin

10903:
10904: cursor l_capital_cost_csr(p_fin_cle_id in number) IS
10905: select kle_fin.capital_amount
10906: from okc_k_lines_b cleb_fin,
10907: okl_k_lines kle_fin
10908: where cleb_fin.id = p_fin_cle_id
10909: and kle_fin.id = cleb_fin.id;
10910:
10911: l_capital_amount okl_k_lines.capital_amount%TYPE;

Line 10911: l_capital_amount okl_k_lines.capital_amount%TYPE;

10907: okl_k_lines kle_fin
10908: where cleb_fin.id = p_fin_cle_id
10909: and kle_fin.id = cleb_fin.id;
10910:
10911: l_capital_amount okl_k_lines.capital_amount%TYPE;
10912:
10913: l_talv_rec okl_txl_assets_pub.tlpv_rec_type;
10914: lx_talv_rec okl_txl_assets_pub.tlpv_rec_type;
10915: l_txdv_rec okl_txd_assets_pub.adpv_rec_type;