CREATE TABLE fnd_tree_node (
    ENTERPRISE_ID                NUMBER(18, 0) ,
    TREE_STRUCTURE_CODE          VARCHAR2(120) ,
    TREE_CODE                    VARCHAR2(120) ,
    TREE_VERSION_ID              VARCHAR2(128) ,
    TREE_NODE_ID                 VARCHAR2(128) ,
    PARENT_TREE_NODE_ID          VARCHAR2(128) ,
    DATA_SOURCE_ID               VARCHAR2(128) ,
    PK1_START_VALUE              VARCHAR2(400) ,
    PK2_START_VALUE              VARCHAR2(400) ,
    PK3_START_VALUE              VARCHAR2(400) ,
    PK4_START_VALUE              VARCHAR2(400) ,
    PK5_START_VALUE              VARCHAR2(400) ,
    PK1_END_VALUE                VARCHAR2(400) ,
    PK2_END_VALUE                VARCHAR2(400) ,
    PK3_END_VALUE                VARCHAR2(400) ,
    PK4_END_VALUE                VARCHAR2(400) ,
    PK5_END_VALUE                VARCHAR2(400) ,
    REFERENCE_TREE_CODE          VARCHAR2(120) ,
    REFERENCE_TREE_VERSION_ID    VARCHAR2(128) ,
    TREE_LABEL_ID                VARCHAR2(128) ,
    PARENT_DATA_SOURCE_ID        VARCHAR2(128) ,
    PARENT_PK1_VALUE             VARCHAR2(400) ,
    PARENT_PK2_VALUE             VARCHAR2(400) ,
    PARENT_PK3_VALUE             VARCHAR2(400) ,
    PARENT_PK4_VALUE             VARCHAR2(400) ,
    PARENT_PK5_VALUE             VARCHAR2(400) ,
    PARENT_TREE_LABEL_ID         VARCHAR2(128) ,
    SORT_ORDER                   NUMBER(18, 0) ,
    DEPTH                        NUMBER(18, 0)     NOT NULL,
    CHILD_COUNT                  NUMBER(18, 0)     NOT NULL,
    CREATED_BY                   VARCHAR2(256)     NOT NULL,
    CREATION_DATE                TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    SEED_DATA_SOURCE             VARCHAR2(2048),
    ORA_SEED_SET1                VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2                VARCHAR2(4)       NOT NULL,
    ENTERPRISE_ID                NUMBER(18, 0) ,
    TREE_STRUCTURE_CODE          VARCHAR2(120) ,
    TREE_CODE                    VARCHAR2(120) ,
    TREE_VERSION_ID              VARCHAR2(128) ,
    TREE_NODE_ID                 VARCHAR2(128) ,
    PARENT_TREE_NODE_ID          VARCHAR2(128) ,
    DATA_SOURCE_ID               VARCHAR2(128) ,
    PK1_START_VALUE              VARCHAR2(400) ,
    PK2_START_VALUE              VARCHAR2(400) ,
    PK3_START_VALUE              VARCHAR2(400) ,
    PK4_START_VALUE              VARCHAR2(400) ,
    PK5_START_VALUE              VARCHAR2(400) ,
    PK1_END_VALUE                VARCHAR2(400) ,
    PK2_END_VALUE                VARCHAR2(400) ,
    PK3_END_VALUE                VARCHAR2(400) ,
    PK4_END_VALUE                VARCHAR2(400) ,
    PK5_END_VALUE                VARCHAR2(400) ,
    REFERENCE_TREE_CODE          VARCHAR2(120) ,
    REFERENCE_TREE_VERSION_ID    VARCHAR2(128) ,
    TREE_LABEL_ID                VARCHAR2(128) ,
    PARENT_DATA_SOURCE_ID        VARCHAR2(128) ,
    PARENT_PK1_VALUE             VARCHAR2(400) ,
    PARENT_PK2_VALUE             VARCHAR2(400) ,
    PARENT_PK3_VALUE             VARCHAR2(400) ,
    PARENT_PK4_VALUE             VARCHAR2(400) ,
    PARENT_PK5_VALUE             VARCHAR2(400) ,
    PARENT_TREE_LABEL_ID         VARCHAR2(128) ,
    SORT_ORDER                   NUMBER(18, 0) ,
    DEPTH                        NUMBER(18, 0)     NOT NULL,
    CHILD_COUNT                  NUMBER(18, 0)     NOT NULL,
    CREATED_BY                   VARCHAR2(256)     NOT NULL,
    CREATION_DATE                TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    SEED_DATA_SOURCE             VARCHAR2(2048),
    ORA_SEED_SET1                VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2                VARCHAR2(4)       NOT NULL,
    CONSTRAINT pk_fnd_tree_node PRIMARY KEY (ENTERPRISE_ID, TREE_STRUCTURE_CODE, TREE_CODE, TREE_VERSION_ID, TREE_NODE_ID, ENTERPRISE_ID, TREE_STRUCTURE_CODE, TREE_CODE, TREE_VERSION_ID, TREE_NODE_ID)
);
