CREATE TABLE msc_bp_buyer_plans (
    BP_PLAN_ID                     NUMBER(18, 0),
    PLAN_ID                        NUMBER(18, 0)    NOT NULL,
    LAST_PLAN_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    PLAN_COMPLETION_DATE           TIMESTAMP(6) ,
    PLAN_LAST_RUN_END_DATE         TIMESTAMP(6) ,
    PLAN_HORIZON_START_DATE        DATE         ,
    PLAN_HORIZON_END_DATE          DATE         ,
    SR_INSTANCE_ID                 NUMBER(18, 0),
    INGESTION_COUNT                NUMBER(9, 0)     NOT NULL,
    INGESTION_AVG_TIME             NUMBER           NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)     NOT NULL,
    CREATED_BY                     VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128),
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)     NOT NULL,
    CHANGE_VERSION_INDICATOR       NUMBER(9, 0) ,
    BASIS_CURRENCY_CODE            VARCHAR2(120),
    BASIS_CONVERSION_TYPE          VARCHAR2(120),
    LAST_INV_ANALYSIS_CALC_DATE    TIMESTAMP(6) ,
    BP_PLAN_ID                     NUMBER(18, 0),
    PLAN_ID                        NUMBER(18, 0)    NOT NULL,
    LAST_PLAN_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    PLAN_COMPLETION_DATE           TIMESTAMP(6) ,
    PLAN_LAST_RUN_END_DATE         TIMESTAMP(6) ,
    PLAN_HORIZON_START_DATE        DATE         ,
    PLAN_HORIZON_END_DATE          DATE         ,
    SR_INSTANCE_ID                 NUMBER(18, 0),
    INGESTION_COUNT                NUMBER(9, 0)     NOT NULL,
    INGESTION_AVG_TIME             NUMBER           NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)     NOT NULL,
    CREATED_BY                     VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128),
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)     NOT NULL,
    CHANGE_VERSION_INDICATOR       NUMBER(9, 0) ,
    BASIS_CURRENCY_CODE            VARCHAR2(120),
    BASIS_CONVERSION_TYPE          VARCHAR2(120),
    LAST_INV_ANALYSIS_CALC_DATE    TIMESTAMP(6) ,
    CONSTRAINT pk_msc_bp_buyer_plans PRIMARY KEY (BP_PLAN_ID, BP_PLAN_ID)
);
