APPS.BOM_RTG_NETWORK_VALIDATE_API dependencies on BOM_OPERATION_NETWORKS

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

Line 258: FROM bom_operation_networks

254: l_op_seq_num NUMBER;
255:
256: CURSOR all_con_ops (c_str_op_id NUMBER) IS
257: SELECT DISTINCT to_op_seq_id operation_sequence_id
258: FROM bom_operation_networks
259: CONNECT BY PRIOR to_op_seq_id = from_op_seq_id
260: AND transition_type <> 3
261: START WITH from_op_seq_id = c_str_op_id
262: AND transition_type <> 3;