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

Line 38: from csf_debrief_headers cdh,

34: -- get total reserved qty
35: cursor total_reservations
36: is
37: select sum(mr.reservation_quantity)
38: from csf_debrief_headers cdh,
39: csp_requirement_headers crh,
40: csp_requirement_lines crl,
41: csp_req_line_details crld,
42: mtl_reservations mr

Line 56: csf_debrief_headers dbf_hdr

52: cursor total_debriefed_quantity
53: is
54: select sum(mat_v.quantity)
55: from csf_debrief_mat_lines_v mat_v,
56: csf_debrief_headers dbf_hdr
57: where mat_v.debrief_header_id = dbf_hdr.debrief_header_id
58: and dbf_hdr.debrief_header_id = p_dbf_hdr_id
59: and mat_v.inventory_item_id = p_inventory_item_id;
60:

Line 65: from csf_debrief_headers cdh,

61: -- get fist requirement line id to link
62: cursor get_req_line_id_to_link
63: is
64: select crl.requirement_line_id
65: from csf_debrief_headers cdh,
66: csp_requirement_headers crh,
67: csp_requirement_lines crl
68: where cdh.debrief_header_id = p_dbf_hdr_id
69: and crh.task_assignment_id = cdh.task_assignment_id