DROP PROCEDURE IF EXISTS sp_alm_ItemsGuiaRemision_list;
DELIMITER $$
CREATE  PROCEDURE `sp_alm_ItemsGuiaRemision_list`(IN `Rguia` INT)
    NO SQL
BEGIN

SELECT ProductID, ProductName, QuantityProduct, unitCode, ProductCode FROM `tec_referral_guide_items` WHERE id_referral_guide = Rguia;

END$$
DELIMITER ;