Subversion Repositories DevTools

Rev

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

Rev 6788 Rev 6789
Line 9... Line 9...
9 
    select LEVEL as ll, pv_id from small_pd pd connect by prior pv_id = dpv_id start with dpv_id=:PV_ID
 9 
    select LEVEL as ll, pv_id from small_pd pd connect by prior pv_id = dpv_id start with dpv_id=:PV_ID
10 
    UNION
 10 
    UNION
11 
    SELECT 0 AS ll, to_number(:PV_ID) AS pv_id FROM dual
 11 
    SELECT 0 AS ll, to_number(:PV_ID) AS pv_id FROM dual
12 
) )
 12 
) )
13 
select t.*,  p.pkg_name, pv.pkg_version, pv.MODIFIED_STAMP,pv.DLOCKED, rc.deprecated_state, pv.build_time, rc.PKG_STATE, usr.FULL_NAME, usr.USER_EMAIL
 13 
select t.*,  p.pkg_name, pv.pkg_version, pv.MODIFIED_STAMP,pv.DLOCKED, rc.deprecated_state, pv.build_time, rc.PKG_STATE, usr.FULL_NAME, usr.USER_EMAIL
14 
from (select MAX(ll) as buildLevel, pv_id
 14 
from (select MIN(ll) as buildLevel, pv_id
15 
      from aa group by pv_id
 15 
      from aa group by pv_id
16 
     ) t, packages p, package_versions pv, release_content rc, USERS usr
16 
     ) t, packages p, package_versions pv, release_content rc, USERS usr
17 
     where t.pv_id = pv.pv_id and pv.pkg_id =  p.pkg_id AND rc.rtag_id = :RTAG_ID and rc.pv_id =  pv.pv_id AND pv.MODIFIER_ID = usr.USER_ID
 17 
     where t.pv_id = pv.pv_id and pv.pkg_id =  p.pkg_id AND rc.rtag_id = :RTAG_ID and rc.pv_id =  pv.pv_id AND pv.MODIFIER_ID = usr.USER_ID
18 
order by buildLevel, upper(pkg_name)
 18 
order by buildLevel, upper(pkg_name)