APPS.CSM_SERVICE_HISTORY_EVENT_PKG dependencies on JTF_TASK_STATUSES_B

Line 37: , JTF_TASK_STATUSES_B tkst

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
40: AND tk.SOURCE_OBJECT_TYPE_CODE = 'SR'
41: AND tk.TASK_ID = ta.TASK_ID

Line 38: , JTF_TASK_STATUSES_B tast

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
40: AND tk.SOURCE_OBJECT_TYPE_CODE = 'SR'
41: AND tk.TASK_ID = ta.TASK_ID
42: AND ta.ASSIGNEE_ROLE = 'ASSIGNEE'

Line 102: , JTF_TASK_STATUSES_B tkst

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
105: AND tk.SOURCE_OBJECT_TYPE_CODE = 'SR'
106: AND tk.TASK_ID = ta.TASK_ID

Line 103: , JTF_TASK_STATUSES_B tast

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
105: AND tk.SOURCE_OBJECT_TYPE_CODE = 'SR'
106: AND tk.TASK_ID = ta.TASK_ID
107: AND ta.ASSIGNEE_ROLE = 'ASSIGNEE'

Line 204: , JTF_TASK_STATUSES_B tkst

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
206: WHERE inc.CLOSE_DATE <= b_max_date
207: AND inc.INCIDENT_ID = tk.SOURCE_OBJECT_ID
208: AND inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID

Line 205: , JTF_TASK_STATUSES_B tast

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
206: WHERE inc.CLOSE_DATE <= b_max_date
207: AND inc.INCIDENT_ID = tk.SOURCE_OBJECT_ID
208: AND inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
209: --AND inc.install_site_id IS NOT NULL

Line 238: , JTF_TASK_STATUSES_B tkst

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
240: WHERE inc.CLOSE_DATE <= b_max_date
241: AND inc.INCIDENT_ID = tk.SOURCE_OBJECT_ID
242: AND inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID

Line 239: , JTF_TASK_STATUSES_B tast

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
240: WHERE inc.CLOSE_DATE <= b_max_date
241: AND inc.INCIDENT_ID = tk.SOURCE_OBJECT_ID
242: AND inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
243: --AND inc.install_site_id IS NOT NULL