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 409: From OKC_K_REL_OBJS RO, OkC_K_HEADERS_V OH

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

Line 424: From okc_k_rel_objs rel

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

Line 440: From okc_k_rel_objs_v rel

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