[Home] [Help]
APPS.GMP_RSRC_AVL_PKG dependencies on BOM_SHIFT_TIMES
Line 117: bom_shift_times bst
113: (bsd.shift_date + (bst.from_time/86400)) ftime,
114: (bsd.shift_date + (bst.to_time/86400)) ttime
115: FROM bom_calendars bc,
116: bom_shift_dates bsd,
117: bom_shift_times bst
118: WHERE bsd.calendar_code = bc.calendar_code
119: AND bst.calendar_code = bsd.calendar_code
120: AND bsd.shift_num = bst.shift_num
121: AND bsd.seq_num is not null