Find business data value in ibm bpm product database

SELECT DISTINCT(bpdIns.BPD_REF) AS BPD_ID, VAR.ALIAS AS SEARCH_ALIAS, VAR.VARIABLE_NAME AS VARIABLE_PATH, BP.NAME AS BPD_NAME, bpdIns.BPD_INSTANCE_ID,
VAR.STRING_VALUE FROM DBWS.LSW_BPD_INSTANCE_VARIABLES VAR LEFT JOIN DBWS.LSW_BPD_INSTANCE bpdIns ON VAR.BPD_INSTANCE_ID = bpdIns.BPD_INSTANCE_ID
LEFT JOIN DBWS.LSW_SNAPSHOT SNAP ON SNAP.SNAPSHOT_ID = bpdIns.SNAPSHOT_ID LEFT JOIN DBWS.LSW_PROJECT PROJ ON SNAP.PROJECT_ID = PROJ.PROJECT_ID
LEFT JOIN DBWS.LSW_BPD BP ON bpdIns.CACHED_BPD_VERSION_ID = BP.VERSION_ID WHERE PROJ.SHORT_NAME= '<ACRONYM NAME>' AND VAR.STRING_VALUE LIKE '%TEST%'
ORDER BY BP.NAME;

Note: DBWS is schema name


--> To find the activity count in Product database:

SELECT * FROM (SELECT COUNT(TSK.TASK_ID) AS COUNTS, TSK.BPD_INSTANCE_ID FROM DBWS.LSW_TASK TSK INNER JOIN DBWS.LSW_BPD_INSTANCE BPD ON BPD.BPD_INSTANCE_ID
= TSK.BPD_INSTANCE_ID WHERE BPD.EXECUTION_STATUS =1 AND TSK.ACTIVITY_NAME='' AND TO_TIMESTAMP(TO_CHAR(TSK.RCVD_DATETIME,'DD-MON-YY HH24:MI:SS'),'DD-MON-YY HH24:MI:SS')>'01-JAN-01 09:45:01 PM' GROUP BY TSK.BPD_INSTANCE_ID ORDERE BY COUNTS DESC WHERE COUNTS > 10)