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_DEBRIEF_PARTS_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 98: FROM csf_debrief_headers dh, jtf_task_assignments tas,

94: CURSOR c_chk_task_status(p_debrief_header_id NUMBER)
95: IS
96: SELECT tst.rejected_flag, tst.on_hold_flag, tst.cancelled_flag,
97: tst.closed_flag, tst.completed_flag
98: FROM csf_debrief_headers dh, jtf_task_assignments tas,
99: jtf_task_statuses_b tst
100: WHERE dh.task_assignment_id = tas.task_assignment_id
101: AND tas.assignment_status_id = tst.task_status_id
102: AND dh.debrief_header_id = p_debrief_header_id;

Line 123: from csf_debrief_headers

119: is
120: select debrief_header_id
121: , task_assignment_id
122: , debrief_number
123: from csf_debrief_headers
124: where task_assignment_id = b_task_assignment_id;
125:
126: cursor c_task_obj_code ( b_task_assignment_id number)
127: is