APPS.JAI_WSH_EXP_HANDLING_PKG SQL Statements

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

Line: 46

  select *
  from   JAI_WSH_EXCEPTIONS_T
  where  delivery_id = p_delivery_id
  order by exception_entity;

Line: 116

  SELECT  *
  FROM    wsh_delivery_details
  WHERE   delivery_detail_id IN
          ( SELECT
              delivery_detail_id
            FROM
              wsh_delivery_assignments
            WHERE
              delivery_id = p_delivery_id
          );

Line: 128

  select 'Y'
  from   JAI_WSH_EXCEPTIONS_T
  where  delivery_id = p_delivery_id and
         exception_entity = 'OM_INTERFACE';

Line: 134

  select 'Y'
  from   JAI_WSH_EXCEPTIONS_T
  where  delivery_id = p_delivery_id and
         exception_entity = 'INVENTORY_INTERFACE';