DBA Data[Home] [Help] [Dependency Information]

VIEW: CSI.CSI_I_PARTIES_H#

Object Details
Object Name: CSI_I_PARTIES_H#
Object Type: VIEW
Owner: CSI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INSTANCE_PARTY_HISTORY_ID NUMBER
Yes
INSTANCE_PARTY_ID NUMBER
Yes
TRANSACTION_ID NUMBER
Yes
OLD_PARTY_SOURCE_TABLE VARCHAR2 (30)
NEW_PARTY_SOURCE_TABLE VARCHAR2 (30)
OLD_PARTY_ID NUMBER

NEW_PARTY_ID NUMBER

OLD_RELATIONSHIP_TYPE_CODE VARCHAR2 (30)
NEW_RELATIONSHIP_TYPE_CODE VARCHAR2 (30)
OLD_CONTACT_FLAG VARCHAR2 (1)
NEW_CONTACT_FLAG VARCHAR2 (1)
OLD_CONTACT_IP_ID NUMBER

NEW_CONTACT_IP_ID NUMBER

OLD_PREFERRED_FLAG VARCHAR2 (1)
NEW_PREFERRED_FLAG VARCHAR2 (1)
OLD_PRIMARY_FLAG VARCHAR2 (1)
NEW_PRIMARY_FLAG VARCHAR2 (1)
OLD_ACTIVE_START_DATE DATE

NEW_ACTIVE_START_DATE DATE

OLD_ACTIVE_END_DATE DATE

NEW_ACTIVE_END_DATE DATE

OLD_CONTEXT VARCHAR2 (30)
NEW_CONTEXT VARCHAR2 (30)
OLD_ATTRIBUTE1 VARCHAR2 (150)
NEW_ATTRIBUTE1 VARCHAR2 (150)
OLD_ATTRIBUTE2 VARCHAR2 (150)
NEW_ATTRIBUTE2 VARCHAR2 (150)
OLD_ATTRIBUTE3 VARCHAR2 (150)
NEW_ATTRIBUTE3 VARCHAR2 (150)
OLD_ATTRIBUTE4 VARCHAR2 (150)
NEW_ATTRIBUTE4 VARCHAR2 (150)
OLD_ATTRIBUTE5 VARCHAR2 (150)
NEW_ATTRIBUTE5 VARCHAR2 (150)
OLD_ATTRIBUTE6 VARCHAR2 (150)
NEW_ATTRIBUTE6 VARCHAR2 (150)
OLD_ATTRIBUTE7 VARCHAR2 (150)
NEW_ATTRIBUTE7 VARCHAR2 (150)
OLD_ATTRIBUTE8 VARCHAR2 (150)
NEW_ATTRIBUTE8 VARCHAR2 (150)
OLD_ATTRIBUTE9 VARCHAR2 (150)
NEW_ATTRIBUTE9 VARCHAR2 (150)
OLD_ATTRIBUTE10 VARCHAR2 (150)
NEW_ATTRIBUTE10 VARCHAR2 (150)
OLD_ATTRIBUTE11 VARCHAR2 (150)
NEW_ATTRIBUTE11 VARCHAR2 (150)
OLD_ATTRIBUTE12 VARCHAR2 (150)
NEW_ATTRIBUTE12 VARCHAR2 (150)
OLD_ATTRIBUTE13 VARCHAR2 (150)
NEW_ATTRIBUTE13 VARCHAR2 (150)
OLD_ATTRIBUTE14 VARCHAR2 (150)
NEW_ATTRIBUTE14 VARCHAR2 (150)
OLD_ATTRIBUTE15 VARCHAR2 (150)
NEW_ATTRIBUTE15 VARCHAR2 (150)
FULL_DUMP_FLAG VARCHAR2 (1)
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)
OBJECT_VERSION_NUMBER NUMBER
Yes
SECURITY_GROUP_ID NUMBER

MIGRATED_FLAG VARCHAR2 (1)
Query Text

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


SELECT INSTANCE_PARTY_HISTORY_ID
,      INSTANCE_PARTY_ID
,      TRANSACTION_ID
,      OLD_PARTY_SOURCE_TABLE
,      NEW_PARTY_SOURCE_TABLE
,      OLD_PARTY_ID
,      NEW_PARTY_ID
,      OLD_RELATIONSHIP_TYPE_CODE
,      NEW_RELATIONSHIP_TYPE_CODE
,      OLD_CONTACT_FLAG
,      NEW_CONTACT_FLAG
,      OLD_CONTACT_IP_ID
,      NEW_CONTACT_IP_ID
,      OLD_PREFERRED_FLAG
,      NEW_PREFERRED_FLAG
,      OLD_PRIMARY_FLAG
,      NEW_PRIMARY_FLAG
,      OLD_ACTIVE_START_DATE
,      NEW_ACTIVE_START_DATE
,      OLD_ACTIVE_END_DATE
,      NEW_ACTIVE_END_DATE
,      OLD_CONTEXT
,      NEW_CONTEXT
,      OLD_ATTRIBUTE1
,      NEW_ATTRIBUTE1
,      OLD_ATTRIBUTE2
,      NEW_ATTRIBUTE2
,      OLD_ATTRIBUTE3
,      NEW_ATTRIBUTE3
,      OLD_ATTRIBUTE4
,      NEW_ATTRIBUTE4
,      OLD_ATTRIBUTE5
,      NEW_ATTRIBUTE5
,      OLD_ATTRIBUTE6
,      NEW_ATTRIBUTE6
,      OLD_ATTRIBUTE7
,      NEW_ATTRIBUTE7
,      OLD_ATTRIBUTE8
,      NEW_ATTRIBUTE8
,      OLD_ATTRIBUTE9
,      NEW_ATTRIBUTE9
,      OLD_ATTRIBUTE10
,      NEW_ATTRIBUTE10
,      OLD_ATTRIBUTE11
,      NEW_ATTRIBUTE11
,      OLD_ATTRIBUTE12
,      NEW_ATTRIBUTE12
,      OLD_ATTRIBUTE13
,      NEW_ATTRIBUTE13
,      OLD_ATTRIBUTE14
,      NEW_ATTRIBUTE14
,      OLD_ATTRIBUTE15
,      NEW_ATTRIBUTE15
,      FULL_DUMP_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      MIGRATED_FLAG
FROM CSI.CSI_I_PARTIES_H#;

Dependencies

[top of page]

CSI.CSI_I_PARTIES_H# references the following:

SchemaCSI
TableCSI_I_PARTIES_H
CSI.CSI_I_PARTIES_H# is referenced by following:

SchemaAPPS
SynonymCSI_I_PARTIES_H