ALTER VIEW [dbo].[V_PRC_FILIAL_GRP_CP]
AS
SELECT 
	A.CD_EMP,
	A.CD_CTR CD_CTR_GRP_CP,
	A.CD_FILIAL,
	D.CD_CTR_DEPO, 
	D.CD_FILIAL_DEPO,
	D.FLAG_DEPO,
	PRC_FILIAL_GRP_EST_PED_ELETR_ENVIO.DS_GRP 
FROM 
	PRC_FILIAL_GRP_EST_PED_ELETR_ENVIO_CPL A
	INNER JOIN V_PRC_FILIAL_DEPOSITO D ON 
	A.CD_EMP =D.CD_EMP AND
	A.CD_FILIAL  =D.CD_FILIAL 
	INNER JOIN 	PRC_FILIAL_GRP_EST_PED_ELETR_ENVIO ON
	A.CD_CTR = PRC_FILIAL_GRP_EST_PED_ELETR_ENVIO.CD_CTR 


