Subversion Repositories DevTools

Rev

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

Rev 6579 Rev 6873
Line 77... Line 77...
77 
                  " FROM RELEASE_CONFIG rc, RELEASE_TAGS rt, PROJECTS p, RUN_LEVEL rl, BUILD_MACHINE_CONFIG bm, PACKAGES pkg " &_
 77 
                  " FROM RELEASE_CONFIG rc, RELEASE_TAGS rt, PROJECTS p, RUN_LEVEL rl, BUILD_MACHINE_CONFIG bm, PACKAGES pkg " &_
78 
                  " WHERE rt.RTAG_ID = rc.RTAG_ID " &_
 78 
                  " WHERE rt.RTAG_ID = rc.RTAG_ID " &_
79 
                  "   AND rc.bmcon_id is not null" &_
 79 
                  "   AND rc.bmcon_id is not null" &_
80 
                  "   AND rt.PROJ_ID = p.PROJ_ID " &_
 80 
                  "   AND rt.PROJ_ID = p.PROJ_ID " &_
81 
                  "   AND rt.OFFICIAL in ( 'N', 'R', 'C')" &_
 81 
                  "   AND rt.OFFICIAL in ( 'N', 'R', 'C')" &_
82 
                  "   AND rl.RCON_ID = rc.RCON_ID" &_
 82 
                  "   AND rl.RCON_ID(+) = rc.RCON_ID" &_
83 
                  "   AND rc.bmcon_id = bm.bmcon_id(+)" &_
 83 
                  "   AND rc.bmcon_id = bm.bmcon_id(+)" &_
84 
                  "   AND pkg.PKG_ID(+) = rl.CURRENT_PKG_ID_BEING_BUILT" &_
 84 
                  "   AND pkg.PKG_ID(+) = rl.CURRENT_PKG_ID_BEING_BUILT" &_
85 
                  " ORDER BY p.PROJ_NAME, rt.RTAG_NAME, rc.DAEMON_MODE, bm.DISPLAY_NAME, rc.DAEMON_MODE"
 85 
                  " ORDER BY p.PROJ_NAME, rt.RTAG_NAME, rc.DAEMON_MODE, bm.DISPLAY_NAME, rc.DAEMON_MODE"
86 
 
 86 
 
87 
    Set buildStatus = CreateObject("Scripting.Dictionary")
 87 
    Set buildStatus = CreateObject("Scripting.Dictionary")