DBA Data[Home] [Help]

APPS.OKC_QA_PRICE_PVT dependencies on OKC_K_ITEMS

Line 305: FROM okc_k_items

301: --NOTE: validate_covered_line_qty is to be called ONLY for (sub) lines with lse_id = 41 as we support only
302: -- this particular linestyle for 'OKX_COVLINE' object code
303: CURSOR c_get_quantity1 (b_cle_id NUMBER) is
304: SELECT object1_id1, number_of_items qty
305: FROM okc_k_items
306: WHERE cle_id = b_cle_id
307: AND dnz_chr_id = p_chr_id
308: AND jtot_object1_code = 'OKX_COVLINE';
309:

Line 314: FROM okc_k_items

310:
311: --gets the quantity of the parent non-service item line being pointed to
312: CURSOR c_get_quantity2 (b_cle_id NUMBER) is
313: SELECT number_of_items qty
314: FROM okc_k_items
315: WHERE cle_id = b_cle_id
316: AND dnz_chr_id = p_chr_id;
317:
318: