1. Tables and Views for SCM
  2. EGP_COMPONENTS_INTERFACE

EGP_COMPONENTS_INTERFACE

EGP_COMPONENTS_INTERFACE temporarily stores information about bill of material components. 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. . You can enter one reference designator and one substitute component for each component you enter. Oracle Bills of Material will insert these records into the tables, EGP_REFERENCE_DESIGNATORS and EGP_SUBSTITUTE_COMPONENTS, respectively.

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Comments Status
OPERATION_SEQ_NUM NUMBER A number that orders component operations in a routing relative to each other. Active
PREPROCESS_THREAD_NUMBER NUMBER 18 PreProcess Thread Number for interface Processing.
PRIMARY_UOM_CODE VARCHAR2 3 Unit which is primarily used to measure quantities of the item.
PRIMARY_UOM_CODE_VALUE VARCHAR2 25 COMPONENT UNIT OF MEASURE VALUE
SHOW_IN_SALES NUMBER Show in Sales is displayed for model structures.
INSTANTIABILITY_CODE VARCHAR2 30 Indicates the instance usage of a component item in a model item structure.
COMPONENT_ITEM_ID NUMBER 18 Item Identifier of the component item Active
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
ITEM_NUM NUMBER Item sequence within bill of material structure Active
COMPONENT_QUANTITY NUMBER Quantity of component in bill of material Active
COMPONENT_YIELD_FACTOR NUMBER Factor used to multiply component quantity to obtain required component quantity Active
COMPONENT_REMARKS VARCHAR2 240 Remarks or comments related to the component Active
EFFECTIVITY_DATE DATE Date at the beginning of the date range during which a given record will be available for transacting for date effective entities. Active
CHANGE_NOTICE VARCHAR2 10 Engineering change order number Active
IMPLEMENTATION_DATE DATE Date on which engineering change order was implemented Active
DISABLE_DATE DATE Date at the end of a date range during which a given record is be available for transacting. Use for date effective entities only. 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 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 4000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
PLANNING_FACTOR NUMBER Factor used to multiply component quantity with to obtain planning quantity Active
QUANTITY_RELATED NUMBER Identifier to indicate if this component has quantity related reference designators Active
SO_BASIS NUMBER Quantity basis used by Oracle Order Management to determine how many units of component to put on an order Active
OPTIONAL NUMBER Flag indicating if component is optional in bill Active
MUTUALLY_EXCLUSIVE_OPTIONS NUMBER Flag indicating if one or more children of component can be picked when taking an order Active
INCLUDE_IN_COST_ROLLUP NUMBER Flag indicating if this component is to be used when rolling up costs Active
CHECK_ATP NUMBER Flag indicating if ATP check is required Active
SHIPPING_ALLOWED NUMBER Flag indicating if component is allowed to ship Active
REQUIRED_TO_SHIP NUMBER Flag indicating if component is required to ship Active
REQUIRED_FOR_REVENUE NUMBER Flag indicating if component is required for revenue Active
INCLUDE_ON_SHIP_DOCS NUMBER Flag indicating if component is displayed on shipping documents Active
INCLUDE_ON_BILL_DOCS NUMBER Attribute indicates whether record should be included in billing documentation, such as invoices. Active
LOW_QUANTITY NUMBER Minimum quantity allowed on an order Active
HIGH_QUANTITY NUMBER Maximum quantity allowed on an order Active
ACD_TYPE NUMBER Add, change, or disable code for component on an engineering change order Active
OLD_COMPONENT_SEQUENCE_ID NUMBER 18 Identifier of original component row that an ECO affects Active
COMPONENT_SEQUENCE_ID NUMBER 18 Sequence id of the Component Item. This is the ID column of the table EGP_COMPONENTS_B Active
BILL_SEQUENCE_ID NUMBER 18 Bill of material unique identifier Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
WIP_SUPPLY_TYPE NUMBER A bill of material component field that controls issue transactions from inventory to work in process. Active
PICK_COMPONENTS NUMBER An indicator that defines an item as a pick to order item. This attribute works in conjunction with structure item type attribute. Active
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. Active
SUPPLY_LOCATOR_ID NUMBER 18 Physical area within a sub inventory where you store material, such as a row, aisle, bin, or shelf. Active
OPERATION_LEAD_TIME_PERCENT NUMBER Operation offset from first operation in routing (Denormalized from corresponding column in BOM_OPERATION_SEQUNCES) Active
REVISED_ITEM_SEQUENCE_ID NUMBER 18 Engineering change order revised item identifier Active
MODEL_COMP_SEQ_ID NUMBER 18 Component sequence identifier from model bill (for ATO) Active
ASSEMBLY_ITEM_ID NUMBER 18 Inventory item identifier of manufactured assembly Active
ALTERNATE_BOM_DESIGNATOR VARCHAR2 80 Unique name given to a specific variation of a Structure type Active
ORGANIZATION_ID NUMBER 18 A organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting. Active
COST_FACTOR NUMBER No longer used. Active
DDF_CONTEXT1 VARCHAR2 30 Context1 Used by the Mass Change. Active
DDF_CONTEXT2 VARCHAR2 30 Context2 Used by the Mass Change. Active
ORGANIZATION_CODE VARCHAR2 18 Abbreviation for organization name Active
COMPONENT_ITEM_NUMBER VARCHAR2 820 Concatenated component item segments Active
ASSEMBLY_ITEM_NUMBER VARCHAR2 820 Concatenated bill item segments Active
REVISED_ITEM_NUMBER VARCHAR2 240 Concatenated revised item segments Active
LOCATION_NAME VARCHAR2 81 Physical area within a sub inventory where you store material, such as a row, aisle, bin, or shelf. Active
REFERENCE_DESIGNATOR VARCHAR2 15 Reference Designators of the Component. Active
SUBSTITUTE_COMP_ID NUMBER 18 Inventory item identifier of the substitute component Active
SUBSTITUTE_COMP_NUMBER VARCHAR2 240 Concatenated item segments of the substitute component Active
TRANSACTION_ID NUMBER 18 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
BOM_ITEM_TYPE NUMBER Type of item (denormalized from BOM Item Type in EGP_SYSTEM_ITEMS) Active
NEW_OPERATION_SEQ_NUM NUMBER Updated value for the operation_seq_num Active
OLD_OPERATION_SEQ_NUM NUMBER Operation sequence number in the original component record that an ECO affects Active
NEW_EFFECTIVITY_DATE DATE Updated value for the effectivity_date Active
OLD_EFFECTIVITY_DATE DATE Value of effective date in the original component record that an ECO affects Active
ASSEMBLY_TYPE NUMBER Assembly type of the parent bill 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_INVENTORY_COMPS_IFCE_KEY VARCHAR2 30 User defined identifier that links rows pertaining to the same business object Active
ENG_REVISED_ITEMS_IFCE_KEY VARCHAR2 30 User defined identifier for linking rows pertaining to the same business object Active
ENG_CHANGES_IFCE_KEY VARCHAR2 30 User defined identifier to link rows corresponding to the same business object Active
FROM_END_ITEM_UNIT_NUMBER VARCHAR2 30 Unit number at the beginning of the end item (or root item) unit number range during which a given record is available. Active
NEW_FROM_END_ITEM_UNIT_NUMBER VARCHAR2 30 New Unit number at the beginning of the end item (or root item) unit number range during which a given record is available. Active
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. Active
DELETE_GROUP_NAME VARCHAR2 10 Delete group name for the entity type you are deleting Active
DG_DESCRIPTION VARCHAR2 240 Description of the delete group Active
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 50 Original system that data for the current record has come from Active
ENFORCE_INT_REQUIREMENTS VARCHAR2 80 Enforce integer requirement for component's calculated quantity or inverse quantity. Active
OPTIONAL_ON_MODEL NUMBER Flag indicating if component is optional on model bill (for ATO) Active
PARENT_BILL_SEQ_ID NUMBER Common bill sequence id of the model bill (for ATO) Active
PLAN_LEVEL NUMBER 18 Plan level based on model bill (for ATO) Active
AUTO_REQUEST_MATERIAL VARCHAR2 1 Auomatically create move order for the material at work order release Active
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. Active
INVERSE_QUANTITY NUMBER Inverse Quantity of component in bill of material Active
SUGGESTED_VENDOR_NAME VARCHAR2 240 Suggested vendor name will be used for direct items for EAM BOMs Active
UNIT_PRICE NUMBER Unit Price for direct items used by EAM BOMs 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
OBJ_NAME VARCHAR2 30 Name of the object. Contains values like EGO_ITEM etc., Active
PK1_VALUE VARCHAR2 240 Identifier representing inventory_item_id of the item Active
PK2_VALUE VARCHAR2 240 Identifier representing Organization_id of the item Active
PK3_VALUE VARCHAR2 240 Used to refer any other identifiers from other tables Active
PK4_VALUE VARCHAR2 240 Used to refer any other identifiers from other tables Active
PK5_VALUE VARCHAR2 240 Used to refer any other identifiers from other tables Active
FROM_OBJECT_REVISION_CODE VARCHAR2 80 No longer used. Active
FROM_OBJECT_REVISION_ID NUMBER 18 No longer used. Active
TO_OBJECT_REVISION_CODE VARCHAR2 240 No longer used. Active
TO_OBJECT_REVISION_ID NUMBER 18 No longer used. Active
FROM_MINOR_REVISION_CODE VARCHAR2 240 Minor Revision Code at the beginning of the (or root item) revision range during which a given record is available. Active
FROM_MINOR_REVISION_ID NUMBER Minor Revision at the beginning of the (or root item) revision range during which a given record is available. Active
TO_MINOR_REVISION_CODE VARCHAR2 240 Minor Revision Code at the end of the (or root item) revision range during which a given record is available. Active
TO_MINOR_REVISION_ID NUMBER Minor Revision at the end of the (or root item) revision range during which a given record is available. Active
FROM_END_ITEM_MINOR_REV_CODE VARCHAR2 240 Minor Revision code at the beginning of the end item (or root item) revision range during which a given record is available. Active
FROM_END_ITEM_MINOR_REV_ID NUMBER Minor Revision at the beginning of the end item (or root item) revision range during which a given record is available. Active
TO_END_ITEM_MINOR_REV_CODE VARCHAR2 240 Revision at the end of the end item (or root item) revision range during which a given record is available. Active
TO_END_ITEM_MINOR_REV_ID NUMBER Revision at the end of the end item (or root item) revision range during which a given record is available. Active
RETURN_STATUS VARCHAR2 1 No longer used. Active
FROM_END_ITEM VARCHAR2 240 End Item (or root item) of the component Active
FROM_END_ITEM_ID NUMBER End Item id (or root item) of the component Active
FROM_END_ITEM_REV_CODE VARCHAR2 240 Revision code of End Item (or root item) Active
FROM_END_ITEM_REV_ID NUMBER 18 Revision at the beginning of the end item (or root item) revision range during which a given record is available. Active
TO_END_ITEM_REV_CODE VARCHAR2 240 Revision code of the end item (or root item) . Active
TO_END_ITEM_REV_ID NUMBER 18 Revision at the end of the end item (or root item) revision range during which a given record is available. Active
COMPONENT_REVISION_CODE VARCHAR2 240 Holds the value of componnet revision code. This value will be used for adding fixed revision components. Active
COMPONENT_REVISION_ID NUMBER 18 Holds the value of componnet revision id. This value will be used for adding fixed revision components. Active
BATCH_ID NUMBER 18 Batch Identifier for Data Load. A unique identifier of an item batch. Active
COMP_SOURCE_SYSTEM_REFERENCE VARCHAR2 255 Component Source System Item Name Active
COMP_SOURCE_SYSTEM_REFER_DESC VARCHAR2 240 Unique identifier of the spoke item that an item is related to. In a related item relationship, an item can be related to another item. This string represents the target item in the relationship. Active
PARENT_SOURCE_SYSTEM_REFERENCE VARCHAR2 255 Parent Structures Item Name in external system Active
CATALOG_CATEGORY_NAME VARCHAR2 240 Name of the Item Catalog Category Active
ITEM_CATALOG_GROUP_ID NUMBER 18 Item Catalog Category Identifier Active
CHANGE_ID NUMBER 18 A unique identifier of a change order. Active
TEMPLATE_NAME VARCHAR2 240 Name of the Item Template, points to the item table Active
PRIMARY_UNIT_OF_MEASURE VARCHAR2 25 The principal unit of measure in which the quantity of an item is managed. Active
ITEM_DESCRIPTION VARCHAR2 240 Statement, picture in words, or account that describes; descriptive representation. Active
COMMON_COMPONENT_SEQUENCE_ID NUMBER 18 Common Component Sequence Identifier Active
CHANGE_TRANSACTION_TYPE VARCHAR2 10 Change Management Transaction Type for Change Orders Active
PARENT_REVISION_CODE VARCHAR2 240 No longer used. Active
PARENT_REVISION_ID NUMBER 18 No longer used. 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
VERSION_REVISION_CODE VARCHAR2 20 Code identifying the Version Revision Active
VERSION_START_DATE DATE Date when new version is set to be effective Active
SOURCE_SYSTEM_ID NUMBER 18 Identifier of the source spoke system Active
INTERFACE_TABLE_UNIQUE_ID NUMBER 18 Interface Table Unique Identifier for Component's interface rows. Active
ITEM_TRANSACTION_ID NUMBER 18 Identifier used for tracking the transaction during import/data load process Active
PHASE_NUMBER NUMBER 18 Phase Number identifer for Import. 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.
SOURCE_SYSTEM_CODE VARCHAR2 30 ORIG_SYSTEM in HZ_ORIG_SYSTEMS_VL
LOAD_REQUEST_ID NUMBER 18 Request Id of the Job which loads the data to interface tables
EFFECTIVITY_CONTROL NUMBER For internal use. Stores the effectivity_control of parent header.
VERSION_ENABLED_FLAG VARCHAR2 1 De-normalized column. Y if parent item has version_enabled_flag as Y.
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
REPLACED_BY_COMPONENT NUMBER 18 Inventory Item Id of the item with which the component is replaced
REPLACED_BY_COMP_NUMBER VARCHAR2 820 Item Number of the item with which the component is replaced
USE_PLACEHOLDER NUMBER Attribute for user to be able to Map and Import the Use Placeholder component attribute.
NEW_FIND_NUMBER NUMBER The new value of Find Number for the component to be replaced
SUGGESTED_OPERATION_SEQ_NUM NUMBER Operation sequence number suggested by the design engineer to be included in work definition.

