APPS.OKS_OCINT_PUB dependencies on CSI_ITEM_INSTANCES

Line 183: ,csi_item_instances csi

179: Cursor csi_ib_trackable(l_ref_order_line_id Number , l_organization_id Number)
180: Is
181: Select mtl.comms_nl_trackable_flag
182: From mtl_system_items_b mtl
183: ,csi_item_instances csi
184: Where csi.instance_id = l_ref_order_line_id
185: and mtl.inventory_item_id = csi.inventory_item_id
186: and mtl.organization_id = l_organization_id
187: and mtl. serviceable_product_flag = 'Y';

Line 671: FROM csi_item_instances csi, okx_system_items_v mtl

667: IS
668: SELECT csi.instance_id cp_id, csi.inventory_item_id, mtl.NAME NAME,
669: mtl.description description, csi.quantity quantity,
670: csi.unit_of_measure uom_code
671: FROM csi_item_instances csi, okx_system_items_v mtl
672: WHERE csi.instance_id = cpid
673: AND mtl.inventory_item_id = csi.inventory_item_id
674: AND ROWNUM < 2;
675:

Line 709: FROM csi_item_instances csi, csi_instance_statuses st

705: /*COMMENTED AND MODIFIED FOR BUG6181908 -- FP BUG6006309
706: CURSOR l_custprod_csr (p_ordlineid NUMBER)
707: IS
708: SELECT csi.instance_id cp_id
709: FROM csi_item_instances csi, csi_instance_statuses st
710: WHERE csi.last_oe_order_line_id = p_ordlineid
711: AND NVL (st.service_order_allowed_flag, 'N') = 'Y'
712: AND csi.instance_status_id = st.instance_status_id;
713: */

Line 718: FROM csi_item_instances csi

714:
715: Cursor l_custprod_csr (p_ordlineid Number
716: ,c_organization_id NUMBER) IS
717: SELECT csi.instance_id cp_id
718: FROM csi_item_instances csi
719: ,csi_instance_statuses st
720: ,mtl_system_items_b mtl
721: WHERE csi.last_oe_order_line_id = p_ordlineid
722: AND csi.instance_status_id = st.instance_status_id

Line 823: FROM csi_item_instances csi,

819: CURSOR l_get_dates_csr (p_cp_id NUMBER)
820: IS
821: SELECT csi.install_date, ol.actual_shipment_date,
822: mtl.service_starting_delay
823: FROM csi_item_instances csi,
824: oe_order_lines_all ol,
825: okx_system_items_v mtl
826: WHERE csi.instance_id = p_cp_id
827: AND csi.last_oe_order_line_id = ol.line_id

Line 869: FROM csi_item_instances

865:
866: CURSOR l_refnum_csr (p_cp_id NUMBER)
867: IS
868: SELECT instance_number
869: FROM csi_item_instances
870: WHERE instance_id = p_cp_id;
871:
872:
873: -- Cursor to roll up the tax amount from sublines to the topline

Line 940: FROM csi_item_instances csi,oe_order_lines_all ol,

936:
937: /*Added for CLOUD ER 16039680*/
938: CURSOR get_item_type(l_instance_id NUMBER) IS
939: SELECT b.contract_item_type_code
940: FROM csi_item_instances csi,oe_order_lines_all ol,
941: mtl_system_items_b_kfv b,
942: mtl_system_items_tl t
943: WHERE csi.last_oe_order_line_id=ol.line_id
944: AND csi.instance_id = l_instance_id

Line 953: FROM okc_k_rel_objs okro,oe_order_lines_all ol,csi_item_instances csi

949: AND b.organization_id = okc_context.get_okc_organization_id;
950:
951: CURSOR Check_Contract_Exists(p_instance_id NUMBER,p_order_header_id NUMBER) IS
952: SELECT okro.chr_id
953: FROM okc_k_rel_objs okro,oe_order_lines_all ol,csi_item_instances csi
954: WHERE ol.line_id=okro.object1_id1
955: AND csi.last_oe_order_line_id=ol.line_id
956: AND csi.instance_id=p_instance_id
957: AND ol.header_id=p_order_header_id;

Line 4884: FROM csi_item_instances

4880:
4881: CURSOR l_refnum_csr (p_cp_id NUMBER)
4882: IS
4883: SELECT instance_number
4884: FROM csi_item_instances
4885: WHERE instance_id = p_cp_id;
4886:
4887: CURSOR l_contract_hdr_dtls IS
4888: SELECT okhb.start_date,okhb.end_date,okcl.cust_acct_id,okcl.sts_code