DBA Data[Home] [Help]

APPS.BOM_CALC_TPCT dependencies on BOM_OPERATION_NETWORKS

Line 29: from bom_operation_networks bon, bom_operation_sequences bos

25: where bos.routing_sequence_id = cv_routing_sequence_id
26: and bos.operation_type = cv_operation_type
27: minus
28: select bon.to_op_seq_id start_operation_sequence_id
29: from bom_operation_networks bon, bom_operation_sequences bos
30: where bon.to_op_seq_id = bos.operation_sequence_id
31: and bos.routing_sequence_id = cv_routing_sequence_id
32: and bos.operation_type = cv_operation_type
33: and nvl(bon.transition_type, 0) <> 3;

Line 41: from bom_operation_networks bon

37: -- For each of the starting points, traverse the network to select all the
38: -- 'to' operations until the end
39: cursor network_cur (cv_start_operation_sequence_id number) is
40: select bon.to_op_seq_id
41: from bom_operation_networks bon
42: connect by prior to_op_seq_id = from_op_seq_id
43: and
44: nvl(bon.transition_type, 0) not in (2, 3)
45: start with from_op_seq_id = cv_start_operation_sequence_id