| Line 15... |
Line 15... |
| 15 |
WHEN (rl.pause = 2) THEN 2 -- disabled
|
15 |
WHEN (rl.pause = 2) THEN 2 -- disabled
|
| 16 |
WHEN ((TRUNC(86400*(SYSDATE - rl.keep_alive)) > 600 ) AND (rl.current_pkg_id_being_built IS NULL)) THEN -2 -- daemon timed out
|
16 |
WHEN ((TRUNC(86400*(SYSDATE - rl.keep_alive)) > 600 ) AND (rl.current_pkg_id_being_built IS NULL)) THEN -2 -- daemon timed out
|
| 17 |
WHEN (rl.current_run_level <> 3) AND (rl.pause IS NULL) THEN 0 -- enabled and not engaged
|
17 |
WHEN (rl.current_run_level <> 3) AND (rl.pause IS NULL) THEN 0 -- enabled and not engaged
|
| 18 |
WHEN (rl.current_run_level = 3) AND (rl.pause IS NULL) THEN 3 -- enabled and engaged
|
18 |
WHEN (rl.current_run_level = 3) AND (rl.pause IS NULL) THEN 3 -- enabled and engaged
|
| 19 |
ELSE -1 -- unavailable
|
19 |
ELSE -1 -- unavailable
|
| 20 |
END AS status
|
20 |
END AS status,
|
| - |
|
21 |
NVL(bm.ACTIVE,'U') as active
|
| 21 |
FROM release_tags rt, release_config rc, run_level rl, build_machine_config bm
|
22 |
FROM release_tags rt, release_config rc, run_level rl, build_machine_config bm
|
| 22 |
WHERE rt.proj_id = :PROJ_ID
|
23 |
WHERE rt.proj_id = :PROJ_ID
|
| 23 |
AND rt.rtag_id = rc.rtag_id
|
24 |
AND rt.rtag_id = rc.rtag_id
|
| 24 |
AND rc.rcon_id = rl.rcon_id (+)
|
25 |
AND rc.rcon_id = rl.rcon_id (+)
|
| 25 |
AND rc.bmcon_id = bm.bmcon_id(+)
|
26 |
AND rc.bmcon_id = bm.bmcon_id(+)
|
| 26 |
ORDER BY bm.display_name, rc.rcon_id
|
27 |
ORDER BY bm.display_name, rc.rcon_id
|
| - |
|
28 |
|