[Home] [Help]
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;
7765:
7766: --get the asset number
7767: CURSOR l_okclines_csr(cp_fin_asset_id IN NUMBER) IS
7768: SELECT name
7769: FROM OKC_K_LINES_v
7770: WHERE id = cp_fin_asset_id;
7771:
7772: -- get the model line id (ITEM) for a financial asset id
7773: CURSOR l_modelline_csr(cp_fin_asset_id IN NUMBER) IS
8306:
8307: --get the asset number
8308: CURSOR l_okclines_csr(cp_fin_asset_id IN NUMBER) IS
8309: SELECT name, lse_id
8310: FROM OKC_K_LINES_v
8311: WHERE id = cp_fin_asset_id;
8312:
8313: -- get contract/line stream types (K1-A1-ST1, K1-A1-ST2, K1-S1-ST3, K1-ST4...)
8314: CURSOR l_kstreamtypes_csr(cp_khr_id IN NUMBER) IS
10000: -- get the tax eligible quote lines
10001: CURSOR l_txlquotelines_csr(cp_qte_id IN NUMBER) IS
10002: SELECT txl.id, txl.sty_id, txl.kle_id,
10003: txl.qlt_code, txl.amount, txl.try_id, cle.name
10004: FROM okl_txl_quote_lines_b txl, okc_k_lines_v cle
10005: WHERE qte_id = cp_qte_id
10006: AND qlt_code NOT IN ('AMCFIA', 'AMCTAX', 'AMYOUB', 'AMCSDD')
10007: AND txl.kle_id = cle.id (+);
10008:
10012:
10013: --get line name
10014: CURSOR l_okclines_csr(cp_line_id IN NUMBER) IS
10015: SELECT name, lse_id
10016: FROM okc_k_lines_v
10017: WHERE id = cp_line_id;
10018:
10019: -- get the inventory item id and inventory item org for a financial asset
10020: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS
10990:
10991: -- get the contract id
10992: CURSOR l_okcklines_csr(cp_kle_id IN NUMBER) IS
10993: SELECT chr_id, name
10994: FROM okc_k_lines_v
10995: WHERE id = cp_kle_id;
10996:
10997: -- get the current, active, billable streams for the asset
10998: CURSOR l_assetstreams_csr(cp_khr_id IN NUMBER, cp_kle_id IN NUMBER) IS
11054: AND ROWNUM = 1;
11055:
11056: CURSOR c_get_ast_instances(p_parent_line_id IN NUMBER) IS
11057: SELECT count(*)
11058: FROM okc_k_lines_v okcl,
11059: okc_line_styles_v lse
11060: WHERE okcl.cle_id = p_parent_line_id
11061: AND okcl.lse_id = lse.id
11062: AND lse.lty_code = 'FREE_FORM2';
12242:
12243: -- get the contract id
12244: CURSOR l_okcklines_csr(cp_kle_id IN NUMBER) IS
12245: SELECT dnz_chr_id, name
12246: FROM okc_k_lines_v
12247: WHERE id = cp_kle_id;
12248:
12249: CURSOR l_racusttrxtypes_csr IS
12250: SELECT cust_trx_type_id
13259: -- so tax calculation will be fired only for these assets
13260: -- Get all the asset lines of the contract
13261: /* CURSOR l_finassets_csr(cp_chr_id IN NUMBER) IS
13262: SELECT cle.id fin_asset_id, cle.name asset_number
13263: FROM okc_k_lines_v cle
13264: WHERE cle.chr_id = cp_chr_id
13265: AND cle.lse_id = 33
13266: AND sts_code NOT IN ('ABANDONED', 'EXPIRED', 'REVERSED', 'TERMINATED');*/
13267:
13267:
13268:
13269: CURSOR l_finassets_csr(cp_chr_id IN NUMBER) IS
13270: SELECT cle.id fin_asset_id, cle.name asset_number
13271: FROM okc_k_lines_v cle
13272: ,okl_k_lines kle
13273: WHERE cle.chr_id = cp_chr_id
13274: AND cle.lse_id = 33
13275: AND kle.id = cle.id
19128:
19129: -- Get line name
19130: CURSOR l_okclines_csr(cp_line_id IN NUMBER) IS
19131: SELECT name
19132: FROM okc_k_lines_v
19133: WHERE id = cp_line_id;
19134:
19135: -- Get the financial asset associated with a given subline
19136: CURSOR l_finasset_csr(cp_fee_serviced_asset_line_id IN NUMBER, cp_line_type IN VARCHAR2) IS