Operation Details |
Description: | Returns a list of work queues for the current user. |
Sterotype: | nsmulti |
SQL |
SELECT name, workQueueID INTO :name, :workQueueID FROM WORKQUEUE WHERE allowUserSubscriptionInd = '1' AND upper(name) LIKE :workQueueName AND workQueueID NOT IN ( SELECT DISTINCT workQueueID FROM WORKQUEUESUBSCRIPTION WHERE subscriberType = 'RL9' AND userName = :userName ) |