CREATE TABLE doo_orchestration_applications (
    ORCHESTRATION_APPLICATION_ID      NUMBER(18, 0) ,
    APPLICATION_ID                    NUMBER(18, 0)     NOT NULL,
    ORCHESTRATION_APPLICATION_CODE    VARCHAR2(120)     NOT NULL,
    APPLICATION_MODULE_NAME           VARCHAR2(400) ,
    APPLICATION_MODULE_CONFIG         VARCHAR2(1000)    NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)      NOT NULL,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    RULE_DICTIONARY_PACKAGE_NAME      VARCHAR2(1000),
    RULE_DICTIONARY_NAME              VARCHAR2(400) ,
    STATUS_ENABLED_FLAG               VARCHAR2(4)   ,
    HOLDS_ENABLED_FLAG                VARCHAR2(4)   ,
    CONSTRAINTS_ENABLED_FLAG          VARCHAR2(4)   ,
    CHANGE_ENABLED_FLAG               VARCHAR2(4)   ,
    PLANNING_ENABLED_FLAG             VARCHAR2(4)   ,
    MESSAGE_ENABLED_FLAG              VARCHAR2(4)   ,
    SEED_DATA_SOURCE                  VARCHAR2(2048),
    ORA_SEED_SET1                     VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2                     VARCHAR2(4)       NOT NULL,
    ORCHESTRATION_APPLICATION_ID      NUMBER(18, 0) ,
    APPLICATION_ID                    NUMBER(18, 0)     NOT NULL,
    ORCHESTRATION_APPLICATION_CODE    VARCHAR2(120)     NOT NULL,
    APPLICATION_MODULE_NAME           VARCHAR2(400) ,
    APPLICATION_MODULE_CONFIG         VARCHAR2(1000)    NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)      NOT NULL,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    RULE_DICTIONARY_PACKAGE_NAME      VARCHAR2(1000),
    RULE_DICTIONARY_NAME              VARCHAR2(400) ,
    STATUS_ENABLED_FLAG               VARCHAR2(4)   ,
    HOLDS_ENABLED_FLAG                VARCHAR2(4)   ,
    CONSTRAINTS_ENABLED_FLAG          VARCHAR2(4)   ,
    CHANGE_ENABLED_FLAG               VARCHAR2(4)   ,
    PLANNING_ENABLED_FLAG             VARCHAR2(4)   ,
    MESSAGE_ENABLED_FLAG              VARCHAR2(4)   ,
    SEED_DATA_SOURCE                  VARCHAR2(2048),
    ORA_SEED_SET1                     VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2                     VARCHAR2(4)       NOT NULL,
    CONSTRAINT pk_doo_orchestration_applications PRIMARY KEY (ORCHESTRATION_APPLICATION_ID, ORCHESTRATION_APPLICATION_ID)
);
