APPS.FTE_ACS_TRIP_PKG SQL Statements

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

Line: 82

    SELECT
        DELIVERY_ID
      , ORGANIZATION_ID
      , STATUS_CODE
      , PLANNED_FLAG
      , NAME
      , INITIAL_PICKUP_DATE
      , INITIAL_PICKUP_LOCATION_ID
      , ULTIMATE_DROPOFF_LOCATION_ID
      , ULTIMATE_DROPOFF_DATE
      , CUSTOMER_ID
      , INTMED_SHIP_TO_LOCATION_ID
      , SHIP_METHOD_CODE
      , DELIVERY_TYPE
      , CARRIER_ID
      , SERVICE_LEVEL
      , MODE_OF_TRANSPORT
      , shipment_direction
      , party_id
      , shipping_control
      , weight_uom_code
      , volume_uom_code
      , nvl(ignore_for_planning,'N') ignore_for_planning
    FROM WSH_NEW_DELIVERIES
    WHERE delivery_id = p_delivery_id;

Line: 109

	SELECT weight_uom_code
        ,volume_uom_code
	FROM wsh_new_deliveries
	WHERE  delivery_id = p_delivery_id;*/

Line: 249

    l_trip_info_tab(1).LAST_UPDATE_DATE      := SYSDATE;

Line: 250

    l_trip_info_tab(1).LAST_UPDATED_BY       := fnd_global.user_id;

Line: 251

    l_trip_info_tab(1).LAST_UPDATE_LOGIN     := fnd_global.login_id;

Line: 254

    l_trip_info_tab(1).PROGRAM_UPDATE_DATE   := FND_API.G_MISS_DATE;

Line: 286

    WSH_TRIPS_GRP.Create_Update_Trip(
       p_api_version_number => l_api_version_number,
       p_init_msg_list      => l_init_msg_list,
       p_commit             => l_commit,
       x_return_status      => l_return_status,
       x_msg_count          => l_msg_count,
       x_msg_data           => l_msg_data,
       p_trip_info_tab      => l_trip_info_tab,
       p_in_rec             => l_trip_in_rec,
       x_out_tab            => l_trip_out_rec_tab);

Line: 337

     WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(
           p_api_version_number    => l_api_version_number,
           p_init_msg_list         => l_init_msg_list,
           p_commit                => l_commit,
           p_in_rec                => l_stop_in_rec,
           p_rec_attr_tab          => l_pickup_rec_attr_tab,
           x_stop_out_tab          => l_pickup_stop_out_tab,
           x_return_status         => l_return_status,
           x_msg_count             => l_msg_count,
           x_msg_data              => l_msg_data,
           x_stop_wt_vol_out_tab   => l_stop_wt_vol_out_tab);

Line: 368

     WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(
           p_api_version_number    => l_api_version_number,
           p_init_msg_list         => l_init_msg_list,
           p_commit                => l_commit,
           p_in_rec                => l_stop_in_rec,
           p_rec_attr_tab          => l_dropoff_rec_attr_tab,
           x_stop_out_tab          => l_dropoff_stop_out_tab,
           x_return_status         => l_return_status,
           x_msg_count             => l_msg_count,
           x_msg_data              => l_msg_data,
           x_stop_wt_vol_out_tab   => l_stop_wt_vol_out_tab);

Line: 500

SELECT name
FROM   FTE_SEL_RULES
WHERE  RULE_ID = p_rule_id;