ALTER TABLE S2S_OPPORTUNITY modify S2S_SUBMISSION_TYPE_CODE null;
update S2S_OPPORTUNITY set S2S_SUBMISSION_TYPE_CODE = null;
ALTER TABLE S2S_OPPORTUNITY modify S2S_SUBMISSION_TYPE_CODE VARCHAR2(3);
update S2S_OPPORTUNITY set S2S_SUBMISSION_TYPE_CODE = '2';
ALTER TABLE S2S_OPPORTUNITY modify S2S_SUBMISSION_TYPE_CODE VARCHAR2(3) default '2' not null enable;
ALTER TABLE S2S_OPPORTUNITY ADD (CONSTRAINT FK_S2S_OPPORTUNITY_KRA FOREIGN KEY (S2S_SUBMISSION_TYPE_CODE)
	  REFERENCES S2S_SUBMISSION_TYPE (S2S_SUBMISSION_TYPE_CODE) ) ;
ALTER TABLE S2S_OPPORTUNITY ADD (CONSTRAINT FK_S2S_OPPORTUNITY_KRA1 FOREIGN KEY (REVISION_CODE)
	  REFERENCES S2S_REVISION_TYPE (S2S_REVISION_TYPE_CODE) ) ;
ALTER TABLE S2S_OPPORTUNITY ADD (CONSTRAINT FK_S2S_OPPORTUNITY_KRA2 FOREIGN KEY (PROPOSAL_NUMBER)
	  REFERENCES EPS_PROPOSAL (PROPOSAL_NUMBER) ) ;
commit;
 

Add constraints to s2s opportunity table
Add constraints to s2s opportunity table

