View: IEU_UWQ_TASKS_NODE_V

Product:	IEU - Universal Work Queue
Description:	View used for UWQ selector SpreadTable.
Implementation/DBA Data:	APPS.IEU_UWQ_TASKS_NODE_V

View Text

SELECT NODE_LABEL
, COUNT
, RESOURCE_ID
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, RESOURCE_ID IEU_PARAM_PK_VALUE
FROM IEU_UWQ_SEL_RT_NODES
WHERE SEL_ENUM_ID = 10054
AND NVL(NOT_VALID
, 'N') = 'N'
AND NODE_DEPTH = 2
AND RESOURCE_ID = (SELECT RESOURCE_ID
FROM JTF_RS_RESOURCE_EXTNS
WHERE USER_ID = FND_GLOBAL.USER_ID)

Columns