CREATE         Procedure sp_OCEstadosDocumentoListarCompradorDocs
	@idempresa		int,
	@iddoc01		int,
	@iddoc02		int,
	@iddoc03		int,
	@iddoc04		int,
	@iddoc05		int,
	@iddoc06		int,
	@iddoc07		int,
	@iddoc08		int,
	@iddoc09		int,
	@iddoc10		int,
	@iddoc11		int,
	@iddoc12		int,
	@iddoc13		int,
	@iddoc14		int,
	@iddoc15		int,
	@iddoc16		int,
	@iddoc17		int,
	@iddoc18		int,
	@iddoc19		int,
	@iddoc20		int,
	@iddoc21		int,
	@iddoc22		int,
	@iddoc23		int,
	@iddoc24		int,
	@iddoc25		int,
	@iddoc26		int,
	@iddoc27		int,
	@iddoc28		int,
	@iddoc29		int,
	@iddoc30		int,
	@iddoc31		int,
	@iddoc32		int,
	@iddoc33		int,
	@iddoc34		int,
	@iddoc35		int,
	@iddoc36		int,
	@iddoc37		int,
	@iddoc38		int,
	@iddoc39		int,
	@iddoc40		int,
	@iddoc41		int,
	@iddoc42		int,
	@iddoc43		int,
	@iddoc44		int,
	@iddoc45		int,
	@iddoc46		int,
	@iddoc47		int,
	@iddoc48		int,
	@iddoc49		int,
	@iddoc50		int
	

as

select 	oc.idempresa,
	oc.idorgc,
	oc.idoc			as iddoc,
	oc.numoc		as numdoc,
	oc.nomoc		as nomdoc,
	oc.idestadodoc,
	oc.comentarios,
	oc.fechaenvio,
	orgc.nombre		as nombreorgc,
	oc.fechacreacion,
	getdate()		as fecharecepcion,
	0			as cantidadlineas,
	u.nombre		as nombreusuario,
	ed.descripcionc		as estado,
	oc.empvnombref 	as nombproveedor,
	oc.empcnombref 	as cliente, 
	oc.descuentos,
	oc.porcimpuesto,
	oc.total,
	mon.descripcorta	as descripcortamo,
	mon.descriplarga	as DESCRIPLARGAMO,
	0			as esintegrado,
	oc.idempresav,
	OC.ENVIADA		ENVIADA

from 
	oc, 
	usuarios 	u, 
	orgc, 
	estadosdoc 	ed, 
	moneda 	mon

where 
	oc.idoc in (@iddoc01,@iddoc02,@iddoc03,@iddoc04,@iddoc05,@iddoc06,@iddoc07,@iddoc08,@iddoc09,@iddoc10,
		@iddoc11,@iddoc12,@iddoc13,@iddoc14,@iddoc15,@iddoc16,@iddoc17,@iddoc18,@iddoc19,@iddoc20,
		@iddoc21,@iddoc22,@iddoc23,@iddoc24,@iddoc25,@iddoc26,@iddoc27,@iddoc28,@iddoc29,@iddoc30,
		@iddoc31,@iddoc32,@iddoc33,@iddoc34,@iddoc35,@iddoc36,@iddoc37,@iddoc38,@iddoc39,@iddoc40,
		@iddoc41,@iddoc42,@iddoc43,@iddoc44,@iddoc45,@iddoc46,@iddoc47,@iddoc48,@iddoc49,@iddoc50)	and
	oc.idempresa		= @idempresa		and
	oc.idoc 			= oc.idoc		and
	oc.idempresa		= oc.idempresa		and -- por rendimiento
	oc.idorgc		= oc.idorgc		and -- por rendimiento

	oc.idempresa		= orgc.idempresa	and
	oc.idorgc		= orgc.idorgc		and

	oc.idempresa		= u.idempresa		and
	oc.idusuario		= u.idusuario		and
	ed.idestadodoc		= oc.idestadodoc	and
	oc.idmoneda		= mon.idmoneda	
						
order by 
	oc.fechacreacion desc


GO