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_II_RELATION_INTERFACE

Object Details

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

This is the Open Interface table for Install Base Open Interface that contains the records for Instance - Instance Relationships. The SUBJECT_INTERFACE_ID and OBJECT_INTERFACE_ID are nothing but INST_INTERFACE_ID loaded in CSI_INSTANCE_INTERFACE.
Scope: public
Product: CSI
Lifecycle: active
Display Name: CSI II Relation 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_II_RELATION_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	REL_INTERFACE_ID
CSI_II_RELATION_INTERFACE_N01	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	OBJECT_ID RELATIONSHIP_TYPE_CODE
CSI_II_RELATION_INTERFACE_N02	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SUBJECT_ID
CSI_II_RELATION_INTERFACE_N03	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SOURCE_TRANSACTION_DATE
CSI_II_RELATION_INTERFACE_N04	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SOURCE_SYSTEM_NAME
CSI_II_RELATION_INTERFACE_N05	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_IDENTIFIER SOURCE_SYSTEM_NAME
CSI_II_RELATION_INTERFACE_N6	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PARALLEL_WORKER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REL_INTERFACE_ID	NUMBER		Yes	Relationship Interface ID
PARALLEL_WORKER_ID	NUMBER			Parallel Worker ID that is assigned to this Instance used when creating instances with the Parallel Worker Process Only.
SUBJECT_INTERFACE_ID	NUMBER			Subject Interface ID
OBJECT_INTERFACE_ID	NUMBER			Object Interface ID
RELATIONSHIP_TYPE_CODE	VARCHAR2	(30)		Relationship Type Code of this Instance to Instance Relationship (i.e. CONNECTED-TO)
RELATIONSHIP_START_DATE	DATE			Active Start Date for the Instance to Instance Relationship.
RELATIONSHIP_END_DATE	DATE			Active End Date for the Instance to Instance Relationship.
POSITION_REFERENCE	VARCHAR2	(30)		Position Reference of the Relationship
DISPLAY_ORDER	NUMBER			Order in which the UI will display the relationships
MANDATORY_FLAG	VARCHAR2	(1)		Mandatory relationship indicator
RELATIONSHIP_DIRECTION	VARCHAR2	(30)		Relationship direction
ERROR_TEXT	VARCHAR2	(2000)		Error text for any errors that are encountered while processing each row of data.
CONTEXT	VARCHAR2	(30)		Standard Oracle DFF context field
ATTRIBUTE1	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE2	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE3	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE4	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE5	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE6	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE7	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE8	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE9	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE10	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE11	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE12	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE13	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE14	VARCHAR2	(150)		Standard Oracle DFF Column
ATTRIBUTE15	VARCHAR2	(150)		Standard Oracle DFF Column
CREATED_BY	NUMBER	(15)		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
SOURCE_SYSTEM_NAME	VARCHAR2	(30)		Source System Name
SOURCE_TRANSACTION_DATE	DATE			Source Transaction Date
SOURCE_TRANSACTION_TYPE	VARCHAR2	(30)		Source Transaction Type
PROCESS_STATUS	VARCHAR2	(1)		Process Status
OBJECT_ID	NUMBER			Object Id
SUBJECT_ID	NUMBER			Subject Id
TRANSACTION_IDENTIFIER	VARCHAR2	(30)		Transaction Identifier
CONFIG_ROOT_NODE	NUMBER			Config Root Node

Query Text

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


SELECT REL_INTERFACE_ID
,      PARALLEL_WORKER_ID
,      SUBJECT_INTERFACE_ID
,      OBJECT_INTERFACE_ID
,      RELATIONSHIP_TYPE_CODE
,      RELATIONSHIP_START_DATE
,      RELATIONSHIP_END_DATE
,      POSITION_REFERENCE
,      DISPLAY_ORDER
,      MANDATORY_FLAG
,      RELATIONSHIP_DIRECTION
,      ERROR_TEXT
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SOURCE_SYSTEM_NAME
,      SOURCE_TRANSACTION_DATE
,      SOURCE_TRANSACTION_TYPE
,      PROCESS_STATUS
,      OBJECT_ID
,      SUBJECT_ID
,      TRANSACTION_IDENTIFIER
,      CONFIG_ROOT_NODE
FROM CSI.CSI_II_RELATION_INTERFACE;

Dependencies

[top of page]

CSI.CSI_II_RELATION_INTERFACE does not reference any database object

CSI.CSI_II_RELATION_INTERFACE is referenced by following:

CSI: CSI_II_RELATION_INTERFACE#