APPS.IEU_TASKS_ENUMS_PVT dependencies on JTF_TASKS_B

Line 43: FROM JTF_TASKS_B TASKS

39: SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
40: FROM JTF_TASK_TYPES_TL TYPES
41: WHERE EXISTS (
42: SELECT 1
43: FROM JTF_TASKS_B TASKS
44: WHERE OPEN_FLAG = 'Y'
45: AND TASKS.OWNER_ID = p_resource_id
46: AND TASKS.OWNER_TYPE_CODE NOT IN ( 'RS_GROUP','RS_TEAM' )
47: AND TASKS.entity = 'TASK'

Line 61: -- (SELECT /*+ use_nl(tasks) */ task_type_id FROM JTF_TASKS_B TASKS

57: -- CURSOR c_grp_own_task_nodes_1 IS
58: -- SELECT /*+ first_rows */ TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
59: -- FROM JTF_TASK_TYPES_TL TYPES
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

Line 83: JTF_TASKS_B TASKS

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'
87: AND TASKS.OWNER_ID =M.GROUP_ID

Line 102: -- (SELECT /*+ use_nl(tasks) */ task_type_id FROM JTF_TASKS_B TASKS

98: -- CURSOR c_team_own_task_nodes_1 IS
99: -- SELECT /*+ first_rows */ TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
100: -- FROM JTF_TASK_TYPES_TL TYPES
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

Line 123: JTF_TASKS_B TASKS

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'
127: AND TASKS.OWNER_ID =M.TEAM_ID

Line 143: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS

139: SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
140: FROM JTF_TASK_TYPES_TL TYPES
141: WHERE TYPES.TASK_TYPE_ID IN
142: (SELECT /*+ use_nl(tasks asg) */ TASKS.TASK_TYPE_ID
143: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS
144: WHERE exists
145: (SELECT null
146: FROM JTF_OBJECT_USAGES
147: WHERE OBJECT_USER_CODE = 'RESOURCES'

Line 166: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS

162: SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
163: FROM
164: JTF_TASK_TYPES_TL TYPES
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

Line 188: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS

184: SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
185: FROM
186: JTF_TASK_TYPES_TL TYPES
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