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_SEEDED_FUNCTIONS_PVT dependencies on OKL_K_LINES_V

Line 1078: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;

1074: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
1075: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
1076: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
1077: l_api_name CONSTANT VARCHAR2(30) := 'FUNCTION_OEC_CALC';
1078: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
1079: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
1080: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1081: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1082: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;

Line 1080: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;

1076: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
1077: l_api_name CONSTANT VARCHAR2(30) := 'FUNCTION_OEC_CALC';
1078: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
1079: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
1080: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1081: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1082: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1083: l_capred_incl_terminated BOOLEAN := FALSE;
1084: -- Cursor to get the lty_code

Line 1081: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;

1077: l_api_name CONSTANT VARCHAR2(30) := 'FUNCTION_OEC_CALC';
1078: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
1079: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
1080: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1081: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1082: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1083: l_capred_incl_terminated BOOLEAN := FALSE;
1084: -- Cursor to get the lty_code
1085: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS

Line 1082: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;

1078: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
1079: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
1080: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1081: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1082: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1083: l_capred_incl_terminated BOOLEAN := FALSE;
1084: -- Cursor to get the lty_code
1085: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
1086: SELECT lse.lty_code

Line 1094: FROM OKL_K_LINES_V kle,

1090: AND cle.lse_id = lse.id;
1091: -- Cursor to sum up oec for contract
1092: CURSOR c_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1093: SELECT SUM(kle.oec) oec
1094: FROM OKL_K_LINES_V kle,
1095: OKC_K_LINES_V cle,
1096: OKC_K_HEADERS_V CHR
1097: WHERE CHR.id = p_dnz_chr_id
1098: AND CHR.id = cle.dnz_chr_id

Line 1104: FROM OKL_K_LINES_V kle,

1100: AND cle.id = kle.id;
1101:
1102: CURSOR c_contract_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1103: SELECT SUM(kle.oec) oec
1104: FROM OKL_K_LINES_V kle,
1105: OKC_K_LINES_V cle,
1106: OKC_K_HEADERS_V CHR
1107: WHERE CHR.id = p_dnz_chr_id
1108: AND CHR.id = cle.dnz_chr_id

Line 1208: FROM OKL_K_LINES_V kle,

1204: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
1205: CURSOR c_nr_con_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE,
1206: p_line_type VARCHAR2) IS
1207: SELECT SUM(kle.oec) oec
1208: FROM OKL_K_LINES_V kle,
1209: OKC_K_LINES_V cle,
1210: OKC_K_HEADERS_V CHR
1211: WHERE CHR.id = p_dnz_chr_id
1212: AND CHR.id = cle.dnz_chr_id

Line 1221: FROM OKL_K_LINES_V kle,

1217:
1218: CURSOR c_nr_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE,
1219: p_line_type VARCHAR2) IS
1220: SELECT SUM(kle.oec) oec
1221: FROM OKL_K_LINES_V kle,
1222: OKC_K_LINES_V cle,
1223: OKC_K_HEADERS_V CHR
1224: WHERE CHR.id = p_dnz_chr_id
1225: AND CHR.id = cle.dnz_chr_id

Line 11829: okl_k_lines_v kle

11825: okc_statuses_b stsb,
11826: fa_additions fad,
11827: fa_book_controls fbc,
11828: fa_books fab,
11829: okl_k_lines_v kle
11830: WHERE fin_ast_cle.id = p_cle_id
11831: AND fin_ast_cle.dnz_chr_id = p_chr_id
11832: AND fin_ast_cle.chr_id = p_chr_id
11833: AND fin_ast_cle.sts_code = stsb.code

Line 11862: okl_k_lines_v kle

11858: okc_statuses_b stsb,
11859: fa_additions fad,
11860: fa_book_controls fbc,
11861: fa_books fab,
11862: okl_k_lines_v kle
11863: WHERE fin_ast_cle.id = p_cle_id
11864: AND fin_ast_cle.dnz_chr_id = p_chr_id
11865: AND fin_ast_cle.chr_id = p_chr_id
11866: AND fin_ast_cle.sts_code = stsb.code