DROP PROCEDURE ConsultaReporteListaPrecCliProc
GO
CREATE PROCEDURE ConsultaReporteListaPrecCliProc
(	
	@PRCLVLCUSTID	UD_PRCLVLCUSTID
)
AS

SELECT OP_PRCLVLCUSTDET.SITEID as Almacen,SITE.NAME,INVTIDSKU as Codigo,DESCR as Descripcion,SLS_PRICE as Prec_Ant,
       DISCMTO as Monto_Desc,SLS_PRICECUST as Prec_Nuevo 
FROM OP_PRCLVLCUSTDET JOIN SITE
ON OP_PRCLVLCUSTDET.SITEID=SITE.SITEID
WHERE PRCLVLCUSTID=@PRCLVLCUSTID ORDER BY INVTIDSKU 





