CREATE TABLE cst_inv_qty_last_record_gt (
    COST_ORG_ID                   NUMBER(18, 0)    NOT NULL,
    COST_BOOK_ID                  NUMBER(18, 0)    NOT NULL,
    VAL_UNIT_ID                   NUMBER(18, 0),
    INVENTORY_ITEM_ID             NUMBER(18, 0)    NOT NULL,
    SNAPSHOT_DATE                 DATE             NOT NULL,
    BUSINESS_UNIT_ID              NUMBER(18, 0),
    INVENTORY_ORG_ID              NUMBER(18, 0)    NOT NULL,
    SUBINVENTORY_CODE             VARCHAR2(40) ,
    LOCATOR_ID                    NUMBER(18, 0),
    QUANTITY                      NUMBER       ,
    UOM_CODE                      VARCHAR2(12) ,
    EFF_TO_DATE                   DATE         ,
    TRANSFER_COST_ORG_ID          NUMBER(18, 0),
    TRANSFER_BOOK_ID              NUMBER(18, 0),
    TRANSFER_INVENTORY_ORG_ID     NUMBER(18, 0),
    TRANSFER_SUBINVENTORY_CODE    VARCHAR2(40) ,
    TRANSFER_LOCATOR_ID           NUMBER(18, 0),
    AMOUNT                        NUMBER       ,
    FOB_POINT                     NUMBER(1, 0) ,
    COST_ORG_ID                   NUMBER(18, 0)    NOT NULL,
    COST_BOOK_ID                  NUMBER(18, 0)    NOT NULL,
    VAL_UNIT_ID                   NUMBER(18, 0),
    INVENTORY_ITEM_ID             NUMBER(18, 0)    NOT NULL,
    SNAPSHOT_DATE                 DATE             NOT NULL,
    BUSINESS_UNIT_ID              NUMBER(18, 0),
    INVENTORY_ORG_ID              NUMBER(18, 0)    NOT NULL,
    SUBINVENTORY_CODE             VARCHAR2(40) ,
    LOCATOR_ID                    NUMBER(18, 0),
    QUANTITY                      NUMBER       ,
    UOM_CODE                      VARCHAR2(12) ,
    EFF_TO_DATE                   DATE         ,
    TRANSFER_COST_ORG_ID          NUMBER(18, 0),
    TRANSFER_BOOK_ID              NUMBER(18, 0),
    TRANSFER_INVENTORY_ORG_ID     NUMBER(18, 0),
    TRANSFER_SUBINVENTORY_CODE    VARCHAR2(40) ,
    TRANSFER_LOCATOR_ID           NUMBER(18, 0),
    AMOUNT                        NUMBER       ,
    FOB_POINT                     NUMBER(1, 0) 
);
