APPS.FLM_CREATE_PRODUCT_SYNCH dependencies on BOM_OPERATION_NETWORKS

Line 93: from bom_operation_networks bon

89: l_assembly_comp_date DATE;
90:
91: cursor network_cur (cv_start_operation_sequence_id number) is
92: select bon.to_op_seq_id to_op_seq_id
93: from bom_operation_networks bon
94: connect by prior to_op_seq_id = from_op_seq_id
95: and
96: nvl(bon.transition_type, 0) not in (2, 3)
97: start with from_op_seq_id = cv_start_operation_sequence_id

Line 165: from bom_operation_networks

161: -- Look at the from_op_seq_id to find out if the line-op
162: -- is in primary path.
163: select count(*)
164: into l_cnt
165: from bom_operation_networks
166: where from_op_seq_id = p_op_seq_id
167: and nvl(transition_type, 3) = 1;
168:
169: if (l_cnt = 0) then

Line 175: from bom_operation_networks

171: -- is in primary path. This is the exception for the
172: -- last line-op
173: select count(*)
174: into l_cnt
175: from bom_operation_networks
176: where to_op_seq_id = p_op_seq_id
177: and nvl(transition_type, 3) = 1;
178:
179: if (l_cnt = 0) then