DBA Data[Home] [Help]

APPS.MRP_FORECAST dependencies on BOM_CALENDAR_DATES

Line 65: FROM bom_calendar_dates cal1,

61: END;
62:
63: SELECT cal1.calendar_date
64: INTO var_fc_begin_date
65: FROM bom_calendar_dates cal1,
66: bom_calendar_dates cal2,
67: mrp_forecast_designators desig
68: WHERE cal1.seq_num =
69: cal2.prior_seq_num -

Line 66: bom_calendar_dates cal2,

62:
63: SELECT cal1.calendar_date
64: INTO var_fc_begin_date
65: FROM bom_calendar_dates cal1,
66: bom_calendar_dates cal2,
67: mrp_forecast_designators desig
68: WHERE cal1.seq_num =
69: cal2.prior_seq_num -
70: LEAST(NVL(desig.backward_update_time_fence, 0),

Line 367: FROM BOM_CALENDAR_DATES DATES,

363: MRP_FQ.NUMBER7,0)))),0), 6),
364: MRP_FQ.NUMBER2, /* (added for web inquiries) */
365: MRP_FQ.NUMBER1, /* (added for web inquiries) */
366: MRP_FQ.CHAR1 /* (added for web inquiries) */
367: FROM BOM_CALENDAR_DATES DATES,
368: MTL_PARAMETERS PARAM,
369: MRP_FORM_QUERY MRP_FQ
370: WHERE DATES.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
371: AND DATES.CALENDAR_CODE = PARAM.CALENDAR_CODE