EGO_ITEM_ASSOCIATIONS

This table is used to store item supplier associations

Details

• Schema: FUSION

• Object owner: EGO

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
EGO_ITEM_ASSOCIATIONS_PK	INVENTORY_ITEM_ID, ORGANIZATION_ID, ACD_TYPE, CHANGE_LINE_ID, VERSION_ID, SUPPLIER_ID, SUPPLIER_SITE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
ASSOCIATION_ID	NUMBER		18	Yes	Unique identifier of item association	Active
PARTY_STATUS	VARCHAR2	4			Attribute indicating the party status of the associations in the import
SUPPLIER_ID	NUMBER		18	Yes	Refers to the Supplier Id of the Associated Supplier
SUPPLIER_SITE_ID	NUMBER		18	Yes	Referes to the Supplier Site Id of the Associated Supplier Site
INVENTORY_ITEM_ID	NUMBER		18	Yes	Refers to inventory item identifier in EGP_SYSTEM_ITEMS_B	Active
ORGANIZATION_ID	NUMBER		18	Yes	Refers to organization_id from mtl_paramteres	Active
STATUS_CODE	NUMBER				Refers to status of the association	Active
PRIMARY_FLAG	VARCHAR2	1			Indicates whether this association is Primary for the item or not	Active
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.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated 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			concurrent request "WHO" column	Active
PROGRAM_APP_NAME	VARCHAR2	50			concurrent request "WHO" column	Active
CHANGE_LINE_ID	NUMBER		18	Yes	A unique identifier of a change order.	Active
VERSION_ID	NUMBER		20	Yes	Version number to identify a version uniquely within a revision.	Active
ACD_TYPE	VARCHAR2	30		Yes	Indicates the type of change performed on Item Supplier Site Organization Association.	Active
VERSION_START_DATE	DATE			Yes	Date when new version is set to be effective	Active
VERSION_END_DATE	DATE				Date after which the version will no longer remain effective.	Active
IMPLEMENTATION_DATE	DATE				The date when an event will take place.	Active
CHANGE_BIT_MAP	VARCHAR2	10		Yes	Attribute indicating attribute changed value.	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
STYLE_ITEM_ID	NUMBER		18		Attribute referring to the associated Style Item

Foreign Keys

Table	Foreign Table	Foreign Key Column
EGO_ITEM_ASSOCIATIONS	egp_system_items_b	INVENTORY_ITEM_ID, ORGANIZATION_ID
ego_item_supplier_eff_tl	ego_item_associations	INVENTORY_ITEM_ID, ORGANIZATION_ID, ACD_TYPE, CHANGE_LINE_ID, VERSION_ID, SUPPLIER_ID, SUPPLIER_SITE_ID
ego_item_supplier_eff_b	ego_item_associations	INVENTORY_ITEM_ID, ORGANIZATION_ID, ACD_TYPE, CHANGE_LINE_ID, VERSION_ID, SUPPLIER_ID, SUPPLIER_SITE_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
EGO_ITEM_ASSOCIATIONS_N1	Non Unique	Default	LAST_UPDATE_DATE
EGO_ITEM_ASSOCIATIONS_U1	Unique	FUSION_TS_TX_IDX	ASSOCIATION_ID, CHANGE_LINE_ID, ACD_TYPE, INVENTORY_ITEM_ID, ORGANIZATION_ID, SUPPLIER_ID, SUPPLIER_SITE_ID	Active
EGO_ITEM_ASSOCIATIONS_U2	Unique	FUSION_TS_TX_DATA	INVENTORY_ITEM_ID, ORGANIZATION_ID, ACD_TYPE, CHANGE_LINE_ID, VERSION_ID, SUPPLIER_ID, SUPPLIER_SITE_ID
EGO_ITEM_ASSOCIATIONS_U3	Unique	FUSION_TS_TX_DATA	INVENTORY_ITEM_ID, ORGANIZATION_ID, CHANGE_LINE_ID, ACD_TYPE, VERSION_START_DATE, SUPPLIER_ID, SUPPLIER_SITE_ID