APPS.OKS_IBINT_PUB dependencies on OKS_K_ORDER_DETAILS

Line 107: From Oks_k_order_details

103: Is
104:
105: Cursor l_link_csr1 Is
106: Select NVL(link_ord_line_id1, order_line_id1)
107: From Oks_k_order_details
108: Where order_line_id1 = to_char(p_ordeR_line_id);
109:
110: Cursor l_link_csr_a(l_link_ord_id varchar2) Is
111: Select id ,ordeR_line_id1,object_version_number

Line 112: From Oks_k_order_details

108: Where order_line_id1 = to_char(p_ordeR_line_id);
109:
110: Cursor l_link_csr_a(l_link_ord_id varchar2) Is
111: Select id ,ordeR_line_id1,object_version_number
112: From Oks_k_order_details
113: Where link_ord_line_id1 = l_link_ord_id
114: And Chr_id Is NULL;
115:
116: Cursor l_link_csr_b(l_link_ord_id varchar2) Is

Line 118: From Oks_k_order_details

114: And Chr_id Is NULL;
115:
116: Cursor l_link_csr_b(l_link_ord_id varchar2) Is
117: Select id ,ordeR_line_id1,object_version_number
118: From Oks_k_order_details
119: Where order_line_id1 = l_link_ord_id
120: And Chr_id Is NULL;
121:
122:

Line 293: From Oks_K_Order_Details_V

289: ,site_id
290: ,cod_type
291: ,billing_profile_id --new parameter added -vigandhi (May29-02)
292: ,line_renewal_type
293: From Oks_K_Order_Details_V
294: Where ORDER_LINE_ID1 = to_char(p_order_line_id);
295:
296: l_chdr_id NUMBER;
297:

Line 390: ,OKS_K_ORDER_DETAILS_V OD

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