CREATE TABLE inv_abc_compile_headers (
    COMPILE_ID                NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    COMPILE_NAME              VARCHAR2(160)     NOT NULL,
    ORGANIZATION_ID           NUMBER(18, 0)     NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    COMPILE_TYPE              VARCHAR2(120)     NOT NULL,
    COMPILE_STATUS            VARCHAR2(120)     NOT NULL,
    SECONDARY_INVENTORY       VARCHAR2(40)  ,
    ITEM_SCOPE_CODE           VARCHAR2(120) ,
    DESCRIPTION               VARCHAR2(200) ,
    COMPILE_ITEMS             NUMBER(18, 0) ,
    COMPILE_DATE              DATE          ,
    COST_TYPE                 NUMBER        ,
    CUMULATIVE_QUANTITY       NUMBER        ,
    CUMULATIVE_VALUE          NUMBER        ,
    SCHEDULE_DESIGNATOR       VARCHAR2(40)  ,
    MRP_PLAN_NAME             VARCHAR2(40)  ,
    START_DATE                DATE          ,
    CUTOFF_DATE               DATE          ,
    ATTRIBUTE_CATEGORY        VARCHAR2(120) ,
    ATTRIBUTE1                VARCHAR2(600) ,
    ATTRIBUTE2                VARCHAR2(600) ,
    ATTRIBUTE3                VARCHAR2(600) ,
    ATTRIBUTE4                VARCHAR2(600) ,
    ATTRIBUTE5                VARCHAR2(600) ,
    ATTRIBUTE6                VARCHAR2(600) ,
    ATTRIBUTE7                VARCHAR2(600) ,
    ATTRIBUTE8                VARCHAR2(600) ,
    ATTRIBUTE9                VARCHAR2(600) ,
    ATTRIBUTE10               VARCHAR2(600) ,
    ATTRIBUTE11               VARCHAR2(600) ,
    ATTRIBUTE12               VARCHAR2(600) ,
    ATTRIBUTE13               VARCHAR2(600) ,
    ATTRIBUTE14               VARCHAR2(600) ,
    ATTRIBUTE15               VARCHAR2(600) ,
    REQUEST_ID                NUMBER(18, 0) ,
    JOB_DEFINITION_NAME       VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE    VARCHAR2(3600),
    MRP_FORECAST_NAME         VARCHAR2(40)  ,
    COMPILE_ID                NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    COMPILE_NAME              VARCHAR2(160)     NOT NULL,
    ORGANIZATION_ID           NUMBER(18, 0)     NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    COMPILE_TYPE              VARCHAR2(120)     NOT NULL,
    COMPILE_STATUS            VARCHAR2(120)     NOT NULL,
    SECONDARY_INVENTORY       VARCHAR2(40)  ,
    ITEM_SCOPE_CODE           VARCHAR2(120) ,
    DESCRIPTION               VARCHAR2(200) ,
    COMPILE_ITEMS             NUMBER(18, 0) ,
    COMPILE_DATE              DATE          ,
    COST_TYPE                 NUMBER        ,
    CUMULATIVE_QUANTITY       NUMBER        ,
    CUMULATIVE_VALUE          NUMBER        ,
    SCHEDULE_DESIGNATOR       VARCHAR2(40)  ,
    MRP_PLAN_NAME             VARCHAR2(40)  ,
    START_DATE                DATE          ,
    CUTOFF_DATE               DATE          ,
    ATTRIBUTE_CATEGORY        VARCHAR2(120) ,
    ATTRIBUTE1                VARCHAR2(600) ,
    ATTRIBUTE2                VARCHAR2(600) ,
    ATTRIBUTE3                VARCHAR2(600) ,
    ATTRIBUTE4                VARCHAR2(600) ,
    ATTRIBUTE5                VARCHAR2(600) ,
    ATTRIBUTE6                VARCHAR2(600) ,
    ATTRIBUTE7                VARCHAR2(600) ,
    ATTRIBUTE8                VARCHAR2(600) ,
    ATTRIBUTE9                VARCHAR2(600) ,
    ATTRIBUTE10               VARCHAR2(600) ,
    ATTRIBUTE11               VARCHAR2(600) ,
    ATTRIBUTE12               VARCHAR2(600) ,
    ATTRIBUTE13               VARCHAR2(600) ,
    ATTRIBUTE14               VARCHAR2(600) ,
    ATTRIBUTE15               VARCHAR2(600) ,
    REQUEST_ID                NUMBER(18, 0) ,
    JOB_DEFINITION_NAME       VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE    VARCHAR2(3600),
    MRP_FORECAST_NAME         VARCHAR2(40)  ,
    CONSTRAINT pk_inv_abc_compile_headers PRIMARY KEY (COMPILE_ID, COMPILE_ID)
);
