Musings - OWB Workflow

I already know how to check whether the Control Center (CC) service is available or not using the template sql provided along with the OWB client installation.

I have come across this following thread in Oracle Warehouse Builder forum which explains how we can check the Workflow installation.

http://forums.oracle.com/forums/thread.jspa?threadID=597761&tstart=30

One guy has posted the following query to check the workflow installation.

SELECT
TEXT VERSION
FROM
.WF_RESOURCES
WHERE
TYPE = 'WFTKN'
AND NAME = 'WF_VERSION'".( - default owf_mgr)

I have checked with my repository installation. When I run the query I got table doesn’t exist. In that server we have installed Oracle Workflow (no idea on version).