APPS.BOM_RTG_NETWORK_VALIDATE_API dependencies on BOM_OPERATION_NETWORKS_V

Line 54: FROM bom_operation_networks_v

50: SELECT 1
51: INTO net_exists
52: FROM dual
53: WHERE EXISTS (SELECT null
54: FROM bom_operation_networks_v
55: WHERE routing_sequence_id = p_rtg_sequence_id
56: AND operation_type = p_operation_type);
57:
58: RETURN (TRUE);

Line 179: FROM bom_operation_networks_v

175: i INTEGER := 1;
176: CURSOR all_links IS
177: SELECT from_op_seq_id,from_seq_num,
178: to_op_seq_id
179: FROM bom_operation_networks_v
180: WHERE routing_sequence_id = p_rtg_sequence_id
181: AND operation_type = p_operation_type
182: AND transition_type <> 3
183: ORDER BY from_seq_num;

Line 217: FROM bom_operation_networks_v bonv

213:
214: i INTEGER := 1;
215: CURSOR all_start_nodes IS
216: SELECT DISTINCT from_op_seq_id, from_seq_num
217: FROM bom_operation_networks_v bonv
218: WHERE routing_sequence_id = p_rtg_sequence_id
219: AND operation_type = p_operation_type
220: AND transition_type <> 3
221: AND NOT EXISTS (SELECT NULL

Line 222: FROM bom_operation_networks_v net

218: WHERE routing_sequence_id = p_rtg_sequence_id
219: AND operation_type = p_operation_type
220: AND transition_type <> 3
221: AND NOT EXISTS (SELECT NULL
222: FROM bom_operation_networks_v net
223: WHERE net.to_op_seq_id = bonv.from_op_seq_id)
224: ORDER BY from_seq_num;
225:
226: BEGIN