APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKC_K_LINES_V

Line 3128: FROM okc_k_headers_all_b okch, okc_k_lines_v okcl

3124: WHERE
3125: a.cust_acct_site_id = b.cust_acct_site_id
3126: AND b.site_use_code = 'BILL_TO'
3127: AND b.site_use_id = (SELECT DECODE(okcl.bill_to_site_use_id, null, okch.bill_to_site_use_id, okcl.bill_to_site_use_id)
3128: FROM okc_k_headers_all_b okch, okc_k_lines_v okcl
3129: WHERE okcl.dnz_chr_id = okch.id
3130: AND okcl.id = p_fin_asset_id)
3131: AND a.party_site_id = c.party_site_id
3132: AND a.cust_account_id = p_cust_acct_id;

Line 7738: FROM OKC_K_LINES_v

7734:
7735: --get the asset number
7736: CURSOR l_okclines_csr(cp_fin_asset_id IN NUMBER) IS
7737: SELECT name
7738: FROM OKC_K_LINES_v
7739: WHERE id = cp_fin_asset_id;
7740:
7741: -- get the model line id (ITEM) for a financial asset id
7742: CURSOR l_modelline_csr(cp_fin_asset_id IN NUMBER) IS

Line 8279: FROM OKC_K_LINES_v

8275:
8276: --get the asset number
8277: CURSOR l_okclines_csr(cp_fin_asset_id IN NUMBER) IS
8278: SELECT name, lse_id
8279: FROM OKC_K_LINES_v
8280: WHERE id = cp_fin_asset_id;
8281:
8282: -- get contract/line stream types (K1-A1-ST1, K1-A1-ST2, K1-S1-ST3, K1-ST4...)
8283: CURSOR l_kstreamtypes_csr(cp_khr_id IN NUMBER) IS

Line 9971: FROM okl_txl_quote_lines_b txl, okc_k_lines_v cle

9967: -- get the tax eligible quote lines
9968: CURSOR l_txlquotelines_csr(cp_qte_id IN NUMBER) IS
9969: SELECT txl.id, txl.sty_id, txl.kle_id,
9970: txl.qlt_code, txl.amount, txl.try_id, cle.name
9971: FROM okl_txl_quote_lines_b txl, okc_k_lines_v cle
9972: WHERE qte_id = cp_qte_id
9973: AND qlt_code NOT IN ('AMCFIA', 'AMCTAX', 'AMYOUB', 'AMCSDD')
9974: AND txl.kle_id = cle.id (+);
9975:

Line 9983: FROM okc_k_lines_v

9979:
9980: --get line name
9981: CURSOR l_okclines_csr(cp_line_id IN NUMBER) IS
9982: SELECT name, lse_id
9983: FROM okc_k_lines_v
9984: WHERE id = cp_line_id;
9985:
9986: -- get the inventory item id and inventory item org for a financial asset
9987: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS

Line 10959: FROM okc_k_lines_v

10955:
10956: -- get the contract id
10957: CURSOR l_okcklines_csr(cp_kle_id IN NUMBER) IS
10958: SELECT chr_id, name
10959: FROM okc_k_lines_v
10960: WHERE id = cp_kle_id;
10961:
10962: -- get the current, active, billable streams for the asset
10963: CURSOR l_assetstreams_csr(cp_khr_id IN NUMBER, cp_kle_id IN NUMBER) IS

Line 11023: FROM okc_k_lines_v okcl,

11019: AND ROWNUM = 1;
11020:
11021: CURSOR c_get_ast_instances(p_parent_line_id IN NUMBER) IS
11022: SELECT count(*)
11023: FROM okc_k_lines_v okcl,
11024: okc_line_styles_v lse
11025: WHERE okcl.cle_id = p_parent_line_id
11026: AND okcl.lse_id = lse.id
11027: AND lse.lty_code = 'FREE_FORM2';

Line 12211: FROM okc_k_lines_v

12207:
12208: -- get the contract id
12209: CURSOR l_okcklines_csr(cp_kle_id IN NUMBER) IS
12210: SELECT dnz_chr_id, name
12211: FROM okc_k_lines_v
12212: WHERE id = cp_kle_id;
12213:
12214: CURSOR l_racusttrxtypes_csr IS
12215: SELECT cust_trx_type_id

Line 13225: FROM okc_k_lines_v cle

13221:
13222: -- Get all the asset lines of the contract
13223: CURSOR l_finassets_csr(cp_chr_id IN NUMBER) IS
13224: SELECT cle.id fin_asset_id, cle.name asset_number
13225: FROM okc_k_lines_v cle
13226: WHERE cle.chr_id = cp_chr_id
13227: AND cle.lse_id = 33
13228: AND sts_code NOT IN ('ABANDONED', 'EXPIRED', 'REVERSED', 'TERMINATED');
13229:

Line 18965: FROM okc_k_lines_v

18961:
18962: -- Get line name
18963: CURSOR l_okclines_csr(cp_line_id IN NUMBER) IS
18964: SELECT name
18965: FROM okc_k_lines_v
18966: WHERE id = cp_line_id;
18967:
18968: -- Get the financial asset associated with a given subline
18969: CURSOR l_finasset_csr(cp_fee_serviced_asset_line_id IN NUMBER, cp_line_type IN VARCHAR2) IS