APPS.WSH_TRIP_CONSOLIDATION SQL Statements

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

Line: 6

 * delivery records and selects only those whose indexes exist in
 * p_IndexTab table
**/
PROCEDURE BuildDeliveryTable(p_IndexTab IN WSH_UTIL_CORE.ID_TAB_TYPE,
                             p_DeliveryTab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
                             x_deliveryTab   IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type) IS
  --
  l_debugOn     BOOLEAN;

Line: 171

   wsh_debug_sv.log(l_moduleName, 'Total number of deliveries selected', v_DelivTab.COUNT);

Line: 183

   l_DelTab.DELETE;

Line: 245

       l_deliveryTab.DELETE;

Line: 297

      wsh_debug_sv.logmsg(l_moduleName, 'No deliveries selected for this hashValue');

Line: 404

  v_Select	     VARCHAR2(1000);

Line: 436

  v_select := 'SELECT  wnd.DELIVERY_ID, wnd.ORGANIZATION_ID, wnd.STATUS_CODE, wnd.PLANNED_FLAG, ' ||
              ' wnd.NAME, wnd.INITIAL_PICKUP_DATE, wnd.INITIAL_PICKUP_LOCATION_ID, ' ||
              ' wnd.ULTIMATE_DROPOFF_LOCATION_ID, wnd.ULTIMATE_DROPOFF_DATE, wnd.CUSTOMER_ID, ' ||
              ' wnd.INTMED_SHIP_TO_LOCATION_ID, wnd.SHIP_METHOD_CODE, wnd.DELIVERY_TYPE, ' ||
              ' wnd.CARRIER_ID, wnd.SERVICE_LEVEL, wnd.MODE_OF_TRANSPORT, ' ||
     	      ' wnd.SHIPMENT_DIRECTION, wnd.PARTY_ID, wnd.SHIPPING_CONTROL, ' ||
              ' NVL(wnd.ignore_for_planning, ''N''), NULL ';

Line: 447

	     ' NOT EXISTS (SELECT 1 FROM wsh_delivery_legs ' ||
      	     ' WHERE delivery_id = wnd.delivery_id) ';

Line: 558

  x_Query := v_select || v_from || v_where || v_OrderBy;

Line: 562

    wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);

Line: 914

  SELECT count(DISTINCT delivery_id)
  FROM wsh_trips wt, wsh_trip_stops wts1,
       wsh_trip_stops wts2, wsh_delivery_legs wdl
  WHERE wt.trip_id = p_tripId
  AND wts1.stop_id = wdl.pick_up_stop_id
  AND wts2.stop_id = wdl.drop_off_stop_id
  AND wts1.trip_id = wt.trip_id
  AND wts2.trip_id = wt.trip_id;

Line: 1040

     l_delivery_tab.DELETE;

Line: 1053

      l_delivery_tab.DELETE;

Line: 1063

      l_delivery_tab.DELETE;