APPS.OKS_OCINT_PUB dependencies on CSI_INSTANCE_STATUSES

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 719: ,csi_instance_statuses st

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
723: AND mtl.inventory_item_id = csi.inventory_item_id