DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on BOM_RESOURCE_SHIFTS

Line 6914: from bom_resource_shifts brs,

6910: SELECT distinct round(bst.to_time / 60) end_time,
6911: round(bst.from_time / 60) start_time,
6912: nvl(brs.CAPACITY_UNITS, 0) cap_units,
6913: brs.shift_num shift_num
6914: from bom_resource_shifts brs,
6915: mtl_parameters mp,
6916: bom_shift_dates bsd,
6917: bom_shift_times bst
6918: where brs.department_id = p_dept_id