--------------------------------------------------------
--  DDL for View SMD_EXACS_PRODUCTION_VW
--------------------------------------------------------

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "OTHQ_OWN"."SMD_EXACS_PRODUCTION_VW" ("SCANNAME", "EXACS_HOSTNAME", "DATACENTER", "NOTE", "OCI_SCANNAME", "ORACLE_DNS_SCANNAME", "NS_DNS_SCANNAME", "AVAILABILITYDOMAIN", "OPERATINGSTATUS", "OPERATINGSTATUSLASTMODIFIED", "REGION", "ENDPOINT", "METADATA_DOWNLOADED_TIMESTAMP_UTC") DEFAULT COLLATION "USING_NLS_COMP"  AS 
  select
    SCANNAME, EXACS_HOSTNAME, DATACENTER, NOTE, OCI_SCANNAME, ORACLE_DNS_SCANNAME, NS_DNS_SCANNAME, AVAILABILITYDOMAIN, OPERATINGSTATUS, OPERATINGSTATUSLASTMODIFIED, REGION, ENDPOINT, METADATA_DOWNLOADED_TIMESTAMP_UTC
from
    SRC_SMD_EXACS_TB
where
    ENDPOINT like 'netsuite-production%'
;
