--------------------------------------------------------
--  DDL for View NLCORP_ISSUE_MIGVAL_VW
--------------------------------------------------------

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "OTHQ_OWN"."NLCORP_ISSUE_MIGVAL_VW" ("TYPE", "ISSUEABSTRACT", "ORA_CODE", "ISSUESTATUS", "CREATEDDATE", "PRODUCTTEAM", "SEVERITY", "ISSHOWSTOPPER", "CUSTEVENT_ISSUE_SHOWSTOPPER_SHOW", "TAGS", "ISSUE_NUMBER", "CLOSEDDATE", "URGENCY_LEVEL", "METADATA_DOWNLOADED_TIMESTAMP_UTC", "BASE_STATUS", "ASSIGNED_TO") DEFAULT COLLATION "USING_NLS_COMP"  AS 
  SELECT
    type,
    issueabstract,
    regexp_substr(issueabstract, 'ORA-\d+') AS ora_code,
    issuestatus,
    createddate,
    productteam,
    severity,
    isshowstopper,
    custevent_issue_showstopper_show,
    tags,
    "NUMBER"                                AS issue_number,
    closeddate,
    urgency_level,
    metadata_downloaded_timestamp_utc,
    base_status,
    assigned_to
FROM
    src_nlcorp_issue_migval_tb
;
