EGO_REVISED_COMPONENTS
EGO_REVISED_COMPONENTS stores information about the implemented and cancelled revised components on an engineering change order. When an ECO or revised item is implemented or cancelled, the revised component records in EGP_COMPONENTS_B are copied into ENG_REVISED_COMPONENTS to maintain a history of the ECO.
Details
-
Schema: FUSION
-
Object owner: EGO
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ENG_REVISED_COMPONENTS_PK |
COMPONENT_SEQUENCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COMPONENT_SEQUENCE_ID | NUMBER | 18 | Yes | Sequence id of the Component Item. This column points to the ID of Components table. | |
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Unit which is primarily used to measure quantities of the item. | ||
| INSTANTIABILITY_CODE | VARCHAR2 | 30 | Indicates the instance usage of a component item in a model item structure. | ||
| SHOW_IN_SALES | NUMBER | Show in Sales is displayed for model structures. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CHANGE_ID | NUMBER | 18 | Yes | Engineering change order number | |
| CHANGE_LINE_ID | NUMBER | Yes | Engineering change revised line identifier | ||
| COMPONENT_ITEM_ID | NUMBER | 18 | Yes | Item Identifier of the component item | |
| OPERATION_SEQUENCE_NUM | NUMBER | Yes | A number that orders component operations in a routing relative to each other. | ||
| BILL_SEQUENCE_ID | NUMBER | 18 | Yes | Bill of material unique identifier | |
| EFFECTIVITY_DATE | DATE | Yes | Start Effective Date of the Component | ||
| COMPONENT_QUANTITY | NUMBER | Yes | Quantity of component in bill of material | ||
| COMPONENT_YIELD_FACTOR | NUMBER | Yes | Factor used to multiply component quantity with to obtain required component quantity | ||
| CANCELLATION_DATE | DATE | Date when the ECO, revised item, or revised component was cancelled | |||
| CANCEL_COMMENTS | VARCHAR2 | 240 | Cancellation Comments for the revised component | ||
| OLD_COMPONENT_SEQUENCE_ID | NUMBER | 18 | Identifier of component that is being disabled or changed | ||
| ITEM_NUM | NUMBER | Item sequence within bill of material structure | |||
| WIP_SUPPLY_TYPE | NUMBER | WIP supply type code. A bill of material component field that controls issue transactions from inventory to work in process | |||
| COMPONENT_REMARKS | VARCHAR2 | 240 | Remarks or comments related to the component | ||
| SUPPLY_SUBINVENTORY | VARCHAR2 | 10 | Subdivision of an organization, representing either a physical area or a logical grouping of items, such as a storeroom or receiving dock. | ||
| SUPPLY_LOCATOR_ID | NUMBER | Physical area within a sub inventory where you store material, such as a row, aisle, bin, or shelf. | |||
| IMPLEMENTATION_DATE | DATE | Date on which engineering change order was implemented | |||
| DISABLE_DATE | DATE | Date on which the component is disabled | |||
| ACD_TYPE | NUMBER | Code indicating whether component is being added, changed, or disabled | |||
| PLANNING_FACTOR | NUMBER | Yes | Factor used to multiply component quantity with to obtain required planning quantity | ||
| QUANTITY_RELATED | NUMBER | Yes | Code to indicate if this component has quantity related reference designators | ||
| SO_BASIS | NUMBER | Quantity basis used by Oracle Order Management to overide the default quantity for an option class in a sales order | |||
| OPTIONAL | NUMBER | Flag indicating if component is optional in bill | |||
| MUTUALLY_EXCLUSIVE_OPTIONS | NUMBER | Flag indicating if one or more children of a component can be picked when taking an order | |||
| INCLUDE_IN_COST_ROLLUP | NUMBER | Yes | Flag indicating if this component is to be used when rolling up costs | ||
| CHECK_ATP | NUMBER | Yes | Flag indicating if ATP check is required | ||
| SHIPPING_ALLOWED | NUMBER | Flag indicating if component is allowed to ship | |||
| REQUIRED_TO_SHIP | NUMBER | Flag indicating if component is required to ship | |||
| REQUIRED_FOR_REVENUE | NUMBER | Flag indicating if component is required for revenue | |||
| INCLUDE_ON_SHIP_DOCS | NUMBER | Flag indicating if component is displayed on shipping documents | |||
| INCLUDE_ON_BILL_DOCS | NUMBER | Flag indicating if component is included on billing documents | |||
| LOW_QUANTITY | NUMBER | Minimum quantity allowed on an order | |||
| HIGH_QUANTITY | NUMBER | Maximum quantity allowed on an order | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PICK_COMPONENTS | NUMBER | No longer used. | |||
| COST_FACTOR | NUMBER | No longer used. | |||
| FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | From End Item Unit Number. Unit number at the beginning of the end item (or root item) unit number range during which a given record is available. | ||
| TO_END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | Unit number at the end of the end item (or root item) unit number range during which a given record is available. | ||
| ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | 50 | Original system that data for the current record has come from. | ||
| ECO_FOR_PRODUCTION | NUMBER | WIP (Work in progress) Only ECO. | |||
| ENFORCE_INT_REQUIREMENTS | NUMBER | Enforce internal requirements. Indicates the instance usage of a component item in a model item structure. | |||
| OPTIONAL_ON_MODEL | NUMBER | Flag indicating if component is optional on model bill (for ATO) | |||
| PLAN_LEVEL | NUMBER | Plan level based on model bill (for ATO) | |||
| AUTO_REQUEST_MATERIAL | VARCHAR2 | 1 | Flag to indicate if the item is automatically requested or not | ||
| FROM_OBJECT_REVISION_ID | NUMBER | From object revision id. No longer used. | |||
| TO_OBJECT_REVISION_ID | NUMBER | No longer used. | |||
| COMPONENT_ITEM_REVISION_ID | NUMBER | Item revision Identifier of the component | |||
| VENDOR_ID | NUMBER | Suggested Vendor Identifier column | |||
| SUGGESTED_VENDOR_NAME | VARCHAR2 | 240 | Suggested vendor name will be used for direct items for EAM BOMs | ||
| UNIT_PRICE | NUMBER | Unit Price for direct items used by EAM BOMs | |||
| FROM_END_ITEM_REV_ID | NUMBER | Revision Id of End Item (or root item) | |||
| TO_END_ITEM_REV_ID | NUMBER | Revision at the end of the end item (or root item) revision range during which a given record is available. | |||
| FROM_END_ITEM_MINOR_REV_ID | NUMBER | From end item minor revision id | |||
| TO_END_ITEM_MINOR_REV_ID | NUMBER | Minor Revision at the end of the end item (or root item) revision range during which a given record is available. | |||
| MODEL_COMP_SEQ_ID | NUMBER | Component sequence identifier from model bill (for ATO) | |||
| PARENT_BILL_SEQ_ID | NUMBER | Parent bill of material sequence id | |||
| BASIS_TYPE | NUMBER | Identifies component usage as fixed or variable. You can specify component usage as a fixed rate per job for activities such as setup and tear down, and variable rates for components whose usage depends on the number of units processed. For lot based components you choose the Lot basis type and your usage rate is fixed, and for item based components you choose the Item basis type to indicate that your usage rate is variable. | |||
| COMMON_COMPONENT_SEQUENCE_ID | NUMBER | Sequence id of the Component Item. This is the ID column of the table EGP_COMPONENTS_B | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Identifies the concurrent program. | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Identifies the Application name spawning the Concurrent Request. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| PK1_VALUE | VARCHAR2 | 240 | Identifier representing inventory_item_id of the item | ||
| PK2_VALUE | VARCHAR2 | 240 | Identifier representing Organization_id of the item | ||
| PK3_VALUE | VARCHAR2 | 240 | Used to refer any other identifiers from other tables | ||
| PK4_VALUE | VARCHAR2 | 240 | Used to refer any other identifiers from other tables | ||
| PK5_VALUE | VARCHAR2 | 240 | Used to refer any other identifiers from other tables | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| OBJ_NAME | VARCHAR2 | 120 | Yes | Name of the object. Contains values like EGO_ITEM etc., | |
| OPERATION_SEQ_NUM | NUMBER | Yes | Operation sequence number. A number that orders component operations in a routing relative to each other. | ||
| OPERATION_LEAD_TIME_PERCENT | NUMBER | Operation Lead Time. Operation offset from first operation in routing (denormalized from corresponding column in BOM_OPERATION_SEQUNCES) | |||
| BOM_ITEM_TYPE | NUMBER | Type of item (denormalized from BOM Item Type in EGP_SYSTEM_ITEMS) | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| VERSION_ID | NUMBER | Yes | Under a version control env this column represents the version id of this component | ||
| DELETE_GROUP_NAME | VARCHAR2 | 10 | Delete group name for the entity type you are deleting | ||
| DG_DESCRIPTION | VARCHAR2 | 240 | Description of the delete group | ||
| REVISED_ITEM_SEQUENCE_ID | NUMBER | Engineering change order revised item identifier | |||
| CHANGE_BIT_MAP | VARCHAR2 | 420 | Bit Map of the changed attributes | ||
| REPLACED_FOR_COMPONENT | NUMBER | 18 | The inventory item of the component which is replaced by the current component. | ||
| REPLACED_BY_COMPONENT | NUMBER | 18 | The inventory item of the component which is replacing the current component. | ||
| REPLACED_FOR_COMP_SEQ_ID | NUMBER | 18 | The component sequence id of the component which was replaced. | ||
| SUGGESTED_OPERATION_SEQ_NUM | NUMBER | Operation sequence number suggested by the design engineer to be included in work definition. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| EGO_REVISED_COMPONENTS | ego_engineering_changes_b | CHANGE_ID |
| EGO_REVISED_COMPONENTS | ego_change_lines_b | CHANGE_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EGO_REVISED_COMPONENTS_N1 | Non Unique | FUSION_TS_TX_DATA | CHANGE_ID, BILL_SEQUENCE_ID |
| EGO_REVISED_COMPONENTS_N2 | Non Unique | FUSION_TS_TX_DATA | COMPONENT_ITEM_ID |
| EGO_REVISED_COMPONENTS_N3 | Non Unique | FUSION_TS_TX_DATA | CHANGE_LINE_ID |
| EGO_REVISED_COMPONENTS_PK | Unique | FUSION_TS_TX_DATA | COMPONENT_SEQUENCE_ID |