· 6 years ago · Oct 17, 2019, 10:10 PM
1USE [dbEmissary]
2GO
3
4/****** Object: StoredProcedure [askerick].[spq_Emissary_DatosOrdenCorreo] Script Date: 17/10/2019 05:06:13 p. m. ******/
5SET ANSI_NULLS ON
6GO
7
8SET QUOTED_IDENTIFIER ON
9GO
10
11-- =============================================
12-- Author: <Author,,Name>
13-- Create date: <Create Date,,>
14-- Description: <Description,,>
15-- =============================================
16CREATE PROCEDURE [askerick].[spq_Emissary_DatosOrdenCorreo] (
17 @orden_id int
18 )
19AS
20BEGIN
21 SELECT Integracion.[plataforma_id]
22 ,[url]
23 ,[apiKey]
24 ,[secretKey]
25 ,numOrden
26 ,TrackingNo
27 ,paqueteria
28 FROM [askerick].[tblEmissary_Orden] as Orden
29 LEFT JOIN [askerick].[tblEmissary_Integracion] as Integracion on Integracion.user_id = orden.usuario_id
30 LEFT JOIN [dbEmissary].[admin_db].[tblEmissary_Envios] as Envios on Envios.envio_id = Orden.envio_id
31 WHERE orden.orden_id =@orden_id AND Integracion.[plataforma_id] = 1
32END
33GO