DBA Data[Home] [Help]

APPS.WIP_WS_LABOR_METRIC_PUB dependencies on BOM_RESOURCE_SHIFTS

Line 326: bom_resource_shifts brs

322: from bom_shift_times bst
323: where bst.calendar_code = p_calendar_code
324: group by bst.shift_num) st,
325: bom_calendar_shifts bcs,
326: bom_resource_shifts brs
327: where bsd.calendar_code = p_calendar_code
328: and bsd.exception_set_id = -1
329: and bsd.shift_date between trunc(start_period) and trunc(end_period)
330: and bsd.shift_num = st.shift_num