DBA Data[Home] [Help]

APPS.MRP_HORIZONTAL_PLAN_SC dependencies on MRP_PLANS

Line 870: mrp_plans plans,

866: bom_calendar_dates dates,
867: mtl_parameters param,
868: mrp_schedule_dates sched,
869: mrp_plan_schedules_v plan_sched,
870: mrp_plans plans,
871: mrp_system_items items
872: WHERE (arg_res_level = 1
873: OR (arg_res_level = 2
874: AND sched.project_id is NULL)

Line 2933: FROM mrp_plans plans,

2929: to_date(1, 'J') new_date,
2930: to_date(1, 'J') old_date,
2931: items.nettable_quantity new_quantity,
2932: 0 old_quantity
2933: FROM mrp_plans plans,
2934: mrp_onhand_quantities items,
2935: mrp_form_query list
2936: WHERE ((arg_res_level = 1 )
2937: OR (arg_res_level = 2

Line 2962: FROM mrp_plans plans,

2958: to_date(1, 'J') new_date,
2959: to_date(1, 'J') old_date,
2960: items.nettable_inventory_quantity new_quantity,
2961: 0 old_quantity
2962: FROM mrp_plans plans,
2963: mrp_system_items items,
2964: mrp_form_query list
2965: WHERE arg_res_level = 1
2966: AND (plans.curr_reservation_level = 4 OR