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


VIEW: APPS.CSI_T_PARTY_CONTACTS_V

Object Details
Object Name: CSI_T_PARTY_CONTACTS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View for Party Contacts


[View Source]

Columns
Name Datatype Length Mandatory Comments
TXN_PARTY_DETAIL_ID NUMBER

Transaction Party Detail ID
TXN_LINE_DETAIL_ID NUMBER

Transaction Line Detail ID
INSTANCE_PARTY_ID NUMBER

Instance Party ID
PARTY_SOURCE_TABLE VARCHAR2 (30)
Party Source Table
PARTY_SOURCE_MEANING VARCHAR2 (80)
Party Source Meaning
PARTY_ID NUMBER

Party ID
RELATIONSHIP_TYPE_CODE VARCHAR2 (30)
Relationship Type Code
CONTACT_FLAG VARCHAR2 (1)
Contact Flag
CONTACT_PARTY_ID NUMBER

Contact Party ID
PREFERRED_FLAG VARCHAR2 (1)
Preferred Flag
PRIMARY_FLAG VARCHAR2 (1)
Primary Flag
ACTIVE_START_DATE DATE

Active Start Date
ACTIVE_END_DATE DATE

Active End Date
CONTEXT VARCHAR2 (30)
Standard DFF Column
ATTRIBUTE1 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE2 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE3 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE4 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE5 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE6 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE7 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE8 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE9 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE10 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE11 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE12 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE13 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE14 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE15 VARCHAR2 (150)
Standard DFF Column
CREATED_BY NUMBER (15)
Standard WHO Column
CREATION_DATE DATE

Standard WHO Column
LAST_UPDATED_BY NUMBER (15)
Standard WHO Column
LAST_UPDATE_DATE DATE

Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
PARTY_NAME VARCHAR2 (360)
Party Name
PARTY_NUMBER VARCHAR2 (30)
Party Number
RELATIONSHIP_NAME VARCHAR2 (50)
Relationship Name
RELATIONSHIP_DESCR VARCHAR2 (240)
Relationship Description
WORK_PHONE_NUMBER VARCHAR2 (84)
Work Phone Number
HOME_PHONE_NUMBER VARCHAR2 (84)
Home Phone Number
EMAIL_ADDRESS VARCHAR2 (2000)
Email Address
ADDRESS1 VARCHAR2 (240)
Line Address 1
ADDRESS2 VARCHAR2 (240)
Line Address 2
ADDRESS3 VARCHAR2 (240)
Line Address 3
ADDRESS4 VARCHAR2 (240)
Line Address 4
CITY VARCHAR2 (60)
City
POSTAL_CODE VARCHAR2 (60)
Postal Code
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
COUNTY VARCHAR2 (60)
County
COUNTRY VARCHAR2 (60)
Country
Query Text

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


SELECT TXN_PARTY_DETAIL_ID
,      TXN_LINE_DETAIL_ID
,      INSTANCE_PARTY_ID
,      PARTY_SOURCE_TABLE
,      PARTY_SOURCE_MEANING
,      PARTY_ID
,      RELATIONSHIP_TYPE_CODE
,      CONTACT_FLAG
,      CONTACT_PARTY_ID
,      PREFERRED_FLAG
,      PRIMARY_FLAG
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      PARTY_NAME
,      PARTY_NUMBER
,      RELATIONSHIP_NAME
,      RELATIONSHIP_DESCR
,      WORK_PHONE_NUMBER
,      HOME_PHONE_NUMBER
,      EMAIL_ADDRESS
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
FROM APPS.CSI_T_PARTY_CONTACTS_V;

Dependencies

[top of page]

APPS.CSI_T_PARTY_CONTACTS_V references the following:

SchemaAPPS
SynonymCSI_IPA_RELATION_TYPES
ViewCSI_LOOKUPS
SynonymCSI_T_PARTY_DETAILS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHZ_CONTACT_POINTS
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS
ViewJTF_RS_GROUPS_VL
ViewJTF_RS_TEAMS_VL
SynonymPER_ALL_PEOPLE_F
SynonymPER_PHONES
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.CSI_T_PARTY_CONTACTS_V is not referenced by any database object