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_TASK_TYPES_TL

Line 40: FROM JTF_TASK_TYPES_TL TYPES

36:
37: -- Owned By Me
38: CURSOR c_ind_own_task_nodes_1 IS
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'

Line 59: -- FROM JTF_TASK_TYPES_TL TYPES

55: -- Begin fix for 7412700 by spamujul
56: -- Commented the Following code to improved the performance
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'

Line 79: FROM JTF_TASK_TYPES_TL TYPES

75: CURSOR c_grp_own_task_nodes_1 IS
76: SELECT /*+ first_rows */
77: TYPES.TASK_TYPE_ID TASK_TYPE_ID,
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

Line 100: -- FROM JTF_TASK_TYPES_TL TYPES

96: -- Begin fix for 7412700 by spamujul
97: -- Commented the Following code to improved the performance
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'

Line 119: FROM JTF_TASK_TYPES_TL TYPES

115: CURSOR c_team_own_task_nodes_1 IS
116: SELECT /*+ first_rows */
117: TYPES.TASK_TYPE_ID TASK_TYPE_ID,
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

Line 140: FROM JTF_TASK_TYPES_TL TYPES

136:
137:
138: CURSOR c_assign_ind_task_nodes_1 IS
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

Line 167: JTF_TASK_TYPES_TL TYPES

163:
164: CURSOR c_assign_grp_task_nodes_1 IS
165: SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
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

Line 192: JTF_TASK_TYPES_TL TYPES

188:
189: CURSOR c_assign_team_task_nodes_1 IS
190: SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
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