Временная таблица + RLS

[leshy]

Наткнулся на следующую ситуацию.

Есть временная таблица (создается на сервере), к ней присоединена 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 в несколько десятков раз вместо одного.

[mit]

может права как то интересно настоены?

[glibs]

Мы как-то наблюдали подобную проблему. Не уверен, была ли там временная таблица, но эффект был очень похожий. Решать не стали. Скорее всего — это бага.

[leshy]

В настройках прав ничего особенного: есть группа пользователей для которой настроен RLS на InventDim, через запятую указан список складов (это видно и по запросу).
Если сделать таблицу постоянной - тогда все нормально.

А можно как нибудь для формы отключить RLS (он учитываетя при создании временной таблицы)? Пробовал в Init формы указывать inventDim.recordLevelSecurity(false) - результат тот же.

[mit]

мне казалось что эти запросы формируются на уровне ядра

[leshy]

Вобщем да, но в руководстве разработчика сказано что этим процессом можно управлять:
You may want to code other methods on reports or forms, and still have the rules of RLS applied. Or, within the RLS-scoped methods listed in the previous section, you might want the scoped RLS to be disabled on selected queries. To have this functionality, a method on a table buffer is available, recordLevelSecurity, to overrule default behavior.

Within scoped RLS, you simply "sign-up" for RLS coverage using:


SalesLine.recordLevelSecurity(true);



And in RLS covered X++ code, you may “sign-up” for an exemption from the rule by using:


SalesLine.recordLevelSecurity(false);

[mit]

да, есть такая штука, но сам на практике не проверял