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
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