eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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	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	(150)	State
PROVINCE	VARCHAR2	(150)	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:

APPS: CSI_IPA_RELATION_TYPES; CSI_LOOKUPS; CSI_T_PARTY_DETAILS; HZ_CONTACT_POINTS; HZ_PARTIES; HZ_RELATIONSHIPS; JTF_RS_GROUPS_VL; JTF_RS_TEAMS_VL; PER_ALL_PEOPLE_F; PER_PHONES; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL

APPS.CSI_T_PARTY_CONTACTS_V is not referenced by any database object