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_PVT dependencies on CSF_DEBRIEF_LAB_LINES_V

Line 3324: from csf_debrief_lab_lines_v cdl,

3320: cursor c_task_assignment is
3321: select min(labor_start_date),
3322: max(labor_end_date),
3323: min(debrief_line_id)
3324: from csf_debrief_lab_lines_v cdl,
3325: cs_transaction_types ctt
3326: where cdl.debrief_header_id = p_debrief_header_id
3327: and cdl.transaction_type_id = ctt.transaction_type_id
3328: and ctt.line_order_category_code = 'ORDER';

Line 3334: from csf_debrief_lab_lines_v cdl,

3330: cursor c_task_assignment_return (p_start_date_order IN date, p_end_date_order IN date) is
3331: select min(labor_start_date),
3332: max(labor_end_date),
3333: min(debrief_line_id)
3334: from csf_debrief_lab_lines_v cdl,
3335: cs_transaction_types ctt
3336: where cdl.debrief_header_id = p_debrief_header_id
3337: and cdl.transaction_type_id = ctt.transaction_type_id
3338: and ctt.line_order_category_code = 'RETURN'

Line 3346: from csf_debrief_lab_lines_v cdl,

3342: cursor c_task is
3343: select min(labor_start_date),
3344: max(labor_end_date),
3345: min(debrief_line_id)
3346: from csf_debrief_lab_lines_v cdl,
3347: csf_debrief_headers cdh,
3348: jtf_task_assignments jta,
3349: cs_transaction_types ctt
3350: where jta.task_id = l_task_id

Line 3360: from csf_debrief_lab_lines_v cdl,

3356: cursor c_task_return (p_start_date_order IN date, p_end_date_order IN date) is
3357: select min(labor_start_date),
3358: max(labor_end_date),
3359: min(debrief_line_id)
3360: from csf_debrief_lab_lines_v cdl,
3361: csf_debrief_headers cdh,
3362: jtf_task_assignments jta,
3363: cs_transaction_types ctt
3364: where jta.task_id = l_task_id