[Home] [Help]
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
Name |
NODE_LABEL |
COUNT |
RESOURCE_ID |
RESOURCE_TYPE |
IEU_PARAM_PK_VALUE |