SELECT II.DESCRIPTOR_ID, COUNT(II.INSTANCE_ID) as INSTANCE_COUNT, II.STATUS_CODE, II.STATUS_CODE_TYPE, II.USABILITY_CODE, II.USABILITY_CODE_TYPE, IE.LOT_NUMBER, II.EXPIRATION_DATE, II.LOCATION_ID, II.SUB_LOCATION_ID, II.OFFICER_ID, OO.MASTER_OFFICER_ID AS NEW_OFFICER_ID, II.EMPLOYEE_ID, II.ORGANIZATION_ID, II.PARENT_INSTANCE_ID, II.LAST_WAREHOUSE_ID, II.LAST_LOCATION_ID FROM ITEM_INSTANCES II INNER JOIN ITEM_ENTRY_INSTANCES IEI ON II.INSTANCE_ID = IEI.INSTANCE_ID INNER JOIN ITEM_ENTRIES IE ON IEI.ENTRY_ID = IE.ENTRY_ID LEFT OUTER JOIN OFFICERS OO ON II.OFFICER_ID = OO.OFFICER_ID AND OO.MASTER_OFFICER_ID IS NOT NULL WHERE DISPOSITION_FLAG = 'N' AND SERIALIZED_HINT_FLAG = 'N' GROUP BY II.DESCRIPTOR_ID, II.STATUS_CODE, II.STATUS_CODE_TYPE, II.USABILITY_CODE, II.USABILITY_CODE_TYPE, IE.LOT_NUMBER, II.EXPIRATION_DATE, II.LOCATION_ID, II.SUB_LOCATION_ID, II.OFFICER_ID, OO.MASTER_OFFICER_ID, II.EMPLOYEE_ID, II.ORGANIZATION_ID, II.PARENT_INSTANCE_ID, II.LAST_WAREHOUSE_ID, II.LAST_LOCATION_ID