| 5503 |
dpurdie |
1 |
-- Generate a table of build machines that are available
|
|
|
2 |
-- Exclude those that users cannot configure
|
| 7278 |
dpurdie |
3 |
-- Mark as selected any machine that matches :bmcon_id
|
|
|
4 |
-- Mark as disabled any machine that is already in use by :rtag_id, except :bmcon_id
|
| 5503 |
dpurdie |
5 |
--
|
|
|
6 |
-- Generate data suitable for filling in a MultiCombo Box
|
|
|
7 |
|
|
|
8 |
SELECT AllMachines.BMCON_ID, AllMachines.display_name, AllMAchines.GBE_VALUE, AllMachines.DESCRIPTION, AllMachines.selected || NVL2(InUse.BMCON_ID, ' disabled', '') AS selected
|
|
|
9 |
FROM
|
|
|
10 |
|
|
|
11 |
(SELECT bm.bmcon_id, display_name, gbe_value,
|
|
|
12 |
COALESCE(SUBSTR(description,1,INSTR(description,CHR(10),1,1)),description) AS description,
|
|
|
13 |
DECODE(:bmcon_id, bm.bmcon_id, 'selected', NULL) AS SELECTED
|
|
|
14 |
FROM build_machine_config bm, gbe_machtype gb
|
|
|
15 |
WHERE bm.gbe_id = gb.gbe_id
|
|
|
16 |
AND (bm.active = 'Y' OR bm.bmcon_id = :bmcon_id )
|
|
|
17 |
) AllMachines,
|
|
|
18 |
|
|
|
19 |
(SELECT BMCON_ID
|
|
|
20 |
FROM release_config rc, gbe_machtype gbe
|
|
|
21 |
WHERE rc.rtag_id = :rtag_id
|
| 7278 |
dpurdie |
22 |
AND gbe.gbe_id = rc.gbe_id
|
|
|
23 |
AND BMCON_ID != :bmcon_id
|
| 5503 |
dpurdie |
24 |
) InUse
|
|
|
25 |
|
|
|
26 |
WHERE AllMachines.BMCON_ID = InUse.BMCON_ID(+)
|
|
|
27 |
ORDER BY UPPER(display_name)
|
|
|
28 |
|
|
|
29 |
|