APPS.OKS_OCINT_PUB dependencies on OKX_SYSTEM_ITEMS_V

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 825: okx_system_items_v mtl

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
828: AND csi.inventory_item_id = mtl.id1
829: AND ROWNUM < 2;