Subversion Repositories DevTools

Rev

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

Rev 6612 Rev 7537
Line 29... Line 29...
29 
       pv.build_type,
 29 
       pv.build_type,
30 
       pv.change_type,
 30 
       pv.change_type,
31 
       pv.bs_id,
 31 
       pv.bs_id,
32 
       pv.is_deployable,
 32 
       pv.is_deployable,
33 
       pv.sbom_priority,
 33 
       pv.sbom_priority,
34 
       pv.ripple_field
 34 
       pv.ripple_field,
- 
 
 35 
       (SELECT count(*) FROM PACKAGE_VERSIONS cpv WHERE cpv.pkg_id = pv.pkg_id) AS pkgVerCount,
- 
 
 36 
       (SELECT IS_COTS from PROJECT_EXTENTIONS WHERE Upper(ext_name) = Upper(pv.v_ext))  AS is_cots,
- 
 
 37 
       (SELECT EREF from PACKAGE_EREF WHERE PV_ID = :PV_ID) AS pkg_eref
35 
  FROM package_versions pv,
 38 
  FROM package_versions pv,
36 
       package_versions lpv,
 39 
       package_versions lpv,
37 
       PACKAGES pkg,
 40 
       PACKAGES pkg,
38 
       users umd,
 41 
       users umd,
39 
       users ucr,
 42 
       users ucr,