CREATE TABLE egp_item_where_used (
    BATCH_ID                          NUMBER(18, 0) ,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    IMPLODED_COMPONENT_ID             NUMBER(18, 0)     NOT NULL,
    IMPLODED_COMP_ORG_ID              NUMBER(18, 0) ,
    SEQUENCE_ID                       NUMBER(18, 0) ,
    CURRENT_LEVEL                     NUMBER            NOT NULL,
    NODE_SEQUENCE                     NUMBER(18, 0) ,
    SORT_CODE                         VARCHAR2(4000),
    CURRENT_OBJ_NAME                  VARCHAR2(200)     NOT NULL,
    CURRENT_PK1_VALUE                 NUMBER(18, 0)     NOT NULL,
    CURRENT_PK2_VALUE                 NUMBER(18, 0) ,
    CURRENT_PK3_VALUE                 NUMBER(18, 0) ,
    CURRENT_PK4_VALUE                 NUMBER(18, 0) ,
    CURRENT_PK5_VALUE                 NUMBER(18, 0) ,
    PARENT_SORT_CODE                  VARCHAR2(4000),
    PARENT_OBJ_NAME                   VARCHAR2(200) ,
    PARENT_PK1_VALUE                  NUMBER(18, 0) ,
    PARENT_PK2_VALUE                  NUMBER(18, 0) ,
    PARENT_PK3_VALUE                  NUMBER(18, 0) ,
    PARENT_PK4_VALUE                  NUMBER(18, 0) ,
    PARENT_PK5_VALUE                  NUMBER(18, 0) ,
    ALTERNATE_DESIGNATOR_ID           NUMBER(18, 0) ,
    COMPONENT_PATH                    VARCHAR2(4000),
    COMPONENT_SEQUENCE_ID             NUMBER(18, 0) ,
    OPERATION_SEQ_NUM                 NUMBER        ,
    EFFECTIVITY_DATE                  TIMESTAMP(6)  ,
    DISABLE_DATE                      TIMESTAMP(6)  ,
    FROM_END_ITEM_UNIT_NUMBER         VARCHAR2(120) ,
    TO_END_ITEM_UNIT_NUMBER           VARCHAR2(120) ,
    FROM_END_ITEM_SERIAL_NUMBER       VARCHAR2(120) ,
    TO_END_ITEM_SERIAL_NUMBER         VARCHAR2(120) ,
    FROM_END_ITEM_REVISION            VARCHAR2(72)  ,
    TO_END_ITEM_REVISION              VARCHAR2(72)  ,
    EFFECTIVITY_CONTROL               NUMBER        ,
    COMPONENT_QUANTITY                NUMBER        ,
    REVISED_ITEM_SEQUENCE_ID          NUMBER(18, 0) ,
    CHANGE_NOTICE                     VARCHAR2(200) ,
    IMPLEMENTED_FLAG                  VARCHAR2(4)   ,
    TOP_ITEM_FLAG                     VARCHAR2(4)   ,
    LOOP_EXISTS_FLAG                  VARCHAR2(4)   ,
    EXCLUDED_BY_RULE_FLAG             VARCHAR2(4)   ,
    ACCESS_FLAG                       VARCHAR2(4)   ,
    IMPL_FROM_DATE                    TIMESTAMP(6)  ,
    IMPL_TO_DATE                      TIMESTAMP(6)  ,
    IMPL_FROM_END_ITEM_UNIT_NUMBER    VARCHAR2(120) ,
    IMPL_TO_END_ITEM_UNIT_NUMBER      VARCHAR2(120) ,
    COMPONENT_ITEM_REVISION_ID        NUMBER(18, 0) ,
    BASIS_TYPE                        VARCHAR2(320) ,
    ITEM_ICON                         VARCHAR2(120) ,
    CONTEXT_ITEM_ICON                 VARCHAR2(120) ,
    ITEM_NAME                         VARCHAR2(1200),
    ITEM_DESCRIPTION                  VARCHAR2(960) ,
    ORGANIZATION_NAME                 VARCHAR2(960) ,
    ALTERNATE_BOM_DESIGNATOR          VARCHAR2(320) ,
    STRUCTURE_NAME                    VARCHAR2(320) ,
    ITEM_CLASS                        VARCHAR2(1000),
    REVISION                          VARCHAR2(72)  ,
    ITEM_TYPE                         VARCHAR2(320) ,
    INVENTORY_ITEM_STATUS_CODE        VARCHAR2(960) ,
    APPROVAL_STATUS                   VARCHAR2(320) ,
    PRIMARY_UOM_CODE                  VARCHAR2(100) ,
    PEER_FLAG                         VARCHAR2(4)   ,
    BILL_SEQUENCE_ID                  NUMBER(18, 0) ,
    COMP_BILL_SEQUENCE_ID             NUMBER(18, 0) ,
    SCHEDULED_DATE                    TIMESTAMP(6)  ,
    ORGANIZATION_CODE                 VARCHAR2(72)  ,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    SUBSTITUTE_FOR_COMPONENT_ID       NUMBER(18, 0) ,
    SUBSTITUTE_FOR_COMPONENT_NAME     VARCHAR2(1200),
    ITEM_NUM                          NUMBER        ,
    SUGGESTED_OPERATION_SEQ_NUM       NUMBER        ,
    BATCH_ID                          NUMBER(18, 0) ,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    IMPLODED_COMPONENT_ID             NUMBER(18, 0)     NOT NULL,
    IMPLODED_COMP_ORG_ID              NUMBER(18, 0) ,
    SEQUENCE_ID                       NUMBER(18, 0) ,
    CURRENT_LEVEL                     NUMBER            NOT NULL,
    NODE_SEQUENCE                     NUMBER(18, 0) ,
    SORT_CODE                         VARCHAR2(4000),
    CURRENT_OBJ_NAME                  VARCHAR2(200)     NOT NULL,
    CURRENT_PK1_VALUE                 NUMBER(18, 0)     NOT NULL,
    CURRENT_PK2_VALUE                 NUMBER(18, 0) ,
    CURRENT_PK3_VALUE                 NUMBER(18, 0) ,
    CURRENT_PK4_VALUE                 NUMBER(18, 0) ,
    CURRENT_PK5_VALUE                 NUMBER(18, 0) ,
    PARENT_SORT_CODE                  VARCHAR2(4000),
    PARENT_OBJ_NAME                   VARCHAR2(200) ,
    PARENT_PK1_VALUE                  NUMBER(18, 0) ,
    PARENT_PK2_VALUE                  NUMBER(18, 0) ,
    PARENT_PK3_VALUE                  NUMBER(18, 0) ,
    PARENT_PK4_VALUE                  NUMBER(18, 0) ,
    PARENT_PK5_VALUE                  NUMBER(18, 0) ,
    ALTERNATE_DESIGNATOR_ID           NUMBER(18, 0) ,
    COMPONENT_PATH                    VARCHAR2(4000),
    COMPONENT_SEQUENCE_ID             NUMBER(18, 0) ,
    OPERATION_SEQ_NUM                 NUMBER        ,
    EFFECTIVITY_DATE                  TIMESTAMP(6)  ,
    DISABLE_DATE                      TIMESTAMP(6)  ,
    FROM_END_ITEM_UNIT_NUMBER         VARCHAR2(120) ,
    TO_END_ITEM_UNIT_NUMBER           VARCHAR2(120) ,
    FROM_END_ITEM_SERIAL_NUMBER       VARCHAR2(120) ,
    TO_END_ITEM_SERIAL_NUMBER         VARCHAR2(120) ,
    FROM_END_ITEM_REVISION            VARCHAR2(72)  ,
    TO_END_ITEM_REVISION              VARCHAR2(72)  ,
    EFFECTIVITY_CONTROL               NUMBER        ,
    COMPONENT_QUANTITY                NUMBER        ,
    REVISED_ITEM_SEQUENCE_ID          NUMBER(18, 0) ,
    CHANGE_NOTICE                     VARCHAR2(200) ,
    IMPLEMENTED_FLAG                  VARCHAR2(4)   ,
    TOP_ITEM_FLAG                     VARCHAR2(4)   ,
    LOOP_EXISTS_FLAG                  VARCHAR2(4)   ,
    EXCLUDED_BY_RULE_FLAG             VARCHAR2(4)   ,
    ACCESS_FLAG                       VARCHAR2(4)   ,
    IMPL_FROM_DATE                    TIMESTAMP(6)  ,
    IMPL_TO_DATE                      TIMESTAMP(6)  ,
    IMPL_FROM_END_ITEM_UNIT_NUMBER    VARCHAR2(120) ,
    IMPL_TO_END_ITEM_UNIT_NUMBER      VARCHAR2(120) ,
    COMPONENT_ITEM_REVISION_ID        NUMBER(18, 0) ,
    BASIS_TYPE                        VARCHAR2(320) ,
    ITEM_ICON                         VARCHAR2(120) ,
    CONTEXT_ITEM_ICON                 VARCHAR2(120) ,
    ITEM_NAME                         VARCHAR2(1200),
    ITEM_DESCRIPTION                  VARCHAR2(960) ,
    ORGANIZATION_NAME                 VARCHAR2(960) ,
    ALTERNATE_BOM_DESIGNATOR          VARCHAR2(320) ,
    STRUCTURE_NAME                    VARCHAR2(320) ,
    ITEM_CLASS                        VARCHAR2(1000),
    REVISION                          VARCHAR2(72)  ,
    ITEM_TYPE                         VARCHAR2(320) ,
    INVENTORY_ITEM_STATUS_CODE        VARCHAR2(960) ,
    APPROVAL_STATUS                   VARCHAR2(320) ,
    PRIMARY_UOM_CODE                  VARCHAR2(100) ,
    PEER_FLAG                         VARCHAR2(4)   ,
    BILL_SEQUENCE_ID                  NUMBER(18, 0) ,
    COMP_BILL_SEQUENCE_ID             NUMBER(18, 0) ,
    SCHEDULED_DATE                    TIMESTAMP(6)  ,
    ORGANIZATION_CODE                 VARCHAR2(72)  ,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    SUBSTITUTE_FOR_COMPONENT_ID       NUMBER(18, 0) ,
    SUBSTITUTE_FOR_COMPONENT_NAME     VARCHAR2(1200),
    ITEM_NUM                          NUMBER        ,
    SUGGESTED_OPERATION_SEQ_NUM       NUMBER        ,
    CONSTRAINT pk_egp_item_where_used PRIMARY KEY (BATCH_ID, SEQUENCE_ID, SORT_CODE, BATCH_ID, SEQUENCE_ID, SORT_CODE)
);
