APPS.FLM_AUTO_REPLENISHMENT dependencies on BOM_OPERATION_SEQUENCES

Line 118: FROM bom_operation_sequences

114: | for this routing, it's valid, otherwise it's not valid. |
115: +---------------------------------------------------------------------*/
116: SELECT count(*)
117: INTO l_cnt
118: FROM bom_operation_sequences
119: WHERE operation_type = 3
120: AND routing_sequence_id = (
121: SELECT max(routing_sequence_id)
122: FROM bom_operation_sequences

Line 122: FROM bom_operation_sequences

118: FROM bom_operation_sequences
119: WHERE operation_type = 3
120: AND routing_sequence_id = (
121: SELECT max(routing_sequence_id)
122: FROM bom_operation_sequences
123: WHERE operation_sequence_id = p_op_seq_id
124: );
125:
126: IF (l_cnt = 1) THEN

Line 436: FROM bom_operation_sequences

432: l_stmt_no := 130;
433:
434: SELECT line_op_seq_id
435: INTO l_line_op_seq_id
436: FROM bom_operation_sequences
437: WHERE routing_sequence_id = l_routing_sequence_id
438: AND operation_seq_num = l_operation_seq_num
439: AND operation_type = 1
440: AND effectivity_date =

Line 442: FROM bom_operation_sequences

438: AND operation_seq_num = l_operation_seq_num
439: AND operation_type = 1
440: AND effectivity_date =
441: (SELECT max(effectivity_date)
442: FROM bom_operation_sequences
443: WHERE routing_sequence_id = l_routing_sequence_id
444: AND operation_seq_num = l_operation_seq_num
445: AND operation_type = 1);
446:

Line 516: FROM bom_operation_sequences

512: BEGIN
513:
514: SELECT CEIL(NVL(total_time_calc, 0) / p_takt_time) * p_takt_time
515: INTO l_total_time
516: FROM bom_operation_sequences
517: WHERE operation_sequence_id = p_line_op_seq_id;
518:
519: RETURN l_total_time;
520: