Skip to content

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 Comments
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:

SchemaCSI
TableCSI_I_PARTY_INTERFACE
CSI.CSI_I_PARTY_INTERFACE# is referenced by following:

SchemaAPPS
SynonymCSI_I_PARTY_INTERFACE