EGP_BOM_COMPARE_RESULTS
This is a permanent table holding the result of comparing two multi level structures. The data in this table is likely deleted in 12 hours
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
EGP_BOM_COMPARE_RESULTS_PK |
BATCH_ID, BATCH_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Batch identifier for the comparison | |
| BATCH_ROW_ID | NUMBER | 18 | Yes | Batch Row Id Identifies a row within the batch uniquely. | |
| GROUP_ID | NUMBER | The group ID of the comparison result. Values : 1 - Left(source) structure, 2 - Right(target) Structure, 999 - Final Result. | |||
| GROUP_NUMBER | VARCHAR2 | 50 | The Group Number which identifies the GROUP the row belongs to. | ||
| SOURCE_PRIMARY_UOM_CODE | VARCHAR2 | 3 | Primary Unit Of Measurement code of the source structure component. | ||
| TARGET_PRIMARY_UOM_CODE | VARCHAR2 | 3 | Primary Unit Of Measurement code of target structure component | ||
| SOURCE_SHOWINSALES | NUMBER | The value of Show In Sales attribute of source structure component. | |||
| TARGET_SHOWINSALES | NUMBER | The value of Show In sales attribute of target structure component. | |||
| SOURCE_INSTANTIABILITY | VARCHAR2 | 30 | The value of Instantiability Code attribute of source structure component | ||
| TARGET_INSTANTIABILITY | VARCHAR2 | 30 | The value of Instantiability Code of Target structure component | ||
| BILL_SEQUENCE_ID | NUMBER | 18 | The value of Bill sequence id attribute of source structure component | ||
| BILL_SEQUENCE_ID1 | NUMBER | 18 | The value of Bill Sequence Id attribute of target structure component | ||
| SOURCE_AUTO_REQ_MATERIAL | VARCHAR2 | 1 | The value of Auto request Material attribute of source structure component | ||
| TARGET_AUTO_REQ_MATERIAL | VARCHAR2 | 1 | The value of Auto Request Material attribute of target structure component | ||
| SOURCE_LOCATOR_ID | NUMBER | 18 | The value of Locator Id attribute of source structure component | ||
| TARGET_LOCATOR_ID | NUMBER | 18 | The value of Locator Id attribute of target structure compoment | ||
| SOURCE_SUBINVENTORY | VARCHAR2 | 10 | The value of Subinventory attribute of source structure component | ||
| TARGET_SUBINVENTORY | VARCHAR2 | 10 | The value of Subinventory attribute of target structure component. | ||
| SOURCE_SUPPLY_TYPE | NUMBER | The value of Supply type attribute of source structure component | |||
| TARGET_SUPPLY_TYPE | NUMBER | The value of Supply type attribute of target structure component | |||
| SOURCE_BASIS_TYPE | NUMBER | The value of Basis Type attribute of source structure component. | |||
| TARGET_BASIS_TYPE | NUMBER | The value of Basis Type attribute of target structure component. | |||
| SOURCE_BOM_ITEM_TYPE | NUMBER | The value of BOM Item Type attribute of source structure component | |||
| TARGET_BOM_ITEM_TYPE | NUMBER | The value of BOM Item type attribute of target structure component | |||
| SOURCE_EFFECTIVITY_CONTROL | NUMBER | The value of Effectivity Control attribute of source structure component | |||
| TARGET_EFFECTIVITY_CONTROL | NUMBER | The value of Effectivity Control attribute of target structure component | |||
| SOURCE_ENF_INT_REQUIREMENT | NUMBER | The value of Enforce Integer Requirement attribute of source structure component | |||
| TARGET_ENF_INT_REQUIREMENT | NUMBER | The value of Enforce Integer Requirement attribute of target structure component | |||
| SOURCE_INV_QUANTITY | NUMBER | The value of Inventory Quantity attribute of source structure component | |||
| TARGET_INV_QUANTITY | NUMBER | The value of Inventory Quantity attribute of target structure component | |||
| SOURCE_ITEM_SEQUENCE | NUMBER | The value of Item Sequence attribute of source structure component | |||
| TARGET_ITEM_SEQUENCE | NUMBER | The value of Item Sequence attribute of target structure component | |||
| TARGET_OPERATION_SEQ_NUM | NUMBER | The value of Operation Sequence Number attribute of target structure component | |||
| TARGET_PLANNING_FACTOR | NUMBER | The value of Planning Factor attribute of target structure component | |||
| COMPONENT_QUANTITY | NUMBER | The value of Component Quantity attribute of source structure component | |||
| TARGET_COMPONENT_QUANTITY | NUMBER | The value of Component Quantity attribute of target structure component | |||
| COMPONENT_YIELD_FACTOR | NUMBER | The value of Component Yield Factor attribute of source structure component | |||
| TARGET_COMP_YIELD | NUMBER | The value of Component Yield Factor attribute of of target structure component | |||
| SOURCE_ITEM_CLASS | VARCHAR2 | 240 | The value of Item Class attribute of source structure component | ||
| TARGET_ITEM_CLASS | VARCHAR2 | 240 | The value of Item Class attribute of target structure component | ||
| SOURCE_DESCRIPTION | VARCHAR2 | 240 | The value of Description attribute of source structure component | ||
| TARGET_DESCRIPTION | VARCHAR2 | 240 | The value of Description attribute of target structure component | ||
| SOURCE_ITEM_TYPE | VARCHAR2 | 240 | The value of Item Type attribute of source structure component | ||
| TARGET_ITEM_TYPE | VARCHAR2 | 240 | The value of Item Type attribute of target structure component | ||
| SOURCE_UOM | VARCHAR2 | 20 | The value of Unit Of Measure attribute of source structure component | ||
| TARGET_UOM | VARCHAR2 | 20 | The value of Unit Of Measure attribute of target structure component | ||
| SOURCE_REVISION | VARCHAR2 | 18 | The value of Revision attribute of source structure component | ||
| TARGET_REVISION | VARCHAR2 | 20 | The value of Revision attribute of target structure component | ||
| SOURCE_VERSION | VARCHAR2 | 20 | The value of Version attribute of source structure component | ||
| TARGET_VERSION | VARCHAR2 | 20 | The value of Version attribute of target structure component | ||
| SOURCE_LIFECYCLE_PHASE | VARCHAR2 | 120 | The value of Lifecycle Phase attribute of source structure component | ||
| TARGET_LIFECYCLE_PHASE | VARCHAR2 | 120 | The value of Lifecycle Phase attribute of target structure component | ||
| SOURCE_CHECK_ATP | NUMBER | The value of Check ATP attribute of source structure component | |||
| TARGET_CHECK_ATP | VARCHAR2 | 20 | The value of Check ATP attribute of target structure component | ||
| SOURCE_MAX_QUANTITY | NUMBER | The value of Maximum Quantity attribute of source structure component | |||
| TARGET_MAX_QUANTITY | NUMBER | The value of Maximum Quantity attribute of source structure component | |||
| SOURCE_MIN_QUANTITY | NUMBER | The value of Minimum Quantity attribute of source structure component | |||
| TARGET_MIN_QUANTITY | VARCHAR2 | 20 | The value of Minimum Quantity attribute of target structure component | ||
| SOURCE_MUTUALLY_EXCLUSIVE | NUMBER | The value of Mutually Exclusive attribute of source structure component | |||
| TARGET_MUTUALLY_EXCLUSIVE | NUMBER | The value of Mutually Exclusive attribute of target structure component | |||
| OPTIONAL | NUMBER | The value of Optional attribute of source structure component | |||
| TARGET_OPTIONAL | NUMBER | The value of Optional attribute of target structure component | |||
| PLANNING_FACTOR | NUMBER | The value of Planning Factor attribute of source structure component | |||
| SOURCE_SO_BASIS | NUMBER | The value of SO-Basis attribute of source structure component | |||
| TARGET_SO_BASIS | NUMBER | The value of SO-Basis attribute of target structure component | |||
| SOURCE_INCLUDE_ON_SHIP_DOCS | NUMBER | The value of Include on Ship Documents attribute of source structure component | |||
| TARGET_INCLUDE_ON_SHIP_DOCS | NUMBER | The value of Include on Ship Documents attribute of target structure component | |||
| SOURCE_REQ_FOR_REVENUE | NUMBER | The value of Required for Revenue attribute of source structure component | |||
| TARGET_REQ_FOR_REVENUE | NUMBER | The value of Required for Revenue attribute of target structure component | |||
| SOURCE_REQ_TO_SHIP | NUMBER | The value of Required To Ship attribute of source structure component | |||
| TARGET_REQ_TO_SHIP | NUMBER | The value of Required To Ship attribute of target structure component | |||
| SOURCE_SHIP_ALLOWED | NUMBER | The value of Ship Allowed attribute of source structure component | |||
| TARGET_SHIP_ALLOWED | NUMBER | The value of Ship Allowed attribute of target structure component | |||
| SOURCE_CHANGE_ORDER | VARCHAR2 | 50 | THe value of Change Order attribute of source structure component | ||
| TARGET_CHANGE_ORDER | VARCHAR2 | 50 | The value of Change order attribute of target structure component | ||
| SOURCE_IMPLEMENTED | NUMBER | The value of Implemented attribute of source structure component | |||
| TARGET_IMPLEMENTED | NUMBER | The Value of Implemented attribute of target structure component | |||
| SOURCE_GTIN | VARCHAR2 | 255 | The value of GTIN attribute of source structure component | ||
| TARGET_GTIN | VARCHAR2 | 255 | The value of GTIN attribute of target structure component | ||
| SOURCE_GTIN_DESC | VARCHAR2 | 240 | The value of GTIN Description attribute of source structure component | ||
| TARGET_GTIN_DESC | VARCHAR2 | 240 | The value of GTIN Description attribute of target structure component | ||
| SOURCE_GTIN_UOM | VARCHAR2 | 20 | The value of GTIN UOM attribute of source structure component | ||
| TARGET_GTIN_UOM | VARCHAR2 | 20 | The value of GTIN UOM attribute of target structure component | ||
| SOURCE_COMP_COMMENTS | VARCHAR2 | 240 | The value of Component Comments attribute of source structure component | ||
| TARGET_COMP_COMMENTS | VARCHAR2 | 240 | The value of Component Comments attribute of target structure component | ||
| TOP_BILL_SEQUENCE_ID | NUMBER | 18 | The value of Top Bill Sequence Id attribute of source structure component | ||
| TOP_BILL_SEQUENCE_ID1 | NUMBER | 18 | The value of Top Bill Sequence Id attribute of target structure component | ||
| ORGANIZATION_ID | NUMBER | 18 | The value of Organization Id attribute of source structure component | ||
| ORGANIZATION_ID1 | NUMBER | 18 | The value of Organization Id attribute of source structure component | ||
| COMPONENT_SEQUENCE_ID | NUMBER | 18 | The value of Component Sequence Id attribute of source structure component | ||
| COMPONENT_SEQUENCE_ID1 | NUMBER | The value of Component Sequence Id attribute of target structure component | |||
| COMPONENT_ITEM_ID | NUMBER | 18 | The value of Component Item Id attribute of source structure component | ||
| COMPONENT_ITEM_ID1 | NUMBER | 18 | The Component Item Id attribute of target structure component | ||
| PLAN_LEVEL | NUMBER | The Plan Level attribute of source structure component | |||
| PLAN_LEVEL1 | NUMBER | The Plan level attribute of target structure component | |||
| SORT_ORDER | VARCHAR2 | 2000 | Yes | The Sort Order attribute identifies the sort position of the item in the structure. | |
| SORT_ORDER1 | VARCHAR2 | 2000 | The Sort Order attribute identifies the sort position of the item in the structure, this is for target structure component | ||
| ORIG_SORT_ORDER | VARCHAR2 | 2000 | The Original Sort order attribute of source structure component | ||
| ORIG_SORT_ORDER1 | VARCHAR2 | 2000 | The value of Original sort order attribute of target structure component | ||
| PK1_VALUE | VARCHAR2 | 240 | The value of PK1 attribute of source structure component | ||
| PK1_VALUE1 | VARCHAR2 | 240 | The value of PK1 attribute of target structure component | ||
| PK2_VALUE | VARCHAR2 | 240 | The value of PK2 attribute of source structure component | ||
| PK2_VALUE1 | VARCHAR2 | 240 | The value of PK2 attribute of target structure component | ||
| PARENT_SORT_ORDER | VARCHAR2 | 2000 | The value of Parent Sort Order attribute identifies the sort position of the parent of the item in the structure. | ||
| PARENT_SORT_ORDER1 | VARCHAR2 | 2000 | The value of Parent Sort Order attribute of target identifies the sort position of the parent of the item in the structure - of target structure component | ||
| ORIG_PARENT_SORT_ORDER | VARCHAR2 | 2000 | The value of Original Parent Sort Order attribute of source structure component | ||
| ORIG_PARENT_SORT_ORDER1 | VARCHAR2 | 2000 | The value of Original Parent Sort Order attribute of target structure component | ||
| TOP_ITEM_NUMBER | VARCHAR2 | 240 | The value of Top Item Number attribute of source structure component | ||
| TOP_ITEM_NUMBER1 | VARCHAR2 | 240 | The value of Top item Number attribute of target structure component | ||
| TOP_ITEM_ID | VARCHAR2 | 240 | The value of Top item Id attribute of source structure component | ||
| TOP_ITEM_ID1 | VARCHAR2 | 240 | The value of Top Item Id attribute of target structure component | ||
| COMPONENT_PATH | VARCHAR2 | 2000 | The value of Component Path attribute of source structure component | ||
| COMPONENT_PATH1 | VARCHAR2 | 2000 | The value of Component Path attribute of target structure component | ||
| ITEM_NAME | VARCHAR2 | 240 | The value of Item Name attribute of the source structure component. | ||
| ITEM_NAME1 | VARCHAR2 | 240 | The value of Item name attribute of the target item. | ||
| SOURCE_SYSTEM_REFERENCE | VARCHAR2 | 240 | The value Source System Reference attribute of source structure component | ||
| SOURCE_SYSTEM_REFERENCE1 | VARCHAR2 | 240 | The value of Source System Reference attribute of target structure component | ||
| COMP_SOURCE_SYSTEM_REFERENCE | VARCHAR2 | 240 | The value of Component Source System Reference attribute of source structure component | ||
| COMP_SOURCE_SYSTEM_REFERENCE1 | VARCHAR2 | 240 | The value of Component Source System Refereence attribute of target structure component | ||
| COMMON_BILL_SEQUENCE_ID | NUMBER | 18 | The value of Common Bill Sequence Id attribute of source structure component | ||
| COMMON_BILL_SEQUENCE_ID1 | NUMBER | 18 | The value of Common Bill Sequence Id attribute of target structure component | ||
| SOURCE_BILL_SEQUENCE_ID | NUMBER | 18 | The value of Bill Sequence Id attribute of source structure component | ||
| SOURCE_BILL_SEQUENCE_ID1 | NUMBER | 18 | The value of Bill Sequence Id attribute of target structure component | ||
| COMPONENT_SEQUENCE_ID2 | NUMBER | The value of Component Sequence Id attribute of source structure component | |||
| ASSEMBLY_ID1 | NUMBER | 18 | The value of Assembly Id attribute of source structure component. | ||
| ASSEMBLY_ID2 | NUMBER | 18 | The value of Assembly Id attribute of target structure component. | ||
| ITEM_NUM | NUMBER | The value of Item Number attribute of source structure component. | |||
| OPERATION_SEQ_NUM | NUMBER | he value of Operational Sequence Number attribute of source structure component. | |||
| EFFECTIVITY_DATE | DATE | The value of Effectivity Date attribute of source structure component. | |||
| DISABLE_DATE | DATE | The value of Disable Date attribute of source structure component. | |||
| FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | The value of Item Unit Number attribute of source structure component. | ||
| TO_END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | The value of Item Unit Number attribute of target structure component. | ||
| IMPLEMENTATION_DATE | DATE | The value of Implementation Date attribute of source structure component. | |||
| TRANSACTION_TYPE | VARCHAR2 | 18 | The value of Transaction Type attribute of source structure component. | ||
| CONFIRM_STATUS | VARCHAR2 | 10 | The value of Confirmation Status attribute of source structure component. | ||
| PARENT_SOURCE_SYSTEM_REF | VARCHAR2 | 255 | The value of Parent Source System Reference attribute of source structure component. | ||
| COMPONENT_NAME | VARCHAR2 | 255 | The value of Component Name attribute of source structure component. | ||
| 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. | |
| PROGRAM_NAME | VARCHAR2 | 30 | The value of Item Number attribute of source structure component. | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | The value of Program App Name attribute of source structure component. | ||
| SOURCE_ITEM | VARCHAR2 | 255 | The value of Source Item attribute of source structure component. | ||
| MASTER_ITEM | VARCHAR2 | 255 | The value of Master Item attribute of source structure component. | ||
| DISPLAY_CHANGE | VARCHAR2 | 10 | The value of Display Change attribute of source structure component. | ||
| COMP_ACTION | VARCHAR2 | 20 | The value of Component Action attribute of source structure component. | ||
| MATCH_ACTION | VARCHAR2 | 10 | The value of Matching Action attribute of source structure component. | ||
| MATCH_STATUS | VARCHAR2 | 20 | The value of Matching Status attribute of source structure component. | ||
| NO_MATCHED_SSREF | VARCHAR2 | 10 | The value of No matching source item reference attribute of source structure component. | ||
| NO_MATCHED_MASTER | VARCHAR2 | 10 | The value of No Matching Master Item attribute of source structure component. | ||
| S_ATTRIBUTE1 | VARCHAR2 | 150 | The value of S_ATTRIBUTE1 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE2 | VARCHAR2 | 150 | The value of S_ATTRIBUTE2 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE3 | VARCHAR2 | 150 | The value of S_ATTRIBUTE3 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE4 | VARCHAR2 | 150 | The value of S_ATTRIBUTE4 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE5 | VARCHAR2 | 150 | The value of S_ATTRIBUTE5 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE6 | VARCHAR2 | 150 | The value of S_ATTRIBUTE6 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE7 | VARCHAR2 | 150 | The value of S_ATTRIBUTE7 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE8 | VARCHAR2 | 150 | The value of S_ATTRIBUTE8 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE9 | VARCHAR2 | 150 | The value of S_ATTRIBUTE9 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE10 | VARCHAR2 | 150 | The value of S_ATTRIBUTE10 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE11 | VARCHAR2 | 150 | The value of S_ATTRIBUTE11 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE12 | VARCHAR2 | 150 | The value of S_ATTRIBUTE12 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE13 | VARCHAR2 | 150 | The value of S_ATTRIBUTE13 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE14 | VARCHAR2 | 150 | The value of S_ATTRIBUTE14 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE15 | VARCHAR2 | 150 | The value of S_ATTRIBUTE15 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE16 | VARCHAR2 | 150 | The value of S_ATTRIBUTE16 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE17 | VARCHAR2 | 150 | The value of S_ATTRIBUTE17 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE18 | VARCHAR2 | 150 | The value of S_ATTRIBUTE18 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE19 | VARCHAR2 | 150 | The value of S_ATTRIBUTE19 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE20 | VARCHAR2 | 150 | The value of S_ATTRIBUTE20 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE21 | VARCHAR2 | 150 | The value of S_ATTRIBUTE21 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE22 | VARCHAR2 | 150 | The value of S_ATTRIBUTE22 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE23 | VARCHAR2 | 150 | The value of S_ATTRIBUTE23 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE24 | VARCHAR2 | 150 | The value of S_ATTRIBUTE24 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE25 | VARCHAR2 | 150 | The value of S_ATTRIBUTE25 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE26 | VARCHAR2 | 4000 | The value of S_ATTRIBUTE26 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE27 | VARCHAR2 | 4000 | The value of S_ATTRIBUTE27 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE28 | VARCHAR2 | 4000 | The value of S_ATTRIBUTE28 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE29 | VARCHAR2 | 4000 | The value of S_ATTRIBUTE29 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE30 | VARCHAR2 | 4000 | The value of S_ATTRIBUTE30 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE_NUMBER1 | NUMBER | The value of S_ATTRIBUTE_NUMBER1 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_NUMBER2 | NUMBER | The value of S_ATTRIBUTE_NUMBER2 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_NUMBER3 | NUMBER | The value of S_ATTRIBUTE_NUMBER3 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_NUMBER4 | NUMBER | The value of S_ATTRIBUTE_NUMBER4 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_NUMBER5 | NUMBER | The value of S_ATTRIBUTE_NUMBER5 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_NUMBER6 | NUMBER | The value of S_ATTRIBUTE_NUMBER6 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_NUMBER7 | NUMBER | The value of S_ATTRIBUTE_NUMBER7 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_NUMBER8 | NUMBER | The value of S_ATTRIBUTE_NUMBER8 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_NUMBER9 | NUMBER | The value of S_ATTRIBUTE_NUMBER9 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_NUMBER10 | NUMBER | The value of S_ATTRIBUTE_NUMBER10 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_DATE1 | DATE | The value of S_ATTRIBUTE_DATE1 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_DATE2 | DATE | The value of S_ATTRIBUTE_DATE2 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_DATE3 | DATE | The value of S_ATTRIBUTE_DATE3 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_DATE4 | DATE | The value of S_ATTRIBUTE_DATE4 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_DATE5 | DATE | The value of S_ATTRIBUTE_DATE5 attribute used for Descriptive Flexfield | |||
| S_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | 6 | The value of S_ATTRIBUTE_TIMESTAMP1 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | 6 | The value of S_ATTRIBUTE_TIMESTAMP2 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | 6 | The value of S_ATTRIBUTE_TIMESTAMP3 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | 6 | The value of S_ATTRIBUTE_TIMESTAMP4 attribute used for Descriptive Flexfield | ||
| S_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | 6 | The value of S_ATTRIBUTE_TIMESTAMP5 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE1 | VARCHAR2 | 150 | The value of T_ATTRIBUTE1 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE2 | VARCHAR2 | 150 | The value of T_ATTRIBUTE2 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE3 | VARCHAR2 | 150 | The value of T_ATTRIBUTE3 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE4 | VARCHAR2 | 150 | The value of T_ATTRIBUTE4 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE5 | VARCHAR2 | 150 | The value of T_ATTRIBUTE5 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE6 | VARCHAR2 | 150 | The value of T_ATTRIBUTE6 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE7 | VARCHAR2 | 150 | The value of T_ATTRIBUTE7 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE8 | VARCHAR2 | 150 | The value of T_ATTRIBUTE8 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE9 | VARCHAR2 | 150 | The value of T_ATTRIBUTE9 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE10 | VARCHAR2 | 150 | The value of T_ATTRIBUTE10 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE11 | VARCHAR2 | 150 | The value of T_ATTRIBUTE11 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE12 | VARCHAR2 | 150 | The value of T_ATTRIBUTE12 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE13 | VARCHAR2 | 150 | The value of T_ATTRIBUTE13 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE14 | VARCHAR2 | 150 | The value of T_ATTRIBUTE14 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE15 | VARCHAR2 | 150 | The value of T_ATTRIBUTE15 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE16 | VARCHAR2 | 150 | The value of T_ATTRIBUTE16 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE17 | VARCHAR2 | 150 | The value of T_ATTRIBUTE17 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE18 | VARCHAR2 | 150 | The value of T_ATTRIBUTE18 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE19 | VARCHAR2 | 150 | The value of T_ATTRIBUTE19 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE20 | VARCHAR2 | 150 | The value of T_ATTRIBUTE20 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE21 | VARCHAR2 | 150 | The value of T_ATTRIBUTE21 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE22 | VARCHAR2 | 150 | The value of T_ATTRIBUTE22 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE23 | VARCHAR2 | 150 | The value of T_ATTRIBUTE23 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE24 | VARCHAR2 | 150 | The value of T_ATTRIBUTE24 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE25 | VARCHAR2 | 150 | The value of T_ATTRIBUTE25 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE26 | VARCHAR2 | 4000 | The value of T_ATTRIBUTE26 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE27 | VARCHAR2 | 4000 | The value of T_ATTRIBUTE27 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE28 | VARCHAR2 | 4000 | The value of T_ATTRIBUTE28 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE29 | VARCHAR2 | 4000 | The value of T_ATTRIBUTE29 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE30 | VARCHAR2 | 4000 | The value of T_ATTRIBUTE30 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE_NUMBER1 | NUMBER | The value of T_ATTRIBUTE_NUMBER1 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_NUMBER2 | NUMBER | The value of T_ATTRIBUTE_NUMBER2 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_NUMBER3 | NUMBER | The value of T_ATTRIBUTE_NUMBER3 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_NUMBER4 | NUMBER | The value of T_ATTRIBUTE_NUMBER4 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_NUMBER5 | NUMBER | The value of T_ATTRIBUTE_NUMBER5 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_NUMBER6 | NUMBER | The value of T_ATTRIBUTE_NUMBER6 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_NUMBER7 | NUMBER | The value of T_ATTRIBUTE_NUMBER7 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_NUMBER8 | NUMBER | The value of T_ATTRIBUTE_NUMBER8 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_NUMBER9 | NUMBER | The value of T_ATTRIBUTE_NUMBER9 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_NUMBER10 | NUMBER | The value of T_ATTRIBUTE_NUMBER10 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_DATE1 | DATE | The value of T_ATTRIBUTE_DATE1 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_DATE2 | DATE | The value of T_ATTRIBUTE_DATE2 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_DATE3 | DATE | The value of T_ATTRIBUTE_DATE3 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_DATE4 | DATE | The value of T_ATTRIBUTE_DATE4 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_DATE5 | DATE | The value of T_ATTRIBUTE_DATE5 attribute used for Descriptive Flexfield | |||
| T_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | 6 | The value of T_ATTRIBUTE_TIMESTAMP1 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | 6 | The value of T_ATTRIBUTE_TIMESTAMP2 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | 6 | The value of T_ATTRIBUTE_TIMESTAMP3 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | 6 | The value of T_ATTRIBUTE_TIMESTAMP4 attribute used for Descriptive Flexfield | ||
| T_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | 6 | The value of T_ATTRIBUTE_TIMESTAMP5 attribute used for Descriptive Flexfield | ||
| PARENT_PK1_VALUE | VARCHAR2 | 240 | The PK1_value of the parent on the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| SUGGESTED_OPER_SEQ_NUM | NUMBER | The value of Suggested Operation Sequence Number attribute of source structure component. | |||
| T_SUGGESTED_OPER_SEQ_NUM | NUMBER | The value of Suggested Operation Sequence Number attribute of target structure component. | |||
| COMP_UNIQUE_PATH | VARCHAR2 | 4000 | The unique path to the source structure component from the root of the structure. | ||
| T_COMP_UNIQUE_PATH | VARCHAR2 | 4000 | The unique path to the target structure component from the root of the structure. | ||
| PARENT_COMP_UNIQUE_PATH | VARCHAR2 | 4000 | The unique path to the parent of the source structure component from root of the structure. | ||
| T_PARENT_COMP_UNIQUE_PATH | VARCHAR2 | 4000 | The unique path to the parent of the source structure component from root of the structure. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EGP_BOM_COMPARE_RESULTS_N1 | Non Unique | Default | BATCH_ID, PARENT_SORT_ORDER |
| EGP_BOM_COMPARE_RESULTS_N2 | Non Unique | Default | BATCH_ID, SORT_ORDER |
| EGP_BOM_COMPARE_RESULTS_U1 | Unique | Default | BATCH_ID, BATCH_ROW_ID |