[Home] [Help] [Dependency Information]
Object Name: | CSI_I_PARTY_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | CSI |
Subobject Name: | |
Status: | VALID |
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) |
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#;
|
|
|