CREATE TABLE dos_workorder_details_int (
    WORKORDER_DETAILS_INTF_ID        NUMBER(18, 0) ,
    MATERIAL_QTY_PER_PRODUCT         NUMBER        ,
    SUBSTITUTE_QTY_PER_PRODUCT       NUMBER        ,
    WD_OP_ALT_RESOURCE_ID            NUMBER(18, 0) ,
    LINE_INTERFACE_ID                NUMBER(18, 0)     NOT NULL,
    HEADER_INTERFACE_ID              NUMBER(18, 0)     NOT NULL,
    INTERFACE_BATCH_NUMBER           VARCHAR2(200)     NOT NULL,
    INTERFACE_STATUS_CODE            VARCHAR2(120) ,
    ACTION_CODE                      VARCHAR2(120) ,
    LOAD_TYPE                        VARCHAR2(120) ,
    MATERIAL_SEQ_NUMBER              NUMBER        ,
    DETAIL_TYPE                      VARCHAR2(120) ,
    WIP_ENTITY_ID                    NUMBER        ,
    OPERATION_SEQUENCE_ID            NUMBER        ,
    OPERATION_SEQUENCE_NUMBER        NUMBER        ,
    SCHEDULED_FLAG                   NUMBER        ,
    ASSIGNED_UNITS                   NUMBER        ,
    WIP_SUPPLY_TYPE                  NUMBER        ,
    WO_PROCESS_PHASE                 NUMBER        ,
    WO_PROCESS_STATUS                NUMBER        ,
    ALTERNATE_NUMBER                 NUMBER        ,
    COMP_ITEM_ID_NEW                 NUMBER        ,
    COMP_ITEM_NAME_NEW               VARCHAR2(80)  ,
    COMP_ITEM_REVISION               VARCHAR2(72)  ,
    COMP_REQUIRED_QUANTITY           NUMBER        ,
    COMP_REQUIRED_QUANTITY_UOM       VARCHAR2(12)  ,
    COMP_QUANTITY_PER_ASSEMBLY       NUMBER        ,
    COMP_QUANTITY_ISSUED             NUMBER        ,
    COMP_DATE_REQUIRED               DATE          ,
    COMP_SUPPLY_LOCATOR_ID           NUMBER        ,
    COMP_SUPPLY_LOCATOR_NAME         VARCHAR2(80)  ,
    COMP_SUPPLY_SUB_INVENTORY        VARCHAR2(40)  ,
    COMP_MRP_NET_FLAG                NUMBER        ,
    COMP_CHARGE_ACCNT_ID             NUMBER        ,
    COMP_ITEM_ID_OLD                 NUMBER        ,
    COMP_ITEM_NAME_OLD               VARCHAR2(80)  ,
    STANDARD_OPERATION_ID            NUMBER        ,
    STANDARD_OPERATION_NAME          VARCHAR2(80)  ,
    STANDARD_RATE_FLAG               NUMBER        ,
    SUBSTITUTION_TYPE                NUMBER        ,
    MIN_TRANSFER_QUANTITY            NUMBER        ,
    MIN_TRANSFER_QUANTITY_UOM        VARCHAR2(12)  ,
    BACKFLUSH_FLAG                   NUMBER        ,
    SOURCE_CODE                      VARCHAR2(80)  ,
    COUNT_POINT_TYPE                 NUMBER        ,
    MPS_REQUIRED_QUANTITY            NUMBER        ,
    MPS_REQUIRED_QUANTITY_UOM        VARCHAR2(12)  ,
    MPS_DATE_REQUIRED                DATE          ,
    APPLIED_RESOURCE_UNITS           NUMBER        ,
    APPLIED_RESOURCE_VALUE           NUMBER        ,
    RESOURCE_SEQUENCE_NUMBER         NUMBER        ,
    RESOURCE_ACTIVITY_ID             NUMBER        ,
    RESOURCE_LOAD_TYPE               NUMBER        ,
    RESOURCE_START_DATE              NUMBER        ,
    RESOURCE_ID_NEW                  NUMBER        ,
    RESOURCE_NAME_NEW                VARCHAR2(80)  ,
    RESOURCE_DEPARTMENT_ID           NUMBER        ,
    RESOURE_DEPARTMENT_NAME          VARCHAR2(80)  ,
    RESOURCE_BASIS_TYPE              NUMBER        ,
    RESOURCE_USAGE_RATE_OR_AMOUNT    NUMBER        ,
    RESOURCE_UOM_CODE                VARCHAR2(12)  ,
    RESOURCE_AUTO_CHARGE_TYPE        NUMBER        ,
    RESOURCE_COMPLETION_DATE         DATE          ,
    RESOURCE_ID_OLD                  NUMBER        ,
    RESOURCE_NAME_OLD                VARCHAR2(80)  ,
    REQUEST_ID                       NUMBER(18, 0) ,
    JOB_DEFINITION_NAME              VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE           VARCHAR2(3600),
    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) ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)      NOT NULL,
    WORKORDER_DETAILS_INTF_ID        NUMBER(18, 0) ,
    LINE_INTERFACE_ID                NUMBER(18, 0)     NOT NULL,
    HEADER_INTERFACE_ID              NUMBER(18, 0)     NOT NULL,
    INTERFACE_BATCH_NUMBER           VARCHAR2(200)     NOT NULL,
    DETAIL_TYPE                      VARCHAR2(120) ,
    WIP_ENTITY_ID                    NUMBER        ,
    OPERATION_SEQUENCE_ID            NUMBER        ,
    OPERATION_SEQUENCE_NUMBER        NUMBER        ,
    SCHEDULED_FLAG                   NUMBER        ,
    ASSIGNED_UNITS                   NUMBER        ,
    WIP_SUPPLY_TYPE                  NUMBER        ,
    WO_PROCESS_PHASE                 NUMBER        ,
    WO_PROCESS_STATUS                NUMBER        ,
    ALTERNATE_NUMBER                 NUMBER        ,
    COMP_ITEM_ID_NEW                 NUMBER        ,
    COMP_ITEM_NAME_NEW               VARCHAR2(80)  ,
    COMP_ITEM_REVISION               VARCHAR2(72)  ,
    COMP_REQUIRED_QUANTITY           NUMBER        ,
    COMP_REQUIRED_QUANTITY_UOM       VARCHAR2(12)  ,
    COMP_QUANTITY_PER_ASSEMBLY       NUMBER        ,
    COMP_QUANTITY_ISSUED             NUMBER        ,
    COMP_DATE_REQUIRED               DATE          ,
    COMP_SUPPLY_LOCATOR_ID           NUMBER        ,
    COMP_SUPPLY_LOCATOR_NAME         VARCHAR2(80)  ,
    COMP_SUPPLY_SUB_INVENTORY        VARCHAR2(40)  ,
    COMP_MRP_NET_FLAG                NUMBER        ,
    COMP_CHARGE_ACCNT_ID             NUMBER        ,
    COMP_ITEM_ID_OLD                 NUMBER        ,
    COMP_ITEM_NAME_OLD               VARCHAR2(80)  ,
    STANDARD_OPERATION_ID            NUMBER        ,
    STANDARD_OPERATION_NAME          VARCHAR2(80)  ,
    STANDARD_RATE_FLAG               NUMBER        ,
    SUBSTITUTION_TYPE                NUMBER        ,
    MIN_TRANSFER_QUANTITY            NUMBER        ,
    MIN_TRANSFER_QUANTITY_UOM        VARCHAR2(12)  ,
    BACKFLUSH_FLAG                   NUMBER        ,
    SOURCE_CODE                      VARCHAR2(80)  ,
    COUNT_POINT_TYPE                 NUMBER        ,
    MPS_REQUIRED_QUANTITY            NUMBER        ,
    MPS_REQUIRED_QUANTITY_UOM        VARCHAR2(12)  ,
    MPS_DATE_REQUIRED                DATE          ,
    APPLIED_RESOURCE_UNITS           NUMBER        ,
    APPLIED_RESOURCE_VALUE           NUMBER        ,
    RESOURCE_SEQUENCE_NUMBER         NUMBER        ,
    RESOURCE_ACTIVITY_ID             NUMBER        ,
    RESOURCE_LOAD_TYPE               NUMBER        ,
    RESOURCE_START_DATE              NUMBER        ,
    RESOURCE_ID_NEW                  NUMBER        ,
    RESOURCE_NAME_NEW                VARCHAR2(80)  ,
    RESOURCE_DEPARTMENT_ID           NUMBER        ,
    RESOURE_DEPARTMENT_NAME          VARCHAR2(80)  ,
    RESOURCE_BASIS_TYPE              NUMBER        ,
    RESOURCE_USAGE_RATE_OR_AMOUNT    NUMBER        ,
    RESOURCE_UOM_CODE                VARCHAR2(12)  ,
    RESOURCE_AUTO_CHARGE_TYPE        NUMBER        ,
    RESOURCE_COMPLETION_DATE         DATE          ,
    RESOURCE_ID_OLD                  NUMBER        ,
    RESOURCE_NAME_OLD                VARCHAR2(80)  ,
    REQUEST_ID                       NUMBER(18, 0) ,
    JOB_DEFINITION_NAME              VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE           VARCHAR2(3600),
    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) ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)      NOT NULL,
    MATERIAL_QTY_PER_PRODUCT         NUMBER        ,
    SUBSTITUTE_QTY_PER_PRODUCT       NUMBER        ,
    WD_OP_ALT_RESOURCE_ID            NUMBER(18, 0) ,
    INTERFACE_STATUS_CODE            VARCHAR2(120) ,
    ACTION_CODE                      VARCHAR2(120) ,
    LOAD_TYPE                        VARCHAR2(120) ,
    MATERIAL_SEQ_NUMBER              NUMBER        ,
    CONSTRAINT pk_dos_workorder_details_int PRIMARY KEY (WORKORDER_DETAILS_INTF_ID, WORKORDER_DETAILS_INTF_ID)
);
