[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
3824:
3825: lv_sts_code OKC_K_LINES_V.STS_CODE%TYPE;
3826: lv_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE;
3827:
3828: CURSOR c_lty_code_validate(p_lse_id OKC_LINE_STYLES_B.ID%TYPE) IS
3829: SELECT lse.lty_code
3830: FROM OKC_LINE_STYLES_V lse
3831: WHERE lse.id = p_lse_id;
3832:
6395: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6396: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6397: SELECT cle.display_sequence,
6398: cim.number_of_items
6399: FROM okc_line_styles_b lse2,
6400: okc_line_styles_b lse1,
6401: okc_k_items cim,
6402: okc_k_lines_b cle
6403: WHERE cle.id = p_cle_id
6396: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6397: SELECT cle.display_sequence,
6398: cim.number_of_items
6399: FROM okc_line_styles_b lse2,
6400: okc_line_styles_b lse1,
6401: okc_k_items cim,
6402: okc_k_lines_b cle
6403: WHERE cle.id = p_cle_id
6404: AND cle.dnz_chr_id = p_dnz_chr_id
6604: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6605: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6606: SELECT cle.display_sequence,
6607: cim.number_of_items
6608: FROM okc_line_styles_b lse2,
6609: okc_line_styles_b lse1,
6610: okc_k_items cim,
6611: okc_k_lines_b cle
6612: WHERE cle.id = p_cle_id
6605: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6606: SELECT cle.display_sequence,
6607: cim.number_of_items
6608: FROM okc_line_styles_b lse2,
6609: okc_line_styles_b lse1,
6610: okc_k_items cim,
6611: okc_k_lines_b cle
6612: WHERE cle.id = p_cle_id
6613: AND cle.dnz_chr_id = p_dnz_chr_id
6816: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
6817: IS
6818: SELECT cle.id
6819: FROM okc_subclass_top_line stl,
6820: okc_line_styles_b lse2,
6821: okc_line_styles_b lse1,
6822: okc_k_lines_b cle
6823: WHERE cle.dnz_chr_id = p_dnz_chr_id
6824: AND cle.lse_id = lse1.id
6817: IS
6818: SELECT cle.id
6819: FROM okc_subclass_top_line stl,
6820: okc_line_styles_b lse2,
6821: okc_line_styles_b lse1,
6822: okc_k_lines_b cle
6823: WHERE cle.dnz_chr_id = p_dnz_chr_id
6824: AND cle.lse_id = lse1.id
6825: AND lse1.lty_code = G_FA_LINE_LTY_CODE
6828: AND lse2.id = stl.lse_id
6829: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
6830: AND cle.cle_id in (SELECT distinct to_char(cle.cle_id)
6831: FROM okc_subclass_top_line stl,
6832: okc_line_styles_b lse2,
6833: okc_line_styles_b lse1,
6834: okc_k_lines_b cle
6835: WHERE cle.id = p_top_line
6836: AND cle.dnz_chr_id = p_dnz_chr_id
6829: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
6830: AND cle.cle_id in (SELECT distinct to_char(cle.cle_id)
6831: FROM okc_subclass_top_line stl,
6832: okc_line_styles_b lse2,
6833: okc_line_styles_b lse1,
6834: okc_k_lines_b cle
6835: WHERE cle.id = p_top_line
6836: AND cle.dnz_chr_id = p_dnz_chr_id
6837: AND cle.lse_id = lse1.id
7014: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
7015: IS
7016: SELECT cle.id
7017: FROM okc_subclass_top_line stl,
7018: okc_line_styles_b lse2,
7019: okc_line_styles_b lse1,
7020: okc_k_lines_b cle
7021: WHERE cle.dnz_chr_id = p_dnz_chr_id
7022: AND cle.lse_id = lse1.id
7015: IS
7016: SELECT cle.id
7017: FROM okc_subclass_top_line stl,
7018: okc_line_styles_b lse2,
7019: okc_line_styles_b lse1,
7020: okc_k_lines_b cle
7021: WHERE cle.dnz_chr_id = p_dnz_chr_id
7022: AND cle.lse_id = lse1.id
7023: AND lse1.lty_code = G_FA_LINE_LTY_CODE
7026: AND lse2.id = stl.lse_id
7027: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
7028: AND cle.cle_id in (SELECT distinct to_char(cle.cle_id)
7029: FROM okc_subclass_top_line stl,
7030: okc_line_styles_b lse2,
7031: okc_line_styles_b lse1,
7032: okc_k_lines_b cle
7033: WHERE cle.id = p_top_line
7034: AND cle.dnz_chr_id = p_dnz_chr_id
7027: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
7028: AND cle.cle_id in (SELECT distinct to_char(cle.cle_id)
7029: FROM okc_subclass_top_line stl,
7030: okc_line_styles_b lse2,
7031: okc_line_styles_b lse1,
7032: okc_k_lines_b cle
7033: WHERE cle.id = p_top_line
7034: AND cle.dnz_chr_id = p_dnz_chr_id
7035: AND cle.lse_id = lse1.id
8389: IS
8390: -- #4414408
8391: SELECT cle.id
8392: -- FROM okc_subclass_top_line stl,
8393: -- okc_line_styles_b lse2,
8394: -- okc_line_styles_b lse1,
8395: FROM okc_k_lines_b cle
8396: WHERE cle.cle_id = p_top_line
8397: AND cle.dnz_chr_id = p_dnz_chr_id
8390: -- #4414408
8391: SELECT cle.id
8392: -- FROM okc_subclass_top_line stl,
8393: -- okc_line_styles_b lse2,
8394: -- okc_line_styles_b lse1,
8395: FROM okc_k_lines_b cle
8396: WHERE cle.cle_id = p_top_line
8397: AND cle.dnz_chr_id = p_dnz_chr_id
8398: -- AND lse1.id = cle.lse_id
8634: CURSOR c_get_lse_id_sts(p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
8635: SELECT lse.id,
8636: cle.sts_code
8637: FROM okc_subclass_top_line stl,
8638: okc_line_styles_b lse,
8639: okc_k_lines_v cle
8640: WHERE cle.id = p_top_line_id
8641: AND cle.lse_id = lse.id
8642: AND lse.lty_code = G_FIN_LINE_LTY_CODE
8856: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
8857: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
8858: SELECT cle.cle_id
8859: FROM okc_subclass_top_line stl,
8860: okc_line_styles_b lse2,
8861: okc_line_styles_b lse1,
8862: okc_k_items_v cim,
8863: okc_k_lines_v cle
8864: WHERE cle.id = p_model_line_id
8857: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
8858: SELECT cle.cle_id
8859: FROM okc_subclass_top_line stl,
8860: okc_line_styles_b lse2,
8861: okc_line_styles_b lse1,
8862: okc_k_items_v cim,
8863: okc_k_lines_v cle
8864: WHERE cle.id = p_model_line_id
8865: AND cle.dnz_chr_id = p_dnz_chr_id
9062: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9063: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9064: SELECT cle.cle_id
9065: FROM okc_subclass_top_line stl,
9066: okc_line_styles_b lse2,
9067: okc_line_styles_b lse1,
9068: okc_k_items_v cim,
9069: okc_k_lines_v cle
9070: WHERE cle.id = p_model_line_id
9063: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9064: SELECT cle.cle_id
9065: FROM okc_subclass_top_line stl,
9066: okc_line_styles_b lse2,
9067: okc_line_styles_b lse1,
9068: okc_k_items_v cim,
9069: okc_k_lines_v cle
9070: WHERE cle.id = p_model_line_id
9071: AND cle.dnz_chr_id = p_dnz_chr_id
9267: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9268: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9269: SELECT cle.cle_id
9270: FROM okc_subclass_top_line stl,
9271: okc_line_styles_b lse2,
9272: okc_line_styles_b lse1,
9273: okc_k_items_v cim,
9274: okc_k_lines_v cle
9275: WHERE cle.id = p_model_line_id
9268: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9269: SELECT cle.cle_id
9270: FROM okc_subclass_top_line stl,
9271: okc_line_styles_b lse2,
9272: okc_line_styles_b lse1,
9273: okc_k_items_v cim,
9274: okc_k_lines_v cle
9275: WHERE cle.id = p_model_line_id
9276: AND cle.dnz_chr_id = p_dnz_chr_id
9774: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
9775: IS
9776: SELECT cle.id
9777: FROM okc_subclass_top_line stl,
9778: okc_line_styles_b lse2,
9779: okc_line_styles_b lse1,
9780: okc_k_lines_v cle
9781: WHERE cle.cle_id = p_top_line
9782: AND cle.dnz_chr_id = p_dnz_chr_id
9775: IS
9776: SELECT cle.id
9777: FROM okc_subclass_top_line stl,
9778: okc_line_styles_b lse2,
9779: okc_line_styles_b lse1,
9780: okc_k_lines_v cle
9781: WHERE cle.cle_id = p_top_line
9782: AND cle.dnz_chr_id = p_dnz_chr_id
9783: AND lse1.id = cle.lse_id
12451: --Bug# 6328924
12452: asr.legal_entity_id
12453: FROM OKL_ASSET_RETURNS_B asr,
12454: OKC_K_LINES_B cle_orig,
12455: OKC_LINE_STYLES_B lse_orig,
12456: OKC_K_ITEMS cim_orig
12457: WHERE asr.kle_id = cle_orig.cle_id
12458: AND asr.ars_code = 'RE_LEASE'
12459: AND cim_orig.object1_id1 = p_asset_id
12512: txlb.depreciation_id,
12513: txlb.asset_number
12514: from okl_txl_assets_b txlb,
12515: okc_k_lines_b fa_cleb,
12516: okc_line_styles_b fa_lseb
12517: where txlb.kle_id = fa_cleb.id
12518: and txlb.tal_type = 'CRL'
12519: and fa_cleb.cle_id = p_cle_id
12520: and fa_cleb.dnz_chr_id = p_chr_id
12529: select model_cleb.id model_cle_id,
12530: model_cim.id model_cim_id
12531: from okc_k_items model_cim,
12532: okc_k_lines_b model_cleb,
12533: okc_line_styles_b model_lseb
12534: where model_cim.cle_id = model_cleb.id
12535: and model_cim.dnz_chr_id = model_cleb.dnz_chr_id
12536: and model_cleb.cle_id = p_cle_id
12537: and model_cleb.dnz_chr_id = p_chr_id
12558: p_chr_id in number) IS
12559:
12560: select addon_cleb.id addon_cle_id
12561: from okc_k_lines_b addon_cleb,
12562: okc_line_styles_b addon_lseb,
12563: okc_k_lines_b model_cleb,
12564: okc_line_styles_b model_lseb
12565: where addon_cleb.cle_id = model_cleb.id
12566: and addon_cleb.dnz_chr_id = model_cleb.dnz_chr_id
12560: select addon_cleb.id addon_cle_id
12561: from okc_k_lines_b addon_cleb,
12562: okc_line_styles_b addon_lseb,
12563: okc_k_lines_b model_cleb,
12564: okc_line_styles_b model_lseb
12565: where addon_cleb.cle_id = model_cleb.id
12566: and addon_cleb.dnz_chr_id = model_cleb.dnz_chr_id
12567: and addon_cleb.lse_id = addon_lseb.id
12568: and addon_lseb.lty_code = 'ADD_ITEM'
12577: CURSOR l_subsidyline_csr (p_cle_id in number,
12578: p_chr_id in number) IS
12579: select subsidy_cleb.id subsidy_cle_id
12580: from okc_k_lines_b subsidy_cleb,
12581: okc_line_styles_b subsidy_lseb
12582: where subsidy_cleb.cle_id = p_cle_id
12583: and subsidy_cleb.dnz_chr_id = p_chr_id
12584: and subsidy_cleb.lse_id = subsidy_lseb.id
12585: and subsidy_lseb.lty_code = 'SUBSIDY';
13575: p_chr_id in NUMBER) is
13576: SELECT cim.id
13577: FROM okc_k_items cim,
13578: okc_k_lines_b cleb,
13579: okc_line_styles_b lseb
13580: WHERE cim.object1_id1 = to_char(p_orig_cle_id)
13581: AND cim.object1_id2 = '#'
13582: AND cim.jtot_object1_code = 'OKX_COVASST'
13583: AND cim.cle_id = cleb.id
13657: po_vendors pov,
13658: okc_k_party_roles_b sub_cplb,
13659: okl_k_lines sub_kle,
13660: okc_k_lines_b sub_cleb,
13661: okc_line_styles_b sub_lseb
13662: where subt.id = subb.id
13663: and subt.language = userenv('LANG')
13664: and subb.id = sub_kle.subsidy_id
13665: and pov.vendor_id = to_number(sub_cplb.object1_id1)
13922: fa_cim.object1_id1 asset_id,
13923: fa_cim.dnz_chr_id chr_id
13924: from okc_k_items fa_cim,
13925: okc_k_lines_b fa_cleb,
13926: okc_line_styles_b fa_lseb
13927: where fa_cim.cle_id = fa_cleb.id
13928: and fa_cim.dnz_chr_id = fa_cleb.dnz_chr_id
13929: and fa_cleb.cle_id = p_fin_asst_id
13930: and fa_cleb.lse_id = fa_lseb.id
13953: chrb.orig_system_source_code
13954: from fa_additions_b fab,
13955: okl_txl_assets_b txlb,
13956: okc_k_lines_b fa_cleb,
13957: okc_line_styles_b fa_lseb,
13958: okc_k_headers_b chrb
13959: where fab.asset_number = txlb.asset_number
13960: and fab.asset_id = p_asset_id
13961: and txlb.kle_id = fa_cleb.id
14155: CURSOR l_modelline_csr(p_cle_id IN NUMBER,
14156: p_chr_id IN NUMBER) IS
14157: SELECT model_cleb.id
14158: FROM OKC_K_LINES_B model_cleb,
14159: OKC_LINE_STYLES_B model_lseb
14160: WHERE model_cleb.cle_id = p_cle_id
14161: AND model_cleb.dnz_chr_id = p_chr_id
14162: AND model_cleb.lse_id = model_lseb.id
14163: AND model_lseb.lty_code = 'ITEM';
14411: txlb.asset_number
14412: from okl_trx_assets trx,
14413: okl_txl_assets_b txlb,
14414: okc_k_lines_b cleb_fa,
14415: okc_line_styles_b lseb_fa
14416: where trx.id = txlb.tas_id
14417: and trx.tsu_code = 'ENTERED'
14418: --Bug# 3783518
14419: --and trx.tas_type = 'CRL'
14438: iti.object_id2_new
14439: from okl_trx_assets trx,
14440: okl_txl_itm_insts iti,
14441: okc_k_lines_b cleb_ib,
14442: okc_line_styles_b lseb_ib,
14443: okc_k_lines_b cleb_inst,
14444: okc_line_styles_b lseb_inst
14445: where trx.id = iti.tas_id
14446: and trx.tsu_code = 'ENTERED'
14440: okl_txl_itm_insts iti,
14441: okc_k_lines_b cleb_ib,
14442: okc_line_styles_b lseb_ib,
14443: okc_k_lines_b cleb_inst,
14444: okc_line_styles_b lseb_inst
14445: where trx.id = iti.tas_id
14446: and trx.tsu_code = 'ENTERED'
14447: --akrangan bug 5362977 start
14448: AND trx.tas_type IN ('CRL','CFA','CRB')
14491:
14492: --cursor to get lty_code
14493: CURSOR l_lty_csr (p_lse_id in number) is
14494: SELECT lty_code
14495: from okc_line_styles_b
14496: where id = p_lse_id;
14497:
14498: l_lty_code OKC_LINE_STYLES_B.lty_code%TYPE;
14499:
14494: SELECT lty_code
14495: from okc_line_styles_b
14496: where id = p_lse_id;
14497:
14498: l_lty_code OKC_LINE_STYLES_B.lty_code%TYPE;
14499:
14500: lx_clev_rec clev_rec_type;
14501: lx_klev_rec klev_rec_type;
14502:
14507: p_lty_code in varchar2) is
14508: select cleb.id,
14509: cleb.price_unit
14510: from okc_k_lines_b cleb,
14511: okc_line_styles_b lseb
14512: where cleb.cle_id = p_cle_id
14513: and cleb.dnz_chr_id = p_chr_id
14514: and cleb.lse_id = lseb.id
14515: and lseb.lty_code = p_lty_code;
15126: IS
15127: SELECT CII.SERIAL_NUMBER IB_SERIAL_NUMBER,
15128: CII.INSTANCE_ID
15129: FROM
15130: OKC_K_HEADERS_V OKHV, OKC_K_LINES_V KLE_FA, OKC_LINE_STYLES_B LSE_FA, OKC_K_LINES_B KLE_IL,
15131: OKC_LINE_STYLES_B LSE_IL, OKC_K_LINES_B KLE_IB, OKC_LINE_STYLES_B LSE_IB, OKC_K_ITEMS ITE,
15132: CSI_ITEM_INSTANCES CII
15133: WHERE
15134: kle_fa.chr_id = okhv.id AND lse_fa.id = kle_fa.lse_id AND lse_fa.lty_code = 'FREE_FORM1'
15127: SELECT CII.SERIAL_NUMBER IB_SERIAL_NUMBER,
15128: CII.INSTANCE_ID
15129: FROM
15130: OKC_K_HEADERS_V OKHV, OKC_K_LINES_V KLE_FA, OKC_LINE_STYLES_B LSE_FA, OKC_K_LINES_B KLE_IL,
15131: OKC_LINE_STYLES_B LSE_IL, OKC_K_LINES_B KLE_IB, OKC_LINE_STYLES_B LSE_IB, OKC_K_ITEMS ITE,
15132: CSI_ITEM_INSTANCES CII
15133: WHERE
15134: kle_fa.chr_id = okhv.id AND lse_fa.id = kle_fa.lse_id AND lse_fa.lty_code = 'FREE_FORM1'
15135: AND kle_il.cle_id = kle_fa.id AND lse_il.id = kle_il.lse_id AND lse_il.lty_code = 'FREE_FORM2'
16216: CURSOR c_asset_iti(p_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
16217: p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
16218: IS
16219: select cle_ib.id id
16220: from okc_line_styles_b lse_ib,
16221: okc_k_lines_b cle_ib,
16222: okc_line_styles_b lse_inst,
16223: okc_k_lines_b cle_inst,
16224: okc_line_styles_b lse_tl,
16218: IS
16219: select cle_ib.id id
16220: from okc_line_styles_b lse_ib,
16221: okc_k_lines_b cle_ib,
16222: okc_line_styles_b lse_inst,
16223: okc_k_lines_b cle_inst,
16224: okc_line_styles_b lse_tl,
16225: okc_k_lines_v cleb_tl
16226: where cleb_tl.name = P_asset_number
16220: from okc_line_styles_b lse_ib,
16221: okc_k_lines_b cle_ib,
16222: okc_line_styles_b lse_inst,
16223: okc_k_lines_b cle_inst,
16224: okc_line_styles_b lse_tl,
16225: okc_k_lines_v cleb_tl
16226: where cleb_tl.name = P_asset_number
16227: and cleb_tl.dnz_chr_id = p_dnz_chr_id
16228: and cleb_tl.lse_id = lse_tl.id
16241: IS
16242: select iti.id, iti.inventory_item_id, iti.inventory_org_id,
16243: iti.object_id1_new, iti.object_id2_new, iti.jtot_object_code_new
16244: from okl_txl_itm_insts iti,
16245: okc_line_styles_b lse_ib,
16246: okc_k_lines_b cle_ib,
16247: okc_line_styles_b lse_inst,
16248: okc_k_lines_b cle_inst
16249: where cle_inst.cle_id = p_top_line_id
16243: iti.object_id1_new, iti.object_id2_new, iti.jtot_object_code_new
16244: from okl_txl_itm_insts iti,
16245: okc_line_styles_b lse_ib,
16246: okc_k_lines_b cle_ib,
16247: okc_line_styles_b lse_inst,
16248: okc_k_lines_b cle_inst
16249: where cle_inst.cle_id = p_top_line_id
16250: and cle_inst.lse_id = lse_inst.id
16251: and lse_inst.lty_code = G_INST_LINE_LTY_CODE
16323: CURSOR c_addon_line_id(p_model_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
16324: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
16325: SELECT cle.id
16326: FROM okc_k_lines_b cle,
16327: okc_line_styles_b lse
16328: WHERE cle.dnz_chr_id = p_chr_id
16329: AND cle.lse_id = lse.id
16330: AND lse.lty_code = G_ADDON_LINE_LTY_CODE
16331: AND cle.cle_id = p_model_cle_id;
17884: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17885: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17886: SELECT count(cle.id)
17887: FROM okc_subclass_top_line stl,
17888: okc_line_styles_b lse2,
17889: okc_line_styles_b lse1,
17890: okc_k_lines_v cle
17891: WHERE cle.cle_id = p_cle_id
17892: AND cle.dnz_chr_id = p_chr_id
17885: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17886: SELECT count(cle.id)
17887: FROM okc_subclass_top_line stl,
17888: okc_line_styles_b lse2,
17889: okc_line_styles_b lse1,
17890: okc_k_lines_v cle
17891: WHERE cle.cle_id = p_cle_id
17892: AND cle.dnz_chr_id = p_chr_id
17893: AND cle.lse_id = lse1.id
17900: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17901: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17902: SELECT cle.id
17903: FROM okc_subclass_top_line stl,
17904: okc_line_styles_b lse2,
17905: okc_line_styles_b lse1,
17906: okc_k_lines_v cle
17907: WHERE cle.cle_id = p_cle_id
17908: AND cle.dnz_chr_id = p_chr_id
17901: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17902: SELECT cle.id
17903: FROM okc_subclass_top_line stl,
17904: okc_line_styles_b lse2,
17905: okc_line_styles_b lse1,
17906: okc_k_lines_v cle
17907: WHERE cle.cle_id = p_cle_id
17908: AND cle.dnz_chr_id = p_chr_id
17909: AND cle.lse_id = lse1.id
17916: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17917: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17918: SELECT cle.id
17919: FROM okc_subclass_top_line stl,
17920: okc_line_styles_b lse2,
17921: okc_line_styles_b lse1,
17922: okc_k_lines_v cle
17923: WHERE cle.cle_id = p_cle_id
17924: AND cle.dnz_chr_id = p_chr_id
17917: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17918: SELECT cle.id
17919: FROM okc_subclass_top_line stl,
17920: okc_line_styles_b lse2,
17921: okc_line_styles_b lse1,
17922: okc_k_lines_v cle
17923: WHERE cle.cle_id = p_cle_id
17924: AND cle.dnz_chr_id = p_chr_id
17925: AND cle.lse_id = lse1.id
17932: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17933: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17934: SELECT cle.id
17935: FROM okc_subclass_top_line stl,
17936: okc_line_styles_b lse3,
17937: okc_line_styles_b lse2,
17938: okc_line_styles_b lse1,
17939: okc_k_lines_b cle
17940: WHERE cle.dnz_chr_id = p_chr_id
17933: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17934: SELECT cle.id
17935: FROM okc_subclass_top_line stl,
17936: okc_line_styles_b lse3,
17937: okc_line_styles_b lse2,
17938: okc_line_styles_b lse1,
17939: okc_k_lines_b cle
17940: WHERE cle.dnz_chr_id = p_chr_id
17941: AND cle.lse_id = lse1.id
17934: SELECT cle.id
17935: FROM okc_subclass_top_line stl,
17936: okc_line_styles_b lse3,
17937: okc_line_styles_b lse2,
17938: okc_line_styles_b lse1,
17939: okc_k_lines_b cle
17940: WHERE cle.dnz_chr_id = p_chr_id
17941: AND cle.lse_id = lse1.id
17942: AND lse1.lty_code = G_ADDON_LINE_LTY_CODE
17947: AND lse3.id = stl.lse_id
17948: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
17949: AND cle.cle_id in (SELECT cle.id
17950: FROM okc_subclass_top_line stl,
17951: okc_line_styles_b lse2,
17952: okc_line_styles_b lse1,
17953: okc_k_lines_b cle
17954: WHERE cle.cle_id = p_cle_id
17955: AND cle.dnz_chr_id = p_chr_id
17948: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
17949: AND cle.cle_id in (SELECT cle.id
17950: FROM okc_subclass_top_line stl,
17951: okc_line_styles_b lse2,
17952: okc_line_styles_b lse1,
17953: okc_k_lines_b cle
17954: WHERE cle.cle_id = p_cle_id
17955: AND cle.dnz_chr_id = p_chr_id
17956: AND cle.lse_id = lse1.id
17963: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17964: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17965: SELECT cim.number_of_items
17966: FROM okc_subclass_top_line stl,
17967: okc_line_styles_b lse2,
17968: okc_line_styles_b lse1,
17969: okc_k_items_v cim,
17970: okc_k_lines_v cle
17971: WHERE cle.cle_id = p_cle_id
17964: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17965: SELECT cim.number_of_items
17966: FROM okc_subclass_top_line stl,
17967: okc_line_styles_b lse2,
17968: okc_line_styles_b lse1,
17969: okc_k_items_v cim,
17970: okc_k_lines_v cle
17971: WHERE cle.cle_id = p_cle_id
17972: AND cle.dnz_chr_id = p_chr_id
18904: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18905: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18906: SELECT count(cle.id)
18907: FROM okc_subclass_top_line stl,
18908: okc_line_styles_b lse2,
18909: okc_line_styles_b lse1,
18910: okc_k_lines_v cle
18911: WHERE cle.cle_id = p_cle_id
18912: AND cle.dnz_chr_id = p_chr_id
18905: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18906: SELECT count(cle.id)
18907: FROM okc_subclass_top_line stl,
18908: okc_line_styles_b lse2,
18909: okc_line_styles_b lse1,
18910: okc_k_lines_v cle
18911: WHERE cle.cle_id = p_cle_id
18912: AND cle.dnz_chr_id = p_chr_id
18913: AND cle.lse_id = lse1.id
18920: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18921: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18922: SELECT cle.id
18923: FROM okc_subclass_top_line stl,
18924: okc_line_styles_b lse2,
18925: okc_line_styles_b lse1,
18926: okc_k_lines_v cle
18927: WHERE cle.cle_id = p_cle_id
18928: AND cle.dnz_chr_id = p_chr_id
18921: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18922: SELECT cle.id
18923: FROM okc_subclass_top_line stl,
18924: okc_line_styles_b lse2,
18925: okc_line_styles_b lse1,
18926: okc_k_lines_v cle
18927: WHERE cle.cle_id = p_cle_id
18928: AND cle.dnz_chr_id = p_chr_id
18929: AND cle.lse_id = lse1.id
18936: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18937: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18938: SELECT cim.object1_id1
18939: FROM okc_subclass_top_line stl,
18940: okc_line_styles_b lse2,
18941: okc_line_styles_b lse1,
18942: okc_k_items cim,
18943: okc_k_lines_v cle
18944: WHERE cle.cle_id = p_cle_id
18937: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18938: SELECT cim.object1_id1
18939: FROM okc_subclass_top_line stl,
18940: okc_line_styles_b lse2,
18941: okc_line_styles_b lse1,
18942: okc_k_items cim,
18943: okc_k_lines_v cle
18944: WHERE cle.cle_id = p_cle_id
18945: AND cle.dnz_chr_id = p_chr_id
18956: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18957: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18958: SELECT cle.id
18959: FROM okc_subclass_top_line stl,
18960: okc_line_styles_b lse2,
18961: okc_line_styles_b lse1,
18962: okc_k_lines_v cle
18963: WHERE cle.cle_id = p_cle_id
18964: AND cle.dnz_chr_id = p_chr_id
18957: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18958: SELECT cle.id
18959: FROM okc_subclass_top_line stl,
18960: okc_line_styles_b lse2,
18961: okc_line_styles_b lse1,
18962: okc_k_lines_v cle
18963: WHERE cle.cle_id = p_cle_id
18964: AND cle.dnz_chr_id = p_chr_id
18965: AND cle.lse_id = lse1.id
18972: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18973: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18974: SELECT cle.id
18975: FROM okc_subclass_top_line stl,
18976: okc_line_styles_b lse3,
18977: okc_line_styles_b lse2,
18978: okc_line_styles_b lse1,
18979: okc_k_lines_b cle
18980: WHERE cle.dnz_chr_id = p_chr_id
18973: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18974: SELECT cle.id
18975: FROM okc_subclass_top_line stl,
18976: okc_line_styles_b lse3,
18977: okc_line_styles_b lse2,
18978: okc_line_styles_b lse1,
18979: okc_k_lines_b cle
18980: WHERE cle.dnz_chr_id = p_chr_id
18981: AND cle.lse_id = lse1.id
18974: SELECT cle.id
18975: FROM okc_subclass_top_line stl,
18976: okc_line_styles_b lse3,
18977: okc_line_styles_b lse2,
18978: okc_line_styles_b lse1,
18979: okc_k_lines_b cle
18980: WHERE cle.dnz_chr_id = p_chr_id
18981: AND cle.lse_id = lse1.id
18982: AND lse1.lty_code = G_ADDON_LINE_LTY_CODE
18987: AND lse3.id = stl.lse_id
18988: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
18989: AND cle.cle_id in (SELECT cle.id
18990: FROM okc_subclass_top_line stl,
18991: okc_line_styles_b lse2,
18992: okc_line_styles_b lse1,
18993: okc_k_lines_b cle
18994: WHERE cle.cle_id = p_cle_id
18995: AND cle.dnz_chr_id = p_chr_id
18988: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
18989: AND cle.cle_id in (SELECT cle.id
18990: FROM okc_subclass_top_line stl,
18991: okc_line_styles_b lse2,
18992: okc_line_styles_b lse1,
18993: okc_k_lines_b cle
18994: WHERE cle.cle_id = p_cle_id
18995: AND cle.dnz_chr_id = p_chr_id
18996: AND cle.lse_id = lse1.id
19807:
19808: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19809: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19810: SELECT count(cle.id)
19811: FROM okc_line_styles_b lse2,
19812: okc_line_styles_b lse1,
19813: okc_k_lines_v cle
19814: WHERE cle.cle_id = p_cle_id
19815: AND cle.dnz_chr_id = p_chr_id
19808: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19809: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19810: SELECT count(cle.id)
19811: FROM okc_line_styles_b lse2,
19812: okc_line_styles_b lse1,
19813: okc_k_lines_v cle
19814: WHERE cle.cle_id = p_cle_id
19815: AND cle.dnz_chr_id = p_chr_id
19816: AND cle.lse_id = lse1.id
19821: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19822: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19823: SELECT cle.id
19824: FROM okc_subclass_top_line stl,
19825: okc_line_styles_b lse2,
19826: okc_line_styles_b lse1,
19827: okc_k_lines_v cle
19828: WHERE cle.cle_id = p_cle_id
19829: AND cle.dnz_chr_id = p_chr_id
19822: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19823: SELECT cle.id
19824: FROM okc_subclass_top_line stl,
19825: okc_line_styles_b lse2,
19826: okc_line_styles_b lse1,
19827: okc_k_lines_v cle
19828: WHERE cle.cle_id = p_cle_id
19829: AND cle.dnz_chr_id = p_chr_id
19830: AND cle.lse_id = lse1.id
19837: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19838: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19839: SELECT cle.id
19840: FROM okc_subclass_top_line stl,
19841: okc_line_styles_b lse2,
19842: okc_line_styles_b lse1,
19843: okc_k_lines_v cle
19844: WHERE cle.cle_id = p_cle_id
19845: AND cle.dnz_chr_id = p_chr_id
19838: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19839: SELECT cle.id
19840: FROM okc_subclass_top_line stl,
19841: okc_line_styles_b lse2,
19842: okc_line_styles_b lse1,
19843: okc_k_lines_v cle
19844: WHERE cle.cle_id = p_cle_id
19845: AND cle.dnz_chr_id = p_chr_id
19846: AND cle.lse_id = lse1.id
19853: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19854: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19855: SELECT cle.id
19856: FROM okc_subclass_top_line stl,
19857: okc_line_styles_b lse3,
19858: okc_line_styles_b lse2,
19859: okc_line_styles_b lse1,
19860: okc_k_lines_b cle
19861: WHERE cle.dnz_chr_id = p_chr_id
19854: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19855: SELECT cle.id
19856: FROM okc_subclass_top_line stl,
19857: okc_line_styles_b lse3,
19858: okc_line_styles_b lse2,
19859: okc_line_styles_b lse1,
19860: okc_k_lines_b cle
19861: WHERE cle.dnz_chr_id = p_chr_id
19862: AND cle.lse_id = lse1.id
19855: SELECT cle.id
19856: FROM okc_subclass_top_line stl,
19857: okc_line_styles_b lse3,
19858: okc_line_styles_b lse2,
19859: okc_line_styles_b lse1,
19860: okc_k_lines_b cle
19861: WHERE cle.dnz_chr_id = p_chr_id
19862: AND cle.lse_id = lse1.id
19863: AND lse1.lty_code = G_ADDON_LINE_LTY_CODE
19868: AND lse3.id = stl.lse_id
19869: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
19870: AND cle.cle_id in (SELECT cle.id
19871: FROM okc_subclass_top_line stl,
19872: okc_line_styles_b lse2,
19873: okc_line_styles_b lse1,
19874: okc_k_lines_b cle
19875: WHERE cle.cle_id = p_cle_id
19876: AND cle.dnz_chr_id = p_chr_id
19869: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
19870: AND cle.cle_id in (SELECT cle.id
19871: FROM okc_subclass_top_line stl,
19872: okc_line_styles_b lse2,
19873: okc_line_styles_b lse1,
19874: okc_k_lines_b cle
19875: WHERE cle.cle_id = p_cle_id
19876: AND cle.dnz_chr_id = p_chr_id
19877: AND cle.lse_id = lse1.id