Subversion Repositories DevTools

Rev

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

Rev 1453 Rev 1454
Line 383... Line 383...
383 
        {
 383 
        {
384 
            $excludes .= " AND rt.RTAG_ID != $_ ";
 384 
            $excludes .= " AND rt.RTAG_ID != $_ ";
385 
        }
 385 
        }
386 
    }
 386 
    }
387 
 
 387 
 
388 
    my $m_sqlstr = "SELECT DISTINCT pv.PV_ID, pkg.PKG_NAME, pv.PKG_VERSION, pv.DLOCKED" .
 388 
    my $m_sqlstr = "SELECT DISTINCT " .
- 
 
 389 
                        "pv.PV_ID, " .                                          #[0]
- 
 
 390 
                        "pkg.PKG_NAME, " .                                      #[1]
- 
 
 391 
                        "pv.PKG_VERSION, " .                                    #[2]
- 
 
 392 
                        "pv.DLOCKED, " .                                        #[3]
389 
                   "    , release_manager.PK_RMAPI.return_vcs_tag(pv.PV_ID), pv.PKG_ID" .
 393 
                        "release_manager.PK_RMAPI.return_vcs_tag(pv.PV_ID), " . #[4]
- 
 
 394 
                        "pv.PKG_ID", .                                          #[5]
390 
                   "    , rt.RTAG_ID, rmv.VIEW_NAME, pv.MODIFIED_STAMP, prj.PROJ_ID" .
 395 
                        "rt.RTAG_ID, " .                                        #[6]
- 
 
 396 
                        "rmv.VIEW_NAME, " .                                     #[7]
- 
 
 397 
                        "pv.MODIFIED_STAMP, " .                                 #[8]
- 
 
 398 
                        "prj.PROJ_ID " .                                        #[9]
391 
                   " FROM RELEASE_MANAGER.RELEASE_CONTENT rc, RELEASE_MANAGER.PACKAGE_VERSIONS pv,".
 399 
                   " FROM RELEASE_MANAGER.RELEASE_CONTENT rc, RELEASE_MANAGER.PACKAGE_VERSIONS pv,".
392 
                   "      RELEASE_MANAGER.PACKAGES pkg, release_manager.release_tags rt, release_manager.projects prj" .
 400 
                   "      RELEASE_MANAGER.PACKAGES pkg, release_manager.release_tags rt, release_manager.projects prj" .
393 
                   "    , release_manager.views rmv" .
 401 
                   "    , release_manager.views rmv" .
394 
                   " WHERE rc.PV_ID = pv.PV_ID AND pv.PKG_ID = pkg.PKG_ID" .
 402 
                   " WHERE rc.PV_ID = pv.PV_ID AND pv.PKG_ID = pkg.PKG_ID" .
395 
                   "   AND rmv.VIEW_ID = rc.BASE_VIEW_ID" .
 403 
                   "   AND rmv.VIEW_ID = rc.BASE_VIEW_ID" .