DBA Data[Home] [Help]

APPS.MRP_CRP_HORIZONTAL_PLAN dependencies on WIP_FLOW_SCHEDULES

Line 260: wip_flow_schedules fs,

256: FROM bom_calendar_dates res_start,
257: bom_calendar_dates order_date,
258: mtl_system_items items,
259: mtl_parameters param,
260: wip_flow_schedules fs,
261: bom_operational_routings routing,
262: bom_operation_sequences seqs,
263: bom_operation_resources res,
264: bom_resources bom_res,

Line 428: FROM wip_flow_schedules fs,

424: DISCRETE_JOBS,
425: fs.scheduled_start_date,
426: to_date(NULL),
427: SUM(GREATEST( 0, (fs.planned_quantity - fs.quantity_completed)))
428: FROM wip_flow_schedules fs,
429: mrp_form_query list
430: WHERE fs.scheduled_start_date 431: AND fs.scheduled_completion_date >= TRUNC(sysdate)
432: AND fs.wip_entity_id >= 0