
/****** Object:  View [dbo].[ApiFeaturesDefsView]    Script Date: 13.09.2021 14:54:51 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[ApiFeaturesDefsView]
AS
SELECT    ErpId Id,  ErpId, ObjectType, Name, Description, TypeNumber
FROM         dbo.ApiFeaturesErpDefsView
WHERE     EXISTS
                          (SELECT     Id, Editable, Required, Survey, ObjectDefId, ObjectType, FeatureDef, Lp
                            FROM          dbo.ApiDocumentFeatures
                            WHERE      (FeatureDef = dbo.ApiFeaturesErpDefsView.ErpId))


GO


