APPS.OPI_EDW_OPM_PRD_PKG dependencies on MR_SHDY_DTL

Line 269: mr_shcl_dtl sc, mr_shdy_dtl sl

265: Batch_day_V DATE )
266: IS
267: SELECT shift_start,shift_duration
268: FROM ps_schd_dtl sd, ps_schd_hdr sh,
269: mr_shcl_dtl sc, mr_shdy_dtl sl
270: WHERE sd.schedule_id = sh.schedule_id
271: AND sd.Calendar_id = sc.Calendar_id
272: AND sc.shopday_no = sl.shopday_no
273: AND sh.schedule = SCHEDULE_V