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 309: csd_repairs cr

305: JTF_TASK_STATUSES_B jtsb,
306: CSF_DEBRIEF_HEADERS cdh,
307: JTF_TASKS_B jtb,
308: JTF_TASK_ASSIGNMENTS jta,
309: csd_repairs cr
310: WHERE cdh.task_assignment_id = jta.task_assignment_id
311: and jta.task_id = jtb.task_id
312: and nvl(jtb.deleted_flag,'N') <> 'Y'
313: and jta.assignment_status_id = jtsb.task_status_id

Line 370: csd_repairs cr

366: JTF_TASK_STATUSES_B jtsb,
367: CSF_DEBRIEF_HEADERS cdh,
368: JTF_TASKS_B jtb,
369: JTF_TASK_ASSIGNMENTS jta,
370: csd_repairs cr
371: WHERE cdh.task_assignment_id = jta.task_assignment_id
372: and jta.task_id = jtb.task_id
373: and nvl(jtb.deleted_flag,'N') <> 'Y'
374: and jta.assignment_status_id = jtsb.task_status_id

Line 1989: from csd_repairs cr,

1985: jtb.task_number,
1986: cdh.debrief_header_id,
1987: cdh.debrief_number,
1988: decode(processed_flag,'PENDING','P','E') debrief_status
1989: from csd_repairs cr,
1990: jtf_tasks_b jtb,
1991: jtf_task_assignments jta,
1992: csf_debrief_headers cdh
1993: where jtb.source_object_id = cr.repair_line_id