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.

[Home] [Help]

APPS.IEU_TASKS_ENUMS_PVT dependencies on JTF_RS_TEAM_MEMBERS

Line 106: -- FROM JTF_RS_TEAM_MEMBERS m

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' )
110: -- AND TASKS.entity = 'TASK'

Line 122: FROM JTF_RS_TEAM_MEMBERS M,

118: TYPES.NAME TASK_TYPE
119: FROM JTF_TASK_TYPES_TL TYPES
120: WHERE EXISTS
121: ( SELECT 1
122: FROM JTF_RS_TEAM_MEMBERS M,
123: JTF_TASKS_B TASKS
124: WHERE M.TEAM_RESOURCE_ID = p_resource_id
125: and TYPES.TASK_TYPE_ID=TASKS.TASK_TYPE_ID
126: AND NVL(M.DELETE_FLAG,'N') <> 'Y'

Line 191: FROM JTF_RS_TEAM_MEMBERS

187: WHERE TYPES.TASK_TYPE_ID IN (SELECT /*+ use_nl(tasks asg) */ TASKS.TASK_TYPE_ID
188: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS
189: WHERE exists
190: (SELECT null
191: FROM JTF_RS_TEAM_MEMBERS
192: WHERE TEAM_RESOURCE_ID = p_resource_id
193: and team_id=asg.resource_id
194: AND NVL(DELETE_FLAG,'N') <> 'Y' )
195: AND TASKS.TASK_ID = ASG.TASK_ID

Line 727: from jtf_rs_team_members m

723: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_TO_V';
724: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_TO_DS';
725: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
726: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.team_resource_id
727: from jtf_rs_team_members m
728: where m.team_id = owner_id
729: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
730: ' and m.team_resource_id = :resource_id)';
731: l_tk_list(l_node_counter).NODE_TYPE := 0;

Line 760: from jtf_rs_team_members m

756: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_TO_V';
757: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_TO_DS';
758: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
759: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.team_resource_id
760: from jtf_rs_team_members m
761: where m.team_id = owner_id
762: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
763: ' and m.team_resource_id = :resource_id) and
764: TASK_TYPE_ID = :task_type_id';

Line 798: from jtf_rs_team_members m

794: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_TO_V';
795: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_TO_DS';
796: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
797: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.team_resource_id
798: from jtf_rs_team_members m
799: where m.team_id = owner_id
800: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
801: ' and m.team_resource_id = :resource_id) and
802: TASK_TYPE_ID = :task_type_id';

Line 844: from jtf_rs_team_members m

840: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_TA_V';
841: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_TA_DS';
842: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
843: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.team_resource_id
844: from jtf_rs_team_members m
845: where m.team_id = owner_id
846: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
847: ' and m.team_resource_id = :resource_id)';
848: l_tk_list(l_node_counter).NODE_TYPE := 0;

Line 876: from jtf_rs_team_members m

872: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_TA_V';
873: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_TA_DS';
874: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
875: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.team_resource_id
876: from jtf_rs_team_members m
877: where m.team_id = owner_id
878: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
879: ' and m.team_resource_id = :resource_id) and
880: TASK_TYPE_ID = :task_type_id';

Line 913: from jtf_rs_team_members m

909: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_TA_V';
910: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_TA_DS';
911: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
912: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.team_resource_id
913: from jtf_rs_team_members m
914: where m.team_id = owner_id
915: and nvl(delete_flag,'||''''||'N'||''''||') = '|| ':delete_flag'||
916: ' and m.team_resource_id = :resource_id) and
917: TASK_TYPE_ID = :task_type_id';