SELECT 
  A.TIME_STARTED, A.TIME_COMPLETED, TIMESTAMPDIFF(2, CHAR(A.TIME_COMPLETED-A.TIME_STARTED)) TIME_S
, A.UOW_ID, A.ACTIVITY_ID
--, A.PARENT_UOW_ID, A.PARENT_ACTIVITY_ID
, V.STMT_VALUE_INDEX, V.STMT_VALUE_ISREOPT
, V.STMT_VALUE_INDEX, VARCHAR(V.STMT_VALUE_DATA, 50) STMT_VALUE_DATA
, VARCHAR(S.STMT_TEXT, 256) stmt_text
FROM ACTIVITY_ACT A
JOIN ACTIVITYSTMT_ACT S ON S.APPL_ID=A.APPL_ID AND S.UOW_ID=A.UOW_ID AND S.ACTIVITY_ID=A.ACTIVITY_ID
LEFT JOIN ACTIVITYVALS_ACT V ON V.APPL_ID=S.APPL_ID AND V.UOW_ID=S.UOW_ID AND V.ACTIVITY_ID=S.ACTIVITY_ID
WHERE S.APPL_ID='<APPLICATION_ID>'
ORDER BY A.TIME_STARTED, A.APPL_ID, A.UOW_ID, A.ACTIVITY_ID;