SELECT
F.SUBJ_NAME AS FOLDER_NAME
, WF.TASK_ID AS WORKFLOW_ID
, WF.TASK_NAME AS WORKFLOW_NAME
, SE.INSTANCE_NAME AS SESSION_NAME
, TSK.TASK_NAME
, decode (attr_value,
0,'None',
1,'Terse',
2,'Normal',
3,'Verbose Initialisation',
4,'Verbose Data','') TRACING_LEVEL FROM OPB_SUBJECT F, OPB_TASK WF ,
(SELECT
WORKFLOW_ID,
INSTANCE_ID,
TASK_ID,
TASK_TYPE,
INSTANCE_NAME,
MAX(VERSION_NUMBER) FROM OPB_TASK_INST SESS
WHERE SESS.TASK_TYPE=68 GROUP BY
WORKFLOW_ID,INSTANCE_ID,TASK_ID,TASK_TYPE,INSTANCE_NAME) SE,
(SELECT SESSION_ID,MAPPING_ID,MAX(VERSION_NUMBER) FROM OPB_SESSION GROUP BY SESSION_ID,MAPPING_ID) S
LEFT JOIN OPB_TASK TSK ON ( TSK.TASK_ID = S.SESSION_ID )
LEFT JOIN REP_SESS_CONFIG_PARM CFG ON ( CFG.SESSION_ID = S.SESSION_ID ) WHERE 1=1
AND WF.IS_VISIBLE = 1
AND WF.SUBJECT_ID = F.SUBJ_ID
AND SE.WORKFLOW_ID = WF.TASK_ID
AND WF.TASK_TYPE = 71
AND SE.TASK_ID = S.SESSION_ID
AND CFG.SESSION_ID=TSK.TASK_ID
AND TSK.TASK_TYPE=68
AND ATTR_ID=204
AND ATTR_TYPE=6
AND attr_value = 4
-- AND F.SUBJ_NAME='MANKELI'
ORDER BY FOLDER_NAME , WORKFLOW_NAME , SESSION_NAME
No comments:
Post a Comment
- the first minus - Comments have to be moderated because of the spammers
- the second minus - I am very lazy at moderating comments ... hardly find time ...
- the third minus - Short links are no good for security ...
- The REAL PLUS : Any critic and positive feedback is better than none, so your comments will be published sooner or later !!!!