[Home] [Help]
328: WHERE EXISTS
329: (
330: SELECT 'Y'
331: FROM OKC_K_ITEMS fa_cim,
332: OKC_K_LINES_B fa_cle,
333: OKC_LINE_STYLES_B fa_lse,
334: OKC_STATUSES_B fa_sts
335: WHERE fa_cim.cle_id = fa_cle.id
336: AND fa_cim.dnz_chr_id = fa_cle.dnz_chr_id
340: AND fa_cle.sts_code = fa_sts.code
341: AND fa_sts.ste_code NOT IN ('CANCELLED','TERMINATED','HOLD','EXPIRED')
342: AND fa_cim.object1_id1 IS NULL
343: AND EXISTS (SELECT '1'
344: FROM OKC_K_LINES_B fa_cle2,
345: OKC_LINE_STYLES_B fa_lse2,
346: OKC_STATUSES_B fa_sts2
347: WHERE fa_cle2.lse_id = fa_lse2.id
348: AND fa_lse2.lty_code = 'FIXED_ASSET'
352: )
353: UNION
354: SELECT 'Y'
355: FROM OKC_K_ITEMS fa_cim,
356: OKC_K_LINES_B fa_cle,
357: OKC_LINE_STYLES_B fa_lse,
358: OKC_STATUSES_B fa_sts
359: WHERE fa_cim.cle_id = fa_cle.id
360: AND fa_cim.dnz_chr_id = fa_cle.dnz_chr_id
368: FROM FA_ADDITIONS_B FAB
369: WHERE FAB.Asset_id = TO_NUMBER(fa_cim.object1_id1)
370: )
371: AND EXISTS (SELECT '1'
372: FROM OKC_K_LINES_B fa_cle2,
373: OKC_LINE_STYLES_B fa_lse2,
374: OKC_STATUSES_B fa_sts2
375: WHERE fa_cle2.lse_id = fa_lse2.id
376: AND fa_lse2.lty_code = 'FIXED_ASSET'
384: FROM DUAL
385: WHERE EXISTS
386: (
387: SELECT 1
388: FROM OKC_K_LINES_B fa_cle,
389: OKC_LINE_STYLES_B fa_lse,
390: OKC_STATUSES_B fa_sts,
391: OKC_K_ITEMS fa_cim,
392: FA_ADDITIONS_B FAB
408: SELECT 'Y'
409: FROM okc_k_headers_b chrb
410: WHERE chrb.id = chrid
411: AND EXISTS (SELECT '1'
412: FROM okc_k_lines_b cleb
413: WHERE cleb.chr_id = chrb.id
414: AND cleb.dnz_chr_id = chrb.id);
415: l_lines_exist VARCHAR2(1) DEFAULT 'N';
416: l_halt_process EXCEPTION;
1094: rulb2.RULE_INFORMATION3 level_periods,
1095: rulb2.RULE_INFORMATION7 stub_days,
1096: rulb2.RULE_INFORMATION8 stub_amount,
1097: rulb2.RULE_INFORMATION10 arrear_yn
1098: FROM okc_k_lines_b cleb,
1099: okc_rule_groups_b rgpb,
1100: okc_rules_b rulb,
1101: okc_rules_b rulb2,
1102: okl_strm_type_b styb
1533: e.ste_code ste_code -- 5264170
1534: FROM OKL_K_LINES a,
1535: OKC_K_LINES_TL b,
1536: OKC_LINE_STYLES_V C,
1537: OKC_K_LINES_B d,
1538: OKC_STATUSES_B e
1539: WHERE a.ID = p_id
1540: AND a.ID = b.ID
1541: AND b.LANGUAGE = USERENV('LANG')
4077: rule.object2_id1,
4078: 'Y' stub_only
4079: FROM okc_rules_b rule,
4080: okc_rule_groups_b rgp,
4081: okc_k_lines_b line,
4082: okc_line_styles_v style,
4083: okc_statuses_b sts
4084: WHERE rgp.id = rule.rgp_id
4085: AND rgp.rgd_code = 'LALEVL'
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,
4204: mtl_system_items mtl
4215: AND item.lse_id = item_style.id
4216: AND item_style.lty_code = 'ITEM';
4217:
4218: --Bug#3877032
4219: CURSOR ib_csr (p_top_cle_id OKC_K_LINES_B.ID%TYPE) IS
4220: SELECT COUNT(inst.serial_number) no_srl
4221: FROM okc_k_lines_b ib,
4222: okc_k_lines_b f2,
4223: okc_line_styles_b style,
4217:
4218: --Bug#3877032
4219: CURSOR ib_csr (p_top_cle_id OKC_K_LINES_B.ID%TYPE) IS
4220: SELECT COUNT(inst.serial_number) no_srl
4221: FROM okc_k_lines_b ib,
4222: okc_k_lines_b f2,
4223: okc_line_styles_b style,
4224: okl_txl_itm_insts inst
4225: WHERE f2.cle_id = p_top_cle_id
4218: --Bug#3877032
4219: CURSOR ib_csr (p_top_cle_id OKC_K_LINES_B.ID%TYPE) IS
4220: SELECT COUNT(inst.serial_number) no_srl
4221: FROM okc_k_lines_b ib,
4222: okc_k_lines_b f2,
4223: okc_line_styles_b style,
4224: okl_txl_itm_insts inst
4225: WHERE f2.cle_id = p_top_cle_id
4226: AND f2.lse_id = style.id
4292:
4293: CURSOR ib_line_csr(p_chr_id NUMBER) IS
4294: SELECT cle.id,
4295: cle.cle_id
4296: FROM okc_k_lines_b cle,
4297: okc_statuses_b sts
4298: WHERE cle.lse_id = G_IB_LINE_LTY_ID
4299: AND cle.dnz_chr_id = p_chr_id
4300: AND cle.sts_code = sts.code
4373:
4374:
4375: CURSOR asset_num_csr(p_cle_id NUMBER) IS
4376: SELECT name
4377: FROM okc_k_lines_b cle1,
4378: okc_k_lines_tl cle_tl,
4379: okc_k_lines_b cle2
4380: WHERE cle_tl.id = cle2.id
4381: AND cle1.id = p_cle_id
4375: CURSOR asset_num_csr(p_cle_id NUMBER) IS
4376: SELECT name
4377: FROM okc_k_lines_b cle1,
4378: okc_k_lines_tl cle_tl,
4379: okc_k_lines_b cle2
4380: WHERE cle_tl.id = cle2.id
4381: AND cle1.id = p_cle_id
4382: AND cle2.id = cle1.cle_id
4383: AND cle_tl.language = USERENV('LANG');
4751: CURSOR c_fin_fee (p_khr_id OKC_K_HEADERS_B.ID%TYPE) IS
4752: SELECT cle.id,
4753: DECODE (lse.lty_code, 'FREE_FORM1', 'ASSET', 'FEE', 'FEE',
4754: 'SOLD_SERVICE','SERVICE') line_type
4755: FROM okc_k_lines_b cle,
4756: okc_line_styles_b lse,
4757: okc_statuses_b sts
4758: WHERE cle.chr_id = p_khr_id
4759: AND cle.lse_id = lse.id
4761: AND sts.ste_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED')
4762: AND lse.lty_code IN ('FREE_FORM1', 'FEE', 'SOLD_SERVICE');
4763:
4764: CURSOR c_strm_sll (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
4765: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
4766: SELECT sll.rule_information2 start_date,
4767: SLL.rule_information3 periods,
4768: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
4769: ( select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
4788: --ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
4789:
4790: /*
4791: CURSOR c_strm_sll_ext (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
4792: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
4793: SELECT
4794: SUM(NVL(TO_NUMBER(SLL.rule_information3),0)) periods,
4795: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
4796: styt.name stream_type
4814: */
4815:
4816: --Bug#3877032
4817: CURSOR c_strm_slh_ext (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
4818: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
4819: SELECT (select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT
4820: where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
4821: AND to_number(RULE.OBJECT1_ID1) = STY.ID ) STREAM_TYPE,
4822: rule.id rule_id,
4867: l_pmnt_end_date DATE;
4868:
4869: -- START: cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938
4870: CURSOR c_strm_sll_count (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
4871: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
4872: SELECT COUNT(sll.id)
4873: FROM okc_rules_b sll,
4874: okc_rules_b slh,
4875: okc_rule_groups_b rgp,
5345:
5346:
5347: CURSOR l_assets_asso_csr(chrId IN NUMBER, kleId in NUMBER) IS
5348: SELECT cleb.id
5349: FROM okc_k_lines_b cleb
5350:
5351: WHERE cleb.dnz_chr_id = chrId
5352: AND cleb.chr_id = chrId
5353: AND CLEB.ID =kleId
5352: AND cleb.chr_id = chrId
5353: AND CLEB.ID =kleId
5354: and exists
5355: ( SELECT '1'
5356: FROM okc_k_lines_b cleb1,
5357: okc_statuses_b okcsts1
5358: WHERE cleb1.dnz_chr_id = cleb.chr_id
5359: AND cleb1.cle_id = cleb.id
5360: AND okcsts1.code = cleb1.sts_code
5776: for top fee line of a given contract. */
5777:
5778: CURSOR l_rq_top_fee_ln_csr1 ( chrID IN OKC_K_HEADERS_B.ID%TYPE ) IS
5779: SELECT kle.qte_id
5780: FROM okc_k_lines_b cleb,
5781: okl_k_lines kle
5782: WHERE cleb.dnz_chr_id = chrID
5783: AND kle.ID = cleb.ID
5784: AND kle.fee_type = 'ROLLOVER'
5795:
5796: CURSOR l_rq_sub_ln_fee_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
5797: feeTopLine IN OKL_K_LINES.ID%TYPE) IS
5798: SELECT kle.id, kle.amount, cleb.end_date
5799: FROM okc_k_lines_b cleb,
5800: okl_k_lines kle
5801: WHERE cleb.dnz_chr_id = chrID
5802: AND kle.ID = cleb.ID
5803: AND cleb.CLE_ID = feeTopLine
6250: CURSOR l_fn_sub_ln_fee_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6251: feeTopLine IN OKL_K_LINES.ID%TYPE) IS
6252: SELECT kle.id, kle.amount, cleb.end_date
6253: ,cleb.start_date -- added for bug 5115701
6254: FROM okc_k_lines_b cleb,
6255: okl_k_lines kle,
6256: okc_statuses_b okcsts
6257: WHERE cleb.dnz_chr_id = chrID
6258: AND kle.ID = cleb.ID
6541: (less than or equal to SYSDATE). */
6542:
6543: CURSOR l_k_std_csr ( chrID OKC_K_HEADERS_B.ID%TYPE ) IS
6544: SELECT 1
6545: FROM okc_k_lines_b cleb,
6546: okl_k_lines kle,
6547: okc_k_headers_b khr
6548: WHERE khr.id = chrID
6549: AND cleb.dnz_chr_id = khr.id
6642: AND sts.code = kle.sts_code
6643: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
6644:
6645: CURSOR l_fee_strm_csr (chrid OKL_K_HEADERS.KHR_ID%TYPE,
6646: lineid OKC_K_LINES_B.ID%TYPE) IS
6647: SELECT itm.object1_id1
6648: FROM okc_k_items itm
6649: WHERE cle_id = lineid
6650: AND dnz_chr_id = chrid
6982: CURSOR get_payment_lns (p_chr_id IN NUMBER) IS
6983: SELECT rgp.id,rgp.cle_id
6984: FROM OKC_RULE_GROUPS_B rgp,
6985: OKC_RULES_B crl2,
6986: okc_k_lines_b cleb,
6987: OKL_STRM_TYPE_B stty
6988: WHERE stty.id = crl2.object1_id1
6989: AND stty.stream_type_purpose = 'RENT'
6990: AND rgp.id = crl2.rgp_id
7135: model_cle.orig_system_id1 orig_model_cle_id,
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
7151: CURSOR l_ib_line_csr (p_chr_id IN NUMBER,
7152: p_fin_ast_cle_id IN NUMBER
7153: ) IS
7154: SELECT ib_cim.object1_id1 instance_id
7155: FROM okc_k_lines_b ib_cle,
7156: okc_k_lines_b inst_cle,
7157: okc_statuses_b sts,
7158: okc_k_items ib_cim
7159: WHERE inst_cle.dnz_chr_id = p_chr_id
7152: p_fin_ast_cle_id IN NUMBER
7153: ) IS
7154: SELECT ib_cim.object1_id1 instance_id
7155: FROM okc_k_lines_b ib_cle,
7156: okc_k_lines_b inst_cle,
7157: okc_statuses_b sts,
7158: okc_k_items ib_cim
7159: WHERE inst_cle.dnz_chr_id = p_chr_id
7160: AND inst_cle.cle_id = p_fin_ast_cle_id
7184: p_orig_chr_id IN NUMBER,
7185: p_rbk_chr_id IN NUMBER) IS
7186: SELECT orig_ib_cim.object1_id1 instance_id
7187: FROM okc_k_items orig_ib_cim,
7188: okc_k_lines_b orig_ib_cle,
7189: okc_k_lines_b orig_inst_cle,
7190: okc_statuses_b inst_sts
7191: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
7192: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
7185: p_rbk_chr_id IN NUMBER) IS
7186: SELECT orig_ib_cim.object1_id1 instance_id
7187: FROM okc_k_items orig_ib_cim,
7188: okc_k_lines_b orig_ib_cle,
7189: okc_k_lines_b orig_inst_cle,
7190: okc_statuses_b inst_sts
7191: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
7192: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
7193: AND orig_inst_cle.lse_id = 43
7200: AND inst_sts.code = orig_ib_cle.sts_code
7201: AND inst_sts.ste_code NOT IN ('HOLD', 'EXPIRED', 'TERMINATED', 'CANCELLED')
7202: AND NOT EXISTS (
7203: SELECT 1
7204: FROM okc_k_lines_b rbk_inst_cle,
7205: okc_statuses_b rbk_inst_sts
7206: WHERE rbk_inst_cle.orig_system_id1 = orig_inst_cle.id
7207: AND rbk_inst_cle.lse_id = 43
7208: AND rbk_inst_cle.dnz_chr_id = p_rbk_chr_id
7212:
7213: CURSOR check_svc_chr(p_object1_id1 IN VARCHAR2,
7214: p_jtot_object_code IN VARCHAR2) IS
7215: SELECT svc_cle.dnz_chr_id
7216: FROM okc_k_lines_b svc_cle,
7217: okc_k_items svc_item,
7218: okc_statuses_b sts,
7219: okc_k_headers_b svc_chr
7220: WHERE svc_item.object1_id1 = p_object1_id1
7229: CURSOR check_usage_svc_chr(p_instance_id IN NUMBER,
7230: p_jtot_object_code IN VARCHAR2,
7231: p_source_object_code IN VARCHAR2) IS
7232: SELECT svc_cle.dnz_chr_id
7233: FROM okc_k_lines_b svc_cle,
7234: okc_k_items svc_item,
7235: okc_statuses_b sts,
7236: okc_k_headers_b svc_chr,
7237: cs_counter_groups csg,
7405: AND sty.lty_code = 'FREE_FORM1'
7406: AND cle.sts_code = sts.code
7407: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
7408:
7409: CURSOR l_down_pmnt_check_csr(p_cle_id OKC_K_LINES_B.ID%TYPE) IS
7410: SELECT crg.cle_id,
7411: crl.id,
7412: crl.object1_id1,
7413: crl.RULE_INFORMATION6
7422: AND crg.cle_id = p_cle_id
7423: AND crg.dnz_chr_id = p_chr_id;
7424: l_down_pmnt_check_rec l_down_pmnt_check_csr%ROWTYPE;
7425:
7426: CURSOR l_down_pmnt_line_csr(p_id OKC_RULES_B.ID%TYPE, p_cle_id OKC_K_LINES_B.ID%TYPE) IS
7427: SELECT crl2.object1_id1,
7428: crl2.object1_id2,
7429: crl2.rule_information2,
7430: NVL(crl2.rule_information3,0) rule_information3,
7683: l_rpt_rec l_rpt_csr%ROWTYPE;
7684: l_report_tax_book VARCHAR2(256);
7685:
7686: CURSOR party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
7687: p_cle_id OKC_K_LINES_B.ID%TYPE) IS
7688: SELECT object1_id1
7689: FROM okc_k_party_roles_b
7690: WHERE dnz_chr_id = p_chr_id
7691: AND cle_id = p_cle_id
7713: AND sts.code = line.sts_code
7714: AND sts.ste_code NOT IN ('HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
7715: AND line.dnz_chr_id = p_chr_id;
7716:
7717: CURSOR sub_line_amt_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
7718: SELECT SUM(NVL(capital_amount,0))
7719: FROM okl_k_lines_full_v line
7720: WHERE line.cle_id = p_line_id;
7721:
10225: SELECT 1 FROM
10226: OKC_K_HEADERS_B chr,
10227: OKL_K_HEADERS khr,
10228: OKL_K_LINES kle,
10229: OKC_K_LINES_B cle,
10230: OKL_TRX_QUOTES_B qte,
10231: OKC_LINE_STYLES_B cls
10232: WHERE cle.id = kle.id
10233: AND chr.id = p_contract_id
10265: Cursor l_orig_ast_csr (p_chr_id in number) is
10266: select --trunc(orig_cleb.date_terminated) date_terminated,
10267: trunc(decode(sign(orig_cleb.end_date - orig_cleb.date_terminated),-1,orig_cleb.end_date,orig_cleb.date_terminated)) date_terminated,
10268: orig_clet.name asset_number
10269: from okc_k_lines_b orig_cleb,
10270: okc_k_lines_tl orig_clet,
10271: okc_k_lines_b cleb
10272: where orig_clet.id = orig_cleb.id
10273: and orig_clet.language = userenv('LANG')
10267: trunc(decode(sign(orig_cleb.end_date - orig_cleb.date_terminated),-1,orig_cleb.end_date,orig_cleb.date_terminated)) date_terminated,
10268: orig_clet.name asset_number
10269: from okc_k_lines_b orig_cleb,
10270: okc_k_lines_tl orig_clet,
10271: okc_k_lines_b cleb
10272: where orig_clet.id = orig_cleb.id
10273: and orig_clet.language = userenv('LANG')
10274: and orig_cleb.id = cleb.orig_system_id1
10275: and cleb.chr_id = p_chr_id
10634: --AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
10635: AND sts.ste_code not in ( 'HOLD', 'EXPIRED', 'CANCELLED');
10636:
10637: --Bug#3877032
10638: CURSOR link_asset_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
10639: SELECT line.start_date
10640: FROM okc_k_lines_b line,
10641: okc_k_items item
10642: WHERE item.cle_id = p_line_id
10636:
10637: --Bug#3877032
10638: CURSOR link_asset_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
10639: SELECT line.start_date
10640: FROM okc_k_lines_b line,
10641: okc_k_items item
10642: WHERE item.cle_id = p_line_id
10643: AND item.object1_id1 = line.id
10644: AND item.object1_id2 = '#'
10768: p_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE) IS
10769: SELECT COUNT(1)
10770: FROM okc_rules_b rule,
10771: okc_rule_groups_b rgp,
10772: okc_k_lines_b line,
10773: okc_line_styles_b style,
10774: okl_strm_type_b strm
10775: WHERE rgp.dnz_chr_id = p_chr_id
10776: AND rgp.cle_id IS NOT NULL
11132: kle.amount,
11133: kle.subsidy_override_amount
11134: FROM okl_k_lines kle,
11135: okc_k_lines_tl clet,
11136: okc_k_lines_b cleb,
11137: okc_line_styles_b lseb,
11138: okc_k_lines_tl clet_asst,
11139: okc_k_lines_b cleb_asst,
11140: okc_line_styles_b lseb_asst
11135: okc_k_lines_tl clet,
11136: okc_k_lines_b cleb,
11137: okc_line_styles_b lseb,
11138: okc_k_lines_tl clet_asst,
11139: okc_k_lines_b cleb_asst,
11140: okc_line_styles_b lseb_asst
11141: WHERE kle.id = cleb.id
11142: AND clet.id = cleb.id
11143: AND clet.LANGUAGE = USERENV('LANG')
11165: CURSOR check_refund_details(p_subsidy_cle_id NUMBER) IS
11166: SELECT pyd.vendor_id
11167: FROM okl_party_payment_dtls pyd,
11168: okc_k_party_roles_b cplb,
11169: okc_k_lines_b cleb
11170: WHERE pyd.cpl_id = cplb.id
11171: AND cplb.cle_id = cleb.id
11172: AND cplb.chr_id IS NULL
11173: AND cplb.RLE_CODE = 'OKL_VENDOR'
11803:
11804: CURSOR l_lne_csr (p_chr_id NUMBER) IS
11805: SELECT lne.id id,
11806: style.name line_type
11807: FROM okc_k_lines_b lne,
11808: okc_line_styles_v style
11809: WHERE dnz_chr_id = p_chr_id
11810: AND style.id = lne.lse_id;
11811:
11816: CURSOR l_financed_csr (p_chr_id NUMBER) IS
11817: SELECT cle.id,
11818: style.name line_type
11819: FROM okl_k_lines kle,
11820: okc_k_lines_b cle,
11821: okc_line_styles_v style
11822: WHERE cle.dnz_chr_id = p_chr_id
11823: AND cle.id = kle.id
11824: AND cle.lse_id = style.id
11826: AND NVL(kle.fee_purpose_code,'XXX') <> 'SALESTAX';
11827:
11828: --Bug#3877032
11829: CURSOR l_strm_slh_csr (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
11830: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
11831: SELECT styt.name stream_type,
11832: rule.id rule_id,
11833: rgp.id rgp_id
11834: FROM okc_rules_b rule,
12104: fab.cost original_cost,
12105: txl.depreciation_cost new_cost
12106: from okl_trx_assets trx,
12107: okl_txl_assets_b txl,
12108: okc_k_lines_b cleb,
12109: okc_statuses_b sts,
12110: fa_books fab,
12111: fa_additions fa
12112: where trx.id = txl.tas_id
12376:
12377: CURSOR l_fin_ast_cle_csr (p_chr_id IN NUMBER) IS
12378: SELECT cle.id,
12379: cle.orig_system_id1
12380: FROM okc_k_lines_b cle,
12381: okc_statuses_b sts
12382: WHERE cle.chr_id = p_chr_id
12383: AND cle.lse_id = 33 --Financial Asset Line
12384: and sts.code = cle.sts_code
12389: ,p_cle_id IN NUMBER) IS
12390: SELECT cle.id,
12391: cim.object1_id1,
12392: cim.object1_id2
12393: FROM okc_k_lines_b cle,
12394: okc_k_items cim,
12395: okc_line_styles_b lse,
12396: okc_statuses_b sts
12397: WHERE cle.dnz_chr_id = p_chr_id