eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IEU_UWQM_WL_NODE_V

Product:	IEU - Universal Work Queue
Description:	View used for UWQ selector SpreadTable.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT NODE_LABEL
, IEU_UWQ_GET_NEXT_WORK_PVT.GET_WORKLIST_QUEUE_COUNT(RESOURCE_ID
, 0
, NODE_TYPE) + IEU_UWQ_GET_NEXT_WORK_PVT.GET_WORKLIST_QUEUE_COUNT(RESOURCE_ID
, 1
, NODE_TYPE) + IEU_UWQ_GET_NEXT_WORK_PVT.GET_WORKLIST_QUEUE_COUNT(RESOURCE_ID
, 2
, NODE_TYPE) COUNT
, IEU_UWQ_GET_NEXT_WORK_PVT.GET_WORKLIST_QUEUE_COUNT(RESOURCE_ID
, 0
, NODE_TYPE) AVAIL_COUNT
, RESOURCE_ID
FROM IEU_UWQ_SEL_RT_NODES
WHERE NVL(NOT_VALID
, 'N') = 'N'
AND SEL_ENUM_ID = 10053
AND NODE_PID = 0

Columns

Name
NODE_LABEL
COUNT
AVAIL_COUNT
RESOURCE_ID