[Home] [Help]
226:
227: /* find out the day that is on */
228: select min(bsd.shift_date)
229: into l_cur_date
230: from bom_shift_dates bsd, bom_resource_shifts brs
231: where bsd.calendar_code = l_cal_code and
232: bsd.shift_date >= trunc( p_date )and
233: brs.department_id = p_dept_id and
234: brs.resource_id = nvl( p_resource_id, brs.resource_id) and
238:
239: /* find out prior and next day in calendar */
240: select max(bsd.shift_date)
241: into l_prior_date
242: from bom_shift_dates bsd, bom_resource_shifts brs
243: where bsd.calendar_code = l_cal_code and
244: bsd.shift_date < l_cur_date and
245: brs.department_id = p_dept_id and
246: brs.resource_id = nvl( p_resource_id, brs.resource_id) and
249: bsd.seq_num is not null;
250:
251: select min(bsd.shift_date)
252: into l_next_date
253: from bom_shift_dates bsd, bom_resource_shifts brs
254: where bsd.calendar_code = l_cal_code and
255: bsd.shift_date > l_cur_date and
256: brs.department_id = p_dept_id and
257: brs.resource_id = nvl( p_resource_id, brs.resource_id) and
270: from
271: (
272: select bsd.shift_num,
273: bsd.seq_num
274: from bom_shift_dates bsd,
275: ( select bst.shift_num,
276: min(bst.from_time) from_time,
277: max (bst.to_time + decode(sign(bst.to_time - bst.from_time), -1, (24*60*60), 0) ) to_time
278: from bom_shift_times bst
482: x_shift_end,
483: x_shift_day,
484: l_shift_description
485: from
486: bom_shift_dates bsd,
487: (select
488: bst.shift_num,
489: min(bst.from_time) from_time,
490: max (bst.to_time + decode(sign(bst.to_time - bst.from_time), -1, (24*60*60), 0) ) to_time
589: wip_ws_util.get_shift_info_for_display(
590: p_organization_id, bsd.seq_num, t.shift_num
591: ) as display
592: from
593: bom_shift_dates bsd,
594: (
595: select
596: bst.calendar_code,
597: bst.shift_num,