APPS.WMS_LABEL_PUB SQL Statements

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

Line: 62

       select  inventory_location_id
              ,concatenated_segments locator
              ,subinventory_code
       from mtl_item_locations_kfv
       where concatenated_segments between
                 decode(p_location_fr,null,concatenated_segments,p_location_fr)
             and decode(p_location_to,null,concatenated_segments,p_location_to)
       and subinventory_code between
             decode(p_zone_fr,null,subinventory_code,p_zone_fr)
             and decode(p_zone_to,null,subinventory_code,p_zone_to)
       and organization_id = p_organization_id;

Line: 536

   select INSTR(value,',',1,2),INSTR(value,',',1,3)
   into v_st_position,v_end_position from  v$parameter
   where upper(name) = 'UTL_FILE_DIR';

Line: 542

   select substr(value,v_st_position+1,v_w_position)
   into v_log_name from v$parameter
   where upper(name) = 'UTL_FILE_DIR';