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: CSI.CSI_IEA_VALUE_INTERFACE

Object Details

Object Name:	CSI_IEA_VALUE_INTERFACE
Object Type:	TABLE
Owner:	CSI
FND Design Data:	CSI.CSI_IEA_VALUE_INTERFACE
Subobject Name:
Status:	VALID

This is the Open Interface table for Install Base Open Interface that contains the records for Extended Attributes Values. This is a child table of CSI_INSTANCE_INTERFACE joined by inst_interface_id.
Scope: public
Product: CSI
Lifecycle: active
Display Name: CSI IEA Values Interface
Category: BUSINESS_ENTITY CSI_ITEM_INSTANCE

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSI_IEA_VALUE_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	IEAV_INTERFACE_ID
CSI_IEA_VALUE_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INST_INTERFACE_ID
CSI_IEA_VALUE_INTERFACE_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ATTRIBUTE_LEVEL
CSI_IEA_VALUE_INTERFACE_N6	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PARALLEL_WORKER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
IEAV_INTERFACE_ID	NUMBER		Yes	Extended Attribute Interface ID
INST_INTERFACE_ID	NUMBER		Yes	Instance Interface ID that will be used to link the rows in this table to its parent in CSI_INSTANCE_INTERFACE
PARALLEL_WORKER_ID	NUMBER			Parallel Worker ID that is assigned to this Instance used when creating instances with the Parallel Worker Process Only.
ERROR_TEXT	VARCHAR2	(2000)		Error text for any errors that are encountered while processing each row of data.
ATTRIBUTE_ID	NUMBER			Extended Attribute ID
INV_CONCATENATED_SEGMENTS	VARCHAR2	(250)		Concatenated Segment for the instance you are interfacing
INVENTORY_ITEM_ID	NUMBER			Inventory Item Id for the instance you are interfacing
MASTER_ORGANIZATION_ID	NUMBER			Master Organization Id for the instance you are interfacing
MASTER_ORGANIZATION_NAME	VARCHAR2	(250)		Master Organization Name for the instance you are interfacing
ITEM_CATEGORY_CONC_SEG	VARCHAR2	(250)		Instance Item Category for the Extended Attribute
ITEM_CATEGORY_ID	NUMBER			Instance Item Category ID for the Extended Attribute
ATTRIBUTE_CODE	VARCHAR2	(30)		Attribute Code which this Extended Attribute is defined
ATTRIBUTE_NAME	VARCHAR2	(50)		Attribute Name which this Extended Attribute is defined
ATTRIBUTE_LEVEL	VARCHAR2	(15)		Attribute Level which this Extended Attribute is defined
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute Category which this Extended Attribute is defined
ATTRIBUTE_VALUE	VARCHAR2	(240)		Attribute Value which this Extended Attribute is defined
ATTRIBUTE_VALUE_ID	NUMBER			Attribute Value ID which this Extended Attribute is defined
IEAV_START_DATE	DATE			Active Start Date for Interfaced Instance
IEAV_END_DATE	DATE			Active End Date for Interfaced Instance
CREATED_BY	NUMBER	(15)	Yes	Standard Oracle Who Column
CREATION_DATE	DATE		Yes	Standard Oracle Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Oracle Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Oracle Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Oracle Who Column

Query Text

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


SELECT IEAV_INTERFACE_ID
,      INST_INTERFACE_ID
,      PARALLEL_WORKER_ID
,      ERROR_TEXT
,      ATTRIBUTE_ID
,      INV_CONCATENATED_SEGMENTS
,      INVENTORY_ITEM_ID
,      MASTER_ORGANIZATION_ID
,      MASTER_ORGANIZATION_NAME
,      ITEM_CATEGORY_CONC_SEG
,      ITEM_CATEGORY_ID
,      ATTRIBUTE_CODE
,      ATTRIBUTE_NAME
,      ATTRIBUTE_LEVEL
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE_VALUE
,      ATTRIBUTE_VALUE_ID
,      IEAV_START_DATE
,      IEAV_END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM CSI.CSI_IEA_VALUE_INTERFACE;

Dependencies

[top of page]

CSI.CSI_IEA_VALUE_INTERFACE does not reference any database object

CSI.CSI_IEA_VALUE_INTERFACE is referenced by following:

CSI: CSI_IEA_VALUE_INTERFACE#