1. Tables and Views for SCM
  2. EGP_ITEM_RELATIONSHIPS_B_

EGP_ITEM_RELATIONSHIPS_B_

This table stores the Item Relationships

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

EGP_ITEM_RELATIONSHIPS_B_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, ITEM_RELATIONSHIP_ID

Columns

Name Datatype Length Precision Not-null Comments Status
ITEM_RELATIONSHIP_ID NUMBER 18 Yes This indicates Type of the Item Relationship Active
TP_ITEM_ID NUMBER 18 Trading Partner Item's Identification Active
ITEM_RELATIONSHIP_TYPE VARCHAR2 30 Attribute to specify the type of item relationship. Active
DESCRIPTION VARCHAR2 200 Deprecated column. Not in use by the application. Active
INVENTORY_ITEM_ID NUMBER Attribute indicating the unique identifier of the item. Active
ORGANIZATION_ID NUMBER 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
SUB_TYPE VARCHAR2 25 Type of the related item relationship Active
CROSS_REFERENCE VARCHAR2 255 Attribute to specify the cross reference or GTIN of the item relationship. Active
ORG_INDEPENDENT_FLAG VARCHAR2 1 This indicates whether the reference applies to all or just specific Organization Active
UOM_CODE VARCHAR2 18 Attribute to specify the Standard unit of measure. Active
REVISION_ID NUMBER Attribute to specify the item revision identifier. Active
EPC_GTIN_SERIAL NUMBER EPC or Global Trade Identification Number Serial Value Active
SOURCE_SYSTEM_ID NUMBER An external system from which item and its information is being imported into product hub. 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
MASTER_ORGANIZATION_ID NUMBER Identification of Master Organization Active
PREFERENCE_NUMBER NUMBER Rank for Customer Item Relationship Active
INACTIVE_FLAG VARCHAR2 1 This indicates whether the customer item is active Active
MRP_PLANNING_CODE NUMBER Attribute indicating the organization level planning for the Item. Choices -Min-Max,Not Planned, Reorder Point. Active
FIRST_ARTICLE_STATUS VARCHAR2 30 Attribute to specify the status of first article. Active
APPROVAL_STATUS VARCHAR2 30 The Approval Status of the Item. Active
RELATED_ITEM_ID NUMBER Identifier of the target item participating in this related item relationship. Active
RECIPROCAL_FLAG VARCHAR2 1 Attribute Indicating whether the Related Item Relationship is Reciprocal. Active
PLANNING_ENABLED_FLAG VARCHAR2 1 Flag to specify if the related item is enabled for planning. Active
RELATEDITEM_RANK VARCHAR2 20 Attribute to specify the rank of the related item. Active
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
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 Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes 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
PROGRAM_NAME VARCHAR2 30 Identifies the concurrent program Active
PROGRAM_APP_NAME VARCHAR2 50 Identifies the Application name spawning the Concurrent Request 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
ALT_ITEM_RELATIONSHIP_CODE VARCHAR2 40 Substitute identifier for Item relationship code 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.
TRADING_PARTNER_ID NUMBER 18 Customer, Manufacturer or Supplier ID for GTIN Relationships
VERSION_ID NUMBER 20 Version number to identify a version uniquely within a revision
CHANGE_LINE_ID NUMBER 20 Unique identifier of the change line used to create this relationship.
VERSION_START_DATE DATE Date when new version is set to be effective
VERSION_END_DATE DATE Date after which the version will no longer remain effective.
IMPLEMENTATION_DATE DATE The date when an event will take place.
CHANGE_BIT_MAP VARCHAR2 400 Attribute indicating attribute changed value.
ACD_TYPE VARCHAR2 30 Refers to the type of modification made to an object, such as add, update or delete.
STATUS_CODE VARCHAR2 30 Status code of the item relationship.
RELATIONSHIP_RANK NUMBER 18 This column will store the rank of the relationships.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User. Used by the audit framework.

Indexes

Index Uniqueness Tablespace Columns
EGP_ITEM_RELATIONSHIPS_BN1_ Non Unique Default ITEM_RELATIONSHIP_ID
EGP_ITEM_RELATIONSHIPS_B_N2_ Non Unique Default AUDIT_ACTION_TYPE_, REQUEST_ID
EGP_ITEM_RELATIONSHIPS_B_PK_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, ITEM_RELATIONSHIP_ID
EGP_ITEM_RELATIONSHIPS_B_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, ITEM_RELATIONSHIP_TYPE, ITEM_RELATIONSHIP_ID