APPS.FTE_ESTIMATE_FREIGHT_RATE SQL Statements

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

Line: 63

    SELECT m.concatenated_segments
    FROM   mtl_system_items_vl m
    WHERE  m.inventory_item_id = p_vehicle_type_id
    AND    m.organization_id in ( select p.master_organization_id
           from mtl_parameters p)
    AND rownum = 1;

Line: 73

select mtl.concatenated_segments VehicleName
from mtl_system_items_kfv mtl, fte_vehicle_types veh
where mtl.vehicle_item_flag = 'Y'
and  mtl.inventory_item_id = veh.inventory_item_id
and veh.vehicle_type_id = l_vehicle_type_id
and rownum=1;

Line: 82

select party_name from hz_parties
where party_id = p_carrier_id;

Line: 87

SELECT GU_VOLUME_UOM
FROM wsh_global_parameters;

Line: 92

select meaning
from fnd_lookup_values_vl
where lookup_type = p_lookup_type
and nvl(start_date_active, sysdate) <= sysdate
and nvl(end_date_active, sysdate) >= sysdate
and lookup_code = p_lookup_code
and enabled_flag='Y';

Line: 203

  delete from FTE_FREIGHT_ESTIMATE_TEMP;

Line: 596

       WSH_DEBUG_SV.logmsg(l_module_name,'inserting the row into temp table ');

Line: 623

    INSERT into FTE_FREIGHT_ESTIMATE_TEMP
        (
         RATE_TEMP_ID ,
         CARRIER      ,
         MODE_OF_TRANSPORT ,
         SERVICE_LEVEL     ,
         VEHICLE_TYPE      ,
         ESTIMATED_RATE    ,
         BASE_PRICE        ,
         ACCESSORIAL_CHARGES ,
         MARKUP_DISCOUNT_TYPE ,
         MARKUP_DISCOUNT_VALUE ,
         CURRENCY_CODE,
         EST_TRANSIT_TIME   ,
         TIME_FEASIBLE_FLAG ,
         CREATED_BY         ,
         CREATION_DATE      ,
         LAST_UPDATED_BY    ,
         LAST_UPDATE_DATE   ,
         LAST_UPDATE_LOGIN
         )
         values
         (
         FTE_FREIGHT_COSTS_TEMP_S.nextval,
         l_carrier      ,
         l_mode_of_transport_meaning ,
         l_service_level     ,
         decode(l_source_header_rates_tab(l_count).mode_of_transport,'TRUCK',l_vehicle_type,null) ,
         l_estimated_rate    ,
         l_base_price        ,
         l_accessorial_charges ,
         p_md_type ,
         l_markup_discount_value ,
         l_currency_code,
         l_est_transit_time   ,
         l_time_feasible_flag ,
         fnd_global.user_id,
         sysdate ,
         fnd_global.user_id ,
         sysdate ,
         fnd_global.login_id
         );