Dyncraft-EWI

 

Use EWI_Admin

 

DECLARE @PROD_TRACKER_AreaID AS INT=147

 

SELECT 
MVCR.MaterialValidationCustomRuleID,
AO.[Option],
MVCR.AreaID
,'[dbo].[MaterialValidation_CustomRule_'+ CAST(MVCR.MaterialValidationCustomRuleID AS NVARCHAR(1))   +'_SELECT' AS [VALIDATION_SPROC_NAME]
FROM EWI_Admin.dbo.MaterialValidationCustomRule MVCR
INNER JOIN ApplicationOptions AO
    ON AO.ApplicationOptionID=MVCR.ApplicationOptionID
WHERE 
    AreaID = @PROD_TRACKER_AreaID
    AND 
    MVCR.isActive = 1