function getPrintedValues(p_string varchar2)
 return varchar2
 is
  l_new_string varchar2(32700);
  l_redex      varchar2(50) := '[^ -~]';
 begin
  SELECT REPLACE(REPLACE(REPLACE(REGEXP_REPLACE(p_string, l_redex, ''), '[CR-LF]', '' ),chr(9),''),chr(10),'8')
    into l_new_string
    from dual;
   return l_new_string;
 end;

----------------------------

     select  trim('	' FROM trim( '	PC FDC Warehouse' )) from dual -- ok
     /
     select  trim(CHR(9) FROM trim( '	PC FDC Warehouse' )) from dual
     /
     select trim( '	PC FDC Warehouse' ) from dual
     /
     select  ASCIISTR( '	PC FDC Warehouse' ) from dual
     /
     SELECT translate(
           translate(
               translate('	PC FDC Warehouse', CHR(10), '')
           , CHR(13), '')
       , CHR(09), '') as massaged
FROM dual;
/
SELECT REGEXP_REPLACE('	PC FDC Warehouse', '[^ -~]','') from dual
/
select wims_aop_qry_rep_pkg.getPrintedValues('	PC FDC Warehouse') from dual
/
select dump('	PC FDC Warehouse') from dual;
/
select trim(replace(replace(replace('	PC FDC Warehouse',chr(9),''),chr(10),''),chr(13),'')) from dual

-------------------------------------