IF EXISTS (SELECT 1  FROM sys.views    WHERE object_id = OBJECT_ID(N'[dbo].[V_PRC_GRP_ECON]'))
DROP VIEW [dbo].[V_PRC_GRP_ECON];
GO

CREATE VIEW [dbo].[V_PRC_GRP_ECON] AS
Select
	pge.CD_GRP_ECON ,
	pge.NM_GRP_ECON ,
	pge.DT_ULT_ALT ,
	pge.DT_CAD,
	pge.CD_USU ,
	pge.STS_GRP_ECON ,
	pge.CD_USU_ALT,
	pge.CD_EMP,
	pec.VALOR AS CONCILIADOR_LINX
FROM 
	PRC_GRP_ECON pge
	INNER join PRC_EMP_CONFIG pec on pec.CD_EMP = pge.CD_EMP
where 
	pec.CD_CHAVE like 'CONCILIADOR_LINX'


