APPS.CSM_SERVICE_HISTORY_EVENT_PKG dependencies on JTF_TASKS_B

Line 34: FROM JTF_TASKS_B tk

30: l_return_status VARCHAR2(2000);
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

Line 99: FROM JTF_TASKS_B tk

95:
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

Line 182: FROM JTF_TASKS_B tk

178: CURSOR c_task_time( b_incident_id NUMBER
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

Line 200: , JTF_TASKS_B tk

196: IS
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

Line 234: , JTF_TASKS_B tk

230: IS
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

Line 444: , JTF_TASKS_B tsk

440: , acc.USER_ID
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'

Line 592: JTF_TASKS_B TASK

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'
596: AND TASK.SOURCE_OBJECT_ID = b_incident_id

Line 691: , jtf_tasks_b jtb

687: , ciia.instance_id
688: FROM cs_incidents_all_b ciab
689: , cs_incident_statuses_b cisb
690: , csm_item_instances_acc ciia
691: , jtf_tasks_b jtb
692: WHERE ciab.customer_product_id = ciia.instance_id
693: AND ciab.incident_status_id = cisb.incident_status_id
694: AND cisb.close_flag = 'Y'
695: AND ciab.incident_id = jtb.source_object_id