CREATE TABLE inv_supply_demand_temp (
    SEQ_NUM                      NUMBER(18, 0)    NOT NULL,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)     NOT NULL,
    GROUP_ID                     NUMBER(18, 0),
    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),
    ROW_NUMBER                   NUMBER       ,
    RECORD_TYPE                  VARCHAR2(40) ,
    ORGANIZATION_ID              NUMBER(18, 0),
    INVENTORY_ITEM_ID            NUMBER(18, 0),
    ATP_PERIOD_TOTAL_SUPPLY      NUMBER       ,
    ATP_PERIOD_TOTAL_DEMAND      NUMBER       ,
    SUPPLY_DEMAND_SOURCE_TYPE    NUMBER(18, 0),
    SUPPLY_DEMAND_TYPE           NUMBER(18, 0),
    DISPOSITION_TYPE             NUMBER(18, 0),
    DISPOSITION_ID               NUMBER(18, 0),
    ATP                          NUMBER       ,
    QUANTITY                     NUMBER       ,
    ON_HAND_QUANTITY             NUMBER       ,
    ATP_PERIOD_START_DATE        DATE         ,
    ATP_PERIOD_END_DATE          DATE         ,
    REQUIREMENT_DATE             DATE         ,
    C_COLUMN1                    VARCHAR2(960),
    C_COLUMN2                    VARCHAR2(960),
    C_COLUMN3                    VARCHAR2(960),
    C_COLUMN4                    VARCHAR2(960),
    C_COLUMN5                    VARCHAR2(960),
    C_COLUMN6                    VARCHAR2(960),
    C_COLUMN7                    VARCHAR2(960),
    C_COLUMN8                    VARCHAR2(960),
    N_COLUMN1                    NUMBER       ,
    N_COLUMN2                    NUMBER       ,
    N_COLUMN3                    NUMBER       ,
    N_COLUMN4                    NUMBER       ,
    N_COLUMN5                    NUMBER       ,
    D_COLUMN1                    DATE         ,
    D_COLUMN2                    DATE         ,
    D_COLUMN3                    DATE         ,
    D_COLUMN4                    DATE         ,
    D_COLUMN5                    DATE         ,
    PERIOD_NET_AVAILABLE         NUMBER       ,
    UOM_CODE                     VARCHAR2(12) ,
    RESOURCE_ID                  NUMBER(18, 0),
    DEPARTMENT_ID                NUMBER(18, 0),
    SEQ_NUM                      NUMBER(18, 0)    NOT NULL,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)     NOT NULL,
    GROUP_ID                     NUMBER(18, 0),
    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),
    ROW_NUMBER                   NUMBER       ,
    RECORD_TYPE                  VARCHAR2(40) ,
    ORGANIZATION_ID              NUMBER(18, 0),
    INVENTORY_ITEM_ID            NUMBER(18, 0),
    ATP_PERIOD_TOTAL_SUPPLY      NUMBER       ,
    ATP_PERIOD_TOTAL_DEMAND      NUMBER       ,
    SUPPLY_DEMAND_SOURCE_TYPE    NUMBER(18, 0),
    SUPPLY_DEMAND_TYPE           NUMBER(18, 0),
    DISPOSITION_TYPE             NUMBER(18, 0),
    DISPOSITION_ID               NUMBER(18, 0),
    ATP                          NUMBER       ,
    QUANTITY                     NUMBER       ,
    ON_HAND_QUANTITY             NUMBER       ,
    ATP_PERIOD_START_DATE        DATE         ,
    ATP_PERIOD_END_DATE          DATE         ,
    REQUIREMENT_DATE             DATE         ,
    C_COLUMN1                    VARCHAR2(960),
    C_COLUMN2                    VARCHAR2(960),
    C_COLUMN3                    VARCHAR2(960),
    C_COLUMN4                    VARCHAR2(960),
    C_COLUMN5                    VARCHAR2(960),
    C_COLUMN6                    VARCHAR2(960),
    C_COLUMN7                    VARCHAR2(960),
    C_COLUMN8                    VARCHAR2(960),
    N_COLUMN1                    NUMBER       ,
    N_COLUMN2                    NUMBER       ,
    N_COLUMN3                    NUMBER       ,
    N_COLUMN4                    NUMBER       ,
    N_COLUMN5                    NUMBER       ,
    D_COLUMN1                    DATE         ,
    D_COLUMN2                    DATE         ,
    D_COLUMN3                    DATE         ,
    D_COLUMN4                    DATE         ,
    D_COLUMN5                    DATE         ,
    PERIOD_NET_AVAILABLE         NUMBER       ,
    UOM_CODE                     VARCHAR2(12) ,
    RESOURCE_ID                  NUMBER(18, 0),
    DEPARTMENT_ID                NUMBER(18, 0)
);
