APPS.FLM_CREATE_PRODUCT_SYNCH dependencies on WIP_LINES

Line 44: from wip_lines

40: l_lead_time NUMBER;
41: BEGIN
42: select start_time, stop_time
43: into l_start_time, l_stop_time
44: from wip_lines
45: where line_id = p_feeder_line_id
46: and organization_id = p_org_id;
47:
48: select nvl(fixed_lead_time,0) + (p_qty - 1)*nvl(variable_lead_time,0)

Line 105: from wip_lines

101: BEGIN
102:
103: select start_time, stop_time, 1/maximum_rate
104: into l_start_time, l_stop_time, l_takt_time
105: from wip_lines
106: where line_id = p_assembly_line_id
107: and organization_id = p_org_id;
108:
109: if (l_stop_time > l_start_time) then

Line 534: wip_lines lines

530: flow.alternate_bom_designator alternate_bom_designator,
531: flow.alternate_routing_designator alternate_routing_designator,
532: nvl(flow.roll_forwarded_flag,2) roll_forwarded_flag
533: FROM wip_flow_schedules flow,
534: wip_lines lines
535: WHERE flow.planned_quantity - nvl(flow.quantity_completed, 0) > 0
536: AND flow.scheduled_start_date >= p_sysdate
537: AND flow.scheduled_start_date between p_start_date and p_end_date
538: AND flow.line_id = lines.line_id

Line 691: FROM wip_lines fl, wip_lines ml

687:
688: /* Added for bug 2373141 */
689: Select (fl.maximum_rate - ml.maximum_rate)
690: INTO l_fast_feeder_line
691: FROM wip_lines fl, wip_lines ml
692: Where ml.line_id = var_line_id
693: and fl.line_id = var_comp_tbl(var_current_row).line_id;
694: /* Added for bug 2373141 */
695: