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.CSM_SERVICE_HISTORY_EVENT_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 35: , JTF_TASK_ASSIGNMENTS ta

31:
32: CURSOR c_closed_assignments( b_incident_id NUMBER ) IS
33: SELECT TASK_ASSIGNMENT_ID
34: FROM JTF_TASKS_B tk
35: , JTF_TASK_ASSIGNMENTS ta
36: , JTF_TASK_TYPES_B tt
37: , JTF_TASK_STATUSES_B tkst
38: , JTF_TASK_STATUSES_B tast
39: WHERE tk.SOURCE_OBJECT_ID = b_incident_id

Line 100: , JTF_TASK_ASSIGNMENTS ta

96: CURSOR c_closed_assignments( b_hist_incident_id NUMBER, b_incident_id IN number,
97: b_user_id IN number) IS
98: SELECT TASK_ASSIGNMENT_ID
99: FROM JTF_TASKS_B tk
100: , JTF_TASK_ASSIGNMENTS ta
101: , JTF_TASK_TYPES_B tt
102: , JTF_TASK_STATUSES_B tkst
103: , JTF_TASK_STATUSES_B tast
104: WHERE tk.SOURCE_OBJECT_ID = b_hist_incident_id

Line 183: , JTF_TASK_ASSIGNMENTS ta

179: , b_user_id NUMBER )
180: IS
181: SELECT MAX(tk.SCHEDULED_END_DATE ) AS "TASK_TIME"
182: FROM JTF_TASKS_B tk
183: , JTF_TASK_ASSIGNMENTS ta
184: , JTF_RS_RESOURCE_EXTNS rs
185: WHERE tk.SOURCE_OBJECT_TYPE_CODE = 'SR'
186: AND tk.SOURCE_OBJECT_ID = b_incident_id
187: AND tk.TASK_ID = ta.TASK_ID

Line 201: , JTF_TASK_ASSIGNMENTS ta

197: SELECT DISTINCT inc.INCIDENT_ID
198: , inc.CLOSE_DATE
199: FROM CS_INCIDENTS_ALL_B inc
200: , JTF_TASKS_B tk
201: , JTF_TASK_ASSIGNMENTS ta
202: , CS_INCIDENT_STATUSES_B ists
203: , JTF_TASK_TYPES_B tt
204: , JTF_TASK_STATUSES_B tkst
205: , JTF_TASK_STATUSES_B tast

Line 235: , JTF_TASK_ASSIGNMENTS ta

231: SELECT DISTINCT inc.INCIDENT_ID
232: , inc.CLOSE_DATE
233: FROM CS_INCIDENTS_ALL_B inc
234: , JTF_TASKS_B tk
235: , JTF_TASK_ASSIGNMENTS ta
236: , CS_INCIDENT_STATUSES_B ists
237: , JTF_TASK_TYPES_B tt
238: , JTF_TASK_STATUSES_B tkst
239: , JTF_TASK_STATUSES_B tast

Line 445: , JTF_TASK_ASSIGNMENTS ta

441: FROM CSM_INCIDENTS_ALL_ACC acc
442: , CS_INCIDENTS_ALL_B inc
443: , CS_INCIDENT_STATUSES_b cis
444: , JTF_TASKS_B tsk
445: , JTF_TASK_ASSIGNMENTS ta
446: , JTF_RS_RESOURCE_EXTNS rs
447: WHERE tsk.SOURCE_OBJECT_ID = inc.INCIDENT_ID
448: AND tsk.SOURCE_OBJECT_TYPE_CODE = 'SR'
449: AND tsk.TASK_ID = ta.TASK_ID

Line 591: JTF_TASK_ASSIGNMENTS ASG,

587: WHERE INCIDENT_ID = b_incident_id
588: AND USER_ID = b_user_id
589: AND NOT EXISTS (SELECT 'X'
590: FROM CSM_TASK_ASSIGNMENTS_ACC ACC,
591: JTF_TASK_ASSIGNMENTS ASG,
592: JTF_TASKS_B TASK
593: WHERE ACC.TASK_ASSIGNMENT_ID = ASG.TASK_ASSIGNMENT_ID
594: AND ASG.TASK_ID = TASK.TASK_ID
595: AND TASK.SOURCE_OBJECT_TYPE_CODE = 'SR'