-- ABS-93898/ ABS-94636

CREATE INDEX XSPPACKINGNOTE4 ON PACKINGNOTE (CORRECTCONSIGNMENTNOTE ASC, CONSIGNMENTNOTE_ID ASC, PACKINGNOTE_ID ASC);

DROP INDEX XSPCONSIGNMENTNOTE1;

CREATE INDEX XSPCONSIGNMENTNOTE1 ON CONSIGNMENTNOTE (CUSTOMER_LINK_ID ASC, STATUS_ID ASC, CONSIGNMENTNOTENUMBER ASC);