CREATE TABLE msc_apa_prod_plan_pub_dets (
    PRODUCTION_PLAN_ID        NUMBER(18, 0) ,
    SEGMENT_ID                NUMBER(18, 0) ,
    PUBLISH_RANGE_START       NUMBER        ,
    PUBLISH_RANGE_END         NUMBER        ,
    PUBLISH_STATUS            NUMBER(2, 0)  ,
    PUBLISH_STATUS_MESSAGE    VARCHAR2(1024),
    PUBLISH_REQUEST_ID        NUMBER(18, 0) ,
    PUBLISH_PAYLOAD           CLOB          ,
    SOURCE_PLAN_ID            NUMBER(18, 0) ,
    PUBLISHED_BY              VARCHAR2(256) ,
    PUBLISHED_DATE            TIMESTAMP(6)  ,
    ACCEPTED_BY               VARCHAR2(256) ,
    ACCEPTED_DATE             TIMESTAMP(6)  ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    PRODUCTION_PLAN_ID        NUMBER(18, 0) ,
    SEGMENT_ID                NUMBER(18, 0) ,
    PUBLISH_RANGE_START       NUMBER        ,
    PUBLISH_RANGE_END         NUMBER        ,
    PUBLISH_STATUS            NUMBER(2, 0)  ,
    PUBLISH_STATUS_MESSAGE    VARCHAR2(1024),
    PUBLISH_REQUEST_ID        NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    PUBLISH_PAYLOAD           CLOB          ,
    SOURCE_PLAN_ID            NUMBER(18, 0) ,
    PUBLISHED_BY              VARCHAR2(256) ,
    PUBLISHED_DATE            TIMESTAMP(6)  ,
    ACCEPTED_BY               VARCHAR2(256) ,
    ACCEPTED_DATE             TIMESTAMP(6)  ,
    CONSTRAINT pk_msc_apa_prod_plan_pub_dets PRIMARY KEY (PRODUCTION_PLAN_ID, SEGMENT_ID, PRODUCTION_PLAN_ID, SEGMENT_ID)
);
