spq_Emissary_DatosOrdenCorreo

USE [dbEmissary]
GO

/****** Object:  StoredProcedure [askerick].[spq_Emissary_DatosOrdenCorreo]    Script Date: 17/10/2019 05:06:13 p. m. ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [askerick].[spq_Emissary_DatosOrdenCorreo] (
	@orden_id int
	)
AS
BEGIN
	SELECT Integracion.[plataforma_id]
      ,[url]
      ,[apiKey]
      ,[secretKey]
      ,numOrden
	  ,TrackingNo
	  ,paqueteria
  FROM [askerick].[tblEmissary_Orden] as Orden
  LEFT JOIN  [askerick].[tblEmissary_Integracion] as Integracion on Integracion.user_id = orden.usuario_id
  LEFT JOIN [dbEmissary].[admin_db].[tblEmissary_Envios] as Envios on Envios.envio_id = Orden.envio_id
  WHERE orden.orden_id =@orden_id  AND Integracion.[plataforma_id] = 1
END
GO