APPS.MRP_PLANNER_PK dependencies on MTL_SYSTEM_ITEMS

Line 35: | We need to go to mtl_system_items because mrp_system_items |

31: var_bkwd_compat VARCHAR2(2) := FND_PROFILE.VALUE('MRP_NEW_PLANNER_BACK_COMPATIBILITY');
32:
33: BEGIN
34: /*-------------------------------------------------------------+
35: | We need to go to mtl_system_items because mrp_system_items |
36: | may not have been populated at that point |
37: +-------------------------------------------------------------*/
38: --1851794 For phantoms if backward compatibility is yes treat them like standard items
39: DELETE mrp_schedule_dates dates

Line 45: mtl_system_items sys

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
48: AND cal1.calendar_code = cal2.calendar_code
49: AND cal1.seq_num = cal2.prior_seq_num +

Line 98: FROM mtl_system_items sys

94:
95: DELETE mrp_schedule_dates dates
96: WHERE EXISTS
97: (SELECT NULL
98: FROM mtl_system_items sys
99: WHERE
100: NVL(DECODE(sys.wip_supply_type,
101: PHANTOM_ASSY, 0,
102: DECODE(sys.planning_time_fence_code, USER_TF,

Line 136: mtl_system_items sys

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
139: AND cal1.exception_set_id = cal2.exception_set_id
140: AND cal1.calendar_code = cal2.calendar_code

Line 162: mtl_system_items sys

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
165: AND cal1.exception_set_id = cal2.exception_set_id
166: AND cal1.calendar_code = cal2.calendar_code