CREATE TABLE msc_compsubs_59294_1_dyd (
    CONFIG_ITEM_FLAG            NUMBER        ,
    LOAD_REQUEST_ID             NUMBER        ,
    PROCESS_FLAG                NUMBER        ,
    ERROR_TEXT                  VARCHAR2(4000),
    INVENTORY_ITEM_NAME         VARCHAR2(4000),
    ALTERNATE_BOM_DESIGNATOR    VARCHAR2(640) ,
    SUB_ITEM_NAME               VARCHAR2(4000),
    OPERATION_SEQ_NUM           NUMBER        ,
    ERROR_CODE                  VARCHAR2(2400),
    EFFECTIVITY_DATE            DATE          ,
    SR_INSTANCE_CODE            VARCHAR2(480) ,
    ASSEMBLY_NAME               VARCHAR2(4000),
    ORGANIZATION_CODE           VARCHAR2(288) ,
    BILL_SEQUENCE_ID            NUMBER        ,
    REFRESH_NUMBER              NUMBER        ,
    SR_INSTANCE_ID              NUMBER        ,
    LAST_UPDATE_LOGIN           VARCHAR2(512) ,
    CREATED_BY                  VARCHAR2(1024),
    CREATION_DATE               TIMESTAMP(6)  ,
    LAST_UPDATED_BY             VARCHAR2(1024),
    LAST_UPDATE_DATE            TIMESTAMP(6)  ,
    DELETED_FLAG                NUMBER        ,
    PRIORITY                    NUMBER        ,
    ORGANIZATION_ID             NUMBER        ,
    USAGE_QUANTITY              NUMBER        ,
    SUBSTITUTE_ITEM_ID          NUMBER        ,
    RETRY_COUNT                 NUMBER        ,
    COMPONENT_SEQUENCE_ID       NUMBER        ,
    CONFIG_ITEM_FLAG            NUMBER        ,
    LOAD_REQUEST_ID             NUMBER        ,
    PROCESS_FLAG                NUMBER        ,
    ERROR_TEXT                  VARCHAR2(4000),
    INVENTORY_ITEM_NAME         VARCHAR2(4000),
    ALTERNATE_BOM_DESIGNATOR    VARCHAR2(640) ,
    SUB_ITEM_NAME               VARCHAR2(4000),
    OPERATION_SEQ_NUM           NUMBER        ,
    ERROR_CODE                  VARCHAR2(2400),
    EFFECTIVITY_DATE            DATE          ,
    SR_INSTANCE_CODE            VARCHAR2(480) ,
    ASSEMBLY_NAME               VARCHAR2(4000),
    ORGANIZATION_CODE           VARCHAR2(288) ,
    BILL_SEQUENCE_ID            NUMBER        ,
    REFRESH_NUMBER              NUMBER        ,
    SR_INSTANCE_ID              NUMBER        ,
    LAST_UPDATE_LOGIN           VARCHAR2(512) ,
    CREATED_BY                  VARCHAR2(1024),
    CREATION_DATE               TIMESTAMP(6)  ,
    LAST_UPDATED_BY             VARCHAR2(1024),
    LAST_UPDATE_DATE            TIMESTAMP(6)  ,
    DELETED_FLAG                NUMBER        ,
    PRIORITY                    NUMBER        ,
    ORGANIZATION_ID             NUMBER        ,
    USAGE_QUANTITY              NUMBER        ,
    SUBSTITUTE_ITEM_ID          NUMBER        ,
    RETRY_COUNT                 NUMBER        ,
    COMPONENT_SEQUENCE_ID       NUMBER        
);
