DBA Data[Home] [Help]

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 808: FROM csi_item_instances csi,

804: CURSOR l_get_dates_csr (p_cp_id NUMBER)
805: IS
806: SELECT csi.install_date, ol.actual_shipment_date,
807: mtl.service_starting_delay
808: FROM csi_item_instances csi,
809: oe_order_lines_all ol,
810: okx_system_items_v mtl
811: WHERE csi.instance_id = p_cp_id
812: AND csi.last_oe_order_line_id = ol.line_id

Line 843: FROM csi_item_instances

839:
840: CURSOR l_refnum_csr (p_cp_id NUMBER)
841: IS
842: SELECT instance_number
843: FROM csi_item_instances
844: WHERE instance_id = p_cp_id;
845:
846:
847: -- Cursor to roll up the tax amount from sublines to the topline