Subversion Repositories DevTools

Rev

Rev 5506 | Rev 5946 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
5939 dpurdie 1 
-- UsedByThisProject.sql
2 
-- Generate detailed data for projects that use a package.suffix
3 
-- It can generate two types of data
4 
--  PV_ID == -1 -- Any package.suffix
5 
--  PV_ID != -1 -- Only package that match this specific package-version
119 ghuddy 6 
SELECT DECODE( ev.PKG_STATE, NULL, 0, ev.PKG_STATE ) AS PKG_STATE,
5939 dpurdie 7 
       rt.RTAG_ID,
8 
       rt.RTAG_NAME,
9 
       rt.OFFICIAL,
10 
       ev.ENV_AREA,
11 
       pv.PV_ID,
12 
       pkg.PKG_NAME,
13 
       pv.PKG_VERSION,
14 
       pv.DLOCKED,
15 
       usr.FULL_NAME,
16 
       usr.USER_EMAIL,
17 
       pv.MODIFIED_STAMP
119 ghuddy 18 
  FROM ENVIRONMENT_VIEW ev,
5939 dpurdie 19 
       PACKAGE_VERSIONS pv,
20 
       PACKAGES pkg,
21 
       RELEASE_TAGS rt,
22 
       USERS usr
119 ghuddy 23 
 WHERE ev.PV_ID = pv.PV_ID
24 
   AND pv.PKG_ID = :PKG_ID
25 
   AND NVL( pv.V_EXT, '|LINK_A_NULL|') = NVL( :V_EXT, '|LINK_A_NULL|')
26 
   AND pv.PKG_ID = pkg.PKG_ID
27 
   AND ev.RTAG_ID = rt.RTAG_ID
28 
   AND pv.MODIFIER_ID = usr.USER_ID
29 
   AND rt.PROJ_ID = :PROJ_ID
5939 dpurdie 30 
   AND (ev.pv_id = :PV_ID OR :PV_ID = -1)
31 
 ORDER BY rt.RTAG_ID DESC
32