APPS.WIP_LEADTIME_TEMP_PKG dependencies on BOM_OPERATION_NETWORKS_V

Line 11: from bom_operation_networks_v

7:
8: cursor network_csr (p_seq_num number)
9: is
10: select to_seq_num
11: from bom_operation_networks_v
12: where routing_sequence_id = p_routing_sequence_id
13: and from_seq_num = p_seq_num
14: and transition_type = 1 ;
15:

Line 55: from bom_operation_networks_v a

51: -- Fixed bug #5691032 - FP for bug#5572730.
52: -- Added distinct in the select clause below.
53: select distinct from_seq_num
54: into l_from_op
55: from bom_operation_networks_v a
56: where routing_sequence_id = p_routing_sequence_id
57: and not exists (select 1
58: from bom_operation_networks_v b
59: where a.routing_sequence_id = b.routing_sequence_id

Line 58: from bom_operation_networks_v b

54: into l_from_op
55: from bom_operation_networks_v a
56: where routing_sequence_id = p_routing_sequence_id
57: and not exists (select 1
58: from bom_operation_networks_v b
59: where a.routing_sequence_id = b.routing_sequence_id
60: and b.to_seq_num = a.from_seq_num
61: and b.transition_type = 1
62: )