DBA Data[Home] [Help]

APPS.CSM_SERVICE_HISTORY_EVENT_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 184: , JTF_RS_RESOURCE_EXTNS rs

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
188: AND ta.ASSIGNEE_ROLE = 'ASSIGNEE'

Line 446: , JTF_RS_RESOURCE_EXTNS rs

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
450: AND ta.RESOURCE_ID = rs.RESOURCE_ID