CREATE TABLE cst_rollup_report_keys (
    ROLLUP_REPORT_KEY_ID     NUMBER(18, 0),
    SCENARIO_ID              NUMBER(18, 0)    NOT NULL,
    ROLLUP_REPORT_ID         NUMBER(18, 0)    NOT NULL,
    BOM_LEVEL                NUMBER           NOT NULL,
    EFFECTIVE_START_DATE     DATE             NOT NULL,
    ROOT_ASSEMBLY_ITEM_ID    NUMBER       ,
    ROOT_ASSEMBLY_ORG_ID     NUMBER       ,
    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),
    ROLLUP_REPORT_KEY_ID     NUMBER(18, 0),
    SCENARIO_ID              NUMBER(18, 0)    NOT NULL,
    ROLLUP_REPORT_ID         NUMBER(18, 0)    NOT NULL,
    BOM_LEVEL                NUMBER           NOT NULL,
    EFFECTIVE_START_DATE     DATE             NOT NULL,
    ROOT_ASSEMBLY_ITEM_ID    NUMBER       ,
    ROOT_ASSEMBLY_ORG_ID     NUMBER       ,
    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),
    CONSTRAINT pk_cst_rollup_report_keys PRIMARY KEY (ROLLUP_REPORT_KEY_ID, ROLLUP_REPORT_KEY_ID)
);
