DBA Data[Home] [Help]

APPS.EAM_WO_SCHEDULE_PVT dependencies on BOM_SHIFT_DATES

Line 50: FROM BOM_SHIFT_DATES

46: SELECT SHIFT_NUM,
47: SHIFT_DATE,
48: SEQ_NUM,
49: CALENDAR_CODE
50: FROM BOM_SHIFT_DATES
51: WHERE CALENDAR_CODE = p_calendar_code
52: AND SHIFT_DATE >= trunc(p_curr_date)
53: AND SHIFT_DATE <= trunc(p_curr_date) + 50
54: AND EXCEPTION_SET_ID = -1

Line 62: FROM BOM_SHIFT_DATES

58: SELECT SHIFT_NUM,
59: SHIFT_DATE,
60: SEQ_NUM,
61: CALENDAR_CODE
62: FROM BOM_SHIFT_DATES
63: WHERE CALENDAR_CODE = p_calendar_code
64: AND SHIFT_DATE >= trunc(p_curr_date) - 50
65: AND SHIFT_DATE <= trunc(p_curr_date)
66: AND EXCEPTION_SET_ID = -1