APPS.WSH_RLM_INTERFACE SQL Statements

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

Line: 25

  v_select_clause             VARCHAR2(32000);

Line: 905

   v_select_clause :=

   'SELECT dd.delivery_detail_id,s.stop_id,s.actual_departure_date,'||
   'nd.name,dd.shipped_quantity, NULL, ol.ordered_item_id, ol.header_id order_hdr_id '||
   'FROM wsh_delivery_Details dd,wsh_trip_stops s,wsh_delivery_legs dl,'||
   'wsh_delivery_assignments_v da,wsh_new_deliveries nd,oe_order_lines_all ol ';

Line: 921

   v_select_clause :=

   'SELECT dd.delivery_detail_id,s.stop_id,s.actual_departure_date,'||
   'nd.name,dd.shipped_quantity,ol.blanket_number,ol.ordered_item_id,'||
   'ol.header_id order_hdr_id '||
   'FROM wsh_delivery_Details dd,wsh_trip_stops s,wsh_delivery_legs dl,'||
   'wsh_delivery_assignments_v da,wsh_new_deliveries nd,oe_order_lines_all ol ';

Line: 931

   ' AND dd.source_header_id IN (select rso_hdr_id FROM rlm_blanket_rso '||
   ' WHERE blanket_number = :blanket_number' ||
   ' AND customer_id = dd.customer_id '||
   ' AND (customer_item_id = dd.customer_item_id '||
   ' OR	customer_item_id = '''|| k_NNULL|| '''))';

Line: 942

 x_c_transit_detail := v_select_clause || v_where_clause;

Line: 992

   SELECT MIN(STP.ACTUAL_DEPARTURE_DATE)
   FROM WSH_TRIP_STOPS STP
   WHERE STP.STOP_ID in
        	( SELECT distinct(LEG.PICK_UP_STOP_ID)
          	  FROM
	            WSH_DELIVERY_DETAILS             DET,
        	    WSH_NEW_DELIVERIES               DEL,
            	    WSH_DELIVERY_LEGS                LEG,
	            wsh_delivery_assignments_v         ASG
        	   WHERE
		    DEL.DELIVERY_ID                 = ASG.DELIVERY_ID AND
         	    ASG.DELIVERY_DETAIL_ID          = DET.DELIVERY_DETAIL_ID AND
         	    LEG.DELIVERY_ID                 = DEL.DELIVERY_ID AND
	 	    DEL.NAME                        = c_del_name
         	)
   AND STP.ACTUAL_DEPARTURE_DATE IS NOT NULL;

Line: 1207

          g_col_tab.DELETE; /* Bug 2946919 */