APPS.OKS_IBINT_PUB dependencies on OKC_K_REL_OBJS

Line 31: From okc_k_rel_objs rel

27: and ol.line_id = p_order_line_id ;
28:
29: CURSOR l_k_exists (p_item_id NUMBER)IS
30: Select 'x'
31: From okc_k_rel_objs rel
32: ,okc_k_lines_b line
33: ,okc_k_items item
34: Where rel.Object1_Id1 = to_char(p_srvord_line_id)
35: And rel.jtot_object1_code = 'OKX_ORDERLINE'

Line 405: From OKC_K_REL_OBJS RO, OkC_K_HEADERS_V OH

401: -- cursor to get chr_id of existing warranty contract for an order. vigandhi
402:
403: Cursor get_chr_id_csr(p_object_id NUmber) IS
404: Select Chr_id
405: From OKC_K_REL_OBJS RO, OkC_K_HEADERS_V OH
406: Where RO.OBJECT1_ID1 = to_char(P_Object_id)
407: And RO.jtot_object1_code = 'OKX_ORDERHEAD'
408: And RO.rty_code = 'CONTRACTWARRANTYORDER'
409: And RO.chr_id = OH.id

Line 420: From okc_k_rel_objs rel

416: Where id = p_chr_id;
417:
418: Cursor l_rel_csr(p_ordlineid Number, p_serv_ordline_id Number,p_item_id Number) Is
419: Select rel.cle_id
420: From okc_k_rel_objs rel
421: ,okc_k_lines_b line
422: ,okc_k_items item
423: Where rel.Object1_Id1 in (to_char(p_ordlineid),to_char(p_serv_ordline_id))
424: And rel.jtot_object1_code = 'OKX_ORDERLINE'

Line 436: From okc_k_rel_objs_v rel

432:
433:
434: Cursor l_cle_csr(p_ordlineid Number, p_serv_ordline_id Number) Is
435: Select rel.cle_id
436: From okc_k_rel_objs_v rel
437: ,okc_k_lines_b line
438: Where rel.Object1_Id1 in (to_char(p_ordlineid),to_char(p_serv_ordline_id))
439: And rel.jtot_object1_code = 'OKX_ORDERLINE'
440: And line.id = rel.cle_id