APPS.WSH_ITM_RESUBMIT SQL Statements

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

Line: 57

		SELECT DISTINCT
			TRIGGERING_POINT
		FROM WSH_ITM_REQUEST_CONTROL
		WHERE request_control_id= c_request_control_id;

Line: 63

		SELECT
		   exception_id,status,logged_at_location_id,exception_location_id,DELIVERY_ID,delivery_name
		FROM
		  wsh_exceptions wex,
		  wsh_itm_request_control wrc
		WHERE
		  wrc.original_system_reference =wex.delivery_id
		  AND wex.exception_name LIKE 'WSH_EXPORT_COMPL_FAILED' AND WEX.STATUS='OPEN'
		  AND WRC.REQUEST_CONTROL_ID = C_REQUEST_CONTROL_ID
		ORDER BY wex.creation_date;

Line: 164

    /*		 UPDATE wsh_itm_request_control
                    SET    process_flag = 0,
                           response_header_id = NULL
                    WHERE  request_control_id = p_request_control_id;

Line: 259

  SELECT  DISTINCT
          wrc.request_control_id
  FROM
          WSH_ITM_REQUEST_CONTROL wrc,
          WSH_ITM_RESPONSE_HEADERS wrh
  WHERE
          wrc.response_header_id  = wrh.response_header_id
  AND     nvl(wrh.vendor_id,-99)  = nvl(p_vendor_id, nvl(wrh.vendor_id,-99))
  AND     nvl(wrh.error_type,-99) = nvl(p_error_type, nvl(wrh.error_type,-99))
  AND     nvl(wrh.error_code,-99) = nvl(p_error_code, nvl(wrh.error_code,-99))
  AND    nvl( wrc.original_system_reference,-99) = nvl(p_reference_id,
                                          nvl(wrc.original_system_reference,-99))
  AND     wrc.process_flag  = 2
  AND     wrc.application_id =665;

Line: 304

     l_sql_string := 'SELECT  DISTINCT wrc.request_control_id '||
                     'FROM    WSH_ITM_REQUEST_CONTROL wrc '||
                     ',       WSH_ITM_RESPONSE_HEADERS wrh '||
                     ',       OE_ORDER_HEADERS_ALL oh ';

Line: 342

                                      ' SELECT DISTINCT wrc.request_control_id '||
                                      ' FROM    WSH_ITM_REQUEST_CONTROL wrc '||
                                      ' ,       WSH_ITM_RESPONSE_HEADERS wrh '||
                                      ' ,       WSH_ITM_RESPONSE_LINES wrl '||
                                      ' ,       OE_ORDER_LINES_ALL ol ';

Line: 493

               UPDATE wsh_itm_request_control
               SET    process_flag = 0,
                      response_header_id = NULL
               WHERE  request_control_id = l_request_control_id;