[Home] [Help]
328: FROM DUAL
329: WHERE EXISTS
330: (
331: SELECT 1
332: FROM OKC_K_LINES_B fa_cle,
333: OKC_LINE_STYLES_B fa_lse,
334: OKC_STATUSES_B fa_sts,
335: OKC_K_ITEMS fa_cim,
336: FA_ADDITIONS_B FAB
353: SELECT 'Y'
354: FROM okc_k_headers_b chrb
355: WHERE chrb.id = chrid
356: AND EXISTS (SELECT '1'
357: FROM okc_k_lines_b cleb
358: WHERE cleb.chr_id = chrb.id
359: AND cleb.dnz_chr_id = chrb.id);
360: l_lines_exist VARCHAR2(1) DEFAULT 'N';
361: l_halt_process EXCEPTION;
1074: rulb2.RULE_INFORMATION3 level_periods,
1075: rulb2.RULE_INFORMATION7 stub_days,
1076: rulb2.RULE_INFORMATION8 stub_amount,
1077: rulb2.RULE_INFORMATION10 arrear_yn
1078: FROM okc_k_lines_b cleb,
1079: okc_rule_groups_b rgpb,
1080: okc_rules_b rulb,
1081: okc_rules_b rulb2,
1082: okl_strm_type_b styb
1543: e.ste_code ste_code -- 5264170
1544: FROM OKL_K_LINES a,
1545: OKC_K_LINES_TL b,
1546: OKC_LINE_STYLES_V C,
1547: OKC_K_LINES_B d,
1548: OKC_STATUSES_B e
1549: WHERE a.ID = p_id
1550: AND a.ID = b.ID
1551: AND b.LANGUAGE = USERENV('LANG')
3526: --Added by bkatraga for bug 9962314
3527: CURSOR l_sub_line_csr(p_chr_id IN NUMBER,
3528: p_cle_id IN NUMBER) IS
3529: SELECT cleb.id
3530: FROM okc_k_lines_b cleb
3531: WHERE cleb.cle_id = p_cle_id
3532: AND cleb.dnz_chr_id = p_chr_id
3533: AND cleb.sts_code <> 'ABANDONED';
3534:
4399: rule.object2_id1,
4400: 'Y' stub_only
4401: FROM okc_rules_b rule,
4402: okc_rule_groups_b rgp,
4403: okc_k_lines_b line,
4404: okc_line_styles_v style,
4405: okc_statuses_b sts
4406: WHERE rgp.id = rule.rgp_id
4407: AND rgp.rgd_code = 'LALEVL'
4523: --Bug# 16681373
4524: NVL(top_kle.re_lease_yn,'N') re_lease_yn
4525: FROM okc_k_lines_v top,
4526: okl_k_lines top_kle,
4527: okc_k_lines_b item,
4528: okc_line_styles_b item_style,
4529: okc_line_styles_b top_style,
4530: okc_k_items kitem,
4531: mtl_system_items mtl
4545: AND top.sts_code <> 'ABANDONED'
4546: AND top_kle.id = top.id;
4547:
4548: --Bug#3877032
4549: CURSOR ib_csr (p_top_cle_id OKC_K_LINES_B.ID%TYPE) IS
4550: SELECT COUNT(inst.serial_number) no_srl
4551: FROM okc_k_lines_b ib,
4552: okc_k_lines_b f2,
4553: okc_line_styles_b style,
4547:
4548: --Bug#3877032
4549: CURSOR ib_csr (p_top_cle_id OKC_K_LINES_B.ID%TYPE) IS
4550: SELECT COUNT(inst.serial_number) no_srl
4551: FROM okc_k_lines_b ib,
4552: okc_k_lines_b f2,
4553: okc_line_styles_b style,
4554: okl_txl_itm_insts inst
4555: WHERE f2.cle_id = p_top_cle_id
4548: --Bug#3877032
4549: CURSOR ib_csr (p_top_cle_id OKC_K_LINES_B.ID%TYPE) IS
4550: SELECT COUNT(inst.serial_number) no_srl
4551: FROM okc_k_lines_b ib,
4552: okc_k_lines_b f2,
4553: okc_line_styles_b style,
4554: okl_txl_itm_insts inst
4555: WHERE f2.cle_id = p_top_cle_id
4556: AND f2.lse_id = style.id
4562: --Bug# 16098797
4563: AND f2.sts_code <> 'ABANDONED';
4564:
4565: --Bug# 16098797
4566: CURSOR new_ib_srl_csr (p_top_cle_id OKC_K_LINES_B.ID%TYPE) IS
4567: SELECT inst.serial_number
4568: FROM okc_k_lines_b ib,
4569: okc_k_lines_b f2,
4570: okc_line_styles_b style,
4564:
4565: --Bug# 16098797
4566: CURSOR new_ib_srl_csr (p_top_cle_id OKC_K_LINES_B.ID%TYPE) IS
4567: SELECT inst.serial_number
4568: FROM okc_k_lines_b ib,
4569: okc_k_lines_b f2,
4570: okc_line_styles_b style,
4571: okl_txl_itm_insts inst
4572: WHERE f2.cle_id = p_top_cle_id
4565: --Bug# 16098797
4566: CURSOR new_ib_srl_csr (p_top_cle_id OKC_K_LINES_B.ID%TYPE) IS
4567: SELECT inst.serial_number
4568: FROM okc_k_lines_b ib,
4569: okc_k_lines_b f2,
4570: okc_line_styles_b style,
4571: okl_txl_itm_insts inst
4572: WHERE f2.cle_id = p_top_cle_id
4573: AND f2.lse_id = style.id
4679:
4680: CURSOR ib_line_csr(p_chr_id NUMBER) IS
4681: SELECT cle.id,
4682: cle.cle_id
4683: FROM okc_k_lines_b cle,
4684: okc_statuses_b sts
4685: WHERE cle.lse_id = G_IB_LINE_LTY_ID
4686: AND cle.dnz_chr_id = p_chr_id
4687: AND cle.sts_code = sts.code
4760:
4761:
4762: CURSOR asset_num_csr(p_cle_id NUMBER) IS
4763: SELECT name
4764: FROM okc_k_lines_b cle1,
4765: okc_k_lines_tl cle_tl,
4766: okc_k_lines_b cle2
4767: WHERE cle_tl.id = cle2.id
4768: AND cle1.id = p_cle_id
4762: CURSOR asset_num_csr(p_cle_id NUMBER) IS
4763: SELECT name
4764: FROM okc_k_lines_b cle1,
4765: okc_k_lines_tl cle_tl,
4766: okc_k_lines_b cle2
4767: WHERE cle_tl.id = cle2.id
4768: AND cle1.id = p_cle_id
4769: AND cle2.id = cle1.cle_id
4770: AND cle_tl.language = USERENV('LANG');
5138: CURSOR c_fin_fee (p_khr_id OKC_K_HEADERS_B.ID%TYPE) IS
5139: SELECT cle.id,
5140: DECODE (lse.lty_code, 'FREE_FORM1', 'ASSET', 'FEE', 'FEE',
5141: 'SOLD_SERVICE','SERVICE') line_type
5142: FROM okc_k_lines_b cle,
5143: okc_line_styles_b lse,
5144: okc_statuses_b sts
5145: WHERE cle.chr_id = p_khr_id
5146: AND cle.lse_id = lse.id
5148: AND sts.ste_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED')
5149: AND lse.lty_code IN ('FREE_FORM1', 'FEE', 'SOLD_SERVICE');
5150:
5151: CURSOR c_strm_sll (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
5152: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
5153: SELECT sll.rule_information2 start_date,
5154: SLL.rule_information3 periods,
5155: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
5156: ( select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
5175: --ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
5176:
5177: /*
5178: CURSOR c_strm_sll_ext (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
5179: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
5180: SELECT
5181: SUM(NVL(TO_NUMBER(SLL.rule_information3),0)) periods,
5182: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
5183: styt.name stream_type
5201: */
5202:
5203: --Bug#3877032
5204: CURSOR c_strm_slh_ext (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
5205: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
5206: SELECT (select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT
5207: where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
5208: AND to_number(RULE.OBJECT1_ID1) = STY.ID ) STREAM_TYPE,
5209: rule.id rule_id,
5254: l_pmnt_end_date DATE;
5255:
5256: -- START: cklee/mvasudev,06-02-2005,Bug#4392051/okl.h 4437938
5257: CURSOR c_strm_sll_count (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
5258: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
5259: SELECT COUNT(sll.id)
5260: FROM okc_rules_b sll,
5261: okc_rules_b slh,
5262: okc_rule_groups_b rgp,
5732:
5733:
5734: CURSOR l_assets_asso_csr(chrId IN NUMBER, kleId in NUMBER) IS
5735: SELECT cleb.id
5736: FROM okc_k_lines_b cleb
5737:
5738: WHERE cleb.dnz_chr_id = chrId
5739: AND cleb.chr_id = chrId
5740: AND CLEB.ID =kleId
5739: AND cleb.chr_id = chrId
5740: AND CLEB.ID =kleId
5741: and exists
5742: ( SELECT '1'
5743: FROM okc_k_lines_b cleb1,
5744: okc_statuses_b okcsts1
5745: WHERE cleb1.dnz_chr_id = cleb.chr_id
5746: AND cleb1.cle_id = cleb.id
5747: AND okcsts1.code = cleb1.sts_code
6163: for top fee line of a given contract. */
6164:
6165: CURSOR l_rq_top_fee_ln_csr1 ( chrID IN OKC_K_HEADERS_B.ID%TYPE ) IS
6166: SELECT kle.qte_id
6167: FROM okc_k_lines_b cleb,
6168: okl_k_lines kle
6169: WHERE cleb.dnz_chr_id = chrID
6170: AND kle.ID = cleb.ID
6171: AND kle.fee_type = 'ROLLOVER'
6182:
6183: CURSOR l_rq_sub_ln_fee_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6184: feeTopLine IN OKL_K_LINES.ID%TYPE) IS
6185: SELECT kle.id, kle.amount, cleb.end_date
6186: FROM okc_k_lines_b cleb,
6187: okl_k_lines kle
6188: WHERE cleb.dnz_chr_id = chrID
6189: AND kle.ID = cleb.ID
6190: AND cleb.CLE_ID = feeTopLine
6637: CURSOR l_fn_sub_ln_fee_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE,
6638: feeTopLine IN OKL_K_LINES.ID%TYPE) IS
6639: SELECT kle.id, kle.amount, cleb.end_date
6640: ,cleb.start_date -- added for bug 5115701
6641: FROM okc_k_lines_b cleb,
6642: okl_k_lines kle,
6643: okc_statuses_b okcsts
6644: WHERE cleb.dnz_chr_id = chrID
6645: AND kle.ID = cleb.ID
6928: (less than or equal to SYSDATE). */
6929:
6930: CURSOR l_k_std_csr ( chrID OKC_K_HEADERS_B.ID%TYPE ) IS
6931: SELECT 1
6932: FROM okc_k_lines_b cleb,
6933: okl_k_lines kle,
6934: okc_k_headers_b khr
6935: WHERE khr.id = chrID
6936: AND cleb.dnz_chr_id = khr.id
7029: AND sts.code = kle.sts_code
7030: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
7031:
7032: CURSOR l_fee_strm_csr (chrid OKL_K_HEADERS.KHR_ID%TYPE,
7033: lineid OKC_K_LINES_B.ID%TYPE) IS
7034: SELECT itm.object1_id1
7035: FROM okc_k_items itm
7036: WHERE cle_id = lineid
7037: AND dnz_chr_id = chrid
7369: CURSOR get_payment_lns (p_chr_id IN NUMBER) IS
7370: SELECT rgp.id,rgp.cle_id
7371: FROM OKC_RULE_GROUPS_B rgp,
7372: OKC_RULES_B crl2,
7373: okc_k_lines_b cleb,
7374: OKL_STRM_TYPE_B stty
7375: WHERE stty.id = crl2.object1_id1
7376: AND stty.stream_type_purpose = 'RENT'
7377: AND rgp.id = crl2.rgp_id
7529: model_cle.orig_system_id1 orig_model_cle_id,
7530: fin_ast_cle.id rbk_fin_ast_cle_id,
7531: fin_ast_cle.orig_system_id1 orig_fin_ast_cle_id,
7532: fin_ast_cle.name asset_number
7533: FROM okc_k_lines_b model_cle,
7534: okc_k_lines_v fin_ast_cle,
7535: okc_statuses_b sts
7536: WHERE fin_ast_cle.chr_id = p_chr_id
7537: AND fin_ast_cle.dnz_chr_id = p_chr_id
7545: CURSOR l_ib_line_csr (p_chr_id IN NUMBER,
7546: p_fin_ast_cle_id IN NUMBER
7547: ) IS
7548: SELECT ib_cim.object1_id1 instance_id
7549: FROM okc_k_lines_b ib_cle,
7550: okc_k_lines_b inst_cle,
7551: okc_statuses_b sts,
7552: okc_k_items ib_cim
7553: WHERE inst_cle.dnz_chr_id = p_chr_id
7546: p_fin_ast_cle_id IN NUMBER
7547: ) IS
7548: SELECT ib_cim.object1_id1 instance_id
7549: FROM okc_k_lines_b ib_cle,
7550: okc_k_lines_b inst_cle,
7551: okc_statuses_b sts,
7552: okc_k_items ib_cim
7553: WHERE inst_cle.dnz_chr_id = p_chr_id
7554: AND inst_cle.cle_id = p_fin_ast_cle_id
7578: p_orig_chr_id IN NUMBER,
7579: p_rbk_chr_id IN NUMBER) IS
7580: SELECT orig_ib_cim.object1_id1 instance_id
7581: FROM okc_k_items orig_ib_cim,
7582: okc_k_lines_b orig_ib_cle,
7583: okc_k_lines_b orig_inst_cle,
7584: okc_statuses_b inst_sts
7585: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
7586: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
7579: p_rbk_chr_id IN NUMBER) IS
7580: SELECT orig_ib_cim.object1_id1 instance_id
7581: FROM okc_k_items orig_ib_cim,
7582: okc_k_lines_b orig_ib_cle,
7583: okc_k_lines_b orig_inst_cle,
7584: okc_statuses_b inst_sts
7585: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
7586: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
7587: AND orig_inst_cle.lse_id = 43
7594: AND inst_sts.code = orig_ib_cle.sts_code
7595: AND inst_sts.ste_code NOT IN ('HOLD', 'EXPIRED', 'TERMINATED', 'CANCELLED')
7596: AND NOT EXISTS (
7597: SELECT 1
7598: FROM okc_k_lines_b rbk_inst_cle,
7599: okc_statuses_b rbk_inst_sts
7600: WHERE rbk_inst_cle.orig_system_id1 = orig_inst_cle.id
7601: AND rbk_inst_cle.lse_id = 43
7602: AND rbk_inst_cle.dnz_chr_id = p_rbk_chr_id
7606:
7607: CURSOR check_svc_chr(p_object1_id1 IN VARCHAR2,
7608: p_jtot_object_code IN VARCHAR2) IS
7609: SELECT svc_cle.dnz_chr_id
7610: FROM okc_k_lines_b svc_cle,
7611: okc_k_items svc_item,
7612: okc_statuses_b sts,
7613: okc_k_headers_b svc_chr
7614: WHERE svc_item.object1_id1 = p_object1_id1
7623: CURSOR check_usage_svc_chr(p_instance_id IN NUMBER,
7624: p_jtot_object_code IN VARCHAR2,
7625: p_source_object_code IN VARCHAR2) IS
7626: SELECT svc_cle.dnz_chr_id
7627: FROM okc_k_lines_b svc_cle,
7628: okc_k_items svc_item,
7629: okc_statuses_b sts,
7630: okc_k_headers_b svc_chr,
7631: cs_counter_groups csg,
7799: AND sty.lty_code = 'FREE_FORM1'
7800: AND cle.sts_code = sts.code
7801: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
7802:
7803: CURSOR l_down_pmnt_check_csr(p_cle_id OKC_K_LINES_B.ID%TYPE) IS
7804: SELECT crg.cle_id,
7805: crl.id,
7806: crl.object1_id1,
7807: crl.RULE_INFORMATION6
7816: AND crg.cle_id = p_cle_id
7817: AND crg.dnz_chr_id = p_chr_id;
7818: l_down_pmnt_check_rec l_down_pmnt_check_csr%ROWTYPE;
7819:
7820: CURSOR l_down_pmnt_line_csr(p_id OKC_RULES_B.ID%TYPE, p_cle_id OKC_K_LINES_B.ID%TYPE) IS
7821: SELECT crl2.object1_id1,
7822: crl2.object1_id2,
7823: crl2.rule_information2,
7824: NVL(crl2.rule_information3,0) rule_information3,
7837: -- when fetching Tradein amount
7838: CURSOR l_line_tradein_csr IS
7839: SELECT kle.tradein_amount
7840: FROM okl_k_lines kle,
7841: okc_k_lines_b cle,
7842: okc_line_styles_b lse,
7843: okc_statuses_b sts
7844: WHERE cle.id = kle.id
7845: AND cle.dnz_chr_id = p_chr_id
8100: l_rpt_rec l_rpt_csr%ROWTYPE;
8101: l_report_tax_book VARCHAR2(256);
8102:
8103: CURSOR party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
8104: p_cle_id OKC_K_LINES_B.ID%TYPE) IS
8105: SELECT object1_id1
8106: FROM okc_k_party_roles_b
8107: WHERE dnz_chr_id = p_chr_id
8108: AND cle_id = p_cle_id
8130: AND sts.code = line.sts_code
8131: AND sts.ste_code NOT IN ('HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
8132: AND line.dnz_chr_id = p_chr_id;
8133:
8134: CURSOR sub_line_amt_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
8135: SELECT SUM(NVL(capital_amount,0))
8136: FROM okl_k_lines_full_v line
8137: WHERE line.cle_id = p_line_id;
8138:
10646: SELECT 1 FROM
10647: OKC_K_HEADERS_B chr,
10648: OKL_K_HEADERS khr,
10649: OKL_K_LINES kle,
10650: OKC_K_LINES_B cle,
10651: OKL_TRX_QUOTES_B qte,
10652: OKC_LINE_STYLES_B cls
10653: WHERE cle.id = kle.id
10654: AND chr.id = p_contract_id
10684: Cursor l_orig_ast_csr (p_chr_id in number) is
10685: select --trunc(orig_cleb.date_terminated) date_terminated,
10686: trunc(decode(sign(orig_cleb.end_date - orig_cleb.date_terminated),-1,orig_cleb.end_date,orig_cleb.date_terminated)) date_terminated,
10687: orig_clet.name asset_number
10688: from okc_k_lines_b orig_cleb,
10689: okc_k_lines_tl orig_clet,
10690: okc_k_lines_b cleb,
10691: okl_k_lines kle
10692: where orig_clet.id = orig_cleb.id
10686: trunc(decode(sign(orig_cleb.end_date - orig_cleb.date_terminated),-1,orig_cleb.end_date,orig_cleb.date_terminated)) date_terminated,
10687: orig_clet.name asset_number
10688: from okc_k_lines_b orig_cleb,
10689: okc_k_lines_tl orig_clet,
10690: okc_k_lines_b cleb,
10691: okl_k_lines kle
10692: where orig_clet.id = orig_cleb.id
10693: and orig_clet.language = userenv('LANG')
10694: and orig_cleb.id = cleb.orig_system_id1
11057: --AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
11058: AND sts.ste_code not in ( 'HOLD', 'EXPIRED', 'CANCELLED');
11059:
11060: --Bug#3877032
11061: CURSOR link_asset_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
11062: SELECT line.start_date
11063: FROM okc_k_lines_b line,
11064: okc_k_items item
11065: WHERE item.cle_id = p_line_id
11059:
11060: --Bug#3877032
11061: CURSOR link_asset_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
11062: SELECT line.start_date
11063: FROM okc_k_lines_b line,
11064: okc_k_items item
11065: WHERE item.cle_id = p_line_id
11066: AND item.object1_id1 = line.id
11067: AND item.object1_id2 = '#'
11191: p_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE) IS
11192: SELECT COUNT(1)
11193: FROM okc_rules_b rule,
11194: okc_rule_groups_b rgp,
11195: okc_k_lines_b line,
11196: okc_line_styles_b style,
11197: okl_strm_type_b strm
11198: WHERE rgp.dnz_chr_id = p_chr_id
11199: AND rgp.cle_id IS NOT NULL
11555: kle.amount,
11556: kle.subsidy_override_amount
11557: FROM okl_k_lines kle,
11558: okc_k_lines_tl clet,
11559: okc_k_lines_b cleb,
11560: okc_line_styles_b lseb,
11561: okc_k_lines_tl clet_asst,
11562: okc_k_lines_b cleb_asst,
11563: okc_line_styles_b lseb_asst
11558: okc_k_lines_tl clet,
11559: okc_k_lines_b cleb,
11560: okc_line_styles_b lseb,
11561: okc_k_lines_tl clet_asst,
11562: okc_k_lines_b cleb_asst,
11563: okc_line_styles_b lseb_asst
11564: WHERE kle.id = cleb.id
11565: AND clet.id = cleb.id
11566: AND clet.LANGUAGE = USERENV('LANG')
11588: CURSOR check_refund_details(p_subsidy_cle_id NUMBER) IS
11589: SELECT pyd.vendor_id
11590: FROM okl_party_payment_dtls pyd,
11591: okc_k_party_roles_b cplb,
11592: okc_k_lines_b cleb
11593: WHERE pyd.cpl_id = cplb.id
11594: AND cplb.cle_id = cleb.id
11595: AND cplb.chr_id IS NULL
11596: AND cplb.RLE_CODE = 'OKL_VENDOR'
12226:
12227: CURSOR l_lne_csr (p_chr_id NUMBER) IS
12228: SELECT lne.id id,
12229: style.name line_type
12230: FROM okc_k_lines_b lne,
12231: okc_line_styles_v style
12232: WHERE dnz_chr_id = p_chr_id
12233: AND style.id = lne.lse_id;
12234:
12239: CURSOR l_financed_csr (p_chr_id NUMBER) IS
12240: SELECT cle.id,
12241: style.name line_type
12242: FROM okl_k_lines kle,
12243: okc_k_lines_b cle,
12244: okc_line_styles_v style
12245: WHERE cle.dnz_chr_id = p_chr_id
12246: AND cle.id = kle.id
12247: AND cle.lse_id = style.id
12249: AND NVL(kle.fee_purpose_code,'XXX') <> 'SALESTAX';
12250:
12251: --Bug#3877032
12252: CURSOR l_strm_slh_csr (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
12253: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
12254: SELECT styt.name stream_type,
12255: rule.id rule_id,
12256: rgp.id rgp_id
12257: FROM okc_rules_b rule,
12527: fab.cost original_cost,
12528: txl.depreciation_cost new_cost
12529: from okl_trx_assets trx,
12530: okl_txl_assets_b txl,
12531: okc_k_lines_b cleb,
12532: okc_statuses_b sts,
12533: fa_books fab,
12534: fa_additions fa
12535: where trx.id = txl.tas_id
12928:
12929: CURSOR l_fin_ast_cle_csr (p_chr_id IN NUMBER) IS
12930: SELECT cle.id,
12931: cle.orig_system_id1
12932: FROM okc_k_lines_b cle,
12933: okc_statuses_b sts
12934: WHERE cle.chr_id = p_chr_id
12935: AND cle.lse_id = 33 --Financial Asset Line
12936: and sts.code = cle.sts_code
12941: ,p_cle_id IN NUMBER) IS
12942: SELECT cle.id,
12943: cim.object1_id1,
12944: cim.object1_id2
12945: FROM okc_k_lines_b cle,
12946: okc_k_items cim,
12947: okc_line_styles_b lse,
12948: okc_statuses_b sts
12949: WHERE cle.dnz_chr_id = p_chr_id
13511: txl.asset_number asset_number,
13512: txl.in_service_date in_service_date
13513: FROM okl_trx_assets trx,
13514: okl_txl_assets_b txl,
13515: okc_k_lines_b cleb_fa,
13516: okc_statuses_b sts,
13517: okc_k_lines_b cleb_fin,
13518: okl_k_lines kle_fin
13519: WHERE trx.id = txl.tas_id
13513: FROM okl_trx_assets trx,
13514: okl_txl_assets_b txl,
13515: okc_k_lines_b cleb_fa,
13516: okc_statuses_b sts,
13517: okc_k_lines_b cleb_fin,
13518: okl_k_lines kle_fin
13519: WHERE trx.id = txl.tas_id
13520: AND trx.tsu_code = 'ENTERED'
13521: AND trx.tas_type IN ('CFA','CRB')
13750: clet_rbk.name,
13751: cleb_rbk.start_date,
13752: kle_rbk.capital_amount new_capital_amount,
13753: kle_orig.capital_amount orig_capital_amount
13754: FROM okc_k_lines_b cleb_rbk,
13755: okc_k_lines_tl clet_rbk,
13756: okl_k_lines kle_rbk,
13757: okl_k_lines kle_orig,
13758: okc_statuses_b sts
13771: clet_rbk.name,
13772: cleb_rbk.start_date,
13773: kle_rbk.amount new_amount,
13774: kle_orig.amount orig_amount
13775: FROM okc_k_lines_b cleb_rbk,
13776: okc_k_lines_tl clet_rbk,
13777: okl_k_lines kle_rbk,
13778: okl_k_lines kle_orig,
13779: okc_statuses_b sts
13792: clet_rbk.name,
13793: cleb_sub_rbk.start_date,
13794: kle_sub_rbk.amount new_amount,
13795: kle_sub_orig.amount orig_amount
13796: FROM okc_k_lines_b cleb_rbk,
13797: okc_k_lines_tl clet_rbk,
13798: okl_k_lines kle_rbk,
13799: okc_k_lines_b cleb_sub_rbk,
13800: okl_k_lines kle_sub_rbk,
13795: kle_sub_orig.amount orig_amount
13796: FROM okc_k_lines_b cleb_rbk,
13797: okc_k_lines_tl clet_rbk,
13798: okl_k_lines kle_rbk,
13799: okc_k_lines_b cleb_sub_rbk,
13800: okl_k_lines kle_sub_rbk,
13801: okl_k_lines kle_sub_orig,
13802: okc_statuses_b sts
13803: WHERE cleb_rbk.chr_id = p_chr_id
13976: SELECT cleb_rbk.id rbk_cle_id,
13977: cleb_rbk.orig_system_id1 orig_cle_id,
13978: clet_rbk.name,
13979: cleb_rbk.start_date
13980: FROM okc_k_lines_b cleb_rbk,
13981: okc_k_lines_tl clet_rbk,
13982: okc_statuses_b sts
13983: WHERE cleb_rbk.chr_id = p_chr_id
13984: AND cleb_rbk.dnz_chr_id = p_chr_id
13993: SELECT cleb_rbk.id rbk_cle_id,
13994: cleb_rbk.orig_system_id1 orig_cle_id,
13995: clet_rbk.name,
13996: cleb_rbk.start_date
13997: FROM okc_k_lines_b cleb_rbk,
13998: okc_k_lines_tl clet_rbk,
13999: okl_k_lines kle_rbk,
14000: okc_statuses_b sts
14001: WHERE cleb_rbk.chr_id = p_chr_id
14012: SELECT cleb_sub_rbk.id rbk_cle_id,
14013: cleb_sub_rbk.orig_system_id1 orig_cle_id,
14014: clet_rbk.name,
14015: cleb_sub_rbk.start_date
14016: FROM okc_k_lines_b cleb_rbk,
14017: okc_k_lines_tl clet_rbk,
14018: okl_k_lines kle_rbk,
14019: okc_k_lines_b cleb_sub_rbk,
14020: okc_statuses_b sts
14015: cleb_sub_rbk.start_date
14016: FROM okc_k_lines_b cleb_rbk,
14017: okc_k_lines_tl clet_rbk,
14018: okl_k_lines kle_rbk,
14019: okc_k_lines_b cleb_sub_rbk,
14020: okc_statuses_b sts
14021: WHERE cleb_rbk.chr_id = p_chr_id
14022: AND cleb_rbk.dnz_chr_id = p_chr_id
14023: AND cleb_rbk.lse_id = 52
14173: clet.name,
14174: cleb.start_date,
14175: kle.date_delivery_expected,
14176: kle.date_funding_expected
14177: FROM okc_k_lines_b cleb,
14178: okc_k_lines_tl clet,
14179: okl_k_lines kle,
14180: okc_statuses_b sts
14181: WHERE cleb.chr_id = p_chr_id