--------------------------------------------------------
--  DDL for View SMD_ACCOUNTS_LOCAL_DCID_PRODUCTION_VW
--------------------------------------------------------

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "OTHQ_OWN"."SMD_ACCOUNTS_LOCAL_DCID_PRODUCTION_VW" ("COMPID", "PDBID", "INACTIVE", "INMAINTENANCE", "PASSWORDDAYS", "AFFILIATE", "REFERALEMAIL", "CONSOLPARENT", "ISTESTDRIVE", "PARENTCOMPID", "EMAIL", "TRIALTEMPLATETYPE", "NAME", "ACCOUNTTYPE", "USABLE", "MASTERACCOUNT", "NOTE", "DCID", "VERSIONMAJOR", "DEBUGDATE", "DEBUGLEVEL", "LASTMODIFIED", "CREATED", "REGION", "ENDPOINT", "METADATA_DOWNLOADED_TIMESTAMP_UTC", "COMPNAME") DEFAULT COLLATION "USING_NLS_COMP"  AS 
  select
    COMPID, PDBID, INACTIVE, INMAINTENANCE, PASSWORDDAYS, AFFILIATE, REFERALEMAIL, CONSOLPARENT, ISTESTDRIVE, PARENTCOMPID, EMAIL, TRIALTEMPLATETYPE, NAME, ACCOUNTTYPE, USABLE, MASTERACCOUNT, NOTE, DCID, VERSIONMAJOR, DEBUGDATE, DEBUGLEVEL, LASTMODIFIED, CREATED, REGION, ENDPOINT, METADATA_DOWNLOADED_TIMESTAMP_UTC, COMPNAME
from
    SRC_SMD_ACCOUNTS_LOCAL_DCID_TB
where
    ENDPOINT like 'netsuite-production%'
;
