[Home] [Help]
3838:
3839: CURSOR l_lne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
3840: SELECT kle.id,
3841: kle.name
3842: FROM OKC_K_LINES_V kle,
3843: OKC_LINE_STYLES_B ls,
3844: OKC_STATUSES_B sts
3845: WHERE kle.lse_id = ls.id
3846: AND ls.lty_code = ltycode
4195: kitem.object1_id1,
4196: kitem.number_of_items,
4197: mtl.description,
4198: mtl.serial_number_control_code
4199: FROM okc_k_lines_v top,
4200: okc_k_lines_b item,
4201: okc_line_styles_b item_style,
4202: okc_line_styles_b top_style,
4203: okc_k_items kitem,
5758: for top fee line of a given contract. */
5759:
5760: CURSOR l_rq_top_fee_ln_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE ) IS
5761: SELECT kle.id, kle.qte_id, kle.amount, cleb.name
5762: FROM okc_k_lines_v cleb,
5763: okl_k_lines kle
5764: WHERE cleb.dnz_chr_id = chrID
5765: AND kle.ID = cleb.ID
5766: AND kle.fee_type = 'ROLLOVER'
5868: AND styt.LANGUAGE = USERENV('LANG')
5869: AND sty.id = styt.id;
5870:
5871: l_top_fee_ln_id OKL_K_LINES.ID%TYPE;
5872: l_top_fee_ln_name OKC_K_LINES_V.NAME%TYPE;
5873: l_sub_fee_ln_id OKL_K_LINES.ID%TYPE;
5874: l_qte_id OKL_K_LINES.QTE_ID%TYPE;
5875: l_qte_num OKL_TRX_QUOTES_V.QUOTE_NUMBER%TYPE;
5876: p_term_tbl Okl_Trx_Quotes_Pub.qtev_tbl_type;
6231: -- Validation of Sales Tax Financed Fee will be done
6232: -- after the Calculate Upfront Tax process
6233: CURSOR l_fn_top_fee_ln_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE ) IS
6234: SELECT kle.id, kle.amount, cleb.name
6235: FROM okc_k_lines_v cleb,
6236: okl_k_lines kle,
6237: okc_statuses_b okcsts
6238: WHERE cleb.dnz_chr_id = chrID
6239: AND cleb.chr_id = chrID
6311: AND styt.LANGUAGE = USERENV('LANG')
6312: AND sty.id = styt.id;
6313:
6314: l_top_fee_ln_id OKL_K_LINES.ID%TYPE;
6315: l_top_fee_ln_name OKC_K_LINES_V.NAME%TYPE;
6316: l_sub_fee_ln_id OKL_K_LINES.ID%TYPE;
6317: x_err_msg VARCHAR2(1000);
6318:
6319: l_fn_sub_ln_fee_cnt NUMBER := 0;
7136: fin_ast_cle.id rbk_fin_ast_cle_id,
7137: fin_ast_cle.orig_system_id1 orig_fin_ast_cle_id,
7138: fin_ast_cle.name asset_number
7139: FROM okc_k_lines_b model_cle,
7140: okc_k_lines_v fin_ast_cle,
7141: okc_statuses_b sts
7142: WHERE fin_ast_cle.chr_id = p_chr_id
7143: AND fin_ast_cle.dnz_chr_id = p_chr_id
7144: AND fin_ast_cle.lse_id = 33 -- Financial Asset Line
7395: -- Bug 6417667 End
7396: --down_payment_yes_no
7397: FROM
7398: okl_k_lines kle,
7399: okc_k_lines_v cle,
7400: okc_line_styles_b sty,
7401: okc_statuses_b sts
7402: WHERE cle.id = kle.id
7403: AND dnz_chr_id = p_chr_id
8955: CURSOR l_asset_csr IS
8956: SELECT cle.id,
8957: name,
8958: kle.residual_value
8959: FROM okc_k_lines_v cle,
8960: okl_k_lines kle,
8961: okc_line_styles_b sty,
8962: okc_statuses_b sts
8963: WHERE cle.lse_id = sty.id
9115: *
9116: * Cursor l_synd_csr ( chrId NUMBER ) IS
9117: * select kl.dnz_chr_id syndId
9118: * from OKC_K_ITEMS_V ITM,
9119: * OKC_K_LINES_V KL,
9120: * OKL_K_HEADERS_FULL_V KHR,
9121: * OKC_LINE_STYLES_B lse
9122: * where KL.LSE_ID=lse.id
9123: * and lse.lty_code='SHARED'
10622: -- Bug 6497111 Start Udhenuko Added.
10623: AND NVL(line.fee_purpose_code,'XXX') <> 'SALESTAX';
10624: -- Bug 6497111 End
10625:
10626: CURSOR fee_subline_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
10627: SELECT id,
10628: NVL(capital_amount,0) capital_amount
10629: FROM okl_k_lines_full_v line,
10630: okc_statuses_b sts
11621: SELECT txl.asset_number asset_num,
11622: fa.id fa_id,
11623: txd.tax_book
11624: FROM okc_k_items cim,
11625: okc_k_lines_V fa,
11626: okc_line_styles_b fa_lse,
11627: OKL_TRX_ASSETS trx,
11628: okl_txl_assets_b txl,
11629: okl_txd_assets_v txd,