VIEW: SYS.KU$_PROCACT_SYS_VIEW

Source

View Text - Preformatted

select '1','0',
  p.package, p.schema,
  p.level#, p.class, pr.prepost,
  case
   when p.class=1 then sys.dbms_metadata.get_action_sys
        ( p.package, p.schema,'SYSTEM_INFO_EXP', pr.prepost)
   else null
  end
  FROM  sys.exppkgact$ p , ku$_prepost_view pr
  where p.class =1
  order by p.level#

View Text - HTML Formatted

SELECT '1'
, '0'
, P.PACKAGE
, P.SCHEMA
, P.LEVEL#
, P.CLASS
, PR.PREPOST
, CASE WHEN P.CLASS=1 THEN SYS.DBMS_METADATA.GET_ACTION_SYS ( P.PACKAGE
, P.SCHEMA
, 'SYSTEM_INFO_EXP'
, PR.PREPOST) ELSE NULL END
FROM SYS.EXPPKGACT$ P
, KU$_PREPOST_VIEW PR
WHERE P.CLASS =1 ORDER BY P.LEVEL#