APPS.FLM_CREATE_PRODUCT_SYNCH dependencies on WIP_FLOW_SCHEDULES

Line 483: from wip_flow_schedules

479: -- Find out if the component used in the particular operation seq number has
480: -- been synchronized
481: select count(*)
482: into var_count
483: from wip_flow_schedules
484: where primary_item_id = var_comp_id
485: and NVL(synch_schedule_num,FND_API.G_MISS_CHAR) = arg_schedule_number
486: and NVL(synch_operation_seq_num,FND_API.G_MISS_NUM) = var_operation_seq_num;
487:

Line 533: FROM wip_flow_schedules flow,

529: flow.scheduled_completion_date scheduled_completion_date,
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

Line 712: -- component combination from wip_flow_schedules

708: l_flow_schedule_rec.synch_operation_seq_num := var_comp_tbl(var_current_row).operation_seq_num;
709: l_flow_schedule_rec.operation := MRP_GLOBALS.G_OPR_CREATE;
710:
711: -- check if build sequence exists for same line, org,
712: -- component combination from wip_flow_schedules
713: var_count := 0;
714: loop_count := 1;
715: var_build_seq_id := scheds1.build_sequence;
716: LOOP

Line 719: from wip_flow_schedules flow

715: var_build_seq_id := scheds1.build_sequence;
716: LOOP
717: select count(*)
718: into var_count
719: from wip_flow_schedules flow
720: where
721: -- flow.primary_item_id =
722: -- var_comp_tbl(var_current_row).item_id
723: -- and