APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_K_ITEMS_V

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 2178: FROM okc_k_items_v ot, okc_k_lines_v ol

2174: -- Extwarranty cascading
2175: CURSOR get_warr_dates_csr
2176: IS
2177: SELECT MAX (ol.end_date)
2178: FROM okc_k_items_v ot, okc_k_lines_v ol
2179: WHERE ot.object1_id1 = TO_CHAR (p_cp_id)
2180: AND ol.ID = ot.cle_id
2181: AND ol.lse_id = 18;
2182:

Line 2866: FROM okc_k_items_v ki,

2862: kh.conversion_rate_date, kh.conversion_euro_rate,
2863: kh.scs_code, okl.tax_amount -- bug 3736860
2864: ,
2865: party.object1_id1 party_id
2866: FROM okc_k_items_v ki,
2867: okc_k_headers_b kh,
2868: oks_k_headers_b ks,
2869: okc_k_lines_v kl,
2870: oks_k_lines_b okl,

Line 2896: FROM okc_k_items_v

2892:
2893: CURSOR get_serv_id (p_cleid NUMBER)
2894: IS
2895: SELECT object1_id1
2896: FROM okc_k_items_v
2897: WHERE cle_id = p_cleid
2898: AND jtot_object1_code IN (g_jtf_warr, g_jtf_extwar, g_jtf_usage);
2899:
2900: --***