Siebel Workflow Related SQLs and Queries

To find the WFs in which BS is used:

SELECT
T1.SERVICE_NAME "BS",
T2.name "WF",
T2.status_cd "WF Status"
FROM
S_WF_STEP T1,
s_wf_step T2
WHERE
T1.row_id = T2.process_id and
T2.SERVICE_NAME like ('BS NAME')
and T1.status_cd ='ACTIVE'

To find WF policy from WF process:

select t1.name from siebel.s_escl_rule t1, s_escl_action t2,s_action_arg t3 where
t1.row_id = t2.rule_id and
t2.action_id = t3.action_id and
t3.DEFAULT_VALUE like 'WF Process Name'

To find parent process from sub process:

select distinct(name) from s_wf_step where
status_cd ='ACTIVE' and
type_cd='PROCESS' and row_id in
(select distinct(process_id) from s_wf_step where method_name like
'Sub Process Name'
and type_cd ='SUB_PROCESS')

at 1/19/2012