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 169: FROM JTF_RS_GROUP_MEMBERS

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

Line 483: from jtf_rs_group_members m

479: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
480: -- Begin fix by spamujul for 7024226
481: -- Commented the Following code in include index in the where clause
482: /* l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
483: from jtf_rs_group_members m
484: where m.group_id = owner_id
485: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
486: ' and m.resource_id = :resource_id)'; */
487: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select /*+ index(m JTF_RS_GROUP_MEMBERS_N1) */

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

483: from jtf_rs_group_members m
484: where m.group_id = owner_id
485: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
486: ' and m.resource_id = :resource_id)'; */
487: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select /*+ index(m JTF_RS_GROUP_MEMBERS_N1) */
488: m.resource_id
489: from jtf_rs_group_members m
490: where m.group_id = owner_id
491: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||

Line 489: from jtf_rs_group_members m

485: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
486: ' and m.resource_id = :resource_id)'; */
487: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select /*+ index(m JTF_RS_GROUP_MEMBERS_N1) */
488: m.resource_id
489: from jtf_rs_group_members m
490: where m.group_id = owner_id
491: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
492: ' and m.resource_id = :resource_id) ';
493: -- End fix by spamujul for 7024226

Line 523: from jtf_rs_group_members m

519: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_GO_V';
520: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_GO_DS';
521: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
522: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
523: from jtf_rs_group_members m
524: where m.group_id = owner_id
525: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
526: ' and m.resource_id = :resource_id) and
527: TASK_TYPE_ID = :task_type_id';

Line 561: from jtf_rs_group_members m

557: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_GO_V';
558: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_GO_DS';
559: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
560: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
561: from jtf_rs_group_members m
562: where m.group_id = owner_id
563: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
564: ' and m.resource_id = :resource_id) and
565: TASK_TYPE_ID = :task_type_id';

Line 605: from jtf_rs_group_members m

601: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_GA_V';
602: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_GA_DS';
603: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
604: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
605: from jtf_rs_group_members m
606: where m.group_id = owner_id
607: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
608: ' and m.resource_id = :resource_id) ';
609: l_tk_list(l_node_counter).NODE_TYPE := 0;

Line 637: from jtf_rs_group_members m

633: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_GA_V';
634: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_GA_DS';
635: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
636: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
637: from jtf_rs_group_members m
638: where m.group_id = owner_id
639: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
640: ' and m.resource_id = :resource_id) and
641: TASK_TYPE_ID = :task_type_id';

Line 674: from jtf_rs_group_members m

670: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_GA_V';
671: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_GA_DS';
672: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
673: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
674: from jtf_rs_group_members m
675: where m.group_id = owner_id
676: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
677: ' and m.resource_id = :resource_id) and
678: TASK_TYPE_ID = :task_type_id';