VIEW: CSI.CSI_I_PARTY_INTERFACE#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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