VIEW: APPS.IEU_UWQ_TASKS_NODE_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)