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]

VIEW: CSI.CSI_I_PARTY_INTERFACE#

Object Details

Object Name:	CSI_I_PARTY_INTERFACE#
Object Type:	VIEW
Owner:	CSI
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
IP_INTERFACE_ID	NUMBER		Yes
INST_INTERFACE_ID	NUMBER		Yes
PARALLEL_WORKER_ID	NUMBER
ERROR_TEXT	VARCHAR2	(2000)
PARTY_ID	NUMBER
PARTY_NUMBER	VARCHAR2	(30)
INSTANCE_PARTY_ID	NUMBER
PARTY_NAME	VARCHAR2	(250)
PARTY_SOURCE_TABLE	VARCHAR2	(30)
PARTY_RELATIONSHIP_TYPE_CODE	VARCHAR2	(30)
PARTY_START_DATE	DATE
PARTY_END_DATE	DATE
CONTACT_FLAG	VARCHAR2	(1)
CONTACT_IP_ID	NUMBER
CONTACT_PARTY_NUMBER	VARCHAR2	(30)
CONTACT_PARTY_NAME	VARCHAR2	(250)
CONTACT_PARTY_ID	NUMBER
CONTACT_PARTY_REL_TYPE	VARCHAR2	(30)
PARTY_CONTEXT	VARCHAR2	(30)
PARTY_ATTRIBUTE1	VARCHAR2	(150)
PARTY_ATTRIBUTE2	VARCHAR2	(150)
PARTY_ATTRIBUTE3	VARCHAR2	(150)
PARTY_ATTRIBUTE4	VARCHAR2	(150)
PARTY_ATTRIBUTE5	VARCHAR2	(150)
PARTY_ATTRIBUTE6	VARCHAR2	(150)
PARTY_ATTRIBUTE7	VARCHAR2	(150)
PARTY_ATTRIBUTE8	VARCHAR2	(150)
PARTY_ATTRIBUTE9	VARCHAR2	(150)
PARTY_ATTRIBUTE10	VARCHAR2	(150)
PARTY_ATTRIBUTE11	VARCHAR2	(150)
PARTY_ATTRIBUTE12	VARCHAR2	(150)
PARTY_ATTRIBUTE13	VARCHAR2	(150)
PARTY_ATTRIBUTE14	VARCHAR2	(150)
PARTY_ATTRIBUTE15	VARCHAR2	(150)
IP_ACCOUNT1_ID	NUMBER
PARTY_ACCOUNT1_NUMBER	VARCHAR2	(30)
PARTY_ACCOUNT1_ID	NUMBER
ACCT1_RELATIONSHIP_TYPE_CODE	VARCHAR2	(30)
PARTY_ACCT1_START_DATE	DATE
PARTY_ACCT1_END_DATE	DATE
BILL_TO_ADDRESS1	NUMBER
SHIP_TO_ADDRESS1	NUMBER
ACCOUNT1_CONTEXT	VARCHAR2	(30)
ACCOUNT1_ATTRIBUTE1	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE2	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE3	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE4	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE5	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE6	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE7	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE8	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE9	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE10	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE11	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE12	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE13	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE14	VARCHAR2	(150)
ACCOUNT1_ATTRIBUTE15	VARCHAR2	(150)
IP_ACCOUNT2_ID	NUMBER
PARTY_ACCOUNT2_NUMBER	VARCHAR2	(30)
PARTY_ACCOUNT2_ID	NUMBER
ACCT2_RELATIONSHIP_TYPE_CODE	VARCHAR2	(30)
PARTY_ACCT2_START_DATE	DATE
PARTY_ACCT2_END_DATE	DATE
BILL_TO_ADDRESS2	NUMBER
SHIP_TO_ADDRESS2	NUMBER
ACCOUNT2_CONTEXT	VARCHAR2	(30)
ACCOUNT2_ATTRIBUTE1	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE2	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE3	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE4	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE5	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE6	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE7	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE8	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE9	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE10	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE11	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE12	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE13	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE14	VARCHAR2	(150)
ACCOUNT2_ATTRIBUTE15	VARCHAR2	(150)
IP_ACCOUNT3_ID	NUMBER
PARTY_ACCOUNT3_NUMBER	VARCHAR2	(30)
PARTY_ACCOUNT3_ID	NUMBER
ACCT3_RELATIONSHIP_TYPE_CODE	VARCHAR2	(30)
PARTY_ACCT3_START_DATE	DATE
PARTY_ACCT3_END_DATE	DATE
BILL_TO_ADDRESS3	NUMBER
SHIP_TO_ADDRESS3	NUMBER
ACCOUNT3_CONTEXT	VARCHAR2	(30)
ACCOUNT3_ATTRIBUTE1	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE2	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE3	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE4	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE5	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE6	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE7	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE8	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE9	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE10	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE11	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE12	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE13	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE14	VARCHAR2	(150)
ACCOUNT3_ATTRIBUTE15	VARCHAR2	(150)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)

Query Text

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


