select 
  s.agent_id, s.query_cost_estimate
, s.stmt_elapsed_time_s, s.rows_read, s.rows_written
, s.stmt_usr_cpu_time_s, s.stmt_sys_cpu_time_s
, coalesce(s.stmt_text, s2.text) stmt_text
from table(snap_get_stmt('')) s
join table(snap_get_appl_info('')) a on s.agent_id=a.agent_id
left join syscat.statements s2 on s.creator=s2.pkgschema and s.package_name=s2.pkgname 
and s.section_number=s2.sectno and s.package_version_id=s2.version
where a.appl_status='UOWEXEC'
order by ...