CREATE VIEW "v$gla_data" AS
       SELECT "gla_hours"."timestamp", "gla_hours"."num_val", "gla_hours"."text_val", "gla_objects"."object_name", "gla_sdamaps"."scan_name", "gla_agents"."agent_name"
       FROM "gla_hours", "gla_objects", "gla_sdamaps", "gla_agents"
       WHERE gla_hours.obj_id = gla_objects.obj_id AND gla_objects.agent_id = gla_sdamaps.agent_id AND gla_objects.scan_index = gla_sdamaps.scan_index AND gla_sdamaps.agent_id = gla_agents.agent_id
GO