Subversion Repositories DevTools

Rev

Rev 6873 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6873 Rev 7162
Line 10... Line 10...
10 
    pv.OWNER_ID,
 10 
    pv.OWNER_ID,
11 
    pv.CREATOR_ID,
 11 
    pv.CREATOR_ID,
12 
    NVL2(rc.rtag_id,1,0) as inuse,
 12 
    NVL2(rc.rtag_id,1,0) as inuse,
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' WHEN 'F' THEN 'ForcedRipple' 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 
    pln.NAME as licence,
20 
    pv.pkg_idext,
 20 
    pv.pkg_idext,