USE [ZUCCO_PILOTO_FMT_2B]
GO

/****** Object:  View [dbo].[VI_API_ARTICULOS_INVENTARIO]    Script Date: 10/20/2020 11:15:17 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW VI_API_ARTICULOS_INVENTARIO

SELECT A.CODSEC, A.CODART, A.UNIVEN, C.DVE, A.EXIVTA, A.EXIDEP, B.CODBAR, D.COO, A.DETART,
(SELECT PRECIO FROM LISTA_PRECIO_DET AS E INNER JOIN APAREMP AS F ON E.ID=F.LISTA_V WHERE E.SEC=A.CODSEC AND E.ART=A.CODART ) AS PREVEN ,
A.COSTO, A.DEPSN, '' AS FOTO
FROM ARTICULOS AS A
LEFT JOIN CODBAR AS B
ON A.CODSEC=B.CODSEC AND A.CODART=B.CODART
INNER JOIN AUNIVTA AS C ON A.UNIVEN=C.ID
LEFT JOIN A_COD_ORI AS D ON D.SEC=A.CODSEC AND D.ART=A.CODART
GO