APPS.MRP_ADJUST_DATES_PK dependencies on BOM_CALENDAR_DATES

Line 95: FROM bom_calendar_dates

91: -- exception
92: IF forecast_exists or demand_exists THEN
93: SELECT min(calendar_date), max(calendar_date)
94: INTO min_date, max_date
95: FROM bom_calendar_dates
96: WHERE exception_set_id = except_set_id
97: AND calendar_code = cal_code;
98:
99: IF min_date IS NULL THEN

Line 157: FROM bom_calendar_dates cal,

153: dates.last_updated_by = user_id, */
154: dates.schedule_workdate =
155: (SELECT DECODE(desig.schedule_type, 1, prior_date,
156: next_date)
157: FROM bom_calendar_dates cal,
158: mrp_schedule_designators desig
159: WHERE cal.calendar_code = cal_code
160: AND cal.exception_set_id = except_set_id
161: /*2285842 AND cal.calendar_date = dates.schedule_workdate*/

Line 208: FROM bom_calendar_dates cal

204: SET /* dates.last_update_date = SYSDATE,
205: dates.last_updated_by = user_id, */
206: dates.rate_end_date =
207: (SELECT GREATEST(prior_date, dates.schedule_date)
208: FROM bom_calendar_dates cal
209: WHERE cal.calendar_code = cal_code
210: AND cal.exception_set_id = except_set_id
211: AND cal.calendar_date = dates.rate_end_date)
212: WHERE dates.rate_end_date IS NOT NULL

Line 224: FROM bom_calendar_dates cal

220: SET /* dates.last_update_date = SYSDATE,
221: dates.last_updated_by = user_id, */
222: dates.forecast_date =
223: (SELECT prior_date
224: FROM bom_calendar_dates cal
225: WHERE cal.calendar_code = cal_code
226: AND cal.exception_set_id = except_set_id
227: AND cal.calendar_date = dates.forecast_date)
228: WHERE dates.bucket_type = 1

Line 238: FROM bom_calendar_dates cal

234: SET /* dates.last_update_date = SYSDATE,
235: dates.last_updated_by = user_id, */
236: dates.rate_end_date =
237: (SELECT prior_date
238: FROM bom_calendar_dates cal
239: WHERE cal.calendar_code = cal_code
240: AND cal.exception_set_id = except_set_id
241: AND cal.calendar_date = dates.rate_end_date)
242: WHERE dates.rate_end_date IS NOT NULL