Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Package Details */
2 
SELECT pv.pv_id,
3 
	   pkg.pkg_id,
4 
	   pkg.pkg_name,
5 
       pv.pkg_version,
6 
       pv.v_ext,
7 
       pv.modified_stamp,
8 
       pv.modifier_id,
9 
       umd.user_name modifier,
10 
       umd.user_email AS modifier_email,
11 
       pv.created_stamp,
12 
       ucr.user_name AS creator,
13 
       ucr.user_email AS creator_email,
14 
       onr.full_name AS owner,
15 
       onr.user_email AS owner_email,
16 
       pv.dlocked,
17 
       rel.proj_id,
18 
       rel.rtag_id,
19 
       rel.rtag_name,
20 
       rel.product_state_used,
21 
       pv.comments,
22 
       pv.pkg_label,
23 
       pv.src_path,
24 
       pv.pv_description,
25 
       pv.is_patch,
26 
       lpv.pkg_version AS previous_version,
27 
       pv.last_pv_id,
28 
	   pv.release_notes_info,
29 
	   pv.is_obsolete,
30 
	   pv.obsolete_comments,
31 
	   pv.build_type,
32 
	   pv.change_type,
33 
	   pv.bs_id,
34 
	   pv.is_deployable,
35 
	   pv.sbom_priority,
36 
	pv.ripple_field
37 
  FROM package_versions pv,
38 
       package_versions lpv,
39 
       PACKAGES pkg,
40 
       release_tags rel,
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 rel.rtag_id (+) = pv.released_at
47 
   AND umd.user_id (+) = pv.modifier_id
48 
   AND ucr.user_id (+) = pv.creator_id
49 
   AND onr.user_id (+) = pv.owner_id
50 
   AND pv.pv_id = :PV_ID