ALTER PROCEDURE [dbo].[reg_doc_documento_cotizacion]
	@p_id INT
AS
BEGIN
	SELECT 	[id] AS [id],
		[uid] AS [uid],
		[eid] AS [eid],
		[id_usuario_modifico] AS [id_usuario_modifico],
		[id_usuario_creo] AS [id_usuario_creo],
		[fechaModificacion] AS [fechaModificacion],
		[fechaCreacion] AS [fechaCreacion],
		[active] AS [active],
		[documento.cotizacion] AS [documento.cotizacion],
		[version] AS [version],
		[validez] AS [validez],
		[contacto] AS [contacto],
		[cargo] AS [cargo],
		[encabezado] AS [encabezado],
		[condiciones] AS [condiciones],
		[notas] AS [notas],
		[esAIU] AS [esAIU],
		[procentajeA] AS [procentajeA],
		[procentajeI] AS [procentajeI],
		[procentajeU] AS [procentajeU],
		[valorA] AS [valorA],
		[valorI] AS [valorI],
		[valorU] AS [valorU],
		[id_sucursal] AS [id_sucursal],
		[id_equipo] AS [id_equipo],
		[id_usuario_asesor] AS [id_usuario_asesor],
		[email] AS [email],
		[telefono] as [telefono]
	FROM [doc_documento.cotizacion]
	WHERE	(id = @p_id)

END
GO
