APPS.FLM_EXECUTION_UTIL dependencies on BOM_OPERATION_NETWORKS

Line 280: from bom_operation_networks bon

276: and nvl(bor.alternate_routing_designator, '@@@@@@@@') = nvl(wfs.alternate_routing_designator, '@@@@@@@@')
277: and bor.common_routing_sequence_id = bos.routing_sequence_id
278: and bos.operation_type = 3 -- line operation
279: and not exists (select '1'
280: from bom_operation_networks bon
281: where bon.to_op_seq_id = bos.operation_sequence_id
282: and bon.transition_type in (1, 2))
283: order by bos.operation_seq_num;
284:

Line 352: from bom_operation_networks

348: -- Is this operation the start point of its path (or are all operations
349: -- before it on the path workstation-disabled?)
350: select count(*)
351: into l_cnt
352: from bom_operation_networks
353: where to_op_seq_id = l_op_seq_id
354: and transition_type in (1,2);
355: IF l_cnt <= 0 THEN
356: --debug_output('start of network');

Line 364: from bom_operation_networks

360: --find out if connection from start op to this operation consist of all disbaled workstations
361: FOR op_rec IN start_op_csr LOOP
362: select count(*)
363: into l_cnt
364: from bom_operation_networks
365: where to_op_seq_id = l_op_seq_id
366: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N'
367: and flm_execution_util.workstation_enabled(op_rec.seq_id) = 'N'
368: start with from_op_seq_id = op_rec.seq_id

Line 381: from bom_operation_networks

377: --return true if there is connection between current op and given lineop consist of all disabled ws
378: FOR op_rec IN sch_cur_op_csr LOOP
379: select count(*)
380: into l_cnt
381: from bom_operation_networks
382: where to_op_seq_id = l_op_seq_id
383: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N'
384: start with from_op_seq_id = op_rec.seq_id
385: connect by prior to_op_seq_id = from_op_seq_id

Line 738: from bom_operation_networks, bom_operation_sequences

734: (
735: select myFrom, operation_seq_num from
736: (
737: select from_op_seq_id myFrom, to_op_seq_id, transition_type, operation_seq_num
738: from bom_operation_networks, bom_operation_sequences
739: where from_op_seq_id = operation_sequence_id
740: start with to_op_seq_id = l_op_seq_id and transition_type in (1,2)
741: connect by PRIOR from_op_seq_id = to_op_seq_id
742: and transition_type in (1,2)

Line 746: from bom_operation_networks

742: and transition_type in (1,2)
743: )
744: where not exists
745: (select from_op_seq_id
746: from bom_operation_networks
747: where to_op_seq_id = myFrom
748: and transition_type in (1,2)
749: )
750: );

Line 754: from bom_operation_networks

750: );
751:
752: cursor incoming_op_csr IS
753: select from_op_seq_id
754: from bom_operation_networks
755: where to_op_seq_id = l_to_op_seq_id
756: and transition_type in (1,2)
757: and from_op_seq_id not in (l_from_op_seq_id);
758:

Line 766: from bom_operation_networks

762: where operation_sequence_id = l_op_seq_id;
763:
764: cursor incoming_op_count_csr IS
765: select count(from_op_seq_id) op_count
766: from bom_operation_networks
767: where to_op_seq_id = l_to_op_seq_id
768: and transition_type in (1,2);
769:
770:

Line 949: from bom_operation_networks, bom_operation_sequences

945: order by operation_sequence_id;
946:
947: CURSOR primary_ops(p_op_seq_id NUMBER) IS
948: select from_op_seq_id, to_op_seq_id, transition_type, operation_seq_num
949: from bom_operation_networks, bom_operation_sequences
950: where from_op_seq_id = operation_sequence_id and transition_type=1
951: start with from_op_seq_id = p_op_seq_id
952: connect by PRIOR to_op_seq_id = from_op_seq_id
953: and prior transition_type =1;