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.

APPS.IEU_TASKS_ENUMS_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 64: -- AND exists (SELECT /+ no_unnest index(m jtf_rs_group_members_n1) / null

60: -- WHERE types.task_type_id in
61: -- (SELECT /*+ use_nl(tasks) */ task_type_id FROM JTF_TASKS_B TASKS
62: -- WHERE OPEN_FLAG = 'Y'
63: -- and TASKS.OWNER_TYPE_CODE= 'RS_GROUP'
64: -- AND exists (SELECT /*+ no_unnest index(m jtf_rs_group_members_n1) */ null
65: -- FROM JTF_RS_GROUP_MEMBERS m
66: -- WHERE RESOURCE_ID = p_resource_id
67: -- and GROUP_ID=TASKS.OWNER_ID
68: -- AND NVL(DELETE_FLAG,'N') <> 'Y' )

Line 65: -- FROM JTF_RS_GROUP_MEMBERS m

61: -- (SELECT /*+ use_nl(tasks) */ task_type_id FROM JTF_TASKS_B TASKS
62: -- WHERE OPEN_FLAG = 'Y'
63: -- and TASKS.OWNER_TYPE_CODE= 'RS_GROUP'
64: -- AND exists (SELECT /*+ no_unnest index(m jtf_rs_group_members_n1) */ null
65: -- FROM JTF_RS_GROUP_MEMBERS m
66: -- WHERE RESOURCE_ID = p_resource_id
67: -- and GROUP_ID=TASKS.OWNER_ID
68: -- AND NVL(DELETE_FLAG,'N') <> 'Y' )
69: -- AND TASKS.entity = 'TASK'

Line 82: FROM JTF_RS_GROUP_MEMBERS M,

78: TYPES.NAME TASK_TYPE
79: FROM JTF_TASK_TYPES_TL TYPES
80: WHERE EXISTS
81: ( SELECT 1
82: FROM JTF_RS_GROUP_MEMBERS M,
83: JTF_TASKS_B TASKS
84: WHERE M.RESOURCE_ID = p_resource_id
85: AND TYPES.TASK_TYPE_ID=TASKS.TASK_TYPE_ID
86: AND NVL(M.DELETE_FLAG,'N') <> 'Y'

Line 105: -- AND exists (SELECT /+ no_unnest index(m jtf_rs_group_members_n1) / null

101: -- WHERE types.task_type_id in
102: -- (SELECT /*+ use_nl(tasks) */ task_type_id FROM JTF_TASKS_B TASKS
103: -- WHERE OPEN_FLAG = 'Y'
104: -- and TASKS.OWNER_TYPE_CODE= 'RS_TEAM'
105: -- AND exists (SELECT /*+ no_unnest index(m jtf_rs_group_members_n1) */ null
106: -- FROM JTF_RS_TEAM_MEMBERS m
107: -- WHERE TEAM_RESOURCE_ID = p_resource_id
108: -- and TEAM_ID=TASKS.OWNER_ID
109: -- AND NVL(DELETE_FLAG,'N') <> 'Y' )

Line 173: FROM JTF_RS_GROUP_MEMBERS

169: WHERE TYPES.TASK_TYPE_ID IN (SELECT /*+ use_nl(tasks asg) */ TASKS.TASK_TYPE_ID
170: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS
171: WHERE exists
172: (SELECT null
173: FROM JTF_RS_GROUP_MEMBERS
174: WHERE RESOURCE_ID = p_resource_id
175: and group_id=asg.resource_id
176: AND NVL(DELETE_FLAG,'N') <> 'Y' )
177: AND TASKS.TASK_ID = ASG.TASK_ID

Line 507: from jtf_rs_group_members m

503: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
504: -- Begin fix by spamujul for 7024226
505: -- Commented the Following code in include index in the where clause
506: /* l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
507: from jtf_rs_group_members m
508: where m.group_id = owner_id
509: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
510: ' and m.resource_id = :resource_id)'; */
511: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select /*+ index(m JTF_RS_GROUP_MEMBERS_N1) */

Line 511: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select /+ index(m JTF_RS_GROUP_MEMBERS_N1) /

507: from jtf_rs_group_members m
508: where m.group_id = owner_id
509: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
510: ' and m.resource_id = :resource_id)'; */
511: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select /*+ index(m JTF_RS_GROUP_MEMBERS_N1) */
512: m.resource_id
513: from jtf_rs_group_members m
514: where m.group_id = owner_id
515: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||

Line 513: from jtf_rs_group_members m

509: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
510: ' and m.resource_id = :resource_id)'; */
511: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select /*+ index(m JTF_RS_GROUP_MEMBERS_N1) */
512: m.resource_id
513: from jtf_rs_group_members m
514: where m.group_id = owner_id
515: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
516: ' and m.resource_id = :resource_id) ';
517: -- End fix by spamujul for 7024226

Line 549: from jtf_rs_group_members m

545: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_GO_SEC_V';
546: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_GO_DS';
547: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
548: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
549: from jtf_rs_group_members m
550: where m.group_id = owner_id
551: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
552: ' and m.resource_id = :resource_id) and
553: TASK_TYPE_ID = :task_type_id';

Line 589: from jtf_rs_group_members m

585: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_GO_SEC_V';
586: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_GO_DS';
587: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
588: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
589: from jtf_rs_group_members m
590: where m.group_id = owner_id
591: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
592: ' and m.resource_id = :resource_id) and
593: TASK_TYPE_ID = :task_type_id';

Line 635: from jtf_rs_group_members m

631: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_GA_SEC_V';
632: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_GA_DS';
633: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
634: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
635: from jtf_rs_group_members m
636: where m.group_id = owner_id
637: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
638: ' and m.resource_id = :resource_id) ';
639: l_tk_list(l_node_counter).NODE_TYPE := 0;

Line 669: from jtf_rs_group_members m

665: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_GA_SEC_V';
666: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_GA_DS';
667: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
668: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
669: from jtf_rs_group_members m
670: where m.group_id = owner_id
671: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
672: ' and m.resource_id = :resource_id) and
673: TASK_TYPE_ID = :task_type_id';

Line 708: from jtf_rs_group_members m

704: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_GA_SEC_V';
705: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_GA_DS';
706: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
707: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
708: from jtf_rs_group_members m
709: where m.group_id = owner_id
710: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
711: ' and m.resource_id = :resource_id) and
712: TASK_TYPE_ID = :task_type_id';