--------------------------------------------------------
--  DDL for View SMD_ACCOUNTS_PRODUCTION_VW
--------------------------------------------------------

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "OTHQ_OWN"."SMD_ACCOUNTS_PRODUCTION_VW" ("CDBNAME", "PDBID", "COMPID", "REGION", "ENDPOINT", "METADATA_DOWNLOADED_TIMESTAMP_UTC", "PRODUCT_TYPE") DEFAULT COLLATION "USING_NLS_COMP"  AS 
  select
    CDBNAME, PDBID, COMPID, REGION, ENDPOINT, METADATA_DOWNLOADED_TIMESTAMP_UTC,
    case when ENDPOINT like '%nsx%' then 'NSX' else 'NSN' end as PRODUCT_TYPE
from
    SRC_SMD_ACCOUNTS_TB
where
    ENDPOINT like 'netsuite-production%'
;
