CREATE TABLE cst_scenarios (
    SCENARIO_ID                   NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER         NUMBER(9, 0)      NOT NULL,
    SCENARIO_NUMBER               VARCHAR2(120)     NOT NULL,
    COST_ORG_ID                   NUMBER(18, 0)     NOT NULL,
    COST_BOOK_ID                  NUMBER(18, 0)     NOT NULL,
    EFFECTIVE_START_DATE          DATE              NOT NULL,
    PERIOD_NAME                   VARCHAR2(60)  ,
    SCENARIO_TYPE                 VARCHAR2(120)     NOT NULL,
    STATE_CODE                    VARCHAR2(120)     NOT NULL,
    STATUS_CODE                   VARCHAR2(120)     NOT NULL,
    ROLLUP_SCOPE                  VARCHAR2(120) ,
    COMMENTS                      VARCHAR2(4000),
    REASON_CODE                   VARCHAR2(120) ,
    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) ,
    REQUEST_ID                    NUMBER(18, 0) ,
    JOB_DEFINITION_NAME           VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE        VARCHAR2(3600),
    ATTRIBUTE_CATEGORY            VARCHAR2(120) ,
    ATTRIBUTE_CHAR1               VARCHAR2(600) ,
    ATTRIBUTE_CHAR2               VARCHAR2(600) ,
    ATTRIBUTE_CHAR3               VARCHAR2(600) ,
    ATTRIBUTE_CHAR4               VARCHAR2(600) ,
    ATTRIBUTE_CHAR5               VARCHAR2(600) ,
    ATTRIBUTE_CHAR6               VARCHAR2(600) ,
    ATTRIBUTE_CHAR7               VARCHAR2(600) ,
    ATTRIBUTE_CHAR8               VARCHAR2(600) ,
    ATTRIBUTE_CHAR9               VARCHAR2(600) ,
    ATTRIBUTE_CHAR10              VARCHAR2(600) ,
    ATTRIBUTE_CHAR11              VARCHAR2(600) ,
    ATTRIBUTE_CHAR12              VARCHAR2(600) ,
    ATTRIBUTE_CHAR13              VARCHAR2(600) ,
    ATTRIBUTE_CHAR14              VARCHAR2(600) ,
    ATTRIBUTE_CHAR15              VARCHAR2(600) ,
    ATTRIBUTE_CHAR16              VARCHAR2(600) ,
    ATTRIBUTE_CHAR17              VARCHAR2(600) ,
    ATTRIBUTE_CHAR18              VARCHAR2(600) ,
    ATTRIBUTE_CHAR19              VARCHAR2(600) ,
    ATTRIBUTE_CHAR20              VARCHAR2(600) ,
    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_DATE1               DATE          ,
    ATTRIBUTE_DATE2               DATE          ,
    ATTRIBUTE_DATE3               DATE          ,
    ATTRIBUTE_DATE4               DATE          ,
    ATTRIBUTE_DATE5               DATE          ,
    ATTRIBUTE_TIMESTAMP1          TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP2          TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP3          TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP4          TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP5          TIMESTAMP(6)  ,
    PLANNING_COST_ORG_ID          NUMBER(18, 0) ,
    INV_ORG_ID                    NUMBER(18, 0) ,
    SCENARIO_VERSION_NUMBER       VARCHAR2(120) ,
    SCENARIO_HEADER_ID            NUMBER(18, 0) ,
    PURPOSE_CODE                  VARCHAR2(120) ,
    CURRENCY_CODE                 VARCHAR2(60)  ,
    CURRENCY_CONVERSION_TYPE      VARCHAR2(120) ,
    PUBLISH_TO_ACCOUNTING_FLAG    VARCHAR2(4)   ,
    EFFECTIVE_END_DATE            DATE          ,
    SCENARIO_VERSION_TYPE         VARCHAR2(120) ,
    CONFIGURED_ENABLED            VARCHAR2(4)   ,
    CONFIGURED_FROM_DATE          DATE          ,
    PLANNING_MODE                 VARCHAR2(120)     NOT NULL,
    PREVIOUS_SCENARIO_ID          NUMBER(18, 0) ,
    SUPPLY_CHAIN_ROLLUP_FLAG      VARCHAR2(4)       NOT NULL,
    ROLLUP_GROUP_ID               NUMBER(18, 0) ,
    ASSIGNMENT_SET_ID             NUMBER(18, 0) ,
    TRANSFER_COST_RULE_SET_ID     NUMBER(18, 0) ,
    ORGANIZATION_CONTEXT          VARCHAR2(120) ,
    ROLLUP_RESULTS_CACHED_FLAG    VARCHAR2(4)   ,
    ROLLUP_RESULTS                CLOB          ,
    SCENARIO_ID                   NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER         NUMBER(9, 0)      NOT NULL,
    PLANNING_COST_ORG_ID          NUMBER(18, 0) ,
    INV_ORG_ID                    NUMBER(18, 0) ,
    SCENARIO_NUMBER               VARCHAR2(120)     NOT NULL,
    SCENARIO_VERSION_NUMBER       VARCHAR2(120) ,
    SCENARIO_HEADER_ID            NUMBER(18, 0) ,
    SCENARIO_TYPE                 VARCHAR2(120)     NOT NULL,
    COMMENTS                      VARCHAR2(4000),
    PURPOSE_CODE                  VARCHAR2(120) ,
    CURRENCY_CODE                 VARCHAR2(60)  ,
    CURRENCY_CONVERSION_TYPE      VARCHAR2(120) ,
    PUBLISH_TO_ACCOUNTING_FLAG    VARCHAR2(4)   ,
    COST_ORG_ID                   NUMBER(18, 0)     NOT NULL,
    EFFECTIVE_END_DATE            DATE          ,
    EFFECTIVE_START_DATE          DATE              NOT NULL,
    STATUS_CODE                   VARCHAR2(120)     NOT NULL,
    SCENARIO_VERSION_TYPE         VARCHAR2(120) ,
    CONFIGURED_ENABLED            VARCHAR2(4)   ,
    CONFIGURED_FROM_DATE          DATE          ,
    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) ,
    REQUEST_ID                    NUMBER(18, 0) ,
    JOB_DEFINITION_NAME           VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE        VARCHAR2(3600),
    ATTRIBUTE_CATEGORY            VARCHAR2(120) ,
    ATTRIBUTE_CHAR1               VARCHAR2(600) ,
    ATTRIBUTE_CHAR2               VARCHAR2(600) ,
    ATTRIBUTE_CHAR3               VARCHAR2(600) ,
    ATTRIBUTE_CHAR4               VARCHAR2(600) ,
    ATTRIBUTE_CHAR5               VARCHAR2(600) ,
    ATTRIBUTE_CHAR6               VARCHAR2(600) ,
    ATTRIBUTE_CHAR7               VARCHAR2(600) ,
    ATTRIBUTE_CHAR8               VARCHAR2(600) ,
    ATTRIBUTE_CHAR9               VARCHAR2(600) ,
    ATTRIBUTE_CHAR10              VARCHAR2(600) ,
    ATTRIBUTE_CHAR11              VARCHAR2(600) ,
    ATTRIBUTE_CHAR12              VARCHAR2(600) ,
    ATTRIBUTE_CHAR13              VARCHAR2(600) ,
    ATTRIBUTE_CHAR14              VARCHAR2(600) ,
    ATTRIBUTE_CHAR15              VARCHAR2(600) ,
    ATTRIBUTE_CHAR16              VARCHAR2(600) ,
    ATTRIBUTE_CHAR17              VARCHAR2(600) ,
    ATTRIBUTE_CHAR18              VARCHAR2(600) ,
    ATTRIBUTE_CHAR19              VARCHAR2(600) ,
    ATTRIBUTE_CHAR20              VARCHAR2(600) ,
    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_DATE1               DATE          ,
    ATTRIBUTE_DATE2               DATE          ,
    ATTRIBUTE_DATE3               DATE          ,
    ATTRIBUTE_DATE4               DATE          ,
    ATTRIBUTE_DATE5               DATE          ,
    ATTRIBUTE_TIMESTAMP1          TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP2          TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP3          TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP4          TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP5          TIMESTAMP(6)  ,
    COST_BOOK_ID                  NUMBER(18, 0)     NOT NULL,
    STATE_CODE                    VARCHAR2(120)     NOT NULL,
    PLANNING_MODE                 VARCHAR2(120)     NOT NULL,
    PREVIOUS_SCENARIO_ID          NUMBER(18, 0) ,
    REASON_CODE                   VARCHAR2(120) ,
    ROLLUP_SCOPE                  VARCHAR2(120) ,
    PERIOD_NAME                   VARCHAR2(60)  ,
    SUPPLY_CHAIN_ROLLUP_FLAG      VARCHAR2(4)       NOT NULL,
    ROLLUP_GROUP_ID               NUMBER(18, 0) ,
    ASSIGNMENT_SET_ID             NUMBER(18, 0) ,
    TRANSFER_COST_RULE_SET_ID     NUMBER(18, 0) ,
    ORGANIZATION_CONTEXT          VARCHAR2(120) ,
    ROLLUP_RESULTS_CACHED_FLAG    VARCHAR2(4)   ,
    ROLLUP_RESULTS                CLOB          ,
    CONSTRAINT pk_cst_scenarios PRIMARY KEY (SCENARIO_ID, SCENARIO_ID)
);
