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.CSL_SERVICE_HISTORY_PKG dependencies on JTF_TASK_STATUSES_B

Line 167: , JTF_TASK_STATUSES_B ts

163: IS
164: CURSOR c_closed_tasks( b_incident_id NUMBER )IS
165: SELECT tk.TASK_ID
166: FROM JTF_TASKS_B tk
167: , JTF_TASK_STATUSES_B ts
168: WHERE tk.SOURCE_OBJECT_TYPE_CODE = 'SR'
169: AND tk.SOURCE_OBJECT_ID = b_incident_id
170: AND tk.TASK_STATUS_ID = ts.TASK_STATUS_ID
171: AND (ts.CLOSED_FLAG = 'Y'

Line 180: , JTF_TASK_STATUSES_B ts

176: CURSOR c_closed_assignments( b_task_id NUMBER ) IS
177: SELECT TASK_ASSIGNMENT_ID
178: , RESOURCE_ID
179: FROM JTF_TASK_ASSIGNMENTS ta
180: , JTF_TASK_STATUSES_B ts
181: WHERE ta.TASK_ID = b_task_id
182: AND ta.ASSIGNEE_ROLE = 'ASSIGNEE'
183: AND ts.TASK_STATUS_ID = ta.ASSIGNMENT_STATUS_ID
184: AND (ts.CLOSED_FLAG = 'Y'

Line 251: , JTF_TASK_STATUSES_B ts

247:
248: CURSOR c_closed_tasks( b_incident_id NUMBER )IS
249: SELECT tk.TASK_ID
250: FROM JTF_TASKS_B tk
251: , JTF_TASK_STATUSES_B ts
252: WHERE tk.SOURCE_OBJECT_TYPE_CODE = 'SR'
253: AND tk.SOURCE_OBJECT_ID = b_incident_id
254: AND tk.TASK_STATUS_ID = ts.TASK_STATUS_ID
255: AND (ts.CLOSED_FLAG = 'Y'

Line 264: , JTF_TASK_STATUSES_B ts

260: CURSOR c_closed_assignments( b_task_id NUMBER ) IS
261: SELECT TASK_ASSIGNMENT_ID
262: , RESOURCE_ID
263: FROM JTF_TASK_ASSIGNMENTS ta
264: , JTF_TASK_STATUSES_B ts
265: WHERE ta.TASK_ID = b_task_id
266: AND ta.ASSIGNEE_ROLE = 'ASSIGNEE'
267: AND ts.TASK_STATUS_ID = ta.ASSIGNMENT_STATUS_ID
268: AND (ts.CLOSED_FLAG = 'Y'

Line 427: , JTF_TASK_STATUSES_B tkst

423: , JTF_TASKS_B tk
424: , JTF_TASK_ASSIGNMENTS ta
425: , CS_INCIDENT_STATUSES_B ists
426: , JTF_TASK_TYPES_B tt
427: , JTF_TASK_STATUSES_B tkst
428: , JTF_TASK_STATUSES_B tast
429: WHERE inc.CLOSE_DATE <= b_max_date
430: AND inc.INCIDENT_ID = tk.SOURCE_OBJECT_ID
431: AND inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID

Line 428: , JTF_TASK_STATUSES_B tast

424: , JTF_TASK_ASSIGNMENTS ta
425: , CS_INCIDENT_STATUSES_B ists
426: , JTF_TASK_TYPES_B tt
427: , JTF_TASK_STATUSES_B tkst
428: , JTF_TASK_STATUSES_B tast
429: WHERE inc.CLOSE_DATE <= b_max_date
430: AND inc.INCIDENT_ID = tk.SOURCE_OBJECT_ID
431: AND inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
432: AND ists.CLOSE_FLAG = 'Y'

Line 462: , JTF_TASK_STATUSES_B tkst

458: , JTF_TASKS_B tk
459: , JTF_TASK_ASSIGNMENTS ta
460: , CS_INCIDENT_STATUSES_B ists
461: , JTF_TASK_TYPES_B tt
462: , JTF_TASK_STATUSES_B tkst
463: , JTF_TASK_STATUSES_B tast
464: WHERE inc.CLOSE_DATE <= b_max_date
465: AND inc.INCIDENT_ID = tk.SOURCE_OBJECT_ID
466: AND inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID

Line 463: , JTF_TASK_STATUSES_B tast

459: , JTF_TASK_ASSIGNMENTS ta
460: , CS_INCIDENT_STATUSES_B ists
461: , JTF_TASK_TYPES_B tt
462: , JTF_TASK_STATUSES_B tkst
463: , JTF_TASK_STATUSES_B tast
464: WHERE inc.CLOSE_DATE <= b_max_date
465: AND inc.INCIDENT_ID = tk.SOURCE_OBJECT_ID
466: AND inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
467: AND ists.CLOSE_FLAG = 'Y'