[Home] [Help]
35:
36: TYPE fin_line_tab_type IS TABLE OF NUMBER;
37:
38: TYPE asset_rec_type IS RECORD (fin_asset_id OKC_K_LINES_B.id%TYPE,
39: amount OKL_K_LINES.tradein_amount%TYPE,
40: asset_number OKC_K_LINES_TL.name%TYPE,
41: description OKC_K_LINES_TL.item_description%TYPE,
42: oec OKL_K_LINES.oec%TYPE,
43: capitalize_yn OKL_K_LINES.capitalize_down_payment_yn%TYPE,
38: TYPE asset_rec_type IS RECORD (fin_asset_id OKC_K_LINES_B.id%TYPE,
39: amount OKL_K_LINES.tradein_amount%TYPE,
40: asset_number OKC_K_LINES_TL.name%TYPE,
41: description OKC_K_LINES_TL.item_description%TYPE,
42: oec OKL_K_LINES.oec%TYPE,
43: capitalize_yn OKL_K_LINES.capitalize_down_payment_yn%TYPE,
44: receiver_code OKL_K_LINES.down_payment_receiver_code%TYPE);
45:
46: TYPE asset_tbl_type IS TABLE OF asset_rec_type INDEX BY BINARY_INTEGER;
39: amount OKL_K_LINES.tradein_amount%TYPE,
40: asset_number OKC_K_LINES_TL.name%TYPE,
41: description OKC_K_LINES_TL.item_description%TYPE,
42: oec OKL_K_LINES.oec%TYPE,
43: capitalize_yn OKL_K_LINES.capitalize_down_payment_yn%TYPE,
44: receiver_code OKL_K_LINES.down_payment_receiver_code%TYPE);
45:
46: TYPE asset_tbl_type IS TABLE OF asset_rec_type INDEX BY BINARY_INTEGER;
47:
40: asset_number OKC_K_LINES_TL.name%TYPE,
41: description OKC_K_LINES_TL.item_description%TYPE,
42: oec OKL_K_LINES.oec%TYPE,
43: capitalize_yn OKL_K_LINES.capitalize_down_payment_yn%TYPE,
44: receiver_code OKL_K_LINES.down_payment_receiver_code%TYPE);
45:
46: TYPE asset_tbl_type IS TABLE OF asset_rec_type INDEX BY BINARY_INTEGER;
47:
48: PROCEDURE Create_all_line(
709: ast_key.concatenated_segments asset_key_name,
710: cim_fa.object1_id1 asset_id
711: FROM okl_txl_assets_b txl,
712: okc_line_styles_b lse_fa,
713: okl_k_lines kle_fa,
714: okc_k_lines_b cleb_fa,
715: okl_asset_key_lov_uv ast_key,
716: okx_ast_locs_v ast_loc,
717: okc_k_items cim_fa
843:
844:
845: --start NISINHA Bug 6490572
846:
847: -- cursor to get Model Number and Manufacturer from OKL_K_LINES for loan contracts
848:
849: CURSOR c_fa_line_loan(p_clev_fin_id IN okc_k_lines_b.id%type,
850: p_dnz_chr_id IN okc_k_headers_all_b.id%type) IS
851: SELECT kle_fa.model_number,
851: SELECT kle_fa.model_number,
852: kle_fa.year_built,
853: kle_fa.manufacturer_name
854: FROM okc_line_styles_b lse_fa,
855: okl_k_lines kle_fa,
856: okc_k_lines_b cleb_fa
857: WHERE cleb_fa.id = kle_fa.id
858: AND lse_fa.id = cleb_fa.lse_id
859: AND lse_fa.lty_code = 'FIXED_ASSET'
1532: clet_fin.item_description description,
1533: NVL(kle_fin.oec,0) oec
1534: FROM okc_k_lines_b cleb_fin,
1535: okc_k_lines_tl clet_fin,
1536: okl_k_lines kle_fin,
1537: okc_line_styles_b lse_fin,
1538: okc_statuses_b sts
1539: WHERE cleb_fin.dnz_chr_id = p_chr_id
1540: AND cleb_fin.chr_id = p_chr_id
1552: clet_fin.item_description description,
1553: NVL(kle_fin.oec,0) oec
1554: FROM okc_k_lines_b cleb_fin,
1555: okc_k_lines_tl clet_fin,
1556: okl_k_lines kle_fin,
1557: okc_line_styles_b lse_fin,
1558: okc_statuses_b sts
1559: WHERE cleb_fin.dnz_chr_id = p_chr_id
1560: AND cleb_fin.chr_id = p_chr_id
1569:
1570: CURSOR c_term_fin_lines(p_chr_id IN NUMBER) is
1571: SELECT SUM(NVL(kle_fin.tradein_amount,0)) amount
1572: FROM okc_k_lines_b cleb_fin,
1573: okl_k_lines kle_fin,
1574: okc_line_styles_b lse_fin
1575: WHERE cleb_fin.dnz_chr_id = p_chr_id
1576: AND cleb_fin.chr_id = p_chr_id
1577: AND cleb_fin.sts_code = 'TERMINATED'
1782: NVL(kle_fin.capitalize_down_payment_yn,'Y') capitalize_yn,
1783: NVL(kle_fin.down_payment_receiver_code,'LESSOR') receiver_code
1784: FROM okc_k_lines_b cleb_fin,
1785: okc_k_lines_tl clet_fin,
1786: okl_k_lines kle_fin,
1787: okc_line_styles_b lse_fin,
1788: okc_statuses_b sts
1789: WHERE cleb_fin.dnz_chr_id = p_chr_id
1790: AND cleb_fin.chr_id = p_chr_id
1804: NVL(kle_fin.capitalize_down_payment_yn,'Y') capitalize_yn,
1805: NVL(kle_fin.down_payment_receiver_code,'LESSOR') receiver_code
1806: FROM okc_k_lines_b cleb_fin,
1807: okc_k_lines_tl clet_fin,
1808: okl_k_lines kle_fin,
1809: okc_line_styles_b lse_fin,
1810: okc_statuses_b sts
1811: WHERE cleb_fin.dnz_chr_id = p_chr_id
1812: AND cleb_fin.chr_id = p_chr_id
1823: CURSOR c_term_fin_lines(p_chr_id IN NUMBER) is
1824: SELECT SUM( NVL(kle_fin.capital_reduction,0) +
1825: (NVL(kle_fin.capital_reduction_percent,0)/100 * kle_fin.oec)) amount
1826: FROM okc_k_lines_b cleb_fin,
1827: okl_k_lines kle_fin,
1828: okc_line_styles_b lse_fin
1829: WHERE cleb_fin.dnz_chr_id = p_chr_id
1830: AND cleb_fin.chr_id = p_chr_id
1831: AND cleb_fin.sts_code = 'TERMINATED'
2035: RETURN VARCHAR2
2036: IS
2037: CURSOR c_subsidy_amount(p_khr_id NUMBER, p_subsidy_id NUMBER) IS
2038: SELECT OKL_ACCOUNTING_UTIL.format_amount(SUM(NVL(kle_sub.subsidy_override_amount,kle_sub.amount)), cleb_sub.currency_code) subsidy_amount
2039: FROM okl_k_lines kle_sub,
2040: okc_k_lines_b cleb_sub
2041: WHERE kle_sub.subsidy_id = p_subsidy_id
2042: AND cleb_sub.dnz_chr_id = p_khr_id
2043: AND cleb_sub.id = kle_sub.id
2059: RETURN VARCHAR2
2060: IS
2061: CURSOR c_down_payment_amount(p_khr_id NUMBER) IS
2062: SELECT OKL_ACCOUNTING_UTIL.format_amount(SUM( NVL(kle_fin.capital_reduction,0) + (NVL(kle_fin.capital_reduction_percent,0)/100 * kle_fin.oec) ), cleb_fin.currency_code) down_payment_amount
2063: FROM okl_k_lines kle_fin,
2064: okc_k_lines_b cleb_fin
2065: WHERE cleb_fin.chr_id = p_khr_id
2066: AND cleb_fin.dnz_chr_id = p_khr_id
2067: AND kle_fin.id = cleb_fin.id