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

TABLE: WSH.WSH_ITM_PARTY_CONTACTS

Object Details
Object Name: WSH_ITM_PARTY_CONTACTS
Object Type: TABLE
Owner: WSH
FND Design Data: TableWSH.WSH_ITM_PARTY_CONTACTS
Subobject Name:
Status: VALID


Contacts of the various Parties are stored in this Table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER

Party ID
NAME VARCHAR2 (360)
Name
JOB_TITLE VARCHAR2 (100)
Job Title
EMAIL VARCHAR2 (2000)
Email
FAX VARCHAR2 (40)
Fax
PHONE VARCHAR2 (40)
Phone
ATTRIBUTE1_NAME VARCHAR2 (240)
Attribute1 Name
ATTRIBUTE2_NAME VARCHAR2 (240)
Attribute2 Name
ATTRIBUTE3_NAME VARCHAR2 (240)
Attribute3 Name
ATTRIBUTE4_NAME VARCHAR2 (240)
Attribute4 Name
ATTRIBUTE5_NAME VARCHAR2 (240)
Attribute5 Name
ATTRIBUTE6_NAME VARCHAR2 (240)
Attribute6 Name
ATTRIBUTE7_NAME VARCHAR2 (240)
Attribute7 Name
ATTRIBUTE8_NAME VARCHAR2 (240)
Attribute8 Name
ATTRIBUTE9_NAME VARCHAR2 (240)
Attribute9 Name
ATTRIBUTE10_NAME VARCHAR2 (240)
Attribute10 Name
ATTRIBUTE11_NAME VARCHAR2 (240)
Attribute11 Name
ATTRIBUTE12_NAME VARCHAR2 (240)
Attribute12 Name
ATTRIBUTE13_NAME VARCHAR2 (240)
Attribute13 Name
ATTRIBUTE14_NAME VARCHAR2 (240)
Attribute14 Name
ATTRIBUTE15_NAME VARCHAR2 (240)
Attribute15 Name
ATTRIBUTE1_VALUE VARCHAR2 (240)
Attribute1 Value
ATTRIBUTE2_VALUE VARCHAR2 (240)
Attribute2 Value
ATTRIBUTE3_VALUE VARCHAR2 (240)
Attribute3 Value
ATTRIBUTE4_VALUE VARCHAR2 (240)
Attribute4 Value
ATTRIBUTE5_VALUE VARCHAR2 (240)
Attribute5 Value
ATTRIBUTE6_VALUE VARCHAR2 (240)
Attribute6 Value
ATTRIBUTE7_VALUE VARCHAR2 (240)
Attribute7 Value
ATTRIBUTE8_VALUE VARCHAR2 (240)
Attribute8 Value
ATTRIBUTE9_VALUE VARCHAR2 (240)
Attribute9 Value
ATTRIBUTE10_VALUE VARCHAR2 (240)
Attribute10 Value
ATTRIBUTE11_VALUE VARCHAR2 (240)
Attribute11 Value
ATTRIBUTE12_VALUE VARCHAR2 (240)
Attribute12 Value
ATTRIBUTE13_VALUE VARCHAR2 (240)
Attribute13 Value
ATTRIBUTE14_VALUE VARCHAR2 (240)
Attribute14 Value
ATTRIBUTE15_VALUE VARCHAR2 (240)
Attribute Value15
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
HZ_PARTY_ID NUMBER

Hz Party Id
HZ_PARTY_NUMBER VARCHAR2 (30)
Hz Party Number
HZ_PARTY_TYPE VARCHAR2 (30)
Hz Party Type
HZ_PARTY_STATUS VARCHAR2 (1)
Hz Party Status
ALTERNATE_NAME VARCHAR2 (320)
Alternate Name
PERSON_FIRST_NAME VARCHAR2 (150)
Person First Name
PERSON_MIDDLE_NAME VARCHAR2 (60)
Person Middle Name
PERSON_LAST_NAME VARCHAR2 (150)
Person Last Name
HZ_COUNTRY VARCHAR2 (60)
Hz Country
HZ_ADDRESS1 VARCHAR2 (240)
Hz Address1
HZ_ADDRESS2 VARCHAR2 (240)
Hz Address2
HZ_ADDRESS3 VARCHAR2 (240)
Hz Address3
HZ_ADDRESS4 VARCHAR2 (240)
HZ_ADDRESS4
HZ_CITY VARCHAR2 (60)
Hz City
HZ_POSTAL_CODE VARCHAR2 (60)
Hz Postal Code
HZ_STATE VARCHAR2 (60)
Hz State
HZ_PROVINCE VARCHAR2 (60)
Hz Province
HZ_COUNTY VARCHAR2 (60)
Hz County
Query Text

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


SELECT PARTY_ID
,      NAME
,      JOB_TITLE
,      EMAIL
,      FAX
,      PHONE
,      ATTRIBUTE1_NAME
,      ATTRIBUTE2_NAME
,      ATTRIBUTE3_NAME
,      ATTRIBUTE4_NAME
,      ATTRIBUTE5_NAME
,      ATTRIBUTE6_NAME
,      ATTRIBUTE7_NAME
,      ATTRIBUTE8_NAME
,      ATTRIBUTE9_NAME
,      ATTRIBUTE10_NAME
,      ATTRIBUTE11_NAME
,      ATTRIBUTE12_NAME
,      ATTRIBUTE13_NAME
,      ATTRIBUTE14_NAME
,      ATTRIBUTE15_NAME
,      ATTRIBUTE1_VALUE
,      ATTRIBUTE2_VALUE
,      ATTRIBUTE3_VALUE
,      ATTRIBUTE4_VALUE
,      ATTRIBUTE5_VALUE
,      ATTRIBUTE6_VALUE
,      ATTRIBUTE7_VALUE
,      ATTRIBUTE8_VALUE
,      ATTRIBUTE9_VALUE
,      ATTRIBUTE10_VALUE
,      ATTRIBUTE11_VALUE
,      ATTRIBUTE12_VALUE
,      ATTRIBUTE13_VALUE
,      ATTRIBUTE14_VALUE
,      ATTRIBUTE15_VALUE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      HZ_PARTY_ID
,      HZ_PARTY_NUMBER
,      HZ_PARTY_TYPE
,      HZ_PARTY_STATUS
,      ALTERNATE_NAME
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      HZ_COUNTRY
,      HZ_ADDRESS1
,      HZ_ADDRESS2
,      HZ_ADDRESS3
,      HZ_ADDRESS4
,      HZ_CITY
,      HZ_POSTAL_CODE
,      HZ_STATE
,      HZ_PROVINCE
,      HZ_COUNTY
FROM WSH.WSH_ITM_PARTY_CONTACTS;

Dependencies

[top of page]

WSH.WSH_ITM_PARTY_CONTACTS does not reference any database object

WSH.WSH_ITM_PARTY_CONTACTS is referenced by following:

SchemaWSH
ViewWSH_ITM_PARTY_CONTACTS#