--ABS-101228
------ DELIVERYSCAN -----
CREATE INDEX XSP2DELIVERYSCAN ON DELIVERYSCAN (BUSINESSUNIT_ID, WEAREREMPLOYMENT_LINK_ID, NVL(PACKINGNOTE_ID,0));
CREATE INDEX XSP3DELIVERYSCAN ON DELIVERYSCAN (BUSINESSUNIT_ID, DISTRIBUTIONPOINT_LINK_ID, NVL(PACKINGNOTE_ID,0));
CREATE INDEX XSP4DELIVERYSCAN ON DELIVERYSCAN (NVL(PACKINGNOTE_ID,0),BUSINESSUNIT_ID,CUSTOMER_LINK_ID);
CREATE INDEX XSP5DELIVERYSCAN ON DELIVERYSCAN (UNIQUEITEM_LINK_ID ASC, PACKINGNOTE_ID ASC);