Subversion Repositories DevTools

Rev

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

Rev 5506 Rev 7278
Line 1... Line 1...
1 
-- 	Generate a table of build machines that are available
 1 
-- 	Generate a table of build machines that are available
2 
--  	Exclude those that users cannot configure
 2 
--  	Exclude those that users cannot configure
3 
--		Mark as selcted any machine that matches :bmcon_id
 3 
--		Mark as selected any machine that matches :bmcon_id
4 
--		Mark as disabled any machine that is already in use by :rtag_id
 4 
--		Mark as disabled any machine that is already in use by :rtag_id, except :bmcon_id
5 
--
 5 
--
6 
--	Generate data suitable for filling in a MultiCombo Box
 6 
--	Generate data suitable for filling in a MultiCombo Box
7 
 
 7 
 
8 
SELECT AllMachines.BMCON_ID, AllMachines.display_name, AllMAchines.GBE_VALUE, AllMachines.DESCRIPTION, AllMachines.selected || NVL2(InUse.BMCON_ID, ' disabled', '') AS selected
8 
SELECT AllMachines.BMCON_ID, AllMachines.display_name, AllMAchines.GBE_VALUE, AllMachines.DESCRIPTION, AllMachines.selected || NVL2(InUse.BMCON_ID, ' disabled', '') AS selected
9 
FROM
9 
FROM
Line 17... Line 17...
17 
  ) AllMachines,
17 
  ) AllMachines,
18
18
19 
  (SELECT BMCON_ID
19 
  (SELECT BMCON_ID
20 
  FROM release_config rc, gbe_machtype gbe
20 
  FROM release_config rc, gbe_machtype gbe
21 
  WHERE rc.rtag_id = :rtag_id
21 
  WHERE rc.rtag_id = :rtag_id
22 
  AND gbe.gbe_id   = rc.gbe_id
22 
  AND gbe.gbe_id   = rc.gbe_id
- 
 
 23 
  AND BMCON_ID != :bmcon_id
23 
  ) InUse
24 
  ) InUse
24
25
25 
WHERE AllMachines.BMCON_ID = InUse.BMCON_ID(+)
26 
WHERE AllMachines.BMCON_ID = InUse.BMCON_ID(+)
26 
ORDER BY UPPER(display_name)
 27 
ORDER BY UPPER(display_name)
27 
 
 28