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 5332: FROM okc_k_lines_b kl

5328: -----
5329: CURSOR l_kl_csr (p_kid NUMBER)
5330: IS
5331: SELECT SUM (price_negotiated)
5332: FROM okc_k_lines_b kl
5333: WHERE kl.dnz_chr_id = p_kid
5334: AND kl.lse_id IN (25, 7, 9, 10, 8, 35, 11)
5335: AND kl.price_negotiated BETWEEN 0 AND 90999999
5336: HAVING SUM (price_negotiated) BETWEEN NVL (p_min, 0)

Line 5348: -- From okc_k_lines_b kl

5344: -- (decode(sign(p_regz_date-kl.end_date),1,kl.end_date,p_regz_date) -
5345: -- decode(sign(p_regz_date+1-kl.start_date),1,kl.start_date,p_regz_date+1)
5346: -- + 1)
5347: -- )
5348: -- From okc_k_lines_b kl
5349: -- Where kl.dnz_chr_id = p_kid And
5350: -- kl.lse_id in (25,7,9,10,8,35,11) And
5351: -- kl.price_negotiated between 0 and 90999999
5352: -- Having Sum(price_negotiated) between p_min and p_max;

Line 5374: FROM okc_k_lines_b kl

5370: )
5371: ),
5372: 0
5373: )
5374: FROM okc_k_lines_b kl
5375: WHERE kl.dnz_chr_id = p_kid
5376: AND kl.lse_id IN (25, 7, 9, 10, 8, 35, 11)
5377: AND kl.price_negotiated BETWEEN 0 AND 90999999
5378: AND kl.start_date <= p_regz_date;

Line 5708: FROM okc_k_lines_b

5704: SELECT TRUNC (MAX (date_billed_to))
5705: FROM oks_bill_cont_lines
5706: WHERE cle_id IN (
5707: SELECT ID
5708: FROM okc_k_lines_b
5709: WHERE dnz_chr_id = p_chr_id
5710: AND lse_id IN (1, 12, 14, 19));
5711:
5712: CURSOR l_bill_cont_line_csr