...
view: cs_objectlocations (refreshed 2012-04-19 [may still need work]05-16)
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT j.ObjectNumber objectNumber, l.LocationString currLocation, o.Handler handlerString, h.MTB_ConstituentID1,h.MTB_ConstituentID2,h.MTB_ConstituentID3,h.MTB_ConstituentID4,h.MTB_ConstituentID5, o.TransDate locationDate, p.LocPurpose reasonForMove, o.AnticipEndDate plannedRemovalDate, o.DateOut removalDate, o.SearchContainer currentLocationNote, l.LocationID locationShortID, o.CrateID, (case when o.Inactive = 1 then 'active' else 'deleted' end) miscStatus FROM ObjLocations o JOIN LocHandlers h ON h.Handler = o.Handler JOIN Locations l ON l.LocationID = o.LocationID JOIN Objects j ON j.ObjectID = o.ComponentID JOIN LocPurposes p ON p.LocPurposeID = o.LocPurposeID ORDER BY locationDate; ; |
...