[Home] [Help]
1483: CIM.LAST_UPDATE_DATE,
1484: CIM.LAST_UPDATE_LOGIN
1485: FROM okc_k_items_v cim,
1486: okc_k_lines_b cle,
1487: okc_line_styles_b lse,
1488: okc_k_lines_b cle1
1489: WHERE cim.dnz_chr_id = p_dnz_chr_id
1490: AND cim.cle_id = cle.id
1491: AND cle.lse_id = lse.id
1800:
1801: CURSOR c_get_lse_id1(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
1802: SELECT lse.id
1803: FROM okc_subclass_top_line stl,
1804: okc_line_styles_b lse
1805: WHERE lse.lty_code = G_FIN_LINE_LTY_CODE
1806: AND lse.lse_parent_id is null
1807: AND lse.lse_type = G_TLS_TYPE
1808: AND lse.id = stl.lse_id
1810:
1811: CURSOR c_get_lse_id2(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
1812: SELECT lse1.id
1813: FROM okc_subclass_top_line stl,
1814: okc_line_styles_b lse2,
1815: okc_line_styles_b lse1
1816: WHERE lse1.lty_code = p_code
1817: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
1818: AND lse1.lse_parent_id = lse2.id
1811: CURSOR c_get_lse_id2(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
1812: SELECT lse1.id
1813: FROM okc_subclass_top_line stl,
1814: okc_line_styles_b lse2,
1815: okc_line_styles_b lse1
1816: WHERE lse1.lty_code = p_code
1817: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
1818: AND lse1.lse_parent_id = lse2.id
1819: AND lse2.id = stl.lse_id
1822: CURSOR c_get_lse_id3(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE,
1823: p_code2 OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
1824: SELECT lse1.id
1825: FROM okc_subclass_top_line stl,
1826: okc_line_styles_b lse3,
1827: okc_line_styles_b lse2,
1828: okc_line_styles_b lse1
1829: WHERE lse1.lty_code = p_code
1830: AND lse1.lse_parent_id = lse2.id
1823: p_code2 OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
1824: SELECT lse1.id
1825: FROM okc_subclass_top_line stl,
1826: okc_line_styles_b lse3,
1827: okc_line_styles_b lse2,
1828: okc_line_styles_b lse1
1829: WHERE lse1.lty_code = p_code
1830: AND lse1.lse_parent_id = lse2.id
1831: AND lse2.lty_code = p_code2
1824: SELECT lse1.id
1825: FROM okc_subclass_top_line stl,
1826: okc_line_styles_b lse3,
1827: okc_line_styles_b lse2,
1828: okc_line_styles_b lse1
1829: WHERE lse1.lty_code = p_code
1830: AND lse1.lse_parent_id = lse2.id
1831: AND lse2.lty_code = p_code2
1832: AND lse2.lse_parent_id = lse3.id
3865:
3866: lv_sts_code OKC_K_LINES_V.STS_CODE%TYPE;
3867: lv_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE;
3868:
3869: CURSOR c_lty_code_validate(p_lse_id OKC_LINE_STYLES_B.ID%TYPE) IS
3870: SELECT lse.lty_code
3871: FROM OKC_LINE_STYLES_V lse
3872: WHERE lse.id = p_lse_id;
3873:
6436: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6437: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6438: SELECT cle.display_sequence,
6439: cim.number_of_items
6440: FROM okc_line_styles_b lse2,
6441: okc_line_styles_b lse1,
6442: okc_k_items cim,
6443: okc_k_lines_b cle
6444: WHERE cle.id = p_cle_id
6437: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6438: SELECT cle.display_sequence,
6439: cim.number_of_items
6440: FROM okc_line_styles_b lse2,
6441: okc_line_styles_b lse1,
6442: okc_k_items cim,
6443: okc_k_lines_b cle
6444: WHERE cle.id = p_cle_id
6445: AND cle.dnz_chr_id = p_dnz_chr_id
6645: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6646: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6647: SELECT cle.display_sequence,
6648: cim.number_of_items
6649: FROM okc_line_styles_b lse2,
6650: okc_line_styles_b lse1,
6651: okc_k_items cim,
6652: okc_k_lines_b cle
6653: WHERE cle.id = p_cle_id
6646: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6647: SELECT cle.display_sequence,
6648: cim.number_of_items
6649: FROM okc_line_styles_b lse2,
6650: okc_line_styles_b lse1,
6651: okc_k_items cim,
6652: okc_k_lines_b cle
6653: WHERE cle.id = p_cle_id
6654: AND cle.dnz_chr_id = p_dnz_chr_id
6857: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
6858: IS
6859: SELECT cle.id
6860: FROM okc_subclass_top_line stl,
6861: okc_line_styles_b lse2,
6862: okc_line_styles_b lse1,
6863: okc_k_lines_b cle
6864: WHERE cle.dnz_chr_id = p_dnz_chr_id
6865: AND cle.lse_id = lse1.id
6858: IS
6859: SELECT cle.id
6860: FROM okc_subclass_top_line stl,
6861: okc_line_styles_b lse2,
6862: okc_line_styles_b lse1,
6863: okc_k_lines_b cle
6864: WHERE cle.dnz_chr_id = p_dnz_chr_id
6865: AND cle.lse_id = lse1.id
6866: AND lse1.lty_code = G_FA_LINE_LTY_CODE
6869: AND lse2.id = stl.lse_id
6870: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
6871: AND cle.cle_id in (SELECT distinct to_char(cle.cle_id)
6872: FROM okc_subclass_top_line stl,
6873: okc_line_styles_b lse2,
6874: okc_line_styles_b lse1,
6875: okc_k_lines_b cle
6876: WHERE cle.id = p_top_line
6877: AND cle.dnz_chr_id = p_dnz_chr_id
6870: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
6871: AND cle.cle_id in (SELECT distinct to_char(cle.cle_id)
6872: FROM okc_subclass_top_line stl,
6873: okc_line_styles_b lse2,
6874: okc_line_styles_b lse1,
6875: okc_k_lines_b cle
6876: WHERE cle.id = p_top_line
6877: AND cle.dnz_chr_id = p_dnz_chr_id
6878: AND cle.lse_id = lse1.id
7055: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
7056: IS
7057: SELECT cle.id
7058: FROM okc_subclass_top_line stl,
7059: okc_line_styles_b lse2,
7060: okc_line_styles_b lse1,
7061: okc_k_lines_b cle
7062: WHERE cle.dnz_chr_id = p_dnz_chr_id
7063: AND cle.lse_id = lse1.id
7056: IS
7057: SELECT cle.id
7058: FROM okc_subclass_top_line stl,
7059: okc_line_styles_b lse2,
7060: okc_line_styles_b lse1,
7061: okc_k_lines_b cle
7062: WHERE cle.dnz_chr_id = p_dnz_chr_id
7063: AND cle.lse_id = lse1.id
7064: AND lse1.lty_code = G_FA_LINE_LTY_CODE
7067: AND lse2.id = stl.lse_id
7068: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
7069: AND cle.cle_id in (SELECT distinct to_char(cle.cle_id)
7070: FROM okc_subclass_top_line stl,
7071: okc_line_styles_b lse2,
7072: okc_line_styles_b lse1,
7073: okc_k_lines_b cle
7074: WHERE cle.id = p_top_line
7075: AND cle.dnz_chr_id = p_dnz_chr_id
7068: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
7069: AND cle.cle_id in (SELECT distinct to_char(cle.cle_id)
7070: FROM okc_subclass_top_line stl,
7071: okc_line_styles_b lse2,
7072: okc_line_styles_b lse1,
7073: okc_k_lines_b cle
7074: WHERE cle.id = p_top_line
7075: AND cle.dnz_chr_id = p_dnz_chr_id
7076: AND cle.lse_id = lse1.id
8430: IS
8431: -- #4414408
8432: SELECT cle.id
8433: -- FROM okc_subclass_top_line stl,
8434: -- okc_line_styles_b lse2,
8435: -- okc_line_styles_b lse1,
8436: FROM okc_k_lines_b cle
8437: WHERE cle.cle_id = p_top_line
8438: AND cle.dnz_chr_id = p_dnz_chr_id
8431: -- #4414408
8432: SELECT cle.id
8433: -- FROM okc_subclass_top_line stl,
8434: -- okc_line_styles_b lse2,
8435: -- okc_line_styles_b lse1,
8436: FROM okc_k_lines_b cle
8437: WHERE cle.cle_id = p_top_line
8438: AND cle.dnz_chr_id = p_dnz_chr_id
8439: -- AND lse1.id = cle.lse_id
8675: CURSOR c_get_lse_id_sts(p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
8676: SELECT lse.id,
8677: cle.sts_code
8678: FROM okc_subclass_top_line stl,
8679: okc_line_styles_b lse,
8680: okc_k_lines_v cle
8681: WHERE cle.id = p_top_line_id
8682: AND cle.lse_id = lse.id
8683: AND lse.lty_code = G_FIN_LINE_LTY_CODE
8941: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
8942: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
8943: SELECT cle.cle_id
8944: FROM okc_subclass_top_line stl,
8945: okc_line_styles_b lse2,
8946: okc_line_styles_b lse1,
8947: okc_k_items_v cim,
8948: okc_k_lines_v cle
8949: WHERE cle.id = p_model_line_id
8942: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
8943: SELECT cle.cle_id
8944: FROM okc_subclass_top_line stl,
8945: okc_line_styles_b lse2,
8946: okc_line_styles_b lse1,
8947: okc_k_items_v cim,
8948: okc_k_lines_v cle
8949: WHERE cle.id = p_model_line_id
8950: AND cle.dnz_chr_id = p_dnz_chr_id
9147: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9148: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9149: SELECT cle.cle_id
9150: FROM okc_subclass_top_line stl,
9151: okc_line_styles_b lse2,
9152: okc_line_styles_b lse1,
9153: okc_k_items_v cim,
9154: okc_k_lines_v cle
9155: WHERE cle.id = p_model_line_id
9148: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9149: SELECT cle.cle_id
9150: FROM okc_subclass_top_line stl,
9151: okc_line_styles_b lse2,
9152: okc_line_styles_b lse1,
9153: okc_k_items_v cim,
9154: okc_k_lines_v cle
9155: WHERE cle.id = p_model_line_id
9156: AND cle.dnz_chr_id = p_dnz_chr_id
9352: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9353: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9354: SELECT cle.cle_id
9355: FROM okc_subclass_top_line stl,
9356: okc_line_styles_b lse2,
9357: okc_line_styles_b lse1,
9358: okc_k_items_v cim,
9359: okc_k_lines_v cle
9360: WHERE cle.id = p_model_line_id
9353: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9354: SELECT cle.cle_id
9355: FROM okc_subclass_top_line stl,
9356: okc_line_styles_b lse2,
9357: okc_line_styles_b lse1,
9358: okc_k_items_v cim,
9359: okc_k_lines_v cle
9360: WHERE cle.id = p_model_line_id
9361: AND cle.dnz_chr_id = p_dnz_chr_id
9859: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
9860: IS
9861: SELECT cle.id
9862: FROM okc_subclass_top_line stl,
9863: okc_line_styles_b lse2,
9864: okc_line_styles_b lse1,
9865: okc_k_lines_v cle
9866: WHERE cle.cle_id = p_top_line
9867: AND cle.dnz_chr_id = p_dnz_chr_id
9860: IS
9861: SELECT cle.id
9862: FROM okc_subclass_top_line stl,
9863: okc_line_styles_b lse2,
9864: okc_line_styles_b lse1,
9865: okc_k_lines_v cle
9866: WHERE cle.cle_id = p_top_line
9867: AND cle.dnz_chr_id = p_dnz_chr_id
9868: AND lse1.id = cle.lse_id
12536: --Bug# 6328924
12537: asr.legal_entity_id
12538: FROM OKL_ASSET_RETURNS_B asr,
12539: OKC_K_LINES_B cle_orig,
12540: OKC_LINE_STYLES_B lse_orig,
12541: OKC_K_ITEMS cim_orig
12542: WHERE asr.kle_id = cle_orig.cle_id
12543: AND asr.ars_code = 'RE_LEASE'
12544: AND cim_orig.object1_id1 = p_asset_id
12598: txlb.depreciation_id,
12599: txlb.asset_number
12600: from okl_txl_assets_b txlb,
12601: okc_k_lines_b fa_cleb,
12602: okc_line_styles_b fa_lseb
12603: where txlb.kle_id = fa_cleb.id
12604: and txlb.tal_type = 'CRL'
12605: and fa_cleb.cle_id = p_cle_id
12606: and fa_cleb.dnz_chr_id = p_chr_id
12615: select model_cleb.id model_cle_id,
12616: model_cim.id model_cim_id
12617: from okc_k_items model_cim,
12618: okc_k_lines_b model_cleb,
12619: okc_line_styles_b model_lseb
12620: where model_cim.cle_id = model_cleb.id
12621: and model_cim.dnz_chr_id = model_cleb.dnz_chr_id
12622: and model_cleb.cle_id = p_cle_id
12623: and model_cleb.dnz_chr_id = p_chr_id
12644: p_chr_id in number) IS
12645:
12646: select addon_cleb.id addon_cle_id
12647: from okc_k_lines_b addon_cleb,
12648: okc_line_styles_b addon_lseb,
12649: okc_k_lines_b model_cleb,
12650: okc_line_styles_b model_lseb
12651: where addon_cleb.cle_id = model_cleb.id
12652: and addon_cleb.dnz_chr_id = model_cleb.dnz_chr_id
12646: select addon_cleb.id addon_cle_id
12647: from okc_k_lines_b addon_cleb,
12648: okc_line_styles_b addon_lseb,
12649: okc_k_lines_b model_cleb,
12650: okc_line_styles_b model_lseb
12651: where addon_cleb.cle_id = model_cleb.id
12652: and addon_cleb.dnz_chr_id = model_cleb.dnz_chr_id
12653: and addon_cleb.lse_id = addon_lseb.id
12654: and addon_lseb.lty_code = 'ADD_ITEM'
12663: CURSOR l_subsidyline_csr (p_cle_id in number,
12664: p_chr_id in number) IS
12665: select subsidy_cleb.id subsidy_cle_id
12666: from okc_k_lines_b subsidy_cleb,
12667: okc_line_styles_b subsidy_lseb
12668: where subsidy_cleb.cle_id = p_cle_id
12669: and subsidy_cleb.dnz_chr_id = p_chr_id
12670: and subsidy_cleb.lse_id = subsidy_lseb.id
12671: and subsidy_lseb.lty_code = 'SUBSIDY';
13674: p_chr_id in NUMBER) is
13675: SELECT cim.id
13676: FROM okc_k_items cim,
13677: okc_k_lines_b cleb,
13678: okc_line_styles_b lseb
13679: WHERE cim.object1_id1 = to_char(p_orig_cle_id)
13680: AND cim.object1_id2 = '#'
13681: AND cim.jtot_object1_code = 'OKX_COVASST'
13682: AND cim.cle_id = cleb.id
13756: po_vendors pov,
13757: okc_k_party_roles_b sub_cplb,
13758: okl_k_lines sub_kle,
13759: okc_k_lines_b sub_cleb,
13760: okc_line_styles_b sub_lseb
13761: where subt.id = subb.id
13762: and subt.language = userenv('LANG')
13763: and subb.id = sub_kle.subsidy_id
13764: and pov.vendor_id = to_number(sub_cplb.object1_id1)
14021: fa_cim.object1_id1 asset_id,
14022: fa_cim.dnz_chr_id chr_id
14023: from okc_k_items fa_cim,
14024: okc_k_lines_b fa_cleb,
14025: okc_line_styles_b fa_lseb
14026: where fa_cim.cle_id = fa_cleb.id
14027: and fa_cim.dnz_chr_id = fa_cleb.dnz_chr_id
14028: and fa_cleb.cle_id = p_fin_asst_id
14029: and fa_cleb.lse_id = fa_lseb.id
14052: chrb.orig_system_source_code
14053: from fa_additions_b fab,
14054: okl_txl_assets_b txlb,
14055: okc_k_lines_b fa_cleb,
14056: okc_line_styles_b fa_lseb,
14057: okc_k_headers_b chrb
14058: where fab.asset_number = txlb.asset_number
14059: and fab.asset_id = p_asset_id
14060: and txlb.kle_id = fa_cleb.id
14261: CURSOR l_modelline_csr(p_cle_id IN NUMBER,
14262: p_chr_id IN NUMBER) IS
14263: SELECT model_cleb.id
14264: FROM OKC_K_LINES_B model_cleb,
14265: OKC_LINE_STYLES_B model_lseb
14266: WHERE model_cleb.cle_id = p_cle_id
14267: AND model_cleb.dnz_chr_id = p_chr_id
14268: AND model_cleb.lse_id = model_lseb.id
14269: AND model_lseb.lty_code = 'ITEM';
14517: txlb.asset_number
14518: from okl_trx_assets trx,
14519: okl_txl_assets_b txlb,
14520: okc_k_lines_b cleb_fa,
14521: okc_line_styles_b lseb_fa
14522: where trx.id = txlb.tas_id
14523: and trx.tsu_code = 'ENTERED'
14524: --Bug# 3783518
14525: --and trx.tas_type = 'CRL'
14544: iti.object_id2_new
14545: from okl_trx_assets trx,
14546: okl_txl_itm_insts iti,
14547: okc_k_lines_b cleb_ib,
14548: okc_line_styles_b lseb_ib,
14549: okc_k_lines_b cleb_inst,
14550: okc_line_styles_b lseb_inst
14551: where trx.id = iti.tas_id
14552: and trx.tsu_code = 'ENTERED'
14546: okl_txl_itm_insts iti,
14547: okc_k_lines_b cleb_ib,
14548: okc_line_styles_b lseb_ib,
14549: okc_k_lines_b cleb_inst,
14550: okc_line_styles_b lseb_inst
14551: where trx.id = iti.tas_id
14552: and trx.tsu_code = 'ENTERED'
14553: --akrangan bug 5362977 start
14554: AND trx.tas_type IN ('CRL','CFA','CRB')
14597:
14598: --cursor to get lty_code
14599: CURSOR l_lty_csr (p_lse_id in number) is
14600: SELECT lty_code
14601: from okc_line_styles_b
14602: where id = p_lse_id;
14603:
14604: l_lty_code OKC_LINE_STYLES_B.lty_code%TYPE;
14605:
14600: SELECT lty_code
14601: from okc_line_styles_b
14602: where id = p_lse_id;
14603:
14604: l_lty_code OKC_LINE_STYLES_B.lty_code%TYPE;
14605:
14606: lx_clev_rec clev_rec_type;
14607: lx_klev_rec klev_rec_type;
14608:
14613: p_lty_code in varchar2) is
14614: select cleb.id,
14615: cleb.price_unit
14616: from okc_k_lines_b cleb,
14617: okc_line_styles_b lseb
14618: where cleb.cle_id = p_cle_id
14619: and cleb.dnz_chr_id = p_chr_id
14620: and cleb.lse_id = lseb.id
14621: and lseb.lty_code = p_lty_code;
15235: IS
15236: SELECT CII.SERIAL_NUMBER IB_SERIAL_NUMBER,
15237: CII.INSTANCE_ID
15238: FROM
15239: OKC_K_HEADERS_V OKHV, OKC_K_LINES_V KLE_FA, OKC_LINE_STYLES_B LSE_FA, OKC_K_LINES_B KLE_IL,
15240: OKC_LINE_STYLES_B LSE_IL, OKC_K_LINES_B KLE_IB, OKC_LINE_STYLES_B LSE_IB, OKC_K_ITEMS ITE,
15241: CSI_ITEM_INSTANCES CII
15242: WHERE
15243: kle_fa.chr_id = okhv.id AND lse_fa.id = kle_fa.lse_id AND lse_fa.lty_code = 'FREE_FORM1'
15236: SELECT CII.SERIAL_NUMBER IB_SERIAL_NUMBER,
15237: CII.INSTANCE_ID
15238: FROM
15239: OKC_K_HEADERS_V OKHV, OKC_K_LINES_V KLE_FA, OKC_LINE_STYLES_B LSE_FA, OKC_K_LINES_B KLE_IL,
15240: OKC_LINE_STYLES_B LSE_IL, OKC_K_LINES_B KLE_IB, OKC_LINE_STYLES_B LSE_IB, OKC_K_ITEMS ITE,
15241: CSI_ITEM_INSTANCES CII
15242: WHERE
15243: kle_fa.chr_id = okhv.id AND lse_fa.id = kle_fa.lse_id AND lse_fa.lty_code = 'FREE_FORM1'
15244: AND kle_il.cle_id = kle_fa.id AND lse_il.id = kle_il.lse_id AND lse_il.lty_code = 'FREE_FORM2'
16354: CURSOR c_asset_iti(p_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
16355: p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
16356: IS
16357: select cle_ib.id id
16358: from okc_line_styles_b lse_ib,
16359: okc_k_lines_b cle_ib,
16360: okc_line_styles_b lse_inst,
16361: okc_k_lines_b cle_inst,
16362: okc_line_styles_b lse_tl,
16356: IS
16357: select cle_ib.id id
16358: from okc_line_styles_b lse_ib,
16359: okc_k_lines_b cle_ib,
16360: okc_line_styles_b lse_inst,
16361: okc_k_lines_b cle_inst,
16362: okc_line_styles_b lse_tl,
16363: okc_k_lines_v cleb_tl
16364: where cleb_tl.name = P_asset_number
16358: from okc_line_styles_b lse_ib,
16359: okc_k_lines_b cle_ib,
16360: okc_line_styles_b lse_inst,
16361: okc_k_lines_b cle_inst,
16362: okc_line_styles_b lse_tl,
16363: okc_k_lines_v cleb_tl
16364: where cleb_tl.name = P_asset_number
16365: and cleb_tl.dnz_chr_id = p_dnz_chr_id
16366: and cleb_tl.lse_id = lse_tl.id
16379: IS
16380: select iti.id, iti.inventory_item_id, iti.inventory_org_id,
16381: iti.object_id1_new, iti.object_id2_new, iti.jtot_object_code_new
16382: from okl_txl_itm_insts iti,
16383: okc_line_styles_b lse_ib,
16384: okc_k_lines_b cle_ib,
16385: okc_line_styles_b lse_inst,
16386: okc_k_lines_b cle_inst
16387: where cle_inst.cle_id = p_top_line_id
16381: iti.object_id1_new, iti.object_id2_new, iti.jtot_object_code_new
16382: from okl_txl_itm_insts iti,
16383: okc_line_styles_b lse_ib,
16384: okc_k_lines_b cle_ib,
16385: okc_line_styles_b lse_inst,
16386: okc_k_lines_b cle_inst
16387: where cle_inst.cle_id = p_top_line_id
16388: and cle_inst.lse_id = lse_inst.id
16389: and lse_inst.lty_code = G_INST_LINE_LTY_CODE
16452: chr.orig_system_id1 orig_chr_id,
16453: chr.start_date
16454: FROM okc_k_headers_b CHR,
16455: okl_txl_assets_b txlb,
16456: okc_line_styles_b lseb,
16457: okc_k_lines_b cleb_top,
16458: okl_k_lines kle_top
16459: WHERE txlb.kle_id = cleb_top.id
16460: AND cleb_top.lse_id = lseb.id
16485: CURSOR c_addon_line_id(p_model_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
16486: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
16487: SELECT cle.id
16488: FROM okc_k_lines_b cle,
16489: okc_line_styles_b lse
16490: WHERE cle.dnz_chr_id = p_chr_id
16491: AND cle.lse_id = lse.id
16492: AND lse.lty_code = G_ADDON_LINE_LTY_CODE
16493: AND cle.cle_id = p_model_cle_id;
16553: CURSOR c_get_line_details(p_dnz_chr_id NUMBER, p_clev_fin_id NUMBER) IS
16554: SELECT cim_mdl.number_of_items,
16555: cleb_mdl.price_unit
16556: FROM okc_k_lines_b cleb_mdl,
16557: okc_line_styles_b lse_mdl,
16558: okc_k_items cim_mdl
16559: WHERE cim_mdl.cle_id = cleb_mdl.id
16560: AND cim_mdl.dnz_chr_id = cleb_mdl.dnz_chr_id
16561: AND cim_mdl.jtot_object1_code = 'OKX_SYSITEM'
18091: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18092: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18093: SELECT count(cle.id)
18094: FROM okc_subclass_top_line stl,
18095: okc_line_styles_b lse2,
18096: okc_line_styles_b lse1,
18097: okc_k_lines_v cle
18098: WHERE cle.cle_id = p_cle_id
18099: AND cle.dnz_chr_id = p_chr_id
18092: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18093: SELECT count(cle.id)
18094: FROM okc_subclass_top_line stl,
18095: okc_line_styles_b lse2,
18096: okc_line_styles_b lse1,
18097: okc_k_lines_v cle
18098: WHERE cle.cle_id = p_cle_id
18099: AND cle.dnz_chr_id = p_chr_id
18100: AND cle.lse_id = lse1.id
18107: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18108: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18109: SELECT cle.id
18110: FROM okc_subclass_top_line stl,
18111: okc_line_styles_b lse2,
18112: okc_line_styles_b lse1,
18113: okc_k_lines_v cle
18114: WHERE cle.cle_id = p_cle_id
18115: AND cle.dnz_chr_id = p_chr_id
18108: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18109: SELECT cle.id
18110: FROM okc_subclass_top_line stl,
18111: okc_line_styles_b lse2,
18112: okc_line_styles_b lse1,
18113: okc_k_lines_v cle
18114: WHERE cle.cle_id = p_cle_id
18115: AND cle.dnz_chr_id = p_chr_id
18116: AND cle.lse_id = lse1.id
18123: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18124: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18125: SELECT cle.id
18126: FROM okc_subclass_top_line stl,
18127: okc_line_styles_b lse2,
18128: okc_line_styles_b lse1,
18129: okc_k_lines_v cle
18130: WHERE cle.cle_id = p_cle_id
18131: AND cle.dnz_chr_id = p_chr_id
18124: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18125: SELECT cle.id
18126: FROM okc_subclass_top_line stl,
18127: okc_line_styles_b lse2,
18128: okc_line_styles_b lse1,
18129: okc_k_lines_v cle
18130: WHERE cle.cle_id = p_cle_id
18131: AND cle.dnz_chr_id = p_chr_id
18132: AND cle.lse_id = lse1.id
18139: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18140: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18141: SELECT cle.id
18142: FROM okc_subclass_top_line stl,
18143: okc_line_styles_b lse3,
18144: okc_line_styles_b lse2,
18145: okc_line_styles_b lse1,
18146: okc_k_lines_b cle
18147: WHERE cle.dnz_chr_id = p_chr_id
18140: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18141: SELECT cle.id
18142: FROM okc_subclass_top_line stl,
18143: okc_line_styles_b lse3,
18144: okc_line_styles_b lse2,
18145: okc_line_styles_b lse1,
18146: okc_k_lines_b cle
18147: WHERE cle.dnz_chr_id = p_chr_id
18148: AND cle.lse_id = lse1.id
18141: SELECT cle.id
18142: FROM okc_subclass_top_line stl,
18143: okc_line_styles_b lse3,
18144: okc_line_styles_b lse2,
18145: okc_line_styles_b lse1,
18146: okc_k_lines_b cle
18147: WHERE cle.dnz_chr_id = p_chr_id
18148: AND cle.lse_id = lse1.id
18149: AND lse1.lty_code = G_ADDON_LINE_LTY_CODE
18154: AND lse3.id = stl.lse_id
18155: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
18156: AND cle.cle_id in (SELECT cle.id
18157: FROM okc_subclass_top_line stl,
18158: okc_line_styles_b lse2,
18159: okc_line_styles_b lse1,
18160: okc_k_lines_b cle
18161: WHERE cle.cle_id = p_cle_id
18162: AND cle.dnz_chr_id = p_chr_id
18155: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
18156: AND cle.cle_id in (SELECT cle.id
18157: FROM okc_subclass_top_line stl,
18158: okc_line_styles_b lse2,
18159: okc_line_styles_b lse1,
18160: okc_k_lines_b cle
18161: WHERE cle.cle_id = p_cle_id
18162: AND cle.dnz_chr_id = p_chr_id
18163: AND cle.lse_id = lse1.id
18170: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18171: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18172: SELECT cim.number_of_items
18173: FROM okc_subclass_top_line stl,
18174: okc_line_styles_b lse2,
18175: okc_line_styles_b lse1,
18176: okc_k_items_v cim,
18177: okc_k_lines_v cle
18178: WHERE cle.cle_id = p_cle_id
18171: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18172: SELECT cim.number_of_items
18173: FROM okc_subclass_top_line stl,
18174: okc_line_styles_b lse2,
18175: okc_line_styles_b lse1,
18176: okc_k_items_v cim,
18177: okc_k_lines_v cle
18178: WHERE cle.cle_id = p_cle_id
18179: AND cle.dnz_chr_id = p_chr_id
18201: CURSOR l_chk_rel_ast_csr (p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE
18202: ,p_asset_num IN OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
18203: SELECT NVL(kle_top.re_lease_yn,'N') release_flag
18204: FROM okl_txl_assets_b txlb,
18205: okc_line_styles_b lseb,
18206: okc_k_lines_b cleb_top,
18207: okl_k_lines kle_top
18208: WHERE txlb.kle_id = cleb_top.id
18209: AND cleb_top.lse_id = lseb.id
19135: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19136: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19137: SELECT count(cle.id)
19138: FROM okc_subclass_top_line stl,
19139: okc_line_styles_b lse2,
19140: okc_line_styles_b lse1,
19141: okc_k_lines_v cle
19142: WHERE cle.cle_id = p_cle_id
19143: AND cle.dnz_chr_id = p_chr_id
19136: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19137: SELECT count(cle.id)
19138: FROM okc_subclass_top_line stl,
19139: okc_line_styles_b lse2,
19140: okc_line_styles_b lse1,
19141: okc_k_lines_v cle
19142: WHERE cle.cle_id = p_cle_id
19143: AND cle.dnz_chr_id = p_chr_id
19144: AND cle.lse_id = lse1.id
19151: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19152: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19153: SELECT cle.id
19154: FROM okc_subclass_top_line stl,
19155: okc_line_styles_b lse2,
19156: okc_line_styles_b lse1,
19157: okc_k_lines_v cle
19158: WHERE cle.cle_id = p_cle_id
19159: AND cle.dnz_chr_id = p_chr_id
19152: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19153: SELECT cle.id
19154: FROM okc_subclass_top_line stl,
19155: okc_line_styles_b lse2,
19156: okc_line_styles_b lse1,
19157: okc_k_lines_v cle
19158: WHERE cle.cle_id = p_cle_id
19159: AND cle.dnz_chr_id = p_chr_id
19160: AND cle.lse_id = lse1.id
19167: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19168: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19169: SELECT cim.object1_id1
19170: FROM okc_subclass_top_line stl,
19171: okc_line_styles_b lse2,
19172: okc_line_styles_b lse1,
19173: okc_k_items cim,
19174: okc_k_lines_v cle
19175: WHERE cle.cle_id = p_cle_id
19168: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19169: SELECT cim.object1_id1
19170: FROM okc_subclass_top_line stl,
19171: okc_line_styles_b lse2,
19172: okc_line_styles_b lse1,
19173: okc_k_items cim,
19174: okc_k_lines_v cle
19175: WHERE cle.cle_id = p_cle_id
19176: AND cle.dnz_chr_id = p_chr_id
19187: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19188: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19189: SELECT cle.id
19190: FROM okc_subclass_top_line stl,
19191: okc_line_styles_b lse2,
19192: okc_line_styles_b lse1,
19193: okc_k_lines_v cle
19194: WHERE cle.cle_id = p_cle_id
19195: AND cle.dnz_chr_id = p_chr_id
19188: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19189: SELECT cle.id
19190: FROM okc_subclass_top_line stl,
19191: okc_line_styles_b lse2,
19192: okc_line_styles_b lse1,
19193: okc_k_lines_v cle
19194: WHERE cle.cle_id = p_cle_id
19195: AND cle.dnz_chr_id = p_chr_id
19196: AND cle.lse_id = lse1.id
19203: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19204: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19205: SELECT cle.id
19206: FROM okc_subclass_top_line stl,
19207: okc_line_styles_b lse3,
19208: okc_line_styles_b lse2,
19209: okc_line_styles_b lse1,
19210: okc_k_lines_b cle
19211: WHERE cle.dnz_chr_id = p_chr_id
19204: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19205: SELECT cle.id
19206: FROM okc_subclass_top_line stl,
19207: okc_line_styles_b lse3,
19208: okc_line_styles_b lse2,
19209: okc_line_styles_b lse1,
19210: okc_k_lines_b cle
19211: WHERE cle.dnz_chr_id = p_chr_id
19212: AND cle.lse_id = lse1.id
19205: SELECT cle.id
19206: FROM okc_subclass_top_line stl,
19207: okc_line_styles_b lse3,
19208: okc_line_styles_b lse2,
19209: okc_line_styles_b lse1,
19210: okc_k_lines_b cle
19211: WHERE cle.dnz_chr_id = p_chr_id
19212: AND cle.lse_id = lse1.id
19213: AND lse1.lty_code = G_ADDON_LINE_LTY_CODE
19218: AND lse3.id = stl.lse_id
19219: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
19220: AND cle.cle_id in (SELECT cle.id
19221: FROM okc_subclass_top_line stl,
19222: okc_line_styles_b lse2,
19223: okc_line_styles_b lse1,
19224: okc_k_lines_b cle
19225: WHERE cle.cle_id = p_cle_id
19226: AND cle.dnz_chr_id = p_chr_id
19219: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
19220: AND cle.cle_id in (SELECT cle.id
19221: FROM okc_subclass_top_line stl,
19222: okc_line_styles_b lse2,
19223: okc_line_styles_b lse1,
19224: okc_k_lines_b cle
19225: WHERE cle.cle_id = p_cle_id
19226: AND cle.dnz_chr_id = p_chr_id
19227: AND cle.lse_id = lse1.id
19245: CURSOR l_chk_rel_ast_csr (p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE
19246: ,p_asset_num IN OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
19247: SELECT NVL(kle_top.re_lease_yn,'N') release_flag
19248: FROM okl_txl_assets_b txlb,
19249: okc_line_styles_b lseb,
19250: okc_k_lines_b cleb_top,
19251: okl_k_lines kle_top
19252: WHERE txlb.kle_id = cleb_top.id
19253: AND cleb_top.lse_id = lseb.id
20063:
20064: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20065: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20066: SELECT count(cle.id)
20067: FROM okc_line_styles_b lse2,
20068: okc_line_styles_b lse1,
20069: okc_k_lines_v cle
20070: WHERE cle.cle_id = p_cle_id
20071: AND cle.dnz_chr_id = p_chr_id
20064: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20065: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20066: SELECT count(cle.id)
20067: FROM okc_line_styles_b lse2,
20068: okc_line_styles_b lse1,
20069: okc_k_lines_v cle
20070: WHERE cle.cle_id = p_cle_id
20071: AND cle.dnz_chr_id = p_chr_id
20072: AND cle.lse_id = lse1.id
20077: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20078: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20079: SELECT cle.id
20080: FROM okc_subclass_top_line stl,
20081: okc_line_styles_b lse2,
20082: okc_line_styles_b lse1,
20083: okc_k_lines_v cle
20084: WHERE cle.cle_id = p_cle_id
20085: AND cle.dnz_chr_id = p_chr_id
20078: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20079: SELECT cle.id
20080: FROM okc_subclass_top_line stl,
20081: okc_line_styles_b lse2,
20082: okc_line_styles_b lse1,
20083: okc_k_lines_v cle
20084: WHERE cle.cle_id = p_cle_id
20085: AND cle.dnz_chr_id = p_chr_id
20086: AND cle.lse_id = lse1.id
20093: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20094: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20095: SELECT cle.id
20096: FROM okc_subclass_top_line stl,
20097: okc_line_styles_b lse2,
20098: okc_line_styles_b lse1,
20099: okc_k_lines_v cle
20100: WHERE cle.cle_id = p_cle_id
20101: AND cle.dnz_chr_id = p_chr_id
20094: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20095: SELECT cle.id
20096: FROM okc_subclass_top_line stl,
20097: okc_line_styles_b lse2,
20098: okc_line_styles_b lse1,
20099: okc_k_lines_v cle
20100: WHERE cle.cle_id = p_cle_id
20101: AND cle.dnz_chr_id = p_chr_id
20102: AND cle.lse_id = lse1.id
20109: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20110: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20111: SELECT cle.id
20112: FROM okc_subclass_top_line stl,
20113: okc_line_styles_b lse3,
20114: okc_line_styles_b lse2,
20115: okc_line_styles_b lse1,
20116: okc_k_lines_b cle
20117: WHERE cle.dnz_chr_id = p_chr_id
20110: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20111: SELECT cle.id
20112: FROM okc_subclass_top_line stl,
20113: okc_line_styles_b lse3,
20114: okc_line_styles_b lse2,
20115: okc_line_styles_b lse1,
20116: okc_k_lines_b cle
20117: WHERE cle.dnz_chr_id = p_chr_id
20118: AND cle.lse_id = lse1.id
20111: SELECT cle.id
20112: FROM okc_subclass_top_line stl,
20113: okc_line_styles_b lse3,
20114: okc_line_styles_b lse2,
20115: okc_line_styles_b lse1,
20116: okc_k_lines_b cle
20117: WHERE cle.dnz_chr_id = p_chr_id
20118: AND cle.lse_id = lse1.id
20119: AND lse1.lty_code = G_ADDON_LINE_LTY_CODE
20124: AND lse3.id = stl.lse_id
20125: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
20126: AND cle.cle_id in (SELECT cle.id
20127: FROM okc_subclass_top_line stl,
20128: okc_line_styles_b lse2,
20129: okc_line_styles_b lse1,
20130: okc_k_lines_b cle
20131: WHERE cle.cle_id = p_cle_id
20132: AND cle.dnz_chr_id = p_chr_id
20125: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
20126: AND cle.cle_id in (SELECT cle.id
20127: FROM okc_subclass_top_line stl,
20128: okc_line_styles_b lse2,
20129: okc_line_styles_b lse1,
20130: okc_k_lines_b cle
20131: WHERE cle.cle_id = p_cle_id
20132: AND cle.dnz_chr_id = p_chr_id
20133: AND cle.lse_id = lse1.id
20151: CURSOR l_chk_rel_ast_csr (p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE
20152: ,p_asset_number IN OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
20153: SELECT NVL(kle_top.re_lease_yn,'N') release_flag
20154: FROM okl_txl_assets_b txlb,
20155: okc_line_styles_b lseb,
20156: okc_k_lines_b cleb_top,
20157: okl_k_lines kle_top
20158: WHERE txlb.kle_id = cleb_top.id
20159: AND cleb_top.lse_id = lseb.id