Indexes

Index Uniqueness Tablespace Columns Status
EGP_COMPONENTS_INTERFACE_N10 Non Unique FUSION_TS_INTERFACE BATCH_ID, PREPROCESS_THREAD_NUMBER, PROCESS_STATUS, THREAD_NUMBER, PHASE_NUMBER Active
EGP_COMPONENTS_INTERFACE_N11 Non Unique Default BATCH_ID, PREPROCESS_THREAD_NUMBER, PROCESS_STATUS, ORGANIZATION_ID, ASSEMBLY_ITEM_ID
EGP_COMPONENTS_INTERFACE_N12 Non Unique Default VERSION_ENABLED_FLAG
EGP_COMPONENTS_INTERFACE_N13 Non Unique Default PROCESS_STATUS, ORGANIZATION_ID, ASSEMBLY_ITEM_ID, PARENT_SOURCE_SYSTEM_REFERENCE
EGP_COMPONENTS_INTERFACE_N14 Non Unique Default COMPONENT_ITEM_NUMBER, BATCH_ID
EGP_COMPONENTS_INTERFACE_N15 Non Unique Default COMP_SOURCE_SYSTEM_REFERENCE, BATCH_ID, ASSEMBLY_ITEM_NUMBER, PARENT_SOURCE_SYSTEM_REFERENCE
EGP_COMPONENTS_INTERFACE_N16 Non Unique Default LOAD_REQUEST_ID
EGP_COMPONENTS_INTERFACE_N2 Non Unique FUSION_TS_INTERFACE COMPONENT_SEQUENCE_ID Active
EGP_COMPONENTS_INTERFACE_N5 Non Unique FUSION_TS_INTERFACE COMPONENT_ITEM_ID, REVISED_ITEM_SEQUENCE_ID Active
EGP_COMPONENTS_INTERFACE_N6 Non Unique FUSION_TS_INTERFACE ASSEMBLY_ITEM_NUMBER, ORGANIZATION_CODE, ALTERNATE_BOM_DESIGNATOR Active
EGP_COMPONENTS_INTERFACE_N7 Non Unique FUSION_TS_INTERFACE ENG_CHANGES_IFCE_KEY Active
EGP_COMPONENTS_INTERFACE_N8 Non Unique FUSION_TS_INTERFACE PREPROCESS_THREAD_NUMBER, PROCESS_STATUS, ORGANIZATION_ID, TRANSACTION_ID Active
EGP_COMPONENTS_INTERFACE_N9 Non Unique Default BATCH_NUMBER
EGP_COMPONENTS_INTERFACE_U1 Unique FUSION_TS_INTERFACE TRANSACTION_ID Active