CREATE TABLE hz_locations_tmp (
    LOCATION_ID                     NUMBER(18, 0)     NOT NULL,
    TIMEZONE_CODE                   VARCHAR2(256) ,
    LAST_UPDATE_DATE                TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                 VARCHAR2(256)     NOT NULL,
    CREATION_DATE                   TIMESTAMP(6)      NOT NULL,
    CREATED_BY                      VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN               VARCHAR2(128) ,
    REQUEST_ID                      NUMBER(18, 0) ,
    JOB_DEFINITION_NAME             VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE          VARCHAR2(3600),
    ATTRIBUTE_CATEGORY              VARCHAR2(120) ,
    ATTRIBUTE1                      VARCHAR2(600) ,
    ATTRIBUTE2                      VARCHAR2(600) ,
    ATTRIBUTE3                      VARCHAR2(600) ,
    ATTRIBUTE4                      VARCHAR2(600) ,
    ATTRIBUTE5                      VARCHAR2(600) ,
    ATTRIBUTE6                      VARCHAR2(600) ,
    ATTRIBUTE7                      VARCHAR2(600) ,
    ATTRIBUTE8                      VARCHAR2(600) ,
    ATTRIBUTE9                      VARCHAR2(600) ,
    ATTRIBUTE10                     VARCHAR2(600) ,
    ATTRIBUTE11                     VARCHAR2(600) ,
    ATTRIBUTE12                     VARCHAR2(600) ,
    ATTRIBUTE13                     VARCHAR2(600) ,
    ATTRIBUTE14                     VARCHAR2(600) ,
    ATTRIBUTE15                     VARCHAR2(600) ,
    ATTRIBUTE16                     VARCHAR2(600) ,
    ATTRIBUTE17                     VARCHAR2(600) ,
    ATTRIBUTE18                     VARCHAR2(600) ,
    ATTRIBUTE19                     VARCHAR2(600) ,
    ATTRIBUTE20                     VARCHAR2(600) ,
    ORIG_SYSTEM_REFERENCE           VARCHAR2(960)     NOT NULL,
    COUNTRY                         VARCHAR2(8)   ,
    ADDRESS1                        VARCHAR2(960) ,
    ADDRESS2                        VARCHAR2(960) ,
    ADDRESS3                        VARCHAR2(960) ,
    ADDRESS4                        VARCHAR2(960) ,
    CITY                            VARCHAR2(240) ,
    POSTAL_CODE                     VARCHAR2(240) ,
    STATE                           VARCHAR2(240) ,
    PROVINCE                        VARCHAR2(240) ,
    COUNTY                          VARCHAR2(240) ,
    ADDRESS_STYLE                   VARCHAR2(120) ,
    ADDRESS_LINES_PHONETIC          VARCHAR2(2240),
    POSTAL_PLUS4_CODE               VARCHAR2(80)  ,
    POSITION                        VARCHAR2(200) ,
    LOCATION_DIRECTIONS             VARCHAR2(2560),
    ADDRESS_EFFECTIVE_DATE          DATE          ,
    ADDRESS_EXPIRATION_DATE         DATE          ,
    CLLI_CODE                       VARCHAR2(240) ,
    SHORT_DESCRIPTION               VARCHAR2(960) ,
    DESCRIPTION                     VARCHAR2(4000),
    VALIDATED_FLAG                  VARCHAR2(4)   ,
    SALES_TAX_GEOCODE               VARCHAR2(120) ,
    SALES_TAX_INSIDE_CITY_LIMITS    VARCHAR2(4)   ,
    FA_LOCATION_ID                  NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)      NOT NULL,
    CREATED_BY_MODULE               VARCHAR2(120) ,
    TIMEZONE_ID                     NUMBER        ,
    GEOMETRY_STATUS_CODE            VARCHAR2(120) ,
    ACTUAL_CONTENT_SOURCE           VARCHAR2(120) ,
    VALIDATION_STATUS_CODE          VARCHAR2(120) ,
    DATE_VALIDATED                  DATE          ,
    DO_NOT_VALIDATE_FLAG            VARCHAR2(4)   ,
    COMMENTS                        VARCHAR2(4000),
    CONFLICT_ID                     NUMBER(18, 0)     NOT NULL,
    USER_LAST_UPDATE_DATE           TIMESTAMP(6)  ,
    ATTRIBUTE21                     VARCHAR2(600) ,
    ATTRIBUTE22                     VARCHAR2(600) ,
    ATTRIBUTE23                     VARCHAR2(600) ,
    ATTRIBUTE24                     VARCHAR2(600) ,
    ATTRIBUTE25                     VARCHAR2(600) ,
    ATTRIBUTE26                     VARCHAR2(600) ,
    ATTRIBUTE27                     VARCHAR2(600) ,
    ATTRIBUTE28                     VARCHAR2(600) ,
    ATTRIBUTE29                     VARCHAR2(600) ,
    ATTRIBUTE30                     VARCHAR2(1020),
    HOUSE_TYPE                      VARCHAR2(120) ,
    CPDRF_VER_SOR                   NUMBER(9, 0)  ,
    CPDRF_VER_PILLAR                NUMBER(9, 0)  ,
    CPDRF_LAST_UPD                  VARCHAR2(60)  ,
    ATTRIBUTE_NUMBER1               NUMBER        ,
    ATTRIBUTE_NUMBER2               NUMBER        ,
    ATTRIBUTE_NUMBER3               NUMBER        ,
    ATTRIBUTE_NUMBER4               NUMBER        ,
    ATTRIBUTE_NUMBER5               NUMBER        ,
    ATTRIBUTE_NUMBER6               NUMBER        ,
    ATTRIBUTE_NUMBER7               NUMBER        ,
    ATTRIBUTE_NUMBER8               NUMBER        ,
    ATTRIBUTE_NUMBER9               NUMBER        ,
    ATTRIBUTE_NUMBER10              NUMBER        ,
    ATTRIBUTE_NUMBER11              NUMBER        ,
    ATTRIBUTE_NUMBER12              NUMBER        ,
    ATTRIBUTE_DATE1                 DATE          ,
    ATTRIBUTE_DATE2                 DATE          ,
    ATTRIBUTE_DATE3                 DATE          ,
    ATTRIBUTE_DATE4                 DATE          ,
    ATTRIBUTE_DATE5                 DATE          ,
    ATTRIBUTE_DATE6                 DATE          ,
    ATTRIBUTE_DATE7                 DATE          ,
    ATTRIBUTE_DATE8                 DATE          ,
    ATTRIBUTE_DATE9                 DATE          ,
    ATTRIBUTE_DATE10                DATE          ,
    ATTRIBUTE_DATE11                DATE          ,
    ATTRIBUTE_DATE12                DATE          ,
    LOCATION_LANGUAGE               VARCHAR2(16)  ,
    STATUS_FLAG                     VARCHAR2(4)       NOT NULL,
    BUILDING                        VARCHAR2(960) ,
    FLOOR_NUMBER                    VARCHAR2(160) ,
    ADDR_ELEMENT_ATTRIBUTE1         VARCHAR2(600) ,
    ADDR_ELEMENT_ATTRIBUTE2         VARCHAR2(600) ,
    ADDR_ELEMENT_ATTRIBUTE3         VARCHAR2(600) ,
    ADDR_ELEMENT_ATTRIBUTE4         VARCHAR2(600) ,
    ADDR_ELEMENT_ATTRIBUTE5         VARCHAR2(600) ,
    INTERNAL_FLAG                   VARCHAR2(4)   ,
    LONGITUDE                       NUMBER        ,
    LATITUDE                        NUMBER        ,
    PERSONAL_ADDRESS_FLAG           VARCHAR2(4)   ,
    LOCATION_ID                     NUMBER(18, 0)     NOT NULL,
    TIMEZONE_CODE                   VARCHAR2(256) ,
    LAST_UPDATE_DATE                TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                 VARCHAR2(256)     NOT NULL,
    CREATION_DATE                   TIMESTAMP(6)      NOT NULL,
    CREATED_BY                      VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN               VARCHAR2(128) ,
    REQUEST_ID                      NUMBER(18, 0) ,
    JOB_DEFINITION_NAME             VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE          VARCHAR2(3600),
    ATTRIBUTE_CATEGORY              VARCHAR2(120) ,
    ATTRIBUTE1                      VARCHAR2(600) ,
    ATTRIBUTE2                      VARCHAR2(600) ,
    ATTRIBUTE3                      VARCHAR2(600) ,
    ATTRIBUTE4                      VARCHAR2(600) ,
    ATTRIBUTE5                      VARCHAR2(600) ,
    ATTRIBUTE6                      VARCHAR2(600) ,
    ATTRIBUTE7                      VARCHAR2(600) ,
    ATTRIBUTE8                      VARCHAR2(600) ,
    ATTRIBUTE9                      VARCHAR2(600) ,
    ATTRIBUTE10                     VARCHAR2(600) ,
    ATTRIBUTE11                     VARCHAR2(600) ,
    ATTRIBUTE12                     VARCHAR2(600) ,
    ATTRIBUTE13                     VARCHAR2(600) ,
    ATTRIBUTE14                     VARCHAR2(600) ,
    ATTRIBUTE15                     VARCHAR2(600) ,
    ATTRIBUTE16                     VARCHAR2(600) ,
    ATTRIBUTE17                     VARCHAR2(600) ,
    ATTRIBUTE18                     VARCHAR2(600) ,
    ATTRIBUTE19                     VARCHAR2(600) ,
    ATTRIBUTE20                     VARCHAR2(600) ,
    ORIG_SYSTEM_REFERENCE           VARCHAR2(960)     NOT NULL,
    COUNTRY                         VARCHAR2(8)   ,
    ADDRESS1                        VARCHAR2(960) ,
    ADDRESS2                        VARCHAR2(960) ,
    ADDRESS3                        VARCHAR2(960) ,
    ADDRESS4                        VARCHAR2(960) ,
    CITY                            VARCHAR2(240) ,
    POSTAL_CODE                     VARCHAR2(240) ,
    STATE                           VARCHAR2(240) ,
    PROVINCE                        VARCHAR2(240) ,
    COUNTY                          VARCHAR2(240) ,
    ADDRESS_STYLE                   VARCHAR2(120) ,
    ADDRESS_LINES_PHONETIC          VARCHAR2(2240),
    POSTAL_PLUS4_CODE               VARCHAR2(80)  ,
    POSITION                        VARCHAR2(200) ,
    LOCATION_DIRECTIONS             VARCHAR2(2560),
    ADDRESS_EFFECTIVE_DATE          DATE          ,
    ADDRESS_EXPIRATION_DATE         DATE          ,
    CLLI_CODE                       VARCHAR2(240) ,
    SHORT_DESCRIPTION               VARCHAR2(960) ,
    DESCRIPTION                     VARCHAR2(4000),
    VALIDATED_FLAG                  VARCHAR2(4)   ,
    SALES_TAX_GEOCODE               VARCHAR2(120) ,
    SALES_TAX_INSIDE_CITY_LIMITS    VARCHAR2(4)   ,
    FA_LOCATION_ID                  NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)      NOT NULL,
    CREATED_BY_MODULE               VARCHAR2(120) ,
    TIMEZONE_ID                     NUMBER        ,
    GEOMETRY_STATUS_CODE            VARCHAR2(120) ,
    ACTUAL_CONTENT_SOURCE           VARCHAR2(120) ,
    VALIDATION_STATUS_CODE          VARCHAR2(120) ,
    DATE_VALIDATED                  DATE          ,
    DO_NOT_VALIDATE_FLAG            VARCHAR2(4)   ,
    COMMENTS                        VARCHAR2(4000),
    CONFLICT_ID                     NUMBER(18, 0)     NOT NULL,
    USER_LAST_UPDATE_DATE           TIMESTAMP(6)  ,
    ATTRIBUTE21                     VARCHAR2(600) ,
    ATTRIBUTE22                     VARCHAR2(600) ,
    ATTRIBUTE23                     VARCHAR2(600) ,
    ATTRIBUTE24                     VARCHAR2(600) ,
    ATTRIBUTE25                     VARCHAR2(600) ,
    ATTRIBUTE26                     VARCHAR2(600) ,
    ATTRIBUTE27                     VARCHAR2(600) ,
    ATTRIBUTE28                     VARCHAR2(600) ,
    ATTRIBUTE29                     VARCHAR2(600) ,
    ATTRIBUTE30                     VARCHAR2(1020),
    HOUSE_TYPE                      VARCHAR2(120) ,
    CPDRF_VER_SOR                   NUMBER(9, 0)  ,
    CPDRF_VER_PILLAR                NUMBER(9, 0)  ,
    CPDRF_LAST_UPD                  VARCHAR2(60)  ,
    ATTRIBUTE_NUMBER1               NUMBER        ,
    ATTRIBUTE_NUMBER2               NUMBER        ,
    ATTRIBUTE_NUMBER3               NUMBER        ,
    ATTRIBUTE_NUMBER4               NUMBER        ,
    ATTRIBUTE_NUMBER5               NUMBER        ,
    ATTRIBUTE_NUMBER6               NUMBER        ,
    ATTRIBUTE_NUMBER7               NUMBER        ,
    ATTRIBUTE_NUMBER8               NUMBER        ,
    ATTRIBUTE_NUMBER9               NUMBER        ,
    ATTRIBUTE_NUMBER10              NUMBER        ,
    ATTRIBUTE_NUMBER11              NUMBER        ,
    ATTRIBUTE_NUMBER12              NUMBER        ,
    ATTRIBUTE_DATE1                 DATE          ,
    ATTRIBUTE_DATE2                 DATE          ,
    ATTRIBUTE_DATE3                 DATE          ,
    ATTRIBUTE_DATE4                 DATE          ,
    ATTRIBUTE_DATE5                 DATE          ,
    ATTRIBUTE_DATE6                 DATE          ,
    ATTRIBUTE_DATE7                 DATE          ,
    ATTRIBUTE_DATE8                 DATE          ,
    ATTRIBUTE_DATE9                 DATE          ,
    ATTRIBUTE_DATE10                DATE          ,
    ATTRIBUTE_DATE11                DATE          ,
    ATTRIBUTE_DATE12                DATE          ,
    LOCATION_LANGUAGE               VARCHAR2(16)  ,
    STATUS_FLAG                     VARCHAR2(4)       NOT NULL,
    BUILDING                        VARCHAR2(960) ,
    FLOOR_NUMBER                    VARCHAR2(160) ,
    ADDR_ELEMENT_ATTRIBUTE1         VARCHAR2(600) ,
    ADDR_ELEMENT_ATTRIBUTE2         VARCHAR2(600) ,
    ADDR_ELEMENT_ATTRIBUTE3         VARCHAR2(600) ,
    ADDR_ELEMENT_ATTRIBUTE4         VARCHAR2(600) ,
    ADDR_ELEMENT_ATTRIBUTE5         VARCHAR2(600) ,
    INTERNAL_FLAG                   VARCHAR2(4)   ,
    LONGITUDE                       NUMBER        ,
    LATITUDE                        NUMBER        ,
    PERSONAL_ADDRESS_FLAG           VARCHAR2(4)   
);
