| 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
|
|
|
4 |
AND RC.INSERT_STAMP >= TO_DATE(:INITDATE,'DD/MM/YYYY')
|
|
|
5 |
AND RC.INSERT_STAMP <= TO_DATE(:DUEDATE,'DD/MM/YYYY')
|
|
|
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
|