CREATE TABLE gtg_hns_inspections_ (
    INSPECTION_ID                NUMBER(18, 0) ,
    INSPECTION_NO                VARCHAR2(80)  ,
    ITEM_IDENTIFICATION_CODE     VARCHAR2(400) ,
    STATUS                       VARCHAR2(80)  ,
    TARGET_COMPLETION_DATE       TIMESTAMP(6)  ,
    TYPE                         VARCHAR2(400) ,
    SUB_TYPE                     VARCHAR2(400) ,
    SUMMARY                      VARCHAR2(4000),
    START_TIME                   TIMESTAMP(6)  ,
    COMPLETED_TIME               TIMESTAMP(6)  ,
    CASUAL_FACTORS_CODE          VARCHAR2(4000),
    CONTRIBUTING_FACTORS_CODE    VARCHAR2(4000),
    UNDERLYING_FACTORS_CODE      VARCHAR2(4000),
    IMMEDIATE_CAUSE_CODE         VARCHAR2(4000),
    ROOT_CAUSE_CODE              VARCHAR2(4000),
    FINDING_COMMENT              VARCHAR2(400) ,
    FINDING_FINAL_RESPONSE       VARCHAR2(400) ,
    DELETED_FLAG                 VARCHAR2(4)   ,
    OWNER                        NUMBER(18, 0) ,
    IS_ACTION_REQUIRED           VARCHAR2(4)   ,
    IS_COMPLETED                 VARCHAR2(4)   ,
    CREATED_BY                   VARCHAR2(256) ,
    CREATION_DATE                TIMESTAMP(6)  ,
    LAST_UPDATED_BY              VARCHAR2(256) ,
    LAST_UPDATE_DATE             TIMESTAMP(6)  ,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    ATTRIBUTE_CATEGORY           VARCHAR2(120) ,
    ATTRIBUTE1                   VARCHAR2(600) ,
    ATTRIBUTE2                   VARCHAR2(600) ,
    ATTRIBUTE3                   VARCHAR2(600) ,
    ATTRIBUTE4                   VARCHAR2(600) ,
    ATTRIBUTE5                   VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1            NUMBER        ,
    ATTRIBUTE_NUMBER2            NUMBER        ,
    ATTRIBUTE_NUMBER3            NUMBER        ,
    ATTRIBUTE_TIMESTAMP1         TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP2         TIMESTAMP(6)  ,
    OWNER_NAME                   VARCHAR2(960) ,
    AUDIT_ACTION_TYPE_           VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_        VARCHAR2(4000),
    AUDIT_IMPERSONATOR_          VARCHAR2(256) ,
    INSPECTION_ID                NUMBER(18, 0) ,
    INSPECTION_NO                VARCHAR2(80)  ,
    ITEM_IDENTIFICATION_CODE     VARCHAR2(400) ,
    STATUS                       VARCHAR2(80)  ,
    TARGET_COMPLETION_DATE       TIMESTAMP(6)  ,
    TYPE                         VARCHAR2(400) ,
    SUB_TYPE                     VARCHAR2(400) ,
    SUMMARY                      VARCHAR2(4000),
    START_TIME                   TIMESTAMP(6)  ,
    COMPLETED_TIME               TIMESTAMP(6)  ,
    CASUAL_FACTORS_CODE          VARCHAR2(4000),
    CONTRIBUTING_FACTORS_CODE    VARCHAR2(4000),
    UNDERLYING_FACTORS_CODE      VARCHAR2(4000),
    IMMEDIATE_CAUSE_CODE         VARCHAR2(4000),
    ROOT_CAUSE_CODE              VARCHAR2(4000),
    FINDING_COMMENT              VARCHAR2(400) ,
    FINDING_FINAL_RESPONSE       VARCHAR2(400) ,
    DELETED_FLAG                 VARCHAR2(4)   ,
    OWNER                        NUMBER(18, 0) ,
    IS_ACTION_REQUIRED           VARCHAR2(4)   ,
    IS_COMPLETED                 VARCHAR2(4)   ,
    CREATED_BY                   VARCHAR2(256) ,
    CREATION_DATE                TIMESTAMP(6)  ,
    LAST_UPDATED_BY              VARCHAR2(256) ,
    LAST_UPDATE_DATE             TIMESTAMP(6)  ,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    ATTRIBUTE_CATEGORY           VARCHAR2(120) ,
    ATTRIBUTE1                   VARCHAR2(600) ,
    ATTRIBUTE2                   VARCHAR2(600) ,
    ATTRIBUTE3                   VARCHAR2(600) ,
    ATTRIBUTE4                   VARCHAR2(600) ,
    ATTRIBUTE5                   VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1            NUMBER        ,
    ATTRIBUTE_NUMBER2            NUMBER        ,
    ATTRIBUTE_NUMBER3            NUMBER        ,
    ATTRIBUTE_TIMESTAMP1         TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP2         TIMESTAMP(6)  ,
    AUDIT_ACTION_TYPE_           VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_        VARCHAR2(4000),
    AUDIT_IMPERSONATOR_          VARCHAR2(256) ,
    OWNER_NAME                   VARCHAR2(960) ,
    CONSTRAINT pk_gtg_hns_inspections_ PRIMARY KEY (INSPECTION_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE, INSPECTION_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE)
);
