| 
			
			 | 
		#1 | 
| 
			
			 Участник 
		
			
	 | 
	
	
	
		
		
			
			
			Временная таблица + RLS
			 
			
			Наткнулся на следующую ситуацию. 
		
		
		
		
		
		
		
	Есть временная таблица (создается на сервере), к ней присоединена InventDim. Все нормально работает. Но как только на InventDim настроил RLS (в моем случае десяток складов, разделенных запятыми) то тут же начинаются жуткие тормоза при прокручивании записей в гриде, после чего аксапта вообще вылетает с сообщением, что сервер завершил сессию. Если строк во временной таблице немного (порядка 100) то еще кое-как работает. Посмотрел мониторинг запросов, испугался. Вот пример запроса: SELECT A.INVENTDIMID,A.INVENTBATCHID,A.WMSLOCATIONID,A.WMSPALLETID,A.INVENTSERIALID,A.INVENTLOCATIONID,A.CONFIGID,A.INVENTSIZEID,A.INVENTCOLORID,A.INVENTGTDID_RU,A.RECID FROM INVENTDIM A WHERE ((DATAAREAID=?) AND ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((INVENTDIMID=?) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))) AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))) ORDER BY A.DATAAREAID,A.INVENTDIMID OPTION(FAST 1) Такое ощущение, что аксапта прибавила условия RLS в несколько десятков раз вместо одного.  | 
| 
	
 | 
| 
	
	 | 
	
			 
			Похожие темы
		 | 
	||||
| Тема | Ответов | |||
| Отчет и временная таблица | 2 | |||
| Временная таблица | 21 | |||
| производительность: map или временная таблица | 5 | |||
| select sum(amount) from временная таблица | 6 | |||
| next и временная таблица | 3 | |||
		
  |