eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_PLANNER_PK dependencies on BOM_CALENDAR_DATES

Line 42: FROM bom_calendar_dates cal1,

38: --1851794 For phantoms if backward compatibility is yes treat them like standard items
39: DELETE mrp_schedule_dates dates
40: WHERE EXISTS
41: (SELECT NULL
42: FROM bom_calendar_dates cal1,
43: bom_calendar_dates cal2,
44: mtl_parameters param,
45: mtl_system_items sys
46: WHERE dates.schedule_date > cal1.calendar_date

Line 43: bom_calendar_dates cal2,

39: DELETE mrp_schedule_dates dates
40: WHERE EXISTS
41: (SELECT NULL
42: FROM bom_calendar_dates cal1,
43: bom_calendar_dates cal2,
44: mtl_parameters param,
45: mtl_system_items sys
46: WHERE dates.schedule_date > cal1.calendar_date
47: AND cal1.exception_set_id = cal2.exception_set_id

Line 133: FROM bom_calendar_dates cal1,

129:
130: UPDATE mrp_schedule_dates dates
131: SET rate_end_date =
132: (SELECT cal1.calendar_date
133: FROM bom_calendar_dates cal1,
134: bom_calendar_dates cal2,
135: mtl_parameters param,
136: mtl_system_items sys
137: WHERE dates.rate_end_date > cal1.calendar_date

Line 134: bom_calendar_dates cal2,

130: UPDATE mrp_schedule_dates dates
131: SET rate_end_date =
132: (SELECT cal1.calendar_date
133: FROM bom_calendar_dates cal1,
134: bom_calendar_dates cal2,
135: mtl_parameters param,
136: mtl_system_items sys
137: WHERE dates.rate_end_date > cal1.calendar_date
138: AND dates.schedule_date <= cal1.calendar_date

Line 159: FROM bom_calendar_dates cal1,

155: AND sys.organization_id = dates.organization_id
156: AND sys.inventory_item_id = dates.inventory_item_id)
157: WHERE EXISTS
158: (SELECT NULL
159: FROM bom_calendar_dates cal1,
160: bom_calendar_dates cal2,
161: mtl_parameters param,
162: mtl_system_items sys
163: WHERE dates.rate_end_date > cal1.calendar_date

Line 160: bom_calendar_dates cal2,

156: AND sys.inventory_item_id = dates.inventory_item_id)
157: WHERE EXISTS
158: (SELECT NULL
159: FROM bom_calendar_dates cal1,
160: bom_calendar_dates cal2,
161: mtl_parameters param,
162: mtl_system_items sys
163: WHERE dates.rate_end_date > cal1.calendar_date
164: AND dates.schedule_date <= cal1.calendar_date