APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_K_ITEMS

Line 264: FROM okc_k_items_v

260: -- Cursor for selecting the Customer product id for a Covered level
261: CURSOR l_k_items_csr (p_line_id NUMBER)
262: IS
263: SELECT object1_id1
264: FROM okc_k_items_v
265: WHERE cle_id = p_line_id AND jtot_object1_code = g_jtf_cusprod;
266:
267: l_serv_rec l_serv_csr%ROWTYPE;
268: l_item_rec l_k_items_csr%ROWTYPE;

Line 314: FROM okc_k_items ki

310: -- gets all the contract lines for a given contract header
311: CURSOR l_serv_csr (p_object_id NUMBER)
312: IS
313: SELECT ki.cle_id line_id
314: FROM okc_k_items ki
315: WHERE ki.dnz_chr_id = p_k_hdr_id
316: AND ki.object1_id1 = TO_CHAR (p_object_id)
317: AND ki.jtot_object1_code = g_jtf_warr;
318:

Line 321: ,OKC_K_ITEMS ki

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
325: And ki.object1_id1 = to_char(p_object_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 568: index(kiw okc_k_items_n1) */ 'D'

564: CURSOR c_Service_Dup(c_order_hdr_id IN VARCHAR2
565: ,c_warr_item_id IN VARCHAR2
566: ,c_instance_id IN VARCHAR2) IS
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

Line 569: FROM Okc_k_items kii

565: ,c_warr_item_id IN VARCHAR2
566: ,c_instance_id IN VARCHAR2) IS
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

Line 572: ,Okc_k_items 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
576: AND kiw.object1_id1 = c_warr_item_id

Line 2173: FROM okc_k_items_v ot, okc_k_lines_v ol

2169: -- Extwarranty cascading
2170: CURSOR get_warr_dates_csr
2171: IS
2172: SELECT MAX (ol.end_date)
2173: FROM okc_k_items_v ot, okc_k_lines_v ol
2174: WHERE ot.object1_id1 = TO_CHAR (p_cp_id)
2175: AND ol.ID = ot.cle_id
2176: AND ol.lse_id = 18;
2177:

Line 2820: FROM okc_k_items_v ki,

2816: kh.conversion_rate_date, kh.conversion_euro_rate,
2817: kh.scs_code, okl.tax_amount -- bug 3736860
2818: ,
2819: party.object1_id1 party_id
2820: FROM okc_k_items_v ki,
2821: okc_k_headers_b kh,
2822: oks_k_headers_b ks,
2823: okc_k_lines_v kl,
2824: oks_k_lines_b okl,

Line 2850: FROM okc_k_items_v

2846:
2847: CURSOR get_serv_id (p_cleid NUMBER)
2848: IS
2849: SELECT object1_id1
2850: FROM okc_k_items_v
2851: WHERE cle_id = p_cleid
2852: AND jtot_object1_code IN (g_jtf_warr, g_jtf_extwar, g_jtf_usage);
2853:
2854: --***

Line 4545: FROM okc_k_items kit

4541: IS
4542: CURSOR get_rule_objectid_csr
4543: IS
4544: SELECT object1_id1
4545: FROM okc_k_items kit
4546: WHERE cle_id = p_cle_id;
4547:
4548: l_object_id NUMBER;
4549: BEGIN