1. Tables and Views for SCM
  2. EGP_SUB_COMPS_INTERFACE

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