APPS.OKS_IBINT_PUB dependencies on CSI_ITEM_INSTANCES

Line 24: from csi_item_instances csi , oe_order_lines_all ol

20: Return BOOLEAN
21: IS
22: CURSOR l_parent_cp_csr IS
23: Select csi.instance_id
24: from csi_item_instances csi , oe_order_lines_all ol
25: where ol.line_id = csi.last_oe_order_line_id
26: and ol.inventory_item_id = csi.inventory_item_id
27: and ol.line_id = p_order_line_id ;
28:

Line 356: from csi_item_instances

352: where org_id = p_org_id;
353:
354: Cursor l_refnum_csr(p_cp_id NUMBER) IS
355: select instance_number
356: from csi_item_instances
357: where instance_id = p_cp_id;
358:
359: Cursor l_subscr_csr(p_instance_id Number) Is
360: Select instance_id

Line 383: From CSI_ITEM_INSTANCES Csi,

379: Cursor Cust_csr(p_id Number) is
380:
381: Select csi.last_oe_agreement_id Product_agreement_id
382: ,oh.transactional_curr_code Original_order_currency_code
383: From CSI_ITEM_INSTANCES Csi,
384: OE_ORDER_HEADERS_ALL OH,
385: OE_ORDER_LINES_ALL OL
386: Where csi.instance_id = p_id
387: And csi.last_oe_order_line_id = ol.line_id

Line 2027: from csi_item_instances

2023: Where oks.instance_id = tmp.old_customer_product_id;
2024:
2025: Cursor l_refnum_csr(p_cp_id NUMBER) IS
2026: select instance_number
2027: from csi_item_instances
2028: where instance_id = p_cp_id;
2029:
2030: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;
2031: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;