APPS.FLM_CREATE_PRODUCT_SYNCH dependencies on BOM_OPERATION_SEQUENCES

Line 25: from bom_operation_sequences

21: l_total_time NUMBER;
22: BEGIN
23: select CEIL(NVL(total_time_calc,0)/p_takt_time) * p_takt_time
24: into l_total_time
25: from bom_operation_sequences
26: where operation_sequence_id = p_line_op_seq_id;
27:
28: return (l_total_time);
29: END get_operation_times;

Line 184: from bom_operation_sequences

180: -- If not network exists, then if only one line operation exists
181: -- for this routing, it's valid, otherwise it's not valid.
182: select count(*)
183: into l_cnt
184: from bom_operation_sequences
185: where operation_type = 3
186: and routing_sequence_id = (
187: select max(routing_sequence_id)
188: from bom_operation_sequences

Line 188: from bom_operation_sequences

184: from bom_operation_sequences
185: where operation_type = 3
186: and routing_sequence_id = (
187: select max(routing_sequence_id)
188: from bom_operation_sequences
189: where operation_sequence_id = p_op_seq_id
190: );
191: if l_cnt = 1 then
192: return true;

Line 444: from bom_operation_sequences

440: -- the routing of the top assembly
441: begin
442: select line_op_seq_id
443: into var_line_op_seq_id
444: from bom_operation_sequences
445: where routing_sequence_id = var_routing_sequence_id
446: and operation_seq_num = var_operation_seq_num
447: and operation_type = 1
448: and effectivity_date =

Line 450: from bom_operation_sequences

446: and operation_seq_num = var_operation_seq_num
447: and operation_type = 1
448: and effectivity_date =
449: (select max(effectivity_date)
450: from bom_operation_sequences
451: where routing_sequence_id = var_routing_sequence_id
452: and operation_seq_num = var_operation_seq_num
453: and operation_type = 1);
454: