APPS.FTE_TRIP_RATING_GRP SQL Statements

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

Line: 35

   SELECT wt.trip_id,
          wt.name,
          wt.planned_flag,
          wt.status_code,
          wt.carrier_id,
          wt.ship_method_code,
          wt.service_level,
          wt.mode_of_transport,
          wt.lane_id,
          wt.schedule_id,
          wt.load_tender_status,
          wt.tp_plan_name,
          ftm.move_id
   FROM   wsh_trips wt, fte_trip_moves ftm
   WHERE  wt.trip_id = c_trip_id
   AND    wt.trip_id = ftm.trip_id (+) ;

Line: 519

      SELECT fte_pricing_comp_request_s.nextval
      FROM   sys.dual;

Line: 1397

      SELECT auto_rate_tp_rel_trips
      FROM  wsh_global_parameters;

Line: 2067

  SELECT trip_id
  FROM wsh_trips
  WHERE name = c_trip_name;

Line: 2177

SELECT  mode_of_transportation_code
FROM    fte_lanes
WHERE   lane_id = c_lane_id;

Line: 2184

SELECT  mode_of_transportation_code
FROM    fte_lanes l, fte_schedules s
WHERE   l.lane_id = s.lane_id
AND     s.schedules_id = c_schedule_id;

Line: 2190

        SELECT  dl.delivery_leg_id
        FROM    wsh_delivery_legs dl ,
                wsh_trip_stops s
        WHERE   dl.pick_up_stop_id = s.stop_id
                and s.trip_id=c_trip_id;

Line: 2339

PROCEDURE Delete_Main_Records(
	p_trip_id IN NUMBER,
	p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
	x_return_status OUT NOCOPY VARCHAR2) IS

l_return_status VARCHAR2(1);

Line: 2354

   SELECT t.mode_of_transport
   FROM   wsh_trips t
   WHERE t.trip_id=c_trip_id;

Line: 2369

 	FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Delete_Main_Records','start');

Line: 2381

		FTE_TL_RATING.Delete_Main_Records(
			p_trip_id=>p_trip_id,
			x_return_status=>l_return_status);

Line: 2389

			  raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail;

Line: 2397

	      FTE_FREIGHT_PRICING.delete_invalid_fc_recs (
		     p_segment_id      =>  p_trip_id,
		     x_return_status   =>  l_return_status ) ;

Line: 2403

		     raise FTE_FREIGHT_PRICING_UTIL.g_delete_invalid_fc_failed;

Line: 2409

	FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Delete_Main_Records');

Line: 2424

WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail THEN
         x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line: 2426

         FTE_FREIGHT_PRICING_UTIL.set_exception('Delete_Main_Records',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_main_rec_fail');

Line: 2427

         FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Delete_Main_Records');

Line: 2434

WHEN FTE_FREIGHT_PRICING_UTIL.g_delete_invalid_fc_failed THEN
         x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line: 2436

         FTE_FREIGHT_PRICING_UTIL.set_exception('Delete_Main_Records',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_delete_invalid_fc_failed');

Line: 2437

         FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Delete_Main_Records');

Line: 2447

	FTE_FREIGHT_PRICING_UTIL.set_exception('Delete_Main_Records',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line: 2449

	FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Delete_Main_Records');

Line: 2457

END Delete_Main_Records;

Line: 3130

	'  LAST_UPDATE_DATE   :'||p_rank_rec.last_update_date);

Line: 3132

	'  LAST_UPDATE_BY     :'||p_rank_rec.last_updated_by);

Line: 3134

	'  LAST_UPDATE_LOGIN  :'||p_rank_rec.last_update_login);

Line: 3204

SELECT	v.inventory_item_id,
	v.organization_id
FROM	FTE_VEHICLE_TYPES v
WHERE	v.vehicle_type_id=c_vehicle_type;

Line: 3568

SELECT delivery_type
FROM wsh_new_deliveries
WHERE delivery_id=c_delivery_id;

Line: 3573

select dl.parent_delivery_leg_id
FROM wsh_delivery_legs dl,
     wsh_trip_stops s
WHERE dl.delivery_id=c_delivery_id
AND dl.parent_delivery_leg_id is not null
AND dl.pick_up_stop_id = s.stop_id
AND s.trip_id=c_trip_id;

Line: 3810

		l_lane_rank_tab.DELETE;

Line: 3811

		l_lane_rank_ref.DELETE;

Line: 4153

		l_elim_rank_tab.DELETE;

Line: 4154

		l_elim_rank_ref.DELETE;

Line: 4179

		l_rate_rank_tab.DELETE;

Line: 4180

		l_rate_rank_ref.DELETE;

Line: 4204

		l_sort_rank_tab.DELETE;

Line: 4205

		l_sort_rank_ref.DELETE;