Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
119 ghuddy 1 
SELECT dnr.RTAG_ID, dnr.PV_ID AS LAST_PV_ID, pv.PV_ID AS NEW_PV_ID
2 
FROM RELEASE_CONTENT rc, DO_NOT_RIPPLE dnr, PACKAGE_VERSIONS pv
3 
WHERE rc.PV_ID = pv.PV_ID
4 
AND rc.RTAG_ID = dnr.RTAG_ID
5 
AND pv.DLOCKED = 'Y'
6 
AND pv.LAST_PV_ID = dnr.PV_ID
7 
AND pv.PV_ID != dnr.PV_ID
8 
ORDER BY LAST_PV_ID
9