1. Tables and Views for SCM
  2. EGO_ITEM_ASSOCIATIONS_

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_

LAST_UPDATE_DATE, LAST_UPDATED_BY, 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 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 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 Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP 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 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 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
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 Attribute indicating the original impersonator user

Indexes

Index Uniqueness Tablespace Columns Status
EGO_ITEM_ASSOCIATIONSN1_ Non Unique Default INVENTORY_ITEM_ID, ORGANIZATION_ID, ACD_TYPE, CHANGE_LINE_ID, VERSION_ID, SUPPLIER_ID, SUPPLIER_SITE_ID
EGO_ITEM_ASSOCIATIONS_N2_ Non Unique Default AUDIT_ACTION_TYPE_, REQUEST_ID
EGO_ITEM_ASSOCIATIONS_U1_ Unique FUSION_TS_TX_IDX LAST_UPDATE_DATE, LAST_UPDATED_BY, 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 LAST_UPDATE_DATE, LAST_UPDATED_BY, 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 LAST_UPDATE_DATE, LAST_UPDATED_BY, INVENTORY_ITEM_ID, ORGANIZATION_ID, CHANGE_LINE_ID, ACD_TYPE, VERSION_START_DATE, SUPPLIER_ID, SUPPLIER_SITE_ID