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_INTF

Object Details

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

This table is used to store the interface records for item associations

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_ITEM_ASSOCIATIONS_INTF_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID
EGO_ITEM_ASSOCIATIONS_INTF_N10	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BUNDLE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	Refers to the batch which needs to be processed
ITEM_NUMBER	VARCHAR2	(700)		Refers to concatenated_segments from mtl_system_items_b_kfv
INVENTORY_ITEM_ID	NUMBER			Refers to inventory item identifier in mtl_system_items_b
ORGANIZATION_ID	NUMBER			Refers to organization_id from mtl_paramteres
PK1_VALUE	NUMBER			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			Refers to data level identifier of the association. Column in ego_data_level_b
PRIMARY_FLAG	VARCHAR2	(1)		Indicates whether this association is Primary for the item or not
STATUS_CODE	NUMBER			Refers to status of the association
ORGANIZATION_CODE	VARCHAR2	(3)		Refers to organization_code from mtl_parameters
TRANSACTION_TYPE	VARCHAR2	(10)	Yes	Indicates the action user wants to perform on the Production Data
PROCESS_FLAG	NUMBER			Indicates the status of the record
TRANSACTION_ID	NUMBER			Unique key to identify a record in this table
ASSOCIATION_ID	NUMBER			Refers to association_id in ego_item_associations
CREATED_BY	NUMBER	(15)		One of the five standard "WHO" columns
CREATION_DATE	DATE			One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER	(15)		One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE			One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER	(15)		One of the five standard "WHO" columns
REQUEST_ID	NUMBER			Refers to the concurrent request id of this import process
PROGRAM_APPLICATION_ID	NUMBER			One of the concurrent request "WHO" column
PROGRAM_ID	NUMBER			One of the concurrent request "WHO" column
PROGRAM_UPDATE_DATE	DATE			One of the concurrent request "WHO" column
SUPPLIER_NAME	VARCHAR2	(360)		This column identifies to which supplier name the association is created for. References party_name from hz_parties for the party_id in ap_suppliers
SUPPLIER_NUMBER	VARCHAR2	(30)		This column identifies the supplier number for which the association is created for.
SUPPLIER_SITE_NAME	VARCHAR2	(15)		This column identifies to which supplier site name the association is created for. References vendor_site_code in ap_supplier_sites_all
DATA_LEVEL_NAME	VARCHAR2	(30)		Refers to data_level_name of the association. References data_level_name from ego_data_level_b.
STYLE_ITEM_FLAG	VARCHAR2	(1)		Style Item flag of the corresponding item. For internal use only
STYLE_ITEM_ID	NUMBER			Style Item Identifier of the corresponding item. For internal use only.
BUNDLE_ID	NUMBER			Bundle Id.
SOURCE_SYSTEM_ID	NUMBER			Source System Id for incoming item.
SOURCE_SYSTEM_REFERENCE	VARCHAR2	(255)		Source System Reference for incoming item.

Query Text

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


SELECT BATCH_ID
,      ITEM_NUMBER
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      DATA_LEVEL_ID
,      PRIMARY_FLAG
,      STATUS_CODE
,      ORGANIZATION_CODE
,      TRANSACTION_TYPE
,      PROCESS_FLAG
,      TRANSACTION_ID
,      ASSOCIATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SUPPLIER_NAME
,      SUPPLIER_NUMBER
,      SUPPLIER_SITE_NAME
,      DATA_LEVEL_NAME
,      STYLE_ITEM_FLAG
,      STYLE_ITEM_ID
,      BUNDLE_ID
,      SOURCE_SYSTEM_ID
,      SOURCE_SYSTEM_REFERENCE
FROM EGO.EGO_ITEM_ASSOCIATIONS_INTF;

Dependencies

[top of page]

EGO.EGO_ITEM_ASSOCIATIONS_INTF does not reference any database object

EGO.EGO_ITEM_ASSOCIATIONS_INTF is referenced by following:

EGO: EGO_ITEM_ASSOCIATIONS_INTF#