Subversion Repositories DevTools

Rev

Rev 6189 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6189 Rev 6268
Line 1... Line 1...
1 
                                                               /* Release Diff */
 1 
/* Release Diff */
2 
SELECT qry.*
 2 
SELECT qry.*
3 
    FROM (
 3 
    FROM (
4 
 
 4 
 
5 
       /* Removed Packages */
 5 
       /* Removed Packages */
6 
       SELECT 'R' AS CHANGE_TYPE,
 6 
       SELECT 'R' AS CHANGE_TYPE,
Line 134... Line 134...
134 
 
 134 
 
135 
       /* UPDATED Packages */
 135 
       /* UPDATED Packages */
136 
       SELECT ( CASE
 136 
       SELECT ( CASE
137 
                  WHEN ra.V_NMM = rb.V_NMM AND ra.patch_number = rb.patch_number AND ra.build_number != rb.build_number THEN
 137 
                  WHEN ra.V_NMM = rb.V_NMM AND ra.patch_number = rb.patch_number AND ra.build_number != rb.build_number THEN
138 
                    'UR'
 138 
                    'UR'
139 
                  WHEN ra.PV_ID < rb.PV_ID OR (ra.V_NMM = rb.V_NMM AND ra.patch_number < rb.patch_number ) THEN
 139 
                  WHEN ra.V_NMM = rb.V_NMM AND TO_NUMBER(ra.patch_number) < TO_NUMBER(rb.patch_number) THEN
140 
                    'UW'
 140 
                    'UW'
141 
                  ELSE
 141 
                  ELSE
142 
                    'U'
 142 
                    'U'
143 
                END
 143 
                END
144 
              ) AS CHANGE_TYPE,
 144 
              ) AS CHANGE_TYPE,