Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
119 ghuddy 1 
SELECT RC.PV_ID, PV.PKG_VERSION, P.PKG_NAME, V.VIEW_NAME, V.VIEW_ID
2 
FROM RELEASE_CONTENT RC, VIEWS V, PACKAGE_VERSIONS PV, PACKAGES P
3 
WHERE RC.RTAG_ID =:RTAG_ID
5638 dpurdie 4 
AND RC.INSERT_STAMP >= TO_DATE(:INITDATE,'DY DD-MON-YYYY')
5 
AND RC.INSERT_STAMP <= TO_DATE(:DUEDATE,'DY DD-MON-YYYY')
119 ghuddy 6 
AND V.VIEW_ID = RC.BASE_VIEW_ID
7 
AND RC.PV_ID = PV.PV_ID
8 
AND PV.PKG_ID = P.PKG_ID
9 
ORDER BY VIEW_NAME