
/****** Object:  StoredProcedure [dbo].[reg_doc_estadoTipoDocumento_m]    Script Date: 21/11/2019 11:44:21 a.m. ******/
DROP PROCEDURE [dbo].[reg_doc_estadoTipoDocumento_m]
GO

/****** Object:  StoredProcedure [dbo].[reg_doc_estadoTipoDocumento_m]    Script Date: 21/11/2019 11:44:21 a.m. ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO

CREATE PROCEDURE [dbo].[reg_doc_estadoTipoDocumento_m]
	@p_id INT,
	@p_eid as varchar(50) = ''
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],
		[estadoTipoDocumento] AS [estadoTipoDocumento],
		[estadoTipoDocumento_codigo] AS [estadoTipoDocumento_codigo],
		[afectaIndicador] AS [afectaIndicador],
		[editaDocumento] AS [editaDocumento],
		[orden] AS [orden],
		[puedeRegresar] AS [puedeRegresar],
		[color] AS [color],
		[afectaInventario] AS [afectaInventario],
		[id_tipoDocumento] AS [id_tipoDocumento],
		[descripcion] AS [descripcion],
		observacionesObligatorio AS [observacionesObligatorio] ,
		motivoObligatorio AS [motivoObligatorio]
	FROM [doc_estadoTipoDocumento]
	WHERE	(id = @p_id)
	AND	(eid LIKE @p_eid+'%')

END

GO


