ALTER TABLE CAPPRESMS ADD ACC_NO VARCHAR2(32) default ' ' not null;


ALTER TABLE  CAPPRESMS DROP CONSTRAINT CAPPRESMS_PK;
ALTER TABLE CAPPRESMS ADD CONSTRAINT CAPPRESMS_PK primary key (FSYS_ID, CAP_TYP, MBL_NO,ACC_NO);

ALTER TABLE  CAPPREBAL DROP CONSTRAINT CAPPREBAL_PK;
ALTER TABLE CAPPREBAL ADD CONSTRAINT CAPPREBAL_PK primary key (FSYS_ID, CAP_TYP, BNK_ORG,ACC_NO);