Subversion Repositories DevTools

Rev

Rev 7002 | Rev 7288 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 7002 Rev 7030
Line 267... Line 267...
267 
        "    package_versions pvc" &_
 267 
        "    package_versions pvc" &_
268 
        " WHERE" &_
 268 
        " WHERE" &_
269 
        "    pv.created_stamp> pvc.created_stamp" &_
 269 
        "    pv.created_stamp> pvc.created_stamp" &_
270 
        "    AND pv.pkg_id = pvc.pkg_id" &_
 270 
        "    AND pv.pkg_id = pvc.pkg_id" &_
271 
        "    AND NVL(pvc.v_ext, 'isNULL') = NVL(pv.v_ext, 'isNULL')" &_
 271 
        "    AND NVL(pvc.v_ext, 'isNULL') = NVL(pv.v_ext, 'isNULL')" &_
272 
        "    AND pvc.build_type != 'Y'" &_
 272 
        "    AND pv.build_type != 'Y'" &_
273 
        "    AND pvc.pv_id = " & parPv_id &_
 273 
        "    AND pvc.pv_id = " & parPv_id &_
274 
        " ORDER by pv.created_stamp desc"
 274 
        " ORDER by pv.created_stamp desc"
275 
 
 275 
 
276 
   Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
 276 
   Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
277 
   sNewerVersionsOptions = ""
 277 
   sNewerVersionsOptions = ""