Wednesday 19 June 2013

Custom Workflow

  SELECT   a.ITEM_TYPE,
           A.NAME,
           A.TYPE,
           A.FUNCTION,
           B.DISPLAY_NAME,
           B.DESCRIPTION
    FROM   WF_ACTIVITIES a, WF_ITEM_types_TL b
   WHERE       a.end_date IS NULL
           AND a.BEGIN_DATE >= '01-JAN-2013'
           AND a.item_type = b.name
           AND B.DISPLAY_NAME NOT LIKE 'Standard%'
ORDER BY   a.BEGIN_DATE DESC

No comments:

Post a Comment