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 CS_INCIDENT_STATUSES_B

Line 202: , CS_INCIDENT_STATUSES_B ists

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
206: WHERE inc.CLOSE_DATE <= b_max_date

Line 236: , CS_INCIDENT_STATUSES_B ists

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
240: WHERE inc.CLOSE_DATE <= b_max_date

Line 443: , CS_INCIDENT_STATUSES_b cis

439: SELECT acc.INCIDENT_ID
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

Line 689: , cs_incident_statuses_b cisb

685: SELECT ciab.incident_id
686: , ciia.user_id
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