CREATE TABLE aca_pd_item_cost (
    ITEM_COST_ID              NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    INVENTORY_ITEM_ID         NUMBER(18, 0)     NOT NULL,
    ORGANIZATION_ID           NUMBER(18, 0)     NOT NULL,
    IS_LEAF                   NUMBER(1, 0)      NOT NULL,
    FROM_REVISION             VARCHAR2(72)      NOT NULL,
    TO_REVISION               VARCHAR2(72)  ,
    LAST_COST_EXTRACT_DATE    TIMESTAMP(6)  ,
    LAST_ROLLUP_DATE          TIMESTAMP(6)  ,
    COST_SOURCE               VARCHAR2(4)       NOT NULL,
    INVENTORY_ORG_ID          NUMBER(18, 0) ,
    CURRENCY_CODE             VARCHAR2(60)  ,
    MATERIAL_COST             NUMBER        ,
    OVERHEAD_COST             NUMBER        ,
    ROLLUP_MATERIAL_COST      NUMBER        ,
    ROLLUP_OVERHEAD_COST      NUMBER        ,
    INCOMPLETE_COST_CNT       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) ,
    REQUEST_ID                NUMBER(18, 0) ,
    JOB_DEFINITION_NAME       VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE    VARCHAR2(3600),
    LAST_CONTRACT_PRICE       NUMBER        ,
    ITEM_COST_ID              NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    INVENTORY_ITEM_ID         NUMBER(18, 0)     NOT NULL,
    ORGANIZATION_ID           NUMBER(18, 0)     NOT NULL,
    IS_LEAF                   NUMBER(1, 0)      NOT NULL,
    FROM_REVISION             VARCHAR2(72)      NOT NULL,
    TO_REVISION               VARCHAR2(72)  ,
    LAST_COST_EXTRACT_DATE    TIMESTAMP(6)  ,
    LAST_ROLLUP_DATE          TIMESTAMP(6)  ,
    COST_SOURCE               VARCHAR2(4)       NOT NULL,
    INVENTORY_ORG_ID          NUMBER(18, 0) ,
    CURRENCY_CODE             VARCHAR2(60)  ,
    MATERIAL_COST             NUMBER        ,
    OVERHEAD_COST             NUMBER        ,
    ROLLUP_MATERIAL_COST      NUMBER        ,
    ROLLUP_OVERHEAD_COST      NUMBER        ,
    INCOMPLETE_COST_CNT       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) ,
    REQUEST_ID                NUMBER(18, 0) ,
    JOB_DEFINITION_NAME       VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE    VARCHAR2(3600),
    LAST_CONTRACT_PRICE       NUMBER        ,
    CONSTRAINT pk_aca_pd_item_cost PRIMARY KEY (ITEM_COST_ID, ITEM_COST_ID)
);
