APPS.MRP_ADJUST_DATES_PK dependencies on MRP_SCHEDULE_DATES

Line 67: FROM mrp_schedule_dates

63: SELECT 'x' into string_buffer
64: FROM dual
65: WHERE exists
66: (SELECT schedule_date
67: FROM mrp_schedule_dates
68: WHERE organization_id = org_id);
69: demand_exists := TRUE;
70: EXCEPTION
71: WHEN NO_DATA_FOUND THEN

Line 106: -- in mrp_schedule_dates

102: statement := 1;
103:
104: END IF;
105: -- Check if enough data exists in the calendar to cover the current dates
106: -- in mrp_schedule_dates
107: IF demand_exists THEN
108: SELECT 'x' INTO string_buffer
109: FROM dual
110: WHERE NOT EXISTS

Line 112: FROM mrp_schedule_dates

108: SELECT 'x' INTO string_buffer
109: FROM dual
110: WHERE NOT EXISTS
111: (SELECT schedule_date
112: FROM mrp_schedule_dates
113: WHERE organization_id = org_id
114: AND schedule_date < min_date
115: AND schedule_level=2)
116: AND NOT EXISTS

Line 118: FROM mrp_schedule_dates

114: AND schedule_date < min_date
115: AND schedule_level=2)
116: AND NOT EXISTS
117: (SELECT schedule_date
118: FROM mrp_schedule_dates
119: WHERE organization_id = org_id
120: AND DECODE(rate_end_date, NULL, schedule_date,
121: rate_end_date) > max_date
122: AND schedule_level=2);

Line 151: UPDATE mrp_schedule_dates dates

147: -- For multi-org schedules we check the schedule type in the owning
148: -- org for entries in the current org
149:
150: IF demand_exists THEN
151: UPDATE mrp_schedule_dates dates
152: SET /* dates.last_update_date = SYSDATE,
153: dates.last_updated_by = user_id, */
154: dates.schedule_workdate =
155: (SELECT DECODE(desig.schedule_type, 1, prior_date,

Line 183: UPDATE mrp_schedule_dates dates

179: -- it's an MPS
180:
181: -- We check the schedule_type from the owning org for multi-org schedules
182:
183: UPDATE mrp_schedule_dates dates
184: SET dates.last_update_date = SYSDATE,
185: dates.last_updated_by = user_id,
186: dates.schedule_date = schedule_workdate
187: WHERE ((organization_id, schedule_designator) IN

Line 203: UPDATE mrp_schedule_dates dates

199:
200: -- Always set the rate end date to be the previous valid date for repetitive
201: -- entries
202:
203: UPDATE mrp_schedule_dates dates
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)