1. Tables and Views for SCM
  2. EGP_ITEM_RELATIONSHIPS_INTF

EGP_ITEM_RELATIONSHIPS_INTF

Unique identifier of the interface record.

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

EGP_ITEM_RELATIONSHIPS_IN_PK

INTERFACE_TABLE_UNIQUE_ID

Columns

Name Datatype Length Precision Comments Status
ITEM_RELATIONSHIP_ID NUMBER 18 This indicates Type of the Item Relationship Active
STATUS_NAME VARCHAR2 80 Display value of the relationship status for trading partner items
STATUS_CODE VARCHAR2 30 Status code of the Trading Partner Item Relationship.
PREPROCESS_THREAD_NUMBER NUMBER 18 PreProcess Thread Number for interface processing.
TP_ITEM_ID NUMBER 18 Unique identifier of the trading partner item Active
TP_ITEM_NUMBER VARCHAR2 150 User friendly identifier of the trading partner item. Active
DESCRIPTION VARCHAR2 800 Description of Item Relationship Active
INVENTORY_ITEM_ID NUMBER 18 Attribute indicating the unique identifier of the item. Active
ITEM_NUMBER VARCHAR2 820 User friendly identifier of the item. Active
RELATED_ITEM_ID NUMBER 18 Identifier of the target item participating in this related item relationship. Active
RELATED_ITEM_NUMBER VARCHAR2 820 User friendly identifier of the target item participating in this related item relationship. Active
RELATEDITEM_RANK VARCHAR2 80 Attribute to specify the rank of the related item. Active
ITEM_RELATIONSHIP_TYPE VARCHAR2 120 Attribute to specify the type of item relationship. Active
REVISION_ID NUMBER 18 Attribute to specify the item revision identifier. Active
REVISION_CODE VARCHAR2 18 Attribute to specify the item revision code. 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
ORGANIZATION_CODE VARCHAR2 18 This refers to Organization code Active
MASTER_ORGANIZATION_ID NUMBER 18 Identification of Master Organization Active
MASTER_ORGANIZATION_CODE VARCHAR2 18 This refers to the master organization code. Active
BATCH_ID NUMBER 18 A unique identifier of an item batch. Active
TRANSACTION_ID NUMBER 18 Attribute indicating the transaction identifier associated with the import. Active
TRANSACTION_TYPE VARCHAR2 10 This refers to Transaction Type for Item Supplier Site Organization Association Mass Update Active
PROCESS_STATUS NUMBER 18 Attribute indicating the process status of the record in the import. Active
BUNDLE_ID NUMBER 18 Unique identifier that groups items together in a single transaction. Active
SOURCE_SYSTEM_ID NUMBER 18 An external system from which item and its information is being imported into product hub. Active
SOURCE_SYSTEM_REFERENCE VARCHAR2 255 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
RELATED_SOURCE_SYSTEM_REF VARCHAR2 255 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.
THREAD_NUMBER NUMBER 18 Attribute indicating the thread number associated with the import Active
SUB_TYPE VARCHAR2 100 Type of the related item relationship Active
CROSS_REFERENCE VARCHAR2 1020 Attribute to specify the cross reference or GTIN of the item relationship. Active
ORG_INDEPENDENT_FLAG VARCHAR2 4 This indicates whether the reference applies to all or just specific Organization Active
UOM_CODE VARCHAR2 72 Attribute to specify the Standard unit of measure code. Active
UNIT_OF_MEASURE VARCHAR2 100 Attribute to specify the Standard unit of measure value. Active
EPC_GTIN_SERIAL NUMBER 18 EPC or Global Trade Identification Number Serial Value Active
START_DATE_ACTIVE DATE The date from which the item relationship is effective. Active
END_DATE_ACTIVE DATE The date on which the effectivity of the item relationship ends. Active
PREFERENCE_NUMBER NUMBER 18 Rank for Customer Item Relationship Active
INACTIVE_FLAG VARCHAR2 4 This indicates whether the customer item is active Active
MRP_PLANNING_CODE NUMBER 18 Attribute indicating the organization level planning for the Item. Choices -Min-Max,Not Planned, Reorder Point. Active
FIRST_ARTICLE_STATUS VARCHAR2 120 Attribute to specify the status of first article. Active
APPROVAL_STATUS VARCHAR2 120 The Approval Status of the Item. Active
RECIPROCAL_FLAG VARCHAR2 4 Attribute Indicating whether the Related Item Relationship is Reciprocal Active
PLANNING_ENABLED_FLAG VARCHAR2 4 Flag to specify if the related item is enabled for planning. Active
ATTRIBUTE_CATEGORY VARCHAR2 600 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 600 Descriptive Flexfield: segment of the user descriptive flexfield. 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
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
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to 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
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
TRADING_PARTNER_ID NUMBER 18 Attribute indicating the unique identifier of the trading partner. Active
TRADING_PARTNER_NUMBER VARCHAR2 30 The unique identifying number of the trading partner party, which can be a supplier, manufacturer, or customer. Active
INTERFACE_TABLE_UNIQUE_ID NUMBER 18 Unique identifier of the interface record. 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.
UOM_NAME VARCHAR2 25 Attribute indicating the name of the unit of measure.
BATCH_NUMBER VARCHAR2 40 Unique identifier of the batch that is used for item import.
SOURCE_SYSTEM_CODE VARCHAR2 30 Attribute indicating the source system code in the import.
LOAD_REQUEST_ID NUMBER 18 Attribute indicating the request id associated with the data load process.
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
RELATIONSHIP_RANK NUMBER 18 This column will store the rank of the relationships.

Indexes

Index Uniqueness Tablespace Columns Status
EGP_ITEM_RELATIONSHIPS_INTF_N3 Non Unique FUSION_TS_INTERFACE BATCH_ID, PROCESS_STATUS, THREAD_NUMBER, PREPROCESS_THREAD_NUMBER Active
EGP_ITEM_RELATIONSHIPS_INTF_N5 Non Unique Default LOAD_REQUEST_ID
EGP_ITEM_RELATIONSHIPS_INTF_N6 Non Unique FUSION_TS_INTERFACE REQUEST_ID, PROCESS_STATUS
EGP_ITEM_RELATIONSHIP_INTF_N1 Non Unique FUSION_TS_INTERFACE BATCH_ID, TRANSACTION_ID, ITEM_RELATIONSHIP_TYPE Active
EGP_ITEM_RELATIONSHIP_INTF_N2 Non Unique Default BATCH_NUMBER
EGP_ITM_RELATIONSHIP_INTF_N4 Non Unique Default BATCH_ID, PROCESS_STATUS, ORGANIZATION_ID, NVL("ITEM_NUMBER", "TRANSACTION_ID")
ITEM_RELATIONSHIPS_INTF_U1 Unique FUSION_TS_INTERFACE INTERFACE_TABLE_UNIQUE_ID Active