DBA Data[Home] [Help]

APPS.MRP_PLANNER_PK dependencies on MTL_PARAMETERS

Line 44: mtl_parameters param,

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

Line 135: mtl_parameters param,

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

Line 161: mtl_parameters param,

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