[Home] [Help]
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
337: WHERE fa_cim.cle_id = fa_cle.id
4161: CURSOR l_lne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
4162: SELECT kle.id,
4163: kle.name
4164: FROM OKC_K_LINES_V kle,
4165: OKC_LINE_STYLES_B ls,
4166: OKC_STATUSES_B sts
4167: WHERE kle.lse_id = ls.id
4168: AND ls.lty_code = ltycode
4169: AND kle.dnz_chr_id = chrid
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
4532: WHERE top.dnz_chr_id = p_chr_id
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
4532: WHERE top.dnz_chr_id = p_chr_id
4533: AND top.lse_id = top_style.id
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
4557: AND f2.dnz_chr_id = p_chr_id
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
4574: AND f2.dnz_chr_id = p_chr_id
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
5147: AND cle.sts_code = sts.code
7790: --down_payment_yes_no
7791: FROM
7792: okl_k_lines kle,
7793: okc_k_lines_v cle,
7794: okc_line_styles_b sty,
7795: okc_statuses_b sts
7796: WHERE cle.id = kle.id
7797: AND dnz_chr_id = p_chr_id
7798: AND cle.lse_id = sty.id
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
7846: AND cle.chr_id = p_chr_id
9378: name,
9379: kle.residual_value
9380: FROM okc_k_lines_v cle,
9381: okl_k_lines kle,
9382: okc_line_styles_b sty,
9383: okc_statuses_b sts
9384: WHERE cle.lse_id = sty.id
9385: AND cle.dnz_chr_id = p_chr_id
9386: AND cle.id = kle.id
9538: * select kl.dnz_chr_id syndId
9539: * from OKC_K_ITEMS_V ITM,
9540: * OKC_K_LINES_V KL,
9541: * OKL_K_HEADERS_FULL_V KHR,
9542: * OKC_LINE_STYLES_B lse
9543: * where KL.LSE_ID=lse.id
9544: * and lse.lty_code='SHARED'
9545: * AND KL.CHR_ID =KL.DNZ_CHR_ID
9546: * AND KL.DNZ_CHR_ID = ITM.DNZ_CHR_ID
9584: CURSOR l_inst_csr( chrId NUMBER ) IS
9585: SELECT inst.object_id1_new
9586: FROM OKL_TXL_ITM_INSTS inst,
9587: OKL_K_LINES_FULL_V kle,
9588: OKC_LINE_STYLES_B lse
9589: WHERE inst.kle_id = kle.id
9590: AND lse.id = kle.lse_id
9591: AND lse.lty_code = 'INST_ITEM'
9592: AND kle.dnz_chr_id = chrId;
9596: CURSOR l_shipto_csr( chrId NUMBER ) IS
9597: SELECT inv.shipping_address_id1
9598: FROM OKL_SUPP_INVOICE_DTLS inv,
9599: OKL_K_LINES_FULL_V kle,
9600: OKC_LINE_STYLES_B lse
9601: WHERE inv.cle_id = kle.id
9602: AND lse.id = kle.lse_id
9603: AND lse.lty_code = 'ITEM'
9604: AND kle.dnz_chr_id = chrId;
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
10655: AND chr.id = cle.chr_id
10656: AND chr.id = cle.dnz_chr_id
11187: ) IS
11188:
11189: --Bug#3931587
11190: CURSOR pmnt_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
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,
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
11200: AND rgp.cle_id = line.id
11279: kle.residual_grnty_amount,
11280: kle.start_date,
11281: kle.end_date
11282: FROM OKL_K_LINES_FULL_V kle,
11283: OKC_LINE_STYLES_B ls,
11284: OKC_STATUSES_B sts
11285: WHERE kle.lse_id = ls.id
11286: AND ls.lty_code = ltycode
11287: AND kle.dnz_chr_id = chrid
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
11564: WHERE kle.id = cleb.id
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')
11567: AND cleb.cle_id = cleb_asst.id
12045: fa.id fa_id,
12046: txd.tax_book
12047: FROM okc_k_items cim,
12048: okc_k_lines_V fa,
12049: okc_line_styles_b fa_lse,
12050: OKL_TRX_ASSETS trx,
12051: okl_txl_assets_b txl,
12052: okl_txd_assets_v txd,
12053: okc_statuses_b sts
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
12950: AND cle.cle_id = p_cle_id
12951: AND cle.lse_id = lse.id