CREATE TABLE cst_attr_onhand_summary (
    PERIOD_NAME                     VARCHAR2(60)  ,
    COST_BOOK_ID                    NUMBER(18, 0) ,
    COST_ORG_ID                     NUMBER(18, 0) ,
    INVENTORY_ORG_ID                NUMBER(18, 0) ,
    SUBINVENTORY_CODE               VARCHAR2(40)  ,
    VAL_UNIT_ID                     NUMBER(18, 0) ,
    VAL_STRUCTURE_TYPE_CODE         VARCHAR2(120) ,
    PERIOD_START_DATE               DATE          ,
    PERIOD_END_DATE                 DATE          ,
    PRIOR_PERIOD_NAME               VARCHAR2(60)  ,
    PRIOR_PERIOD_START_DATE         DATE          ,
    PRIOR_PERIOD_END_DATE           DATE          ,
    INVENTORY_VALUE                 NUMBER        ,
    PRIOR_INVENTORY_VALUE           NUMBER        ,
    COSTED_AMOUNT                   NUMBER        ,
    COSTED_WRITEOFF_AMOUNT          NUMBER        ,
    PRIOR_COSTED_AMOUNT             NUMBER        ,
    PRIOR_COSTED_WRITEOFF_AMOUNT    NUMBER        ,
    ACCTD_AMOUNT                    NUMBER        ,
    ACCTD_WRITEOFF_AMOUNT           NUMBER        ,
    PRIOR_ACCTD_AMOUNT              NUMBER        ,
    PRIOR_ACCTD_WRITEOFF_AMOUNT     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),
    PERIOD_NAME                     VARCHAR2(60)  ,
    COST_BOOK_ID                    NUMBER(18, 0) ,
    COST_ORG_ID                     NUMBER(18, 0) ,
    INVENTORY_ORG_ID                NUMBER(18, 0) ,
    SUBINVENTORY_CODE               VARCHAR2(40)  ,
    VAL_UNIT_ID                     NUMBER(18, 0) ,
    VAL_STRUCTURE_TYPE_CODE         VARCHAR2(120) ,
    PERIOD_START_DATE               DATE          ,
    PERIOD_END_DATE                 DATE          ,
    PRIOR_PERIOD_NAME               VARCHAR2(60)  ,
    PRIOR_PERIOD_START_DATE         DATE          ,
    PRIOR_PERIOD_END_DATE           DATE          ,
    INVENTORY_VALUE                 NUMBER        ,
    PRIOR_INVENTORY_VALUE           NUMBER        ,
    COSTED_AMOUNT                   NUMBER        ,
    COSTED_WRITEOFF_AMOUNT          NUMBER        ,
    PRIOR_COSTED_AMOUNT             NUMBER        ,
    PRIOR_COSTED_WRITEOFF_AMOUNT    NUMBER        ,
    ACCTD_AMOUNT                    NUMBER        ,
    ACCTD_WRITEOFF_AMOUNT           NUMBER        ,
    PRIOR_ACCTD_AMOUNT              NUMBER        ,
    PRIOR_ACCTD_WRITEOFF_AMOUNT     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),
    CONSTRAINT pk_cst_attr_onhand_summary PRIMARY KEY (PERIOD_NAME, COST_BOOK_ID, COST_ORG_ID, INVENTORY_ORG_ID, SUBINVENTORY_CODE, VAL_UNIT_ID, PERIOD_NAME, COST_BOOK_ID, COST_ORG_ID, INVENTORY_ORG_ID, SUBINVENTORY_CODE, VAL_UNIT_ID)
);
