Database Software

Hello all,

We have lot of custom workflows processes and we want to know when they were used last based on that we want to clear the inventory. I'm using the below query to find out the workflow transaction and i see that its missing lot of workflow processes which i think are being used somewhere. Below is the query i am using but its only display few of our custom workflow processes. Does that mean the other processes were never been used?

SELECT witems.ITEM_TYPE,
witems.ITEM_KEY,
witems.ROOT_ACTIVITY,
wactivity.DISPLAY_NAME PROCESS_NAME,
witems.ROOT_ACTIVITY_VERSION,
witems.OWNER_ROLE,
WFN.NOTIFICATION_ID,
witems.PARENT_ITEM_TYPE,
witems.PARENT_ITEM_KEY,
witems.PARENT_CONTEXT,
witems.BEGIN_DATE,
witems.END_DATE,
PA.INSTANCE_ID,
witems.USER_KEY,
wtypes.NAME,
wtypes.DISPLAY_NAME
FROM WF_ITEMS witems,
WF_ITEM_TYPES_VL wtypes,
WF_ACTIVITIES_VL wactivity,
WF_NOTIFICATIONS WFN,
WF_PROCESS_ACTIVITIES PA
WHERE witems.ITEM_TYPE = wtypes.NAME
AND wactivity.ITEM_TYPE = witems.ITEM_TYPE
AND WFN.ITEM_KEY = witems.Item_Key
AND wactivity.NAME = witems.ROOT_ACTIVITY
AND PA.PROCESS_ITEM_TYPE = witems.Item_Type
AND (wactivity.DISPLAY_NAME) in ('xxx Process Name'

)
AND wactivity.VERSION = witems.ROOT_ACTIVITY_VERSION



Thank You
KK