ALTER TABLE COMBGRUPOTPPRAT ADD CDFILIAL VARCHAR2(4) NOT NULL
/
ALTER TABLE COMBGRUPOTPPRAT ADD 
	CONSTRAINT FKPLA01147FILIAL FOREIGN KEY (CDFILIAL) 
		REFERENCES FILIAL (CDFILIAL)
/
CREATE INDEX FKPLA01147FILIAL ON COMBGRUPOTPPRAT (CDFILIAL)