CREATE TABLE msc_bm_run_customer_sourcing (
    BM_RUN_ID            NUMBER       ,
    CUSTOMER_ID          NUMBER       ,
    CUSTOMER_SITE_ID     NUMBER       ,
    INVENTORY_ITEM_ID    NUMBER       ,
    DEMAND_CLASS         VARCHAR2(136),
    SOURCING_RULE_ID     NUMBER       ,
    LAST_UPDATE_LOGIN    VARCHAR2(128),
    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,
    BM_RUN_ID            NUMBER       ,
    CUSTOMER_ID          NUMBER       ,
    CUSTOMER_SITE_ID     NUMBER       ,
    INVENTORY_ITEM_ID    NUMBER       ,
    DEMAND_CLASS         VARCHAR2(136),
    SOURCING_RULE_ID     NUMBER       ,
    LAST_UPDATE_LOGIN    VARCHAR2(128),
    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,
    CONSTRAINT pk_msc_bm_run_customer_sourcing PRIMARY KEY (BM_RUN_ID, CUSTOMER_ID, CUSTOMER_SITE_ID, INVENTORY_ITEM_ID, DEMAND_CLASS, BM_RUN_ID, CUSTOMER_ID, CUSTOMER_SITE_ID, INVENTORY_ITEM_ID, DEMAND_CLASS)
);
