APPS.OKS_IBINT_PUB dependencies on OKS_K_ORDER_DETAILS

Line 111: From Oks_k_order_details

107: Is
108:
109: Cursor l_link_csr1 Is
110: Select NVL(link_ord_line_id1, order_line_id1)
111: From Oks_k_order_details
112: Where order_line_id1 = to_char(p_ordeR_line_id);
113:
114: Cursor l_link_csr_a(l_link_ord_id varchar2) Is
115: Select id ,ordeR_line_id1,object_version_number

Line 116: From Oks_k_order_details

112: Where order_line_id1 = to_char(p_ordeR_line_id);
113:
114: Cursor l_link_csr_a(l_link_ord_id varchar2) Is
115: Select id ,ordeR_line_id1,object_version_number
116: From Oks_k_order_details
117: Where link_ord_line_id1 = l_link_ord_id
118: And Chr_id Is NULL;
119:
120: Cursor l_link_csr_b(l_link_ord_id varchar2) Is

Line 122: From Oks_k_order_details

118: And Chr_id Is NULL;
119:
120: Cursor l_link_csr_b(l_link_ord_id varchar2) Is
121: Select id ,ordeR_line_id1,object_version_number
122: From Oks_k_order_details
123: Where order_line_id1 = l_link_ord_id
124: And Chr_id Is NULL;
125:
126:

Line 297: From Oks_K_Order_Details_V

293: ,site_id
294: ,cod_type
295: ,billing_profile_id --new parameter added -vigandhi (May29-02)
296: ,line_renewal_type
297: From Oks_K_Order_Details_V
298: Where ORDER_LINE_ID1 = to_char(p_order_line_id);
299:
300: l_chdr_id NUMBER;
301:

Line 394: ,OKS_K_ORDER_DETAILS_V OD

390: Cursor l_contact_csr(p_line_id Number) Is
391: Select OC.Object1_id1
392: ,OC.cro_code
393: From OKS_K_ORDER_CONTACTS_V OC
394: ,OKS_K_ORDER_DETAILS_V OD
395: Where OC.cod_id = OD.id
396: -- And OD.order_line_id1 = p_line_id;
397: And OD.order_line_id1 = to_char(p_line_id); -- Bug Fix #4896051
398: