eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: EGO.EGO_ITEM_ASSOCIATIONS

Object Details

Object Name:	EGO_ITEM_ASSOCIATIONS
Object Type:	TABLE
Owner:	EGO
FND Design Data:	EGO.EGO_ITEM_ASSOCIATIONS
Subobject Name:
Status:	VALID

This table is used to store item associations

Storage Details

Tablespace:
PCT Free:
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_ITEM_ASSOCIATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSOCIATION_ID
EGO_ITEM_ASSOCIATIONS_U2	NORMAL	UNIQUE		INVENTORY_ITEM_ID ORGANIZATION_ID DATA_LEVEL_ID PK1_VALUE PK2_VALUE PK3_VALUE PK4_VALUE PK5_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
ASSOCIATION_ID	NUMBER		Yes	Unique identifier of item association
INVENTORY_ITEM_ID	NUMBER		Yes	Refers to inventory item identifier in mtl_system_items_b
ORGANIZATION_ID	NUMBER		Yes	Refers to organization_id from mtl_paramteres
PK1_VALUE	NUMBER		Yes	Refers to pk1_value of the associated entity
PK2_VALUE	NUMBER			Refers to pk2_value of the associated entity
PK3_VALUE	NUMBER			Refers to pk3_value of the associated entity
PK4_VALUE	NUMBER			Refers to pk4_value of the associated entity
PK5_VALUE	NUMBER			Refers to pk5_value of the associated entity
DATA_LEVEL_ID	NUMBER		Yes	Refers to data level identifier of the association. Column in ego_data_level_b.
STATUS_CODE	NUMBER			Refers to status of the association
PRIMARY_FLAG	VARCHAR2	(1)		Indicates whether this association is Primary for the item or not
CREATED_BY	NUMBER		Yes	standard "WHO" column
CREATION_DATE	DATE		Yes	standard "WHO" column
LAST_UPDATED_BY	NUMBER		Yes	standard "WHO" column
LAST_UPDATE_DATE	DATE		Yes	standard "WHO" column
LAST_UPDATE_LOGIN	NUMBER		Yes	standard "WHO" column
REQUEST_ID	NUMBER			Refers to the concurrent request id of this import process
PROGRAM_APPLICATION_ID	NUMBER			concurrent request "WHO" column
PROGRAM_ID	NUMBER			concurrent request "WHO" column
PROGRAM_UPDATE_DATE	DATE			concurrent request "WHO" column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ASSOCIATION_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      DATA_LEVEL_ID
,      STATUS_CODE
,      PRIMARY_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM EGO.EGO_ITEM_ASSOCIATIONS;

Dependencies

[top of page]

EGO.EGO_ITEM_ASSOCIATIONS does not reference any database object

EGO.EGO_ITEM_ASSOCIATIONS is referenced by following:

EGO: EGO_ITEM_ASSOCIATIONS#