Subversion Repositories computer_asset_manager_v2

Rev

Rev 46 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 46 Rev 54
Line 262... Line 262...
262 
      location.created location_created,
 262 
      location.created location_created,
263 
      location.removed location_removed,
 263 
      location.removed location_removed,
264 
      owner.owner_id owner_id,
 264 
      owner.owner_id owner_id,
265 
      owner.name owner,
 265 
      owner.name owner,
266 
      owner.created owner_created,
 266 
      owner.created owner_created,
267 
      owner.removed owner_removed
 267 
      owner.removed owner_removed,
- 
 
 268 
      (
- 
 
 269 
         owner.removed is null
- 
 
 270 
         and location.removed is null
- 
 
 271 
         and device.removed is null
- 
 
 272 
      ) active
268 
   from
 273 
   from
269 
      device
 274 
      device
270 
      join view_device_types using (device_id )
 275 
      join view_device_types using (device_id )
271 
      join location_device using (device_id)
 276 
      join location_device using (device_id)
272 
      join location using (location_id)
 277 
      join location using (location_id)