SELECT RC.PV_ID, PV.PKG_VERSION, P.PKG_NAME, V.VIEW_NAME, V.VIEW_ID
FROM RELEASE_CONTENT RC, VIEWS V, PACKAGE_VERSIONS PV, PACKAGES P
WHERE RC.RTAG_ID =:RTAG_ID
AND RC.INSERT_STAMP >= TO_DATE(:INITDATE,'DD/MM/YYYY')
AND RC.INSERT_STAMP <= TO_DATE(:DUEDATE,'DD/MM/YYYY')
AND V.VIEW_ID = RC.BASE_VIEW_ID
AND RC.PV_ID = PV.PV_ID
AND PV.PKG_ID = P.PKG_ID
ORDER BY VIEW_NAME