SELECT IP_INTERFACE_ID
,      INST_INTERFACE_ID
,      PARALLEL_WORKER_ID
,      ERROR_TEXT
,      PARTY_ID
,      PARTY_NUMBER
,      INSTANCE_PARTY_ID
,      PARTY_NAME
,      PARTY_SOURCE_TABLE
,      PARTY_RELATIONSHIP_TYPE_CODE
,      PARTY_START_DATE
,      PARTY_END_DATE
,      CONTACT_FLAG
,      CONTACT_IP_ID
,      CONTACT_PARTY_NUMBER
,      CONTACT_PARTY_NAME
,      CONTACT_PARTY_ID
,      CONTACT_PARTY_REL_TYPE
,      PARTY_CONTEXT
,      PARTY_ATTRIBUTE1
,      PARTY_ATTRIBUTE2
,      PARTY_ATTRIBUTE3
,      PARTY_ATTRIBUTE4
,      PARTY_ATTRIBUTE5
,      PARTY_ATTRIBUTE6
,      PARTY_ATTRIBUTE7
,      PARTY_ATTRIBUTE8
,      PARTY_ATTRIBUTE9
,      PARTY_ATTRIBUTE10
,      PARTY_ATTRIBUTE11
,      PARTY_ATTRIBUTE12
,      PARTY_ATTRIBUTE13
,      PARTY_ATTRIBUTE14
,      PARTY_ATTRIBUTE15
,      IP_ACCOUNT1_ID
,      PARTY_ACCOUNT1_NUMBER
,      PARTY_ACCOUNT1_ID
,      ACCT1_RELATIONSHIP_TYPE_CODE
,      PARTY_ACCT1_START_DATE
,      PARTY_ACCT1_END_DATE
,      BILL_TO_ADDRESS1
,      SHIP_TO_ADDRESS1
,      ACCOUNT1_CONTEXT
,      ACCOUNT1_ATTRIBUTE1
,      ACCOUNT1_ATTRIBUTE2
,      ACCOUNT1_ATTRIBUTE3
,      ACCOUNT1_ATTRIBUTE4
,      ACCOUNT1_ATTRIBUTE5
,      ACCOUNT1_ATTRIBUTE6
,      ACCOUNT1_ATTRIBUTE7
,      ACCOUNT1_ATTRIBUTE8
,      ACCOUNT1_ATTRIBUTE9
,      ACCOUNT1_ATTRIBUTE10
,      ACCOUNT1_ATTRIBUTE11
,      ACCOUNT1_ATTRIBUTE12
,      ACCOUNT1_ATTRIBUTE13
,      ACCOUNT1_ATTRIBUTE14
,      ACCOUNT1_ATTRIBUTE15
,      IP_ACCOUNT2_ID
,      PARTY_ACCOUNT2_NUMBER
,      PARTY_ACCOUNT2_ID
,      ACCT2_RELATIONSHIP_TYPE_CODE
,      PARTY_ACCT2_START_DATE
,      PARTY_ACCT2_END_DATE
,      BILL_TO_ADDRESS2
,      SHIP_TO_ADDRESS2
,      ACCOUNT2_CONTEXT
,      ACCOUNT2_ATTRIBUTE1
,      ACCOUNT2_ATTRIBUTE2
,      ACCOUNT2_ATTRIBUTE3
,      ACCOUNT2_ATTRIBUTE4
,      ACCOUNT2_ATTRIBUTE5
,      ACCOUNT2_ATTRIBUTE6
,      ACCOUNT2_ATTRIBUTE7
,      ACCOUNT2_ATTRIBUTE8
,      ACCOUNT2_ATTRIBUTE9
,      ACCOUNT2_ATTRIBUTE10
,      ACCOUNT2_ATTRIBUTE11
,      ACCOUNT2_ATTRIBUTE12
,      ACCOUNT2_ATTRIBUTE13
,      ACCOUNT2_ATTRIBUTE14
,      ACCOUNT2_ATTRIBUTE15
,      IP_ACCOUNT3_ID
,      PARTY_ACCOUNT3_NUMBER
,      PARTY_ACCOUNT3_ID
,      ACCT3_RELATIONSHIP_TYPE_CODE
,      PARTY_ACCT3_START_DATE
,      PARTY_ACCT3_END_DATE
,      BILL_TO_ADDRESS3
,      SHIP_TO_ADDRESS3
,      ACCOUNT3_CONTEXT
,      ACCOUNT3_ATTRIBUTE1
,      ACCOUNT3_ATTRIBUTE2
,      ACCOUNT3_ATTRIBUTE3
,      ACCOUNT3_ATTRIBUTE4
,      ACCOUNT3_ATTRIBUTE5
,      ACCOUNT3_ATTRIBUTE6
,      ACCOUNT3_ATTRIBUTE7
,      ACCOUNT3_ATTRIBUTE8
,      ACCOUNT3_ATTRIBUTE9
,      ACCOUNT3_ATTRIBUTE10
,      ACCOUNT3_ATTRIBUTE11
,      ACCOUNT3_ATTRIBUTE12
,      ACCOUNT3_ATTRIBUTE13
,      ACCOUNT3_ATTRIBUTE14
,      ACCOUNT3_ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM CSI.CSI_I_PARTY_INTERFACE#;

Dependencies

[top of page]

CSI.CSI_I_PARTY_INTERFACE# references the following:

CSI: CSI_I_PARTY_INTERFACE

CSI.CSI_I_PARTY_INTERFACE# is referenced by following:

APPS: CSI_I_PARTY_INTERFACE