--------------------------------------------------------
--  DDL for View OSEARCH_PROFILEDATA_APPLICATION_SERVER_HEALTH_VW
--------------------------------------------------------

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "OTHQ_OWN"."OSEARCH_PROFILEDATA_APPLICATION_SERVER_HEALTH_VW" ("TIMESTAMP", "SMACHINETYPE", "SDCID", "APPSERVERAD", "SCOMPID", "SDBINSTANCE", "KDATABASE", "SRELEASE", "PEAK_HOUR_LABEL", "DOC_COUNT", "INDEX_", "SREGION", "SUM_NCPUTIME", "METADATA_REGION", "METADATA_DOWNLOADED_TIMESTAMP_UTC", "TIMEZONE", "LAT", "LON") DEFAULT COLLATION "USING_NLS_COMP"  AS 
  SELECT
  t."TIMESTAMP",t."SMACHINETYPE",t."SDCID",t."APPSERVERAD",t."SCOMPID",t."SDBINSTANCE",t."KDATABASE",t."SRELEASE",t."PEAK_HOUR_LABEL",t."DOC_COUNT",t."INDEX_",t."SREGION",t."SUM_NCPUTIME",t."METADATA_REGION",t."METADATA_DOWNLOADED_TIMESTAMP_UTC",
  r.TIMEZONE,
  r.LAT,
  r.LON
FROM
  SRC_OSEARCH_PROFILEDATA_APPLICATION_SERVER_HEALTH_TB t
  JOIN SRC_CSV_REGIONS_TB r
      ON t.METADATA_REGION = LOWER(r.REGION_KEY)
;
