Subversion Repositories DevTools

Rev

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

Rev 6788 Rev 6790
Line 10... Line 10...
10 
With aa as (
 10 
With aa as (
11 
    select distinct LEVEL as ll, pd.dpv_id from package_dependencies pd connect by prior dpv_id = pv_id start with pv_id=:PV_ID
 11 
    select distinct LEVEL as ll, pd.dpv_id from package_dependencies pd connect by prior dpv_id = pv_id start with pv_id=:PV_ID
12 
    UNION
 12 
    UNION
13 
    SELECT 0 AS ll, to_number(:PV_ID) AS dpv_id FROM dual
 13 
    SELECT 0 AS ll, to_number(:PV_ID) AS dpv_id FROM dual
14 
)
 14 
)
15 
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
 15 
select t.*,  p.pkg_name, pv.pkg_version, pv.MODIFIED_STAMP,pv.DLOCKED,pv.pkg_id, rc.deprecated_state, pv.build_time, rc.PKG_STATE, usr.FULL_NAME, usr.USER_EMAIL
16 
from (select MIN(ll) as buildLevel, dpv_id as pv_id
 16 
from (select MIN(ll) as buildLevel, dpv_id as pv_id
17 
      from aa group by dpv_id
 17 
      from aa group by dpv_id
18 
     ) t, packages p, package_versions pv, release_content rc, USERS usr
 18 
     ) t, packages p, package_versions pv, release_content rc, USERS usr
19 
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
 19 
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
20 
order by buildLevel, UPPER(pkg_name)
 20 
order by buildLevel, UPPER(pkg_name)
21 
 
 21