APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_K_LINES_B

Line 320: From OKC_K_LINES_B kl

316: AND ki.object1_id1 = TO_CHAR (p_object_id)
317: AND ki.jtot_object1_code = g_jtf_warr;
318:
319: /*Select Kl.id
320: From OKC_K_LINES_B kl
321: ,OKC_K_ITEMS ki
322: Where kl.dnz_chr_id = p_K_hdr_Id
323: And kl.lse_id in (14,19)
324: And ki.cle_id = kl.id

Line 333: FROM okc_k_lines_b kl, okc_k_items ki

329: */
330: CURSOR l_cov_lvl_csr (p_line_id NUMBER, p_object_id NUMBER)
331: IS
332: SELECT 'x'
333: FROM okc_k_lines_b kl, okc_k_items ki
334: WHERE ki.cle_id = kl.ID
335: AND ki.jtot_object1_code = 'OKX_CUSTPROD'
336: AND kl.lse_id IN (25, 18)
337: AND kl.cle_id = p_line_id

Line 571: ,Okc_k_lines_b kl

567: SELECT /*+ leading (kii) use_nl (kii rel kl kiw)
568: index(kiw okc_k_items_n1) */ 'D'
569: FROM Okc_k_items kii
570: ,Okc_k_rel_objs rel
571: ,Okc_k_lines_b kl
572: ,Okc_k_items kiw
573: WHERE rel.object1_id1 = c_order_hdr_id
574: AND rel.jtot_object1_code = 'OKX_ORDERHEAD'
575: AND kiw.dnz_chr_id = rel.chr_id

Line 5286: FROM okc_k_lines_b kl

5282: -----
5283: CURSOR l_kl_csr (p_kid NUMBER)
5284: IS
5285: SELECT SUM (price_negotiated)
5286: FROM okc_k_lines_b kl
5287: WHERE kl.dnz_chr_id = p_kid
5288: AND kl.lse_id IN (25, 7, 9, 10, 8, 35, 11)
5289: AND kl.price_negotiated BETWEEN 0 AND 90999999
5290: HAVING SUM (price_negotiated) BETWEEN NVL (p_min, 0)

Line 5302: -- From okc_k_lines_b kl

5298: -- (decode(sign(p_regz_date-kl.end_date),1,kl.end_date,p_regz_date) -
5299: -- decode(sign(p_regz_date+1-kl.start_date),1,kl.start_date,p_regz_date+1)
5300: -- + 1)
5301: -- )
5302: -- From okc_k_lines_b kl
5303: -- Where kl.dnz_chr_id = p_kid And
5304: -- kl.lse_id in (25,7,9,10,8,35,11) And
5305: -- kl.price_negotiated between 0 and 90999999
5306: -- Having Sum(price_negotiated) between p_min and p_max;

Line 5328: FROM okc_k_lines_b kl

5324: )
5325: ),
5326: 0
5327: )
5328: FROM okc_k_lines_b kl
5329: WHERE kl.dnz_chr_id = p_kid
5330: AND kl.lse_id IN (25, 7, 9, 10, 8, 35, 11)
5331: AND kl.price_negotiated BETWEEN 0 AND 90999999
5332: AND kl.start_date <= p_regz_date;

Line 5662: FROM okc_k_lines_b

5658: SELECT TRUNC (MAX (date_billed_to))
5659: FROM oks_bill_cont_lines
5660: WHERE cle_id IN (
5661: SELECT ID
5662: FROM okc_k_lines_b
5663: WHERE dnz_chr_id = p_chr_id
5664: AND lse_id IN (1, 12, 14, 19));
5665:
5666: CURSOR l_bill_cont_line_csr