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.CSF_DEBRIEF_UPDATE_PKG dependencies on CS_INCIDENTS_ALL

Line 280: cs_incidents_all_b ciab

276: JTF_TASK_STATUSES_B jtsb,
277: CSF_DEBRIEF_HEADERS cdh,
278: JTF_TASKS_B jtb,
279: JTF_TASK_ASSIGNMENTS jta,
280: cs_incidents_all_b ciab
281: WHERE cdh.task_assignment_id = jta.task_assignment_id
282: and jta.task_id = jtb.task_id
283: and nvl(jtb.deleted_flag,'N') <> 'Y'
284: and jta.assignment_status_id = jtsb.task_status_id

Line 339: cs_incidents_all_b ciab

335: JTF_TASK_STATUSES_B jtsb,
336: CSF_DEBRIEF_HEADERS cdh,
337: JTF_TASKS_B jtb,
338: JTF_TASK_ASSIGNMENTS jta,
339: cs_incidents_all_b ciab
340: WHERE cdh.task_assignment_id = jta.task_assignment_id
341: and jta.task_id = jtb.task_id
342: and nvl(jtb.deleted_flag,'N') <> 'Y'
343: and jta.assignment_status_id = jtsb.task_status_id

Line 424: from cs_incidents_all

420:
421: cursor c_site (p_incident_id number) Is
422: select install_site_use_id,
423: ship_to_site_use_id
424: from cs_incidents_all
425: where incident_id = p_incident_id;
426:
427: cursor c_party_site_id (p_install_site_id number) Is
428: select party_site_id