Subversion Repositories DevTools

Rev

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

Rev 6080 Rev 6785
Line 55... Line 55...
55 
       dpv.PKG_VERSION AS DPKG_VERSION,
 55 
       dpv.PKG_VERSION AS DPKG_VERSION,
56 
       ev.ENV_AREA,
 56 
       ev.ENV_AREA,
57 
       vi.VIEW_NAME,
 57 
       vi.VIEW_NAME,
58 
       usr.FULL_NAME,
 58 
       usr.FULL_NAME,
59 
       usr.USER_EMAIL,
 59 
       usr.USER_EMAIL,
60 
       pv.MODIFIED_STAMP
60 
       pv.MODIFIED_STAMP,
- 
 
 61 
       ev.deprecated_state
61 
  FROM ENVIRONMENT_VIEW ev,
 62 
  FROM ENVIRONMENT_VIEW ev,
62 
       PACKAGE_DEPENDENCIES dep,
 63 
       PACKAGE_DEPENDENCIES dep,
63 
       PACKAGE_VERSIONS dpv,
 64 
       PACKAGE_VERSIONS dpv,
64 
       PACKAGE_VERSIONS pv,
 65 
       PACKAGE_VERSIONS pv,
65 
       PACKAGES pkg,
 66 
       PACKAGES pkg,
Line 84... Line 85...
84 
   AND ev.VIEW_ID = vi.VIEW_ID
85 
   AND ev.VIEW_ID = vi.VIEW_ID
85 
   AND pv.MODIFIER_ID = usr.USER_ID
 86 
   AND pv.MODIFIER_ID = usr.USER_ID
86 
   AND igw.PV_ID (+) = dep.PV_ID
 87 
   AND igw.PV_ID (+) = dep.PV_ID
87 
   AND igw.DPV_ID (+) = dep.DPV_ID
 88 
   AND igw.DPV_ID (+) = dep.DPV_ID
88 
 ORDER BY UPPER(pkg.PKG_NAME)
89 
 ORDER BY UPPER(pkg.PKG_NAME)
89
- 
 
90 

            90
            
   

          

          

            -
            
 

            91