Subversion Repositories DevTools

Rev

Rev 6623 | Rev 6873 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6623 Rev 6707
Line 13... Line 13...
13 
    trunc(SYSDATE - pv.CREATED_STAMP + 0.5) as age,
 13 
    trunc(SYSDATE - pv.CREATED_STAMP + 0.5) as age,
14 
    pm.code_lines,
 14 
    pm.code_lines,
15 
    (CASE bi.reason WHEN 'R' THEN 'Ripple' WHEN 'N' THEN 'New Version' WHEN 'T' THEN 'Test' WHEN 'P' THEN 'Restored' ELSE '' END ) as reason,
 15 
    (CASE bi.reason WHEN 'R' THEN 'Ripple' WHEN 'N' THEN 'New Version' WHEN 'T' THEN 'Test' WHEN 'P' THEN 'Restored' ELSE '' END ) as reason,
16 
    bi.state,
 16 
    bi.state,
17 
    (select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count,
 17 
    (select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count,
18 
    pv.build_time
 18 
    pv.build_time,
- 
 
 19 
    pln.NAME as licence
19 
  FROM PACKAGE_VERSIONS pv,
 20 
  FROM PACKAGE_VERSIONS pv,
20 
       USERS usr,
 21 
       USERS usr,
21 
       RELEASE_CONTENT rc,
 22 
       RELEASE_CONTENT rc,
22 
       ( select pv_id, max(build_id) as build_id  from BUILD_INSTANCES bi
 23 
       ( select pv_id, max(build_id) as build_id  from BUILD_INSTANCES bi
23 
          where bi.state in ('C')
 24 
          where bi.state in ('C')
24 
          and bi.reason not in ('T')
 25 
          and bi.reason not in ('T')
25 
          group by pv_id
 26 
          group by pv_id
26 
        ) cbi,
 27 
        ) cbi,
27 
       BUILD_INSTANCES bi,
 28 
       BUILD_INSTANCES bi,
28 
       package_metrics pm
 29 
       package_metrics pm,
- 
 
 30 
       LICENCING pl,
- 
 
 31 
       LICENCES pln
29 
 WHERE pv.PKG_ID = :PKG_ID
 32 
 WHERE pv.PKG_ID = :PKG_ID
30 
   AND pv.PKG_VERSION LIKE :PKG_VERSION
 33 
   AND pv.PKG_VERSION LIKE :PKG_VERSION
31 
   AND pv.MODIFIER_ID = usr.USER_ID(+)
 34 
   AND pv.MODIFIER_ID = usr.USER_ID(+)
32 
   AND pv.pv_id = rc.pv_id(+)
 35 
   AND pv.pv_id = rc.pv_id(+)
33 
   AND cbi.pv_id(+) = pv.pv_id
 36 
   AND cbi.pv_id(+) = pv.pv_id
34 
   and cbi.build_id = bi.build_id(+)
 37 
   and cbi.build_id = bi.build_id(+)
35 
   AND pm.pv_id (+) = pv.pv_id
 38 
   AND pm.pv_id (+) = pv.pv_id
- 
 
 39 
   and pl.PV_ID(+) = pv.pv_id
- 
 
 40 
   and pln.LICENCE(+) = pl.LICENCE
36 
 
 41