CREATE TABLE inv_physical_adjustments (
    ADJUSTMENT_ID               NUMBER(18, 0) ,
    OWNING_ENTITY_ID            NUMBER(18, 0) ,
    OWNING_TYPE                 VARCHAR2(120) ,
    OBJECT_VERSION_NUMBER       NUMBER(9, 0)      NOT NULL,
    ORGANIZATION_ID             NUMBER(18, 0)     NOT NULL,
    PHYSICAL_INVENTORY_ID       NUMBER(18, 0)     NOT NULL,
    INVENTORY_ITEM_ID           NUMBER(18, 0)     NOT NULL,
    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) ,
    SUBINVENTORY_NAME           VARCHAR2(40)      NOT NULL,
    SYSTEM_QUANTITY             NUMBER            NOT NULL,
    COUNT_QUANTITY              NUMBER        ,
    ADJUSTMENT_QUANTITY         NUMBER            NOT NULL,
    ADJUSTMENT_UOM              VARCHAR2(12)  ,
    REVISION                    VARCHAR2(72)  ,
    LOCATOR_ID                  NUMBER(18, 0) ,
    LOT_NUMBER                  VARCHAR2(320) ,
    LOT_EXPIRATION_DATE         DATE          ,
    SERIAL_NUMBER               VARCHAR2(320) ,
    ACTUAL_COST                 NUMBER        ,
    ADJUSTMENT_AMOUNT           NUMBER        ,
    APPROVAL_STATUS             VARCHAR2(120) ,
    APPROVED_BY_EMPLOYEE_ID     NUMBER(18, 0) ,
    REQUEST_ID                  NUMBER(18, 0) ,
    JOB_DEFINITION_NAME         VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE      VARCHAR2(3600),
    LOT_SERIAL_CONTROLS         VARCHAR2(4)   ,
    TEMP_APPROVER               NUMBER(1, 0)  ,
    SECONDARY_SYSTEM_QTY        NUMBER        ,
    SECONDARY_COUNT_QTY         NUMBER        ,
    SECONDARY_ADJUSTMENT_QTY    NUMBER        ,
    INV_STRIPING_CATEGORY       VARCHAR2(160) ,
    PROJECT_ID                  NUMBER(18, 0) ,
    TASK_ID                     NUMBER(18, 0) ,
    COUNTRY_OF_ORIGIN_CODE      VARCHAR2(8)   ,
    PARENT_LPN_ID               NUMBER(18, 0) ,
    OUTERMOST_LPN_ID            NUMBER(18, 0) ,
    LPN_SUMMARY_COUNT_FLAG      VARCHAR2(4)   ,
    LPN_DISCREPANCY_FLAG        VARCHAR2(4)   ,
    INV_RESERVED_ATTRIBUTE1     VARCHAR2(600) ,
    INV_RESERVED_ATTRIBUTE2     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE1     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE2     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE3     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE4     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE5     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE6     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE7     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE8     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE9     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE10    VARCHAR2(600) ,
    ADJUSTMENT_ID               NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER       NUMBER(9, 0)      NOT NULL,
    ORGANIZATION_ID             NUMBER(18, 0)     NOT NULL,
    PHYSICAL_INVENTORY_ID       NUMBER(18, 0)     NOT NULL,
    INVENTORY_ITEM_ID           NUMBER(18, 0)     NOT NULL,
    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) ,
    SUBINVENTORY_NAME           VARCHAR2(40)      NOT NULL,
    SYSTEM_QUANTITY             NUMBER            NOT NULL,
    COUNT_QUANTITY              NUMBER        ,
    ADJUSTMENT_QUANTITY         NUMBER            NOT NULL,
    ADJUSTMENT_UOM              VARCHAR2(12)  ,
    REVISION                    VARCHAR2(72)  ,
    LOCATOR_ID                  NUMBER(18, 0) ,
    LOT_NUMBER                  VARCHAR2(320) ,
    LOT_EXPIRATION_DATE         DATE          ,
    SERIAL_NUMBER               VARCHAR2(320) ,
    ACTUAL_COST                 NUMBER        ,
    APPROVAL_STATUS             VARCHAR2(120) ,
    APPROVED_BY_EMPLOYEE_ID     NUMBER(18, 0) ,
    REQUEST_ID                  NUMBER(18, 0) ,
    JOB_DEFINITION_NAME         VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE      VARCHAR2(3600),
    LOT_SERIAL_CONTROLS         VARCHAR2(4)   ,
    TEMP_APPROVER               NUMBER(1, 0)  ,
    SECONDARY_SYSTEM_QTY        NUMBER        ,
    SECONDARY_COUNT_QTY         NUMBER        ,
    SECONDARY_ADJUSTMENT_QTY    NUMBER        ,
    OWNING_ENTITY_ID            NUMBER(18, 0) ,
    OWNING_TYPE                 VARCHAR2(120) ,
    INV_STRIPING_CATEGORY       VARCHAR2(160) ,
    PROJECT_ID                  NUMBER(18, 0) ,
    TASK_ID                     NUMBER(18, 0) ,
    COUNTRY_OF_ORIGIN_CODE      VARCHAR2(8)   ,
    INV_RESERVED_ATTRIBUTE1     VARCHAR2(600) ,
    INV_RESERVED_ATTRIBUTE2     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE1     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE2     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE3     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE4     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE5     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE6     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE7     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE8     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE9     VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE10    VARCHAR2(600) ,
    ADJUSTMENT_AMOUNT           NUMBER        ,
    PARENT_LPN_ID               NUMBER(18, 0) ,
    OUTERMOST_LPN_ID            NUMBER(18, 0) ,
    LPN_SUMMARY_COUNT_FLAG      VARCHAR2(4)   ,
    LPN_DISCREPANCY_FLAG        VARCHAR2(4)   ,
    CONSTRAINT pk_inv_physical_adjustments PRIMARY KEY (ADJUSTMENT_ID, ADJUSTMENT_ID)
);
