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 CSD_REPAIRS

Line 236: csd_repairs cr

232: JTF_TASK_STATUSES_B jtsb,
233: CSF_DEBRIEF_HEADERS cdh,
234: JTF_TASKS_B jtb,
235: JTF_TASK_ASSIGNMENTS jta,
236: csd_repairs cr
237: WHERE cdh.task_assignment_id = jta.task_assignment_id
238: and jta.task_id = jtb.task_id
239: and nvl(jtb.deleted_flag,'N') <> 'Y'
240: and jta.assignment_status_id = jtsb.task_status_id

Line 292: csd_repairs cr

288: JTF_TASK_STATUSES_B jtsb,
289: CSF_DEBRIEF_HEADERS cdh,
290: JTF_TASKS_B jtb,
291: JTF_TASK_ASSIGNMENTS jta,
292: csd_repairs cr
293: WHERE cdh.task_assignment_id = jta.task_assignment_id
294: and jta.task_id = jtb.task_id
295: and nvl(jtb.deleted_flag,'N') <> 'Y'
296: and jta.assignment_status_id = jtsb.task_status_id

Line 1376: from csd_repairs cr,

1372: jtb.task_number,
1373: cdh.debrief_header_id,
1374: cdh.debrief_number,
1375: decode(processed_flag,'PENDING','P','E') debrief_status
1376: from csd_repairs cr,
1377: jtf_tasks_b jtb,
1378: jtf_task_assignments jta,
1379: csf_debrief_headers cdh
1380: where jtb.source_object_id = cr.repair_line_id