select
APEX_ITEM.HIDDEN(2,a.file_name)||a.file_name FILE_NAME
,a.file_size
,a.file_modify
,APEX_ITEM.CHECKBOX2(1,a.file_name,'onclick="get_phone(this.checked,this.value)"  id="trace_checks2"'||decode(b.file_name,null,null,'checked')) "CHK"
,apex_item.hidden(10,case when c.parse_error is null then e.parse_error else c.parse_error end)||case when c.parse_state is null then DECODE(e.parse_state,NULL,'<a href="javascript:showDialog('''||a.file_name||''')">Проанализировать</a>',e.parse_state||'(ПОСМОТРЕТЬ)') else c.parse_state end as parse_state
,'<a href="javascript:trace_to_zip_js('''||a.file_name||''')">Заказать ZIP</a>' as order_zip
,:P1_DIS
from
v_traces a
, (select * from TRACE_LIST_TEMP where user_name=:APP_USER) b
, ufprof.UFP_PARSE c
, (select parse_id,substr(trace_filename,instr(trace_filename,'\',-1,1)+1) file_name from ufprof.ufp_trace) d
, (select distinct parse_state,parse_error,substr(parse_error,instr(parse_error,'\',-1,1)+1,instr(parse_error,'trc',-1,1)+2-instr(parse_error,'\',-1,1)) as file_name from ufprof.UFP_PARSE) e
WHERE
a.FILE_NAME=b.file_name(+)
and 
substr(a.file_name,-3)='trc'
and d.file_name(+)=a.file_name and d.parse_id=c.parse_id(+) and a.file_name=e.file_name(+)
and (upper(a.FILE_NAME) LIKE '%'||upper(nvl(:P1_REPORT_SEARCH,''))||'%'
or upper(c.parse_state) LIKE '%'||upper(nvl(:P1_REPORT_SEARCH,''))||'%')
 order by 5 desc,1

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.24          0        132          0           0
Execute      1      0.00       0.01          0          0          0           0
Fetch      493      0.31       0.43       1456       1488          1         492
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      495      0.32       0.68       1456       1620          1         492

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 95     (recursive depth: 1)
Number of plan statistics captured: 1