CREATE TABLE cst_work_order_operations_int (
    EXTERNAL_SYSTEM_REFERENCE       VARCHAR2(240) ,
    EXTERNAL_SYSTEM_REF_ID          VARCHAR2(120) ,
    WORK_ORDER_OPERATION_ID         NUMBER(18, 0) ,
    OPERATION_SEQ_NUMBER            NUMBER            NOT NULL,
    OPERATION_TYPE                  VARCHAR2(120)     NOT NULL,
    OSP_ITEM_ID                     NUMBER(18, 0) ,
    SUPPLIER_ID                     NUMBER(18, 0) ,
    SUPPLIER_SITE_ID                NUMBER(18, 0) ,
    WORK_DEFINITION_OPERATION_ID    NUMBER(18, 0) ,
    WORK_CENTER_ID                  NUMBER(18, 0) ,
    PREPROCESSING_STATUS            VARCHAR2(4)   ,
    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) ,
    REQUEST_ID                      NUMBER(18, 0) ,
    JOB_DEFINITION_NAME             VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE          VARCHAR2(3600),
    OP_YIELD_FACTOR                 NUMBER        ,
    EXTERNAL_SYSTEM_REFERENCE       VARCHAR2(240) ,
    EXTERNAL_SYSTEM_REF_ID          VARCHAR2(120) ,
    WORK_ORDER_OPERATION_ID         NUMBER(18, 0) ,
    OPERATION_SEQ_NUMBER            NUMBER            NOT NULL,
    WORK_DEFINITION_OPERATION_ID    NUMBER(18, 0) ,
    WORK_CENTER_ID                  NUMBER(18, 0) ,
    PREPROCESSING_STATUS            VARCHAR2(4)   ,
    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) ,
    REQUEST_ID                      NUMBER(18, 0) ,
    JOB_DEFINITION_NAME             VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE          VARCHAR2(3600),
    OPERATION_TYPE                  VARCHAR2(120)     NOT NULL,
    OSP_ITEM_ID                     NUMBER(18, 0) ,
    SUPPLIER_ID                     NUMBER(18, 0) ,
    SUPPLIER_SITE_ID                NUMBER(18, 0) ,
    OP_YIELD_FACTOR                 NUMBER        ,
    CONSTRAINT pk_cst_work_order_operations_int PRIMARY KEY (EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, WORK_ORDER_OPERATION_ID, EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, WORK_ORDER_OPERATION_ID)
);
