APPS.CRP_PLANNER_PK dependencies on MRP_PLANS

Line 10: UPDATE mrp_plans

6: arg_compile_desig IN VARCHAR2,
7: arg_org_id IN NUMBER,
8: arg_user_id IN NUMBER) IS
9: BEGIN
10: UPDATE mrp_plans
11: SET crp_plan_start_date = SYSDATE,
12: last_update_date = SYSDATE,
13: last_updated_by = arg_user_id
14: WHERE organization_id = arg_org_id

Line 26: UPDATE mrp_plans

22: arg_compile_desig IN VARCHAR2,
23: arg_org_id IN NUMBER,
24: arg_user_id IN NUMBER) IS
25: BEGIN
26: UPDATE mrp_plans
27: SET crp_plan_completion_date = SYSDATE,
28: last_update_date = SYSDATE,
29: last_updated_by = arg_user_id
30: WHERE organization_id = arg_org_id

Line 227: mrp_plans mp

223: bom_calendar_dates sched_date,
224: mrp_system_items items,
225: mrp_planned_resource_reqs labor,
226: mrp_recommendations recom,
227: mrp_plans mp
228: WHERE res_date.seq_num =
229: TRUNC(sched_date.seq_num
230: - CEIL((items.variable_lead_time * new_order_quantity +
231: items.fixed_lead_time) *

Line 463: mrp_plans mp

459: bom_calendar_dates first_due,
460: mrp_system_items items,
461: mrp_planned_resource_reqs labor,
462: mrp_recommendations recom,
463: mrp_plans mp
464: WHERE last_res_date.seq_num =
465: TRUNC(last_due.seq_num
466: - CEIL((items.variable_lead_time *
467: NVL(recom.daily_rate,0) +