SOA 12c: finding flow and instance names and titles


To identify via SQL the latest flow and instance titles, run the following query:

SELECT f.flow_id
      ,f.title
      ,c.composite_id
      ,c.title
FROM   sca_flow_instance         f
      ,sca_flow_to_cpst          c
WHERE  c.flow_id                 = f.flow_id
ORDER BY
       f.flow_id      DESC
      ,c.composite_id DESC

Also including the composite type:

SELECT f.flow_id
      ,f.title
      ,r.composite
      ,c.composite_id
      ,c.title
FROM   sca_flow_instance         f
      ,sca_flow_to_cpst          c
      ,sca_entity                r
WHERE  c.flow_id                 = f.flow_id
  AND  c.composite_sca_entity_id = r.id
ORDER BY
       f.flow_id      DESC
       c.composite_id DESC