Subversion Repositories DevTools

Rev

Rev 6612 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
4687 dpurdie 1 
/* Package Details, no release information */
119 ghuddy 2 
SELECT pv.pv_id,
5929 dpurdie 3 
       pkg.pkg_id,
4 
       pkg.pkg_name,
119 ghuddy 5 
       pv.pkg_version,
6 
       pv.v_ext,
7 
       pv.modified_stamp,
8 
       pv.modifier_id,
6612 dpurdie 9 
       umd.full_name modifier,
119 ghuddy 10 
       umd.user_email AS modifier_email,
11 
       pv.created_stamp,
5929 dpurdie 12 
       pv.creator_id,
6612 dpurdie 13 
       ucr.full_name AS creator,
5929 dpurdie 14 
       ucr.user_email AS creator_email,
15 
       pv.owner_id,
119 ghuddy 16 
       onr.full_name AS owner,
17 
       onr.user_email AS owner_email,
18 
       pv.dlocked,
19 
       pv.comments,
20 
       pv.pkg_label,
21 
       pv.src_path,
22 
       pv.pv_description,
23 
       pv.is_patch,
24 
       lpv.pkg_version AS previous_version,
25 
       pv.last_pv_id,
5929 dpurdie 26 
       pv.release_notes_info,
27 
       pv.is_obsolete,
28 
       pv.obsolete_comments,
29 
       pv.build_type,
30 
       pv.change_type,
31 
       pv.bs_id,
32 
       pv.is_deployable,
33 
       pv.sbom_priority,
7537 dpurdie 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
119 ghuddy 38 
  FROM package_versions pv,
39 
       package_versions lpv,
40 
       PACKAGES pkg,
41 
       users umd,
42 
       users ucr,
43 
       users onr
44 
 WHERE pkg.pkg_id = pv.pkg_id
45 
   AND pv.last_pv_id = lpv.pv_id (+)
46 
   AND umd.user_id (+) = pv.modifier_id
47 
   AND ucr.user_id (+) = pv.creator_id
48 
   AND onr.user_id (+) = pv.owner_id
6612 dpurdie 49 
   AND pv.pv_id = :PV_ID
50