DBA Data[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