APPS.WSH_ITM_OVERRIDE SQL Statements

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

Line: 42

   SELECT application_short_name
   FROM   fnd_application_vl
   WHERE  application_id = appl_id;

Line: 47

   SELECT 'x'
   FROM   WSH_ITM_REQUEST_CONTROL
   WHERE  request_set_id = req_set_id
   AND    process_flag not in (1,3);

Line: 185

    SELECT
          exception_name,
          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 wrc.request_control_id = l_request_control_id
           AND (wex.exception_name LIKE 'WSH_PR%'OR wex.exception_name LIKE 'WSH_SC%' OR       wex.exception_name LIKE
           'WSH_EXPORT_COMPL_FAILED') AND WEX.STATUS <> 'CLOSED';

Line: 357

  SELECT  DISTINCT
          wrc.request_control_id,
          wrc.request_set_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: 375

  SELECT  DISTINCT
          wrc.request_control_id,
          wrc.request_set_id
  FROM
          WSH_ITM_REQUEST_CONTROL wrc
  WHERE
         nvl(wrc.original_system_reference,-99) = nvl(p_reference_id,
                                          nvl(wrc.original_system_reference,-99))
  AND     wrc.process_flag in  (0,-4);

Line: 387

  SELECT  DISTINCT
          wrc.request_control_id,
          wrc.request_set_id
  FROM
          WSH_ITM_REQUEST_CONTROL wrc,
          WSH_ITM_SERVICE_PREFERENCES wsp,
          WSH_ITM_VENDOR_SERVICES wvs
  WHERE
         nvl(wrc.original_system_reference,-99) = nvl(p_reference_id,
                                          nvl(wrc.original_system_reference,-99))
  AND     wrc.application_id = wsp.application_id
  AND     wrc.master_organization_id = wsp.master_organization_id
  AND     wsp.active_flag = 'Y'
  AND     wsp.vendor_service_id = wvs.vendor_service_id
  AND     wrc.service_type_code = wvs.service_type
  AND     wvs.vendor_id = p_vendor_id
  AND     wrc.process_flag in (0,-4);

Line: 446

                        l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';

Line: 521

                        l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';

Line: 646

               update wsh_itm_request_control
               SET    process_flag = 3
               WHERE  request_control_id = l_request_control_id;

Line: 710

            l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';

Line: 757

            l_sql_string := l_sql_string || 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';

Line: 917

                        UPDATE wsh_itm_request_control
                        SET    process_flag = 3
                        WHERE  request_control_id = l_request_control_id;