EGP_SUB_COMPS_INTERFACE
EGP_SUB_COMPS_INTERFACE temporarily stores information about the substitute components associated with a bill of material component. This table is shared by the Bills of Material and Engineering Change Order open interfaces. This table contains user friendly columns which allow you to easily enter your data as well as their corresponding foreign keys. The open interfaces will derive column values you do not enter, after performing the proper validation. For example, you enter the ORGANIZATION_CODE, and the open interfaces will fill in the corresponding ORGANIZATION_ID for you. . Also, you can enter ASSEMBLY_ITEM_ID, ORGANIZATION_ID and ALTERNATE_BOM_DESIGNATOR instead of BILL_SEQUENCE_ID. The open interfaces will fill in the corresponding BILL_SEQUENCE_ID. . In addition, you can enter BILL_SEQUENCE_ID, COMPONENT_ITEM_ID, OPERATION_SEQ_NUM, and EFFECTIVITY_DATE instead of COMPONENT_SEQUENCE_ID. The open interfaces will fill in the corresponding COMPONENT_SEQUENCE_ID.
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Comments | Status |
---|---|---|---|---|---|
SUBSTITUTE_COMPONENT_ID | NUMBER | 18 | Inventory item identifier of substitute component | Active | |
PREPROCESS_THREAD_NUMBER | NUMBER | 18 | PreProcess Thread Number for interface processing | ||
ITEM_TRANSACTION_ID | NUMBER | 18 | Item Transaction Id of the Parent Assembly Item | ||
LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | Active | |
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | Active | ||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | Active | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | |
SUBSTITUTE_ITEM_QUANTITY | NUMBER | Number of substitute components needed to replace the full component quantity. | Active | ||
COMPONENT_SEQUENCE_ID | NUMBER | 18 | Sequence id of the Component Item | Active | |
ACD_TYPE | NUMBER | Add or delete code from an engineering change order | Active | ||
CHANGE_NOTICE | VARCHAR2 | 10 | Engineering change order number | Active | |
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | |
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Active | |
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |
BILL_SEQUENCE_ID | NUMBER | 18 | Bill of material unique identifier | Active | |
ASSEMBLY_ITEM_ID | NUMBER | 18 | Inventory item identifier of the bill | Active | |
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | 80 | Alternate BOM Designator Code to identify the structure type | Active | |
ORGANIZATION_ID | NUMBER | 18 | Organization Identifier of the component | Active | |
COMPONENT_ITEM_ID | NUMBER | 18 | Identifier of the Component Item | Active | |
OPERATION_SEQ_NUM | NUMBER | Operation Sequence Number of the Component Item | Active | ||
EFFECTIVITY_DATE | DATE | Start Effective Date of the Component | Active | ||
TRANSACTION_ID | NUMBER | 18 | Row identifier. Identifier used for tracking the transaction during import/data load process | Active | |
PROCESS_STATUS | NUMBER | 18 | Row Status for the Import and Data Load Jobs | Active | |
ORGANIZATION_CODE | VARCHAR2 | 18 | Abbreviation of organization name | Active | |
SUBSTITUTE_COMP_NUMBER | VARCHAR2 | 820 | Concatenated item segments of the substitute component | Active | |
COMPONENT_ITEM_NUMBER | VARCHAR2 | 820 | Concatenated item segments of the component | Active | |
ASSEMBLY_ITEM_NUMBER | VARCHAR2 | 820 | Concatenated item segments of the bill | Active | |
NEW_SUB_COMP_ID | NUMBER | 18 | Updated value for the SUBSTITUTE_COMPONENT_ID | Active | |
NEW_SUB_COMP_NUMBER | VARCHAR2 | 820 | Updated value for the SUBSTITUTE_COMP_NUMBER | Active | |
INTERFACE_ENTITY_TYPE | VARCHAR2 | 4 | Record used for Bill or ECO Open Interface: BILL, ECO | Active | |
TRANSACTION_TYPE | VARCHAR2 | 10 | Type of action: CREATE, UPDATE or DELETE | Active | |
BOM_SUB_COMPS_IFCE_KEY | VARCHAR2 | 30 | User defined identifier to link rows pertaining to the same business object | Active | |
BOM_INVENTORY_COMPS_IFCE_KEY | VARCHAR2 | 30 | User defined identifier to link rows pertaining to the same business object | Active | |
ENG_REVISED_ITEMS_IFCE_KEY | VARCHAR2 | 30 | User defined identifier to link rows pertaining to the same business object | Active | |
ENG_CHANGES_IFCE_KEY | VARCHAR2 | 30 | User defined identifier to link rows pertaining to the same business object | Active | |
FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | 240 | Unit Number of the From End Item. From End Item Unit Number | Active | |
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | 240 | Original system that data for the current record has come from | Active | |
ENFORCE_INT_REQUIREMENTS | VARCHAR2 | 80 | Enforce integer requirement for substitute component's calculated quantity or inverse quantity. | Active | |
NEW_REVISED_ITEM_REVISION | VARCHAR2 | 3 | New Revised Item Revision is one of the unique keys to identify a revised item of a change | Active | |
RETURN_STATUS | VARCHAR2 | 1 | No longer used. | Active | |
BATCH_ID | NUMBER | 18 | A unique identifier of an item batch. Batch Identifier for Data Load | Active | |
COMP_SOURCE_SYSTEM_REFERENCE | VARCHAR2 | 255 | Component Source System Item Name | Active | |
PARENT_SOURCE_SYSTEM_REFERENCE | VARCHAR2 | 255 | Parent Source System Reference Number | Active | |
SUBCOM_SOURCE_SYSTEM_REFERENCE | VARCHAR2 | 255 | Subcomponent Source System Item Name | Active | |
CHANGE_ID | NUMBER | 18 | A unique identifier of a change order. | Active | |
SUB_COMP_INVERSE_QUANTITY | NUMBER | Inverse Quantity of substitute component in bill of material | Active | ||
CHANGE_TRANSACTION_TYPE | VARCHAR2 | 10 | Change Management Transaction Type for Change Orders | Active | |
ASSEMBLY_ITEM_REVISION_CODE | VARCHAR2 | 240 | Revision code of the Assembly Item | Active | |
ASSEMBLY_ITEM_REVISION_ID | NUMBER | 18 | Revision id of the Assembly Item | Active | |
OBJECT_VERSION_NUMBER | NUMBER | 9 | 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. | Active | |
PROGRAM_NAME | VARCHAR2 | 30 | Identifies the concurrent program. | Active | |
PROGRAM_APP_NAME | VARCHAR2 | 50 | Identifies the Application name spawning the Concurrent Request. | Active | |
THREAD_NUMBER | NUMBER | 18 | Thread Number for interface processing | Active | |
INTERFACE_TABLE_UNIQUE_ID | NUMBER | 18 | Interface Table Unique Identifier for Substitute Component's interface rows | Active | |
COMPONENT_TRANSACTION_ID | NUMBER | 18 | Transaction ID of the Component Item | Active | |
PHASE_NUMBER | NUMBER | 18 | Phase Number identifer for Import. | Active | |
SUB_COMP_SEQUENCE_ID | NUMBER | 18 | Substitute Component Sequence Id | Active | |
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. | |||
BATCH_NUMBER | VARCHAR2 | 40 | Unique identifier of the batch that is used for item import. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Request Identifier used for Data Load | ||
EFFECTIVITY_CONTROL | NUMBER | For internal use. Stores the effectivity_control of parent header. | |||
INTERFACE_DATA_TYPE | VARCHAR2 | 100 | Data type of record. Values-BATCH/SUPPLIER_STAGE/SPOKE_STAGE | ||
SUPPLIER_ID | NUMBER | 18 | Unique identifier for supplier in case of supplier stage record |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
EGP_SUB_COMPS_INTERFACE_N1 | Non Unique | FUSION_TS_INTERFACE | COMPONENT_SEQUENCE_ID, SUBSTITUTE_COMPONENT_ID | Active |
EGP_SUB_COMPS_INTERFACE_N2 | Non Unique | FUSION_TS_INTERFACE | ORGANIZATION_ID, ASSEMBLY_ITEM_ID, ALTERNATE_BOM_DESIGNATOR | Active |
EGP_SUB_COMPS_INTERFACE_N3 | Non Unique | FUSION_TS_INTERFACE | TRANSACTION_ID | Active |
EGP_SUB_COMPS_INTERFACE_N4 | Non Unique | FUSION_TS_INTERFACE | ASSEMBLY_ITEM_NUMBER, ORGANIZATION_ID, BOM_SUB_COMPS_IFCE_KEY | Active |
EGP_SUB_COMPS_INTERFACE_N5 | Non Unique | FUSION_TS_INTERFACE | ASSEMBLY_ITEM_NUMBER, ORGANIZATION_CODE, ALTERNATE_BOM_DESIGNATOR | Active |
EGP_SUB_COMPS_INTERFACE_N6 | Non Unique | FUSION_TS_INTERFACE | ENG_CHANGES_IFCE_KEY | Active |
EGP_SUB_COMPS_INTERFACE_N7 | Non Unique | Default | BATCH_NUMBER | |
EGP_SUB_COMPS_INTERFACE_N8 | Non Unique | Default | LOAD_REQUEST_ID |