Index: OBJTimpl/Herbevoorrading/OphalenProductenKlein.cls.xml
===================================================================
diff -u -r68860 -r70687
--- OBJTimpl/Herbevoorrading/OphalenProductenKlein.cls.xml	(.../OphalenProductenKlein.cls.xml)	(revision 68860)
+++ OBJTimpl/Herbevoorrading/OphalenProductenKlein.cls.xml	(.../OphalenProductenKlein.cls.xml)	(revision 70687)
@@ -45,12 +45,16 @@
     Set SqlStatement= "  SELECT "
 	_ "  it.NAME ITEMID"
 	_ "  ,it.DESCRIPTION"
- 	_ "  ,it.USRNUM2 as DREMPEL" ;_ " ,case when it.NAME = '0.888.547.3' then 250 when it.NAME = '0.644.998.3' then 100 when it.NAME = '0.661.673.8' then 100 else it.USRNUM2 end as DREMPEL"
+ 	_ "  ,it.USRNUM2 as DREMPEL" 
  	_ "  ,it.USRNUM3 as MINAANTAL"
  	_ "  ,case when CHILDOID is null then null else it.USRNUM2 end PODMULTIPLE"
     _ " FROM objt_item it "
     _ " LEFT OUTER JOIN OBJT_ITEMLINK on Childclassname ='objt.custom.common.itemmgt.bo.Item' and ParentClassName='objt.common.itemmgt.bo.ItemGroup' and [PARENTOID]=14726528 and CHILDOID=it.OID"
-    _ " WHERE isnull(it.USRNUM2,0)>0 " ; or it.NAME in ('0.661.673.8','0.644.998.3','0.888.547.3')"
+    _ " WHERE isnull(it.USRNUM2,0)>0 " 
+    _ "	 	AND it.OID not in (SELECT AIL.ITEMOID"
+  	_ "      	FROM [vanhoecke].[dbo].[OBJT_ASRSITEMLINK] AIL"
+  	_ "			LEFT OUTER JOIN OBJT_ASRS A on A.OID=AIL.ASRSOID"
+  	_ " 		WHERE A.ID='KARDEX' and AIL.ISONLINE='T')"
     
     try
     {