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 198: FROM JTF_RS_TEAM_MEMBERS

194: WHERE TYPES.TASK_TYPE_ID IN (SELECT /*+ use_nl(tasks asg) */ TASKS.TASK_TYPE_ID
195: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS
196: WHERE exists
197: (SELECT null
198: FROM JTF_RS_TEAM_MEMBERS
199: WHERE TEAM_RESOURCE_ID = p_resource_id
200: and team_id=asg.resource_id
201: AND NVL(DELETE_FLAG,'N') <> 'Y' )
202: AND TASKS.TASK_ID = ASG.TASK_ID

Line 763: from jtf_rs_team_members m

759: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_TO_SEC_V';
760: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_TO_DS';
761: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
762: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.team_resource_id
763: from jtf_rs_team_members m
764: where m.team_id = owner_id
765: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
766: ' and m.team_resource_id = :resource_id)';
767: l_tk_list(l_node_counter).NODE_TYPE := 0;

Line 798: from jtf_rs_team_members m

794: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_TO_SEC_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 838: from jtf_rs_team_members m

834: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_TO_SEC_V';
835: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_TO_DS';
836: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
837: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.team_resource_id
838: from jtf_rs_team_members m
839: where m.team_id = owner_id
840: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
841: ' and m.team_resource_id = :resource_id) and
842: TASK_TYPE_ID = :task_type_id';

Line 886: from jtf_rs_team_members m

882: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_TA_SEC_V';
883: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_TA_DS';
884: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
885: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.team_resource_id
886: from jtf_rs_team_members m
887: where m.team_id = owner_id
888: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
889: ' and m.team_resource_id = :resource_id)';
890: l_tk_list(l_node_counter).NODE_TYPE := 0;

Line 920: from jtf_rs_team_members m

916: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_TA_SEC_V';
917: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_TA_DS';
918: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
919: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.team_resource_id
920: from jtf_rs_team_members m
921: where m.team_id = owner_id
922: and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
923: ' and m.team_resource_id = :resource_id) and
924: TASK_TYPE_ID = :task_type_id';

Line 959: from jtf_rs_team_members m

955: l_tk_list(l_node_counter).VIEW_NAME := 'IEU_UWQ_TASKS_TA_SEC_V';
956: l_tk_list(l_node_counter).DATA_SOURCE := 'IEU_UWQ_TASKS_TA_DS';
957: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
958: l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.team_resource_id
959: from jtf_rs_team_members m
960: where m.team_id = owner_id
961: and nvl(delete_flag,'||''''||'N'||''''||') = '|| ':delete_flag'||
962: ' and m.team_resource_id = :resource_id) and
963: TASK_TYPE_ID = :task_type_id';