DBA Data[Home] [Help]

APPS.FLM_AUTO_REPLENISHMENT dependencies on WIP_LINES

Line 565: FROM wip_lines

561: 1/maximum_rate
562: INTO l_start_time,
563: l_stop_time,
564: l_takt_time
565: FROM wip_lines
566: WHERE line_id = p_line_id
567: AND organization_id = p_organization_id;
568:
569: IF (l_stop_time > l_start_time) THEN

Line 813: wip_lines lines

809: flow.scheduled_completion_date scheduled_completion_date,
810: flow.alternate_bom_designator alternate_bom_designator,
811: flow.alternate_routing_designator alternate_routing_designator
812: FROM wip_flow_schedules flow,
813: wip_lines lines
814: WHERE flow.planned_quantity - nvl(flow.quantity_completed, 0) > 0
815: AND flow.status <> 2
816: AND flow.scheduled_completion_date <= (l_server_compl_date + 1)
817: AND flow.scheduled_completion_date >= nvl(l_server_from_compl_date,sysdate) /*Added for bug 6816497 */