APPS.BOM_CALC_TPCT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23

  select bos.operation_sequence_id start_operation_sequence_id
  from bom_operation_sequences bos
  where bos.routing_sequence_id = cv_routing_sequence_id
  and bos.operation_type = cv_operation_type
    minus
  select bon.to_op_seq_id start_operation_sequence_id
  from bom_operation_networks bon, bom_operation_sequences bos
  where bon.to_op_seq_id = bos.operation_sequence_id
  and bos.routing_sequence_id = cv_routing_sequence_id
  and bos.operation_type = cv_operation_type
  and nvl(bon.transition_type, 0) <> 3;

Line: 40

  select bon.to_op_seq_id
  from bom_operation_networks bon
  connect by prior to_op_seq_id = from_op_seq_id
             and
             nvl(bon.transition_type, 0) not in (2, 3)
  start with from_op_seq_id = cv_start_operation_sequence_id
             and
             nvl(bon.transition_type, 0) not in (2, 3);

Line: 56

    select nvl(total_time_calc, 0)
    into v_tpct
    from bom_operation_sequences
    where operation_sequence_id = start_ops_rec.start_operation_sequence_id;

Line: 65

      select nvl(total_time_calc, 0)
      into v_ttc
      from bom_operation_sequences
      where operation_sequence_id = network_rec.to_op_seq_id;

Line: 95

   update bom_operational_routings
   set total_product_cycle_time = total_cycle_time
   where common_routing_sequence_id = p_routing_sequence_id;