APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_K_REL_OBJS

Line 127: FROM okc_k_rel_objs

123: -- Cursor for Gettin g Contract hader id for a particular Order Header
124: CURSOR l_kexists_csr
125: IS
126: SELECT chr_id
127: FROM okc_k_rel_objs
128: WHERE object1_id1 = TO_CHAR (p_order_hdr_id);
129:
130: -- And JTOT_OBJECT1_CODE = (Select Object_id from JTF_OBJECTS_B where object_code =
131: -- And OBJECT1_NAME = 'OE_ORDER_HEADERS';

Line 558: FROM okc_k_rel_objs

554: IS
555: CURSOR l_khdr_csr (p_order_hdr_id NUMBER)
556: IS
557: SELECT chr_id
558: FROM okc_k_rel_objs
559: WHERE object1_id1 = TO_CHAR (p_order_hdr_id)
560: AND jtot_object1_code = 'OKX_ORDERHEAD';
561:
562: --Added for bug# 5382119

Line 570: ,Okc_k_rel_objs rel

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
574: AND rel.jtot_object1_code = 'OKX_ORDERHEAD'

Line 2906: FROM okc_k_rel_objs_v

2902: p_object_code VARCHAR2
2903: )
2904: IS
2905: SELECT object1_id1
2906: FROM okc_k_rel_objs_v
2907: WHERE cle_id = p_line_id
2908: AND chr_id = p_hdr_id
2909: AND jtot_object1_code = p_object_code;
2910: