APPS.MRP_HORIZONTAL_PLAN_SC dependencies on WIP_FLOW_SCHEDULES

Line 410: wip_flow_schedules flow_sched,

406: flow_sched.quantity_completed))) new_quantity,
407: SUM(GREATEST( 0, (flow_sched.planned_quantity -
408: flow_sched.quantity_completed))) old_quantity
409: FROM mrp_form_query list,
410: wip_flow_schedules flow_sched,
411: mrp_system_items items,
412: mrp_sub_inventories msi
413: WHERE (arg_res_level = 1
414: OR (arg_res_level = 2

Line 465: wip_flow_schedules fs,

461: (bic.component_quantity/bic.component_yield_factor)
462: * bic.planning_factor/100))) old_quantity
463: FROM bom_calendar_dates dates,
464: mtl_parameters mp,
465: wip_flow_schedules fs,
466: mrp_system_items msi_assy,
467: bom_bill_of_materials bbm,
468: bom_inventory_components bic,
469: mrp_system_items items,

Line 548: wip_flow_schedules fs,

544: (bic.component_quantity/bic.component_yield_factor)
545: * bic.planning_factor/100)) old_quantity
546: FROM bom_calendar_dates dates,
547: mtl_parameters mp,
548: wip_flow_schedules fs,
549: mrp_system_items msi_assy,
550: bom_bill_of_materials bbm,
551: bom_inventory_components bic,
552: mrp_system_items items,

Line 628: FROM wip_flow_schedules flow_sched,

624: nvl(items.shrinkage_rate, 0)))) new_quantity,
625: SUM(GREATEST( 0, ((flow_sched.planned_quantity -
626: flow_sched.quantity_completed) *
627: nvl(items.shrinkage_rate, 0)))) old_quantity
628: FROM wip_flow_schedules flow_sched,
629: mrp_system_items items,
630: mrp_form_query list,
631: mrp_sub_inventories msi
632: WHERE (arg_res_level = 1