CREATE TABLE egp_components_b_ (
    OPERATION_SEQ_NUM                NUMBER        ,
    PRIMARY_UOM_CODE                 VARCHAR2(12)  ,
    SHOW_IN_SALES                    NUMBER        ,
    INSTANTIABILITY_CODE             VARCHAR2(120) ,
    CHANGE_ID                        NUMBER        ,
    LAST_UPDATE_DATE                 TIMESTAMP(6)  ,
    LAST_UPDATED_BY                  VARCHAR2(256) ,
    CREATION_DATE                    TIMESTAMP(6)  ,
    CREATED_BY                       VARCHAR2(256) ,
    LAST_UPDATE_LOGIN                VARCHAR2(128) ,
    ITEM_NUM                         NUMBER        ,
    COMPONENT_QUANTITY               NUMBER        ,
    COMPONENT_YIELD_FACTOR           NUMBER        ,
    COMPONENT_REMARKS                VARCHAR2(4000),
    EFFECTIVITY_DATE                 DATE          ,
    IMPLEMENTATION_DATE              DATE          ,
    DISABLE_DATE                     DATE          ,
    ATTRIBUTE_CATEGORY               VARCHAR2(120) ,
    ATTRIBUTE1                       VARCHAR2(600) ,
    ATTRIBUTE2                       VARCHAR2(600) ,
    ATTRIBUTE3                       VARCHAR2(600) ,
    ATTRIBUTE4                       VARCHAR2(600) ,
    ATTRIBUTE5                       VARCHAR2(600) ,
    ATTRIBUTE6                       VARCHAR2(600) ,
    ATTRIBUTE7                       VARCHAR2(600) ,
    ATTRIBUTE8                       VARCHAR2(600) ,
    ATTRIBUTE9                       VARCHAR2(600) ,
    ATTRIBUTE10                      VARCHAR2(600) ,
    ATTRIBUTE11                      VARCHAR2(600) ,
    ATTRIBUTE12                      VARCHAR2(600) ,
    ATTRIBUTE13                      VARCHAR2(600) ,
    ATTRIBUTE14                      VARCHAR2(600) ,
    ATTRIBUTE15                      VARCHAR2(600) ,
    ATTRIBUTE16                      VARCHAR2(600) ,
    ATTRIBUTE17                      VARCHAR2(600) ,
    ATTRIBUTE18                      VARCHAR2(600) ,
    ATTRIBUTE19                      VARCHAR2(600) ,
    ATTRIBUTE20                      VARCHAR2(600) ,
    ATTRIBUTE21                      VARCHAR2(600) ,
    ATTRIBUTE22                      VARCHAR2(600) ,
    ATTRIBUTE23                      VARCHAR2(600) ,
    ATTRIBUTE24                      VARCHAR2(600) ,
    ATTRIBUTE25                      VARCHAR2(600) ,
    ATTRIBUTE26                      VARCHAR2(4000),
    ATTRIBUTE27                      VARCHAR2(4000),
    ATTRIBUTE28                      VARCHAR2(4000),
    ATTRIBUTE29                      VARCHAR2(4000),
    ATTRIBUTE30                      VARCHAR2(4000),
    PLANNING_FACTOR                  NUMBER        ,
    QUANTITY_RELATED                 NUMBER        ,
    SO_BASIS                         NUMBER        ,
    OPTIONAL                         NUMBER        ,
    MUTUALLY_EXCLUSIVE_OPTIONS       NUMBER        ,
    CHECK_ATP                        NUMBER        ,
    SHIPPING_ALLOWED                 NUMBER        ,
    REQUIRED_TO_SHIP                 NUMBER        ,
    REQUIRED_FOR_REVENUE             NUMBER        ,
    INCLUDE_ON_SHIP_DOCS             NUMBER        ,
    INCLUDE_ON_BILL_DOCS             NUMBER        ,
    LOW_QUANTITY                     NUMBER        ,
    HIGH_QUANTITY                    NUMBER        ,
    ACD_TYPE                         NUMBER        ,
    OLD_COMPONENT_SEQUENCE_ID        NUMBER(18, 0) ,
    COMPONENT_SEQUENCE_ID            NUMBER(18, 0) ,
    BILL_SEQUENCE_ID                 NUMBER(18, 0) ,
    REQUEST_ID                       NUMBER(18, 0) ,
    WIP_SUPPLY_TYPE                  NUMBER        ,
    PICK_COMPONENTS                  NUMBER        ,
    SUPPLY_SUBINVENTORY              VARCHAR2(40)  ,
    SUPPLY_LOCATOR_ID                NUMBER(18, 0) ,
    OPERATION_LEAD_TIME_PERCENT      NUMBER        ,
    REVISED_ITEM_SEQUENCE_ID         NUMBER        ,
    BOM_ITEM_TYPE                    NUMBER        ,
    FROM_END_ITEM_UNIT_NUMBER        VARCHAR2(120) ,
    TO_END_ITEM_UNIT_NUMBER          VARCHAR2(120) ,
    COMPONENT_ITEM_REVISION_ID       NUMBER        ,
    ORIGINAL_SYSTEM_REFERENCE        VARCHAR2(200) ,
    DELETE_GROUP_NAME                VARCHAR2(40)  ,
    DG_DESCRIPTION                   VARCHAR2(960) ,
    ENFORCE_INT_REQUIREMENTS         NUMBER        ,
    OPTIONAL_ON_MODEL                NUMBER        ,
    PARENT_BILL_SEQ_ID               NUMBER        ,
    MODEL_COMP_SEQ_ID                NUMBER        ,
    PLAN_LEVEL                       NUMBER        ,
    AUTO_REQUEST_MATERIAL            VARCHAR2(4)   ,
    SUGGESTED_VENDOR_NAME            VARCHAR2(960) ,
    VENDOR_ID                        NUMBER(18, 0) ,
    UNIT_PRICE                       NUMBER        ,
    OBJ_NAME                         VARCHAR2(120) ,
    PK1_VALUE                        VARCHAR2(960) ,
    PK2_VALUE                        VARCHAR2(960) ,
    PK3_VALUE                        VARCHAR2(960) ,
    PK4_VALUE                        VARCHAR2(960) ,
    PK5_VALUE                        VARCHAR2(960) ,
    FROM_END_ITEM_REV_ID             NUMBER(18, 0) ,
    TO_END_ITEM_REV_ID               NUMBER(18, 0) ,
    BASIS_TYPE                       NUMBER        ,
    COMMON_COMPONENT_SEQUENCE_ID     NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)  ,
    PROGRAM_NAME                     VARCHAR2(120) ,
    PROGRAM_APP_NAME                 VARCHAR2(200) ,
    JOB_DEFINITION_NAME              VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE           VARCHAR2(3600),
    CHANGE_LINE_ID                   NUMBER        ,
    VERSION_ID                       NUMBER        ,
    CHANGE_BIT_MAP                   VARCHAR2(1680),
    ATTRIBUTE_NUMBER1                NUMBER        ,
    ATTRIBUTE_NUMBER2                NUMBER        ,
    ATTRIBUTE_NUMBER3                NUMBER        ,
    ATTRIBUTE_NUMBER4                NUMBER        ,
    ATTRIBUTE_NUMBER5                NUMBER        ,
    ATTRIBUTE_NUMBER6                NUMBER        ,
    ATTRIBUTE_NUMBER7                NUMBER        ,
    ATTRIBUTE_NUMBER8                NUMBER        ,
    ATTRIBUTE_NUMBER9                NUMBER        ,
    ATTRIBUTE_NUMBER10               NUMBER        ,
    ATTRIBUTE_DATE1                  DATE          ,
    ATTRIBUTE_DATE2                  DATE          ,
    ATTRIBUTE_DATE3                  DATE          ,
    ATTRIBUTE_DATE4                  DATE          ,
    ATTRIBUTE_DATE5                  DATE          ,
    ATTRIBUTE_TIMESTAMP1             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP2             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP3             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP4             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP5             TIMESTAMP(6)  ,
    REPLACED_FOR_COMPONENT           NUMBER(18, 0) ,
    REPLACED_BY_COMPONENT            NUMBER(18, 0) ,
    REPLACED_FOR_COMP_SEQ_ID         NUMBER(18, 0) ,
    USE_PLACEHOLDER                  NUMBER        ,
    SUGGESTED_OPERATION_SEQ_NUM      NUMBER        ,
    COMPONENT_TYPE                   VARCHAR2(120) ,
    PRODUCT_TYPE                     VARCHAR2(120) ,
    COMP_ALTERNATE_BOM_DESIGNATOR    VARCHAR2(320) ,
    ABSOLUTE_YIELD                   NUMBER        ,
    CONTRIBUTE_TO_YIELD              VARCHAR2(120) ,
    PERCENT_BATCH                    NUMBER        ,
    PERCENT_FORMULA                  NUMBER        ,
    COMPLETION_TYPE                  VARCHAR2(120) ,
    AUDIT_ACTION_TYPE_               VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_            VARCHAR2(4000),
    AUDIT_IMPERSONATOR_              VARCHAR2(256) ,
    OPERATION_SEQ_NUM                NUMBER        ,
    PRIMARY_UOM_CODE                 VARCHAR2(12)  ,
    SHOW_IN_SALES                    NUMBER        ,
    INSTANTIABILITY_CODE             VARCHAR2(120) ,
    CHANGE_ID                        NUMBER        ,
    LAST_UPDATE_DATE                 TIMESTAMP(6)  ,
    LAST_UPDATED_BY                  VARCHAR2(256) ,
    CREATION_DATE                    TIMESTAMP(6)  ,
    CREATED_BY                       VARCHAR2(256) ,
    LAST_UPDATE_LOGIN                VARCHAR2(128) ,
    ITEM_NUM                         NUMBER        ,
    COMPONENT_QUANTITY               NUMBER        ,
    COMPONENT_YIELD_FACTOR           NUMBER        ,
    COMPONENT_REMARKS                VARCHAR2(4000),
    EFFECTIVITY_DATE                 DATE          ,
    IMPLEMENTATION_DATE              DATE          ,
    DISABLE_DATE                     DATE          ,
    ATTRIBUTE_CATEGORY               VARCHAR2(120) ,
    ATTRIBUTE1                       VARCHAR2(600) ,
    ATTRIBUTE2                       VARCHAR2(600) ,
    ATTRIBUTE3                       VARCHAR2(600) ,
    ATTRIBUTE4                       VARCHAR2(600) ,
    ATTRIBUTE5                       VARCHAR2(600) ,
    ATTRIBUTE6                       VARCHAR2(600) ,
    ATTRIBUTE7                       VARCHAR2(600) ,
    ATTRIBUTE8                       VARCHAR2(600) ,
    ATTRIBUTE9                       VARCHAR2(600) ,
    ATTRIBUTE10                      VARCHAR2(600) ,
    ATTRIBUTE11                      VARCHAR2(600) ,
    ATTRIBUTE12                      VARCHAR2(600) ,
    ATTRIBUTE13                      VARCHAR2(600) ,
    ATTRIBUTE14                      VARCHAR2(600) ,
    ATTRIBUTE15                      VARCHAR2(600) ,
    ATTRIBUTE16                      VARCHAR2(600) ,
    ATTRIBUTE17                      VARCHAR2(600) ,
    ATTRIBUTE18                      VARCHAR2(600) ,
    ATTRIBUTE19                      VARCHAR2(600) ,
    ATTRIBUTE20                      VARCHAR2(600) ,
    ATTRIBUTE21                      VARCHAR2(600) ,
    ATTRIBUTE22                      VARCHAR2(600) ,
    ATTRIBUTE23                      VARCHAR2(600) ,
    ATTRIBUTE24                      VARCHAR2(600) ,
    ATTRIBUTE25                      VARCHAR2(600) ,
    ATTRIBUTE26                      VARCHAR2(4000),
    ATTRIBUTE27                      VARCHAR2(4000),
    ATTRIBUTE28                      VARCHAR2(4000),
    ATTRIBUTE29                      VARCHAR2(4000),
    ATTRIBUTE30                      VARCHAR2(4000),
    PLANNING_FACTOR                  NUMBER        ,
    QUANTITY_RELATED                 NUMBER        ,
    SO_BASIS                         NUMBER        ,
    OPTIONAL                         NUMBER        ,
    MUTUALLY_EXCLUSIVE_OPTIONS       NUMBER        ,
    CHECK_ATP                        NUMBER        ,
    SHIPPING_ALLOWED                 NUMBER        ,
    REQUIRED_TO_SHIP                 NUMBER        ,
    REQUIRED_FOR_REVENUE             NUMBER        ,
    INCLUDE_ON_SHIP_DOCS             NUMBER        ,
    INCLUDE_ON_BILL_DOCS             NUMBER        ,
    LOW_QUANTITY                     NUMBER        ,
    HIGH_QUANTITY                    NUMBER        ,
    ACD_TYPE                         NUMBER        ,
    OLD_COMPONENT_SEQUENCE_ID        NUMBER(18, 0) ,
    COMPONENT_SEQUENCE_ID            NUMBER(18, 0) ,
    BILL_SEQUENCE_ID                 NUMBER(18, 0) ,
    REQUEST_ID                       NUMBER(18, 0) ,
    WIP_SUPPLY_TYPE                  NUMBER        ,
    PICK_COMPONENTS                  NUMBER        ,
    SUPPLY_SUBINVENTORY              VARCHAR2(40)  ,
    SUPPLY_LOCATOR_ID                NUMBER(18, 0) ,
    OPERATION_LEAD_TIME_PERCENT      NUMBER        ,
    REVISED_ITEM_SEQUENCE_ID         NUMBER        ,
    BOM_ITEM_TYPE                    NUMBER        ,
    FROM_END_ITEM_UNIT_NUMBER        VARCHAR2(120) ,
    TO_END_ITEM_UNIT_NUMBER          VARCHAR2(120) ,
    COMPONENT_ITEM_REVISION_ID       NUMBER        ,
    ORIGINAL_SYSTEM_REFERENCE        VARCHAR2(200) ,
    DELETE_GROUP_NAME                VARCHAR2(40)  ,
    DG_DESCRIPTION                   VARCHAR2(960) ,
    ENFORCE_INT_REQUIREMENTS         NUMBER        ,
    OPTIONAL_ON_MODEL                NUMBER        ,
    PARENT_BILL_SEQ_ID               NUMBER        ,
    MODEL_COMP_SEQ_ID                NUMBER        ,
    PLAN_LEVEL                       NUMBER        ,
    AUTO_REQUEST_MATERIAL            VARCHAR2(4)   ,
    SUGGESTED_VENDOR_NAME            VARCHAR2(960) ,
    VENDOR_ID                        NUMBER(18, 0) ,
    UNIT_PRICE                       NUMBER        ,
    OBJ_NAME                         VARCHAR2(120) ,
    PK1_VALUE                        VARCHAR2(960) ,
    PK2_VALUE                        VARCHAR2(960) ,
    PK3_VALUE                        VARCHAR2(960) ,
    PK4_VALUE                        VARCHAR2(960) ,
    PK5_VALUE                        VARCHAR2(960) ,
    FROM_END_ITEM_REV_ID             NUMBER(18, 0) ,
    TO_END_ITEM_REV_ID               NUMBER(18, 0) ,
    BASIS_TYPE                       NUMBER        ,
    COMMON_COMPONENT_SEQUENCE_ID     NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)  ,
    PROGRAM_NAME                     VARCHAR2(120) ,
    PROGRAM_APP_NAME                 VARCHAR2(200) ,
    JOB_DEFINITION_NAME              VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE           VARCHAR2(3600),
    CHANGE_LINE_ID                   NUMBER        ,
    VERSION_ID                       NUMBER        ,
    CHANGE_BIT_MAP                   VARCHAR2(1680),
    ATTRIBUTE_NUMBER1                NUMBER        ,
    ATTRIBUTE_NUMBER2                NUMBER        ,
    ATTRIBUTE_NUMBER3                NUMBER        ,
    ATTRIBUTE_NUMBER4                NUMBER        ,
    ATTRIBUTE_NUMBER5                NUMBER        ,
    ATTRIBUTE_NUMBER6                NUMBER        ,
    ATTRIBUTE_NUMBER7                NUMBER        ,
    ATTRIBUTE_NUMBER8                NUMBER        ,
    ATTRIBUTE_NUMBER9                NUMBER        ,
    ATTRIBUTE_NUMBER10               NUMBER        ,
    ATTRIBUTE_DATE1                  DATE          ,
    ATTRIBUTE_DATE2                  DATE          ,
    ATTRIBUTE_DATE3                  DATE          ,
    ATTRIBUTE_DATE4                  DATE          ,
    ATTRIBUTE_DATE5                  DATE          ,
    ATTRIBUTE_TIMESTAMP1             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP2             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP3             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP4             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP5             TIMESTAMP(6)  ,
    AUDIT_ACTION_TYPE_               VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_            VARCHAR2(4000),
    REPLACED_FOR_COMPONENT           NUMBER(18, 0) ,
    REPLACED_BY_COMPONENT            NUMBER(18, 0) ,
    REPLACED_FOR_COMP_SEQ_ID         NUMBER(18, 0) ,
    USE_PLACEHOLDER                  NUMBER        ,
    AUDIT_IMPERSONATOR_              VARCHAR2(256) ,
    SUGGESTED_OPERATION_SEQ_NUM      NUMBER        ,
    COMPONENT_TYPE                   VARCHAR2(120) ,
    PRODUCT_TYPE                     VARCHAR2(120) ,
    COMP_ALTERNATE_BOM_DESIGNATOR    VARCHAR2(320) ,
    ABSOLUTE_YIELD                   NUMBER        ,
    CONTRIBUTE_TO_YIELD              VARCHAR2(120) ,
    PERCENT_BATCH                    NUMBER        ,
    PERCENT_FORMULA                  NUMBER        ,
    COMPLETION_TYPE                  VARCHAR2(120) ,
    CONSTRAINT pk_egp_components_b_ PRIMARY KEY (LAST_UPDATE_DATE, LAST_UPDATED_BY, COMPONENT_SEQUENCE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, COMPONENT_SEQUENCE_ID)
);
