CREATE TABLE cml_topt_assignment_rules (
    TOPT_ASSIGNMENT_RULE_ID        NUMBER(18, 0),
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)     NOT NULL,
    TRADE_OPERATION_TEMPLATE_ID    NUMBER(18, 0)    NOT NULL,
    REQUISITIONING_BU_ID           NUMBER(18, 0)    NOT NULL,
    DELIVER_TO_INV_ORG_ID          NUMBER(18, 0),
    SHIP_TO_LOCATION_ID            NUMBER(18, 0),
    VENDOR_ID                      NUMBER(18, 0),
    VENDOR_SITE_ID                 NUMBER(18, 0),
    ITEM_CATEGORY_ID               NUMBER(18, 0),
    INVENTORY_ITEM_ID              NUMBER(18, 0),
    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),
    TOPT_ASSIGNMENT_RULE_ID        NUMBER(18, 0),
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)     NOT NULL,
    TRADE_OPERATION_TEMPLATE_ID    NUMBER(18, 0)    NOT NULL,
    REQUISITIONING_BU_ID           NUMBER(18, 0)    NOT NULL,
    DELIVER_TO_INV_ORG_ID          NUMBER(18, 0),
    SHIP_TO_LOCATION_ID            NUMBER(18, 0),
    VENDOR_ID                      NUMBER(18, 0),
    VENDOR_SITE_ID                 NUMBER(18, 0),
    ITEM_CATEGORY_ID               NUMBER(18, 0),
    INVENTORY_ITEM_ID              NUMBER(18, 0),
    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),
    CONSTRAINT pk_cml_topt_assignment_rules PRIMARY KEY (TOPT_ASSIGNMENT_RULE_ID, TOPT_ASSIGNMENT_RULE_ID)
);
