-- ABS-38506/ ABS-38528

ALTER TABLE ALLOCATIONSTATUS MODIFY (STOCKCOUNTSCHEDULE_LINK_ID NULL);
 
DROP INDEX XAK1ALLOCATIONSTATUS;
CREATE UNIQUE INDEX XAK1ALLOCATIONSTATUS ON ALLOCATIONSTATUS (ALLOCATIONDATE ASC, DISTRIBUTIONPOINT_LINK_ID ASC, NVL(STOCKCOUNTSCHEDULE_LINK_ID, 0) ASC);
