Query to Select all Oracle Workflow Items for a given Item Type

SELECT item_type

      ,item_key

  ,TO_CHAR(begin_date, 'DD-MON-RR HH24:MI:SS') begin_date

  ,TO_CHAR(end_date, 'DD-MON-RR HH24:MI:SS') end_date

  ,root_activity activity

  FROM apps.wf_items

 WHERE item_type = 'XXITEMTP'

   AND end_date IS NULL

 ORDER BY to_date(begin_date, 'DD-MON-YYYY hh24:mi:ss')

 ASC