APPS.FTE_FREIGHT_RATING_PUB SQL Statements

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

Line: 21

   SELECT a.ship_method_code
   FROM wsh_carrier_services a, wsh_org_carrier_services b
   WHERE a.carrier_service_id = b.carrier_service_id
     AND b.organization_id = c_org_id
     AND b.enabled_flag = 'Y'
     AND a.enabled_flag = 'Y'
     AND a.mode_of_transport = c_mode_of_trans
     AND a.service_level = c_service_level
     AND a.carrier_id = c_carrier_id;

Line: 32

   SELECT freight_code
   FROM   wsh_carriers
   WHERE carrier_id = c_carrier_id;

Line: 37

   SELECT generic_flag
   FROM   wsh_carriers
   WHERE carrier_id = c_carrier_id;

Line: 42

   SELECT a.generic_flag
   FROM   wsh_carriers a, wsh_carrier_services b
   WHERE a.carrier_id = b.carrier_id
     AND b.ship_method_code = c_ship_method_code;

Line: 49

   SELECT ship_method_code,carrier_id, service_level, mode_of_transport, ship_method_meaning
   FROM   wsh_carrier_services
   WHERE  ship_method_code = c_shp_mthd_cd;

Line: 927

  fte_freight_pricing.g_shipment_line_rows.DELETE;

Line: 1544

	l_values_tab.DELETE;

Line: 1780

	l_lane_info_tab.DELETE;

Line: 2424

   SELECT fte_pricing_comp_request_s.nextval
   FROM   sys.dual;

Line: 2695

    	l_lane_info_tab.DELETE;

Line: 2786

	l_tl_source_header_rates_tab.delete;

Line: 2787

	l_tl_source_line_rates_tab.delete;