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: ,JTF_TASK_STATUSES_B STB --Added the following code by rgandhi for Bug9920514
145: WHERE exists
146: (SELECT null
147: FROM JTF_OBJECT_USAGES

Line 170: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS

166: FROM
167: JTF_TASK_TYPES_TL TYPES
168: ,JTF_TASK_STATUSES_B STB --Added the following code by rgandhi for Bug9920514
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

Line 195: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS

191: FROM
192: JTF_TASK_TYPES_TL TYPES
193: ,JTF_TASK_STATUSES_B STB --Added the following code by rgandhi for Bug9920514
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