Subversion Repositories DevTools

Rev

Rev 5506 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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

            10