APPS.MST_CM_DETAILS SQL Statements

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

Line: 11

  select count(trip_id)
  from mst_trips
  where plan_id = arg_plan_id
  and continuous_move_id = arg_continuous_move_id;

Line: 36

  select sum(total_trip_distance)
  from mst_trips
  where plan_id = arg_plan_id
  and continuous_move_id = arg_continuous_move_id;

Line: 62

  select nvl(total_saving, 0)
  into l_savings
  from mst_cm_trips
  where plan_id = arg_plan_id
  and continuous_move_id = arg_continuous_move_id;

Line: 105

cursor num_of_excep is select count(1)
from mst_exception_details
where plan_id = arg_plan_id
and continuous_move_id is not null;

Line: 127

    select count(1) from mst_trips
    where plan_id = arg_plan_id
    and mode_of_transport = 'TRUCK'
--Bug_Fix for 3803450
--	and move_type = 2;

Line: 135

    select count(1) from mst_trips
    where plan_id = arg_plan_id
    and mode_of_transport = 'TRUCK'
    and continuous_move_id is not null
--Bug_Fix for 3803450
--	and move_type = 2;

Line: 164

  select count(1)
  from mst_delivery_legs
  where plan_id = arg_plan_id
  and trip_id = arg_trip_id;

Line: 172

  select meaning
    from mfg_lookups
    where lookup_type = 'MST_YES_NO'
    and lookup_code = 1;