APPS.FLM_EXECUTION_UTIL dependencies on BOM_OPERATION_NETWORKS

Line 372: from bom_operation_networks

368: i_op_seq_id IN NUMBER) RETURN VARCHAR2 IS
369:
370: cursor c_bon_exists IS
371: select from_op_seq_id
372: from bom_operation_networks
373: where transition_type in (1, 2)
374: start with to_op_seq_id = i_op_seq_id
375: connect by level = 1 and prior from_op_seq_id = to_op_seq_id
376: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'Y';

Line 464: from bom_operation_networks bon

460: and nvl(bor.alternate_routing_designator, '@@@@@@@@') = nvl(wfs.alternate_routing_designator, '@@@@@@@@')
461: and bor.common_routing_sequence_id = bos.routing_sequence_id
462: and bos.operation_type = 3 -- line operation
463: and not exists (select '1'
464: from bom_operation_networks bon
465: where bon.to_op_seq_id = bos.operation_sequence_id
466: and bon.transition_type in (1, 2))
467: order by bos.operation_seq_num;
468:

Line 561: from bom_operation_networks

557: -- Is this operation the start point of its path (or are all operations
558: -- before it on the path workstation-disabled?)
559: select count(*)
560: into l_cnt
561: from bom_operation_networks
562: where to_op_seq_id = l_op_seq_id
563: and transition_type in (1,2);
564: IF l_cnt <= 0 THEN
565: --debug_output('start of network');

Line 576: from bom_operation_networks

572: l_enabled := flm_execution_util.workstation_enabled(op_rec.seq_id);
573: if(l_enabled = 'N') then
574: select count(*)
575: into l_cnt
576: from bom_operation_networks
577: where to_op_seq_id = l_op_seq_id
578: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N'
579: --and flm_execution_util.workstation_enabled(op_rec.seq_id) = 'N'
580: start with from_op_seq_id = op_rec.seq_id

Line 595: from bom_operation_networks

591: --return true if there is connection between current op and given lineop consist of all disabled ws
592: FOR op_rec IN sch_cur_op_csr LOOP
593: select count(*)
594: into l_cnt
595: from bom_operation_networks
596: where to_op_seq_id = l_op_seq_id
597: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N'
598: start with from_op_seq_id = op_rec.seq_id
599: connect by prior to_op_seq_id = from_op_seq_id

Line 955: from bom_operation_networks, bom_operation_sequences

951: (
952: select myFrom, operation_seq_num from
953: (
954: select from_op_seq_id myFrom, to_op_seq_id, transition_type, operation_seq_num
955: from bom_operation_networks, bom_operation_sequences
956: where from_op_seq_id = operation_sequence_id
957: start with to_op_seq_id = l_op_seq_id and transition_type in (1,2)
958: connect by PRIOR from_op_seq_id = to_op_seq_id
959: and transition_type in (1,2)

Line 963: from bom_operation_networks

959: and transition_type in (1,2)
960: )
961: where not exists
962: (select from_op_seq_id
963: from bom_operation_networks
964: where to_op_seq_id = myFrom
965: and transition_type in (1,2)
966: )
967: );

Line 971: from bom_operation_networks

967: );
968:
969: cursor incoming_op_csr IS
970: select from_op_seq_id
971: from bom_operation_networks
972: where to_op_seq_id = l_to_op_seq_id
973: and transition_type in (1,2)
974: and from_op_seq_id not in (l_from_op_seq_id);
975:

Line 983: from bom_operation_networks

979: where operation_sequence_id = l_op_seq_id;
980:
981: cursor incoming_op_count_csr IS
982: select count(from_op_seq_id) op_count
983: from bom_operation_networks
984: where to_op_seq_id = l_to_op_seq_id
985: and transition_type in (1,2);
986:
987:

Line 1166: from bom_operation_networks, bom_operation_sequences

1162: order by operation_sequence_id;
1163:
1164: CURSOR primary_ops(p_op_seq_id NUMBER) IS
1165: select from_op_seq_id, to_op_seq_id, transition_type, operation_seq_num
1166: from bom_operation_networks, bom_operation_sequences
1167: where from_op_seq_id = operation_sequence_id and transition_type=1
1168: start with from_op_seq_id = p_op_seq_id
1169: connect by PRIOR to_op_seq_id = from_op_seq_id
1170: and prior transition_type =1;