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 |