DBA Data[Home] [Help]

APPS.WIP_WS_LABOR_METRIC_PUB dependencies on BOM_RESOURCE_SHIFTS

Line 320: bom_resource_shifts brs

316: from bom_shift_times bst
317: where bst.calendar_code = p_calendar_code
318: group by bst.shift_num) st,
319: bom_calendar_shifts bcs,
320: bom_resource_shifts brs
321: where bsd.calendar_code = p_calendar_code
322: and bsd.exception_set_id = -1
323: and bsd.shift_date between trunc(start_period) and trunc(end_period)
324: and bsd.shift_num = st.shift_num