-- ABS-67637

DROP INDEX XIF2SERVICECHARGEEVENT_DESC;
CREATE INDEX XIF2SERVICECHARGEEVENT_DESC ON SERVICECHARGEEVENT_DESC (LANGUAGE_ID ASC);

DROP VIEW V_SCANNINGSPERCUSTOMER_NORP;
DROP VIEW V_SCANNINGSPERCUSTOMERTOTALNRP;

CREATE INDEX XIF7STOCKROOM ON STOCKROOM (RECEIVESHIPMENTLOCATION_ID ASC);