CREATE TABLE inv_transfer_order_status_gt (
    LINE_ID                          NUMBER(18, 0) ,
    LINE_NUMBER                      NUMBER(9, 0)  ,
    HEADER_NUMBER                    VARCHAR2(200) ,
    SOURCE_TYPE_LOOKUP               VARCHAR2(120) ,
    SOURCE_TYPE                      VARCHAR2(320) ,
    REQUESTER_ID                     NUMBER(18, 0) ,
    REQUESTER_NAME                   VARCHAR2(960) ,
    PLANNER_ID                       NUMBER(18, 0) ,
    PLANNER_NAME                     VARCHAR2(960) ,
    SOURCE_ORGANIZATION_ID           NUMBER(18, 0) ,
    SOURCE_ORGANIZATION_CODE         VARCHAR2(72)  ,
    DESTINATION_ORGANIZATION_ID      NUMBER(18, 0) ,
    DESTINATION_ORGANIZATION_CODE    VARCHAR2(72)  ,
    DESTINATION_SUBINVENTORY_CODE    VARCHAR2(40)  ,
    DESTINATION_LOCATION_ID          NUMBER(18, 0) ,
    DESTINATION_LOCATION_CODE        VARCHAR2(240) ,
    INVENTORY_ITEM_ID                NUMBER(18, 0) ,
    ITEM_NUMBER                      VARCHAR2(1200),
    ITEM_DESCRIPTION                 VARCHAR2(960) ,
    ITEM_REVISION                    VARCHAR2(72)  ,
    LINE_CREATION_DATE               TIMESTAMP(6)  ,
    LINE_LAST_UPDATE_DATE            TIMESTAMP(6)  ,
    NEED_BY_DATE                     DATE          ,
    INTERFACE_STATUS_LOOKUP          VARCHAR2(120) ,
    INTERFACE_STATUS                 VARCHAR2(320) ,
    REQ_BU_ID                        NUMBER(18, 0) ,
    REQ_BU_NAME                      VARCHAR2(960) ,
    REQUISITION_ID                   NUMBER(18, 0) ,
    REQUISITION_NUMBER               VARCHAR2(256) ,
    REQUISITION_LINE_ID              NUMBER(18, 0) ,
    REQUISITION_LINE_NUMBER          NUMBER        ,
    PREPARER_NAME                    VARCHAR2(960) ,
    DESTINATION_TYPE_LOOKUP          VARCHAR2(120) ,
    DESTINATION_TYPE                 VARCHAR2(320) ,
    QTY_UOM_CODE                     VARCHAR2(12)  ,
    UNIT_OF_MEASURE                  VARCHAR2(100) ,
    REQUESTED_QTY                    NUMBER        ,
    SHIPPED_QTY                      NUMBER        ,
    RECEIVED_QTY                     NUMBER        ,
    DELIVERED_QTY                    NUMBER        ,
    SECONDARY_QTY_UOM_CODE           VARCHAR2(12)  ,
    SECONDARY_UNIT_OF_MEASURE        VARCHAR2(100) ,
    SECONDARY_REQUESTED_QTY          NUMBER        ,
    SECONDARY_SHIPPED_QTY            NUMBER        ,
    SECONDARY_RECEIVED_QTY           NUMBER        ,
    SECONDARY_DELIVERED_QTY          NUMBER        ,
    UNIT_PRICE                       NUMBER        ,
    CURRENCY_CODE                    VARCHAR2(60)  ,
    TOTAL_PRICE                      NUMBER        ,
    INCL_NONRECOVERABLE_TAX          NUMBER        ,
    INCL_RECOVERABLE_TAX             NUMBER        ,
    NONINCL_NONRECOVERABLE_TAX       NUMBER        ,
    NONINCL_RECOVERABLE_TAX          NUMBER        ,
    FULFILLMENT_STATUS               VARCHAR2(320) ,
    CHARGE_ACCOUNT                   VARCHAR2(480) ,
    BUDGET_DATE                      VARCHAR2(192) ,
    SHIPMENT_PRIORITY_LOOKUP         VARCHAR2(120) ,
    SHIPMENT_PRIORITY                VARCHAR2(320) ,
    DESTINATION_LOCATION_NAME        VARCHAR2(960) ,
    SCHEDULED_SHIP_DATE              DATE          ,
    ERR_MSG_TEXT                     VARCHAR2(4000),
    STATUS_LOOKUP                    VARCHAR2(120) ,
    LINE_STATUS                      VARCHAR2(320) ,
    CANCEL_RESULT_LOOKUP             VARCHAR2(120) ,
    CANCEL_RESULT                    VARCHAR2(320) ,
    WDD_IN_PROCESS_LOOKUP            VARCHAR2(4)   ,
    WDD_IN_PROCESS                   VARCHAR2(320) ,
    SORT_SEQUENCE                    NUMBER        ,
    PJC_PROJECT_ID                   NUMBER(18, 0) ,
    PJC_TASK_ID                      NUMBER(18, 0) ,
    PJC_PROJECT_NUMBER               VARCHAR2(100) ,
    PJC_TASK_NUMBER                  VARCHAR2(400) ,
    CONSUMED_REQUESTED_QTY           NUMBER        ,
    LINE_ID                          NUMBER(18, 0) ,
    LINE_NUMBER                      NUMBER(9, 0)  ,
    HEADER_NUMBER                    VARCHAR2(200) ,
    SOURCE_TYPE_LOOKUP               VARCHAR2(120) ,
    SOURCE_TYPE                      VARCHAR2(320) ,
    REQUESTER_ID                     NUMBER(18, 0) ,
    REQUESTER_NAME                   VARCHAR2(960) ,
    PLANNER_ID                       NUMBER(18, 0) ,
    PLANNER_NAME                     VARCHAR2(960) ,
    SOURCE_ORGANIZATION_ID           NUMBER(18, 0) ,
    SOURCE_ORGANIZATION_CODE         VARCHAR2(72)  ,
    DESTINATION_ORGANIZATION_ID      NUMBER(18, 0) ,
    DESTINATION_ORGANIZATION_CODE    VARCHAR2(72)  ,
    DESTINATION_SUBINVENTORY_CODE    VARCHAR2(40)  ,
    DESTINATION_LOCATION_ID          NUMBER(18, 0) ,
    DESTINATION_LOCATION_CODE        VARCHAR2(240) ,
    INVENTORY_ITEM_ID                NUMBER(18, 0) ,
    ITEM_NUMBER                      VARCHAR2(1200),
    ITEM_DESCRIPTION                 VARCHAR2(960) ,
    ITEM_REVISION                    VARCHAR2(72)  ,
    LINE_CREATION_DATE               TIMESTAMP(6)  ,
    LINE_LAST_UPDATE_DATE            TIMESTAMP(6)  ,
    NEED_BY_DATE                     DATE          ,
    INTERFACE_STATUS_LOOKUP          VARCHAR2(120) ,
    INTERFACE_STATUS                 VARCHAR2(320) ,
    REQ_BU_ID                        NUMBER(18, 0) ,
    REQ_BU_NAME                      VARCHAR2(960) ,
    REQUISITION_ID                   NUMBER(18, 0) ,
    REQUISITION_NUMBER               VARCHAR2(256) ,
    REQUISITION_LINE_ID              NUMBER(18, 0) ,
    REQUISITION_LINE_NUMBER          NUMBER        ,
    PREPARER_NAME                    VARCHAR2(960) ,
    DESTINATION_TYPE_LOOKUP          VARCHAR2(120) ,
    DESTINATION_TYPE                 VARCHAR2(320) ,
    QTY_UOM_CODE                     VARCHAR2(12)  ,
    UNIT_OF_MEASURE                  VARCHAR2(100) ,
    REQUESTED_QTY                    NUMBER        ,
    SHIPPED_QTY                      NUMBER        ,
    RECEIVED_QTY                     NUMBER        ,
    DELIVERED_QTY                    NUMBER        ,
    SECONDARY_QTY_UOM_CODE           VARCHAR2(12)  ,
    SECONDARY_UNIT_OF_MEASURE        VARCHAR2(100) ,
    SECONDARY_REQUESTED_QTY          NUMBER        ,
    SECONDARY_SHIPPED_QTY            NUMBER        ,
    SECONDARY_RECEIVED_QTY           NUMBER        ,
    SECONDARY_DELIVERED_QTY          NUMBER        ,
    UNIT_PRICE                       NUMBER        ,
    CURRENCY_CODE                    VARCHAR2(60)  ,
    TOTAL_PRICE                      NUMBER        ,
    INCL_NONRECOVERABLE_TAX          NUMBER        ,
    INCL_RECOVERABLE_TAX             NUMBER        ,
    NONINCL_NONRECOVERABLE_TAX       NUMBER        ,
    NONINCL_RECOVERABLE_TAX          NUMBER        ,
    FULFILLMENT_STATUS               VARCHAR2(320) ,
    CHARGE_ACCOUNT                   VARCHAR2(480) ,
    BUDGET_DATE                      VARCHAR2(192) ,
    SHIPMENT_PRIORITY_LOOKUP         VARCHAR2(120) ,
    SHIPMENT_PRIORITY                VARCHAR2(320) ,
    DESTINATION_LOCATION_NAME        VARCHAR2(960) ,
    SCHEDULED_SHIP_DATE              DATE          ,
    ERR_MSG_TEXT                     VARCHAR2(4000),
    STATUS_LOOKUP                    VARCHAR2(120) ,
    LINE_STATUS                      VARCHAR2(320) ,
    CANCEL_RESULT_LOOKUP             VARCHAR2(120) ,
    CANCEL_RESULT                    VARCHAR2(320) ,
    WDD_IN_PROCESS_LOOKUP            VARCHAR2(4)   ,
    WDD_IN_PROCESS                   VARCHAR2(320) ,
    SORT_SEQUENCE                    NUMBER        ,
    PJC_PROJECT_ID                   NUMBER(18, 0) ,
    PJC_TASK_ID                      NUMBER(18, 0) ,
    PJC_PROJECT_NUMBER               VARCHAR2(100) ,
    PJC_TASK_NUMBER                  VARCHAR2(400) ,
    CONSUMED_REQUESTED_QTY           NUMBER        
);
