APPS.FLM_AUTO_REPLENISHMENT dependencies on BOM_OPERATION_NETWORKS

Line 94: FROM bom_operation_networks

90: | has a primary path originating from it. |
91: +---------------------------------------------------------------------*/
92: SELECT count(*)
93: INTO l_cnt
94: FROM bom_operation_networks
95: WHERE from_op_seq_id = p_op_seq_id
96: AND nvl(transition_type, 3) = 1;
97:
98: IF (l_cnt = 0) THEN

Line 107: FROM bom_operation_networks

103: | last line-op |
104: +---------------------------------------------------------------------*/
105: SELECT count(*)
106: INTO l_cnt
107: FROM bom_operation_networks
108: WHERE to_op_seq_id = p_op_seq_id
109: AND nvl(transition_type, 3) = 1;
110:
111: IF (l_cnt = 0) THEN

Line 551: FROM Bom_Operation_Networks

547: l_op_start_date DATE;
548:
549: CURSOR Network_Csr (i_start_operation_sequence_id NUMBER) IS
550: SELECT to_op_seq_id
551: FROM Bom_Operation_Networks
552: CONNECT BY PRIOR to_op_seq_id = from_op_seq_id
553: AND nvl(transition_type, 0) NOT IN (2,3)
554: START WITH from_op_seq_id = i_start_operation_sequence_id
555: AND nvl(transition_type, 0) NOT IN (2,3);