Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Tuesday, 21 June 2016

Query To get workflow Details



SELECT
  CASE
    WHEN row_number() over(PARTITION BY wit.display_name
      || ' ('
      || wit.name
      || ')' ORDER BY pro.name,wpa.instance_label,wpa.activity_name nulls LAST) = 1
    THEN wit.display_name
      || ' ('
      || wit.name
      || ')'
    ELSE NULL
  END "Item Type" ,
  CASE
    WHEN row_number() over(PARTITION BY wit.display_name
      || ' ('
      || wit.name
      || ')' ,pro.name ORDER BY wpa.instance_label,wpa.activity_name nulls LAST) = 1
    THEN pro.name
    ELSE NULL
  END "Process" ,
  wpa.instance_label
  || ' ('
  || wpa.activity_name
  || ')' "Process Activity" ,
  CASE
    WHEN act.FUNCTION IS NOT NULL
    THEN 'Function: '
      || act.function
    WHEN act.message IS NOT NULL
    THEN 'Message: '
      || act.message
    ELSE NULL
  END "Activity Detail"
FROM wf_item_types_tl wit ,
  wf_activities pro ,
  wf_process_activities wpa ,
  wf_activities act
WHERE wit.name            = pro.item_type
AND pro.TYPE              = 'PROCESS'
AND pro.end_date         IS NULL
AND wit.language          = 'US'
AND pro.item_type         = wpa.process_item_type
AND pro.VERSION           = wpa.process_version
AND wpa.process_name      = pro.name
AND wpa.activity_name     = act.name
AND wpa.process_item_type = act.item_type
AND act.end_date         IS NULL
  --AND    UPPER(wit.name)         = :1
ORDER BY wit.display_name,
  wit.name,
  pro.name,
  wpa.instance_label
Share this article :

0 comments:

Post a Comment