[Home] [Help]
51: shifts.to_time,shifts.to_time + 24*3600,
52: shifts.to_time) - shifts.from_time)/3600))),0))
53: FROM bom_calendar_dates cal,
54: bom_department_resources bdr,
55: bom_resource_shifts brs,
56: bom_shift_times shifts,
57: mtl_parameters mp,
58: mrp_form_query mfq
59: WHERE bdr.department_id = p_dept_id