-- ABS-109721 / ABS-109952

-----------------PRODUCTIONPROCESSSCAN TABLE ---------------- 
CREATE INDEX XSP1PRODUCTIONPROCESSSCAN ON PRODUCTIONPROCESSSCAN(NVL(UNIQUEITEMBUFFERINFO_ID, -1) ASC, PLANT_ID ASC, SCANDATE ASC